No objects to activate !!!

[Former Member]

We moved some objects (at views) from one dev sys to another dev system.

I used the developer mode.

When the objects got to the new system they had a diamond on them like this:

There are like 500 of them. I can mass activate them because I get this message: "There are no inactive objects in your workspace to be activated". I get the same error when I r-click on it and try to activate it.

When I open it up and try to activate it I get this error message: "Move of source code from inactive to active objects failed for activation 711: exception 40129:nrepository/base/activation/sourceCodeMove.cpp:220nMost likely another version of the object (edw.se16, AT_ADRC, attributeview)edw.se16;AT_ADRC;attributeview;0;1;1;1;2;1;1 has already been activated by another activation call. The latest version id: 2. Your inactive version id: 1.n"

This leaves us in limbo with these. That diamond means something I just don't know what and I don't know how to resolve this issue.

Help?

Mike

[Former Member · Accepted solution]

Hi,Please help me here...

Thanks in advance..

i am trying to activate analytic view which was imported from BW and modelled in HANA studio after completing model,i am activating the view but it is throwing error like " Most likely another version of the object (analytic view) has already been activated by another activation call,your latest version id is 8 and your inactive version is 4".so please help me here how to resolve the issue?

awaiting for your valuable inputs.

Regards,

Madhu.

[former_member42822 · Accepted solution]

Hello Madhu,

Can you try the below steps.

1.Open the analytic view

2. Revert the model to the active version

3. Then continue with your changes what you want to do with the model.

4. Then activate the model once again, the activation should go through with the latest changes.

How to do revert to active check the image
Hope this helps

Regards,

Vinoth

[Former Member · Accepted solution]

HI Vinoth,

Thanks a lot for the prompt response, I have followed your suggestion now its activated successfully but changes gone and redeveloped, is there any solution without doing rechanges?Please let me know.

Regards,

Madhavi.

[Former Member · Accepted solution]

Here is another way:

1. Using the developer mode u export *all* the objects in the package to ur laptop.
2. You can make some changes if you need to n the exported xml.
3. You import the objects back to the package and *overwrite* them all.
4. For each object you activate it manually.

When happens sometimes is the objects get moved, deleted, ... etc and this is pretty much the only way I have found to "straighten out the mess"

Mike

[Former Member · Accepted solution]

I had this happen again on some other objects and after importing the views using the developer mode and choosing "overwrite" I got this error message on a couple of AT views when I went to manually activate them:

exception 40129: repository/base/activation/sourceCodeMove.cpp:165 Most likely another version of the object (fico.cost_smry, AT_DRCT_COST_SMRY, attributeview)fico.cost_smry;AT_DRCT_COST_SMRY;attributeview;0;0;1;11;-1;11;1 has already been activated by another activation call. The latest version id: 11. Your inactive version id: 11.

I looked in the active.objects table and I do not see it <- a good thing

I looked in the inactive.objects table and I do see it <- expected

But I still can not manually activate it.

So here is the fix:

1. delete the problem objects where you get this err msg,
2. re-import the deleted ones,
3. manually activate them.

Mike

[haifenghu]

Hi,

This happened to me as well. What I did was the following.

1. Export HANA content in developer mode.

2. Delete relevant HANA contents.

3. Delete the package.

4. Import HANA content back.

This works for my case.

Haifeng

[Ravi_Channe]

Hi Michael,

Can you please check if these objects are listed under _SYS_REPO.ACTIVE_OBJECTS or _SYS_REPO.INACTIVE_OBJECTS. Please also check the version numbers of these objects in the tables.

We also faced some issues related to the transports / moving the objects and requested SAP to look into that. In my case, the objects were present in BOTH active and inactive tables with different version numbers. Which, is not suppose to happen as per SAP.

Regards,

Ravi

[Former Member]

Ravi,

Yes ther are in BOTH.

Do you know what the fix is?

Mike

[Ravi_Channe]

There are few possibilities like:

• The objects were refactored (moved) from one package to another
• The underlying tables on which these views are based have been modified and the changes are not yet transported to the second system.
• Please go to Modeler -> Quick Launch -> Activate and try to activate the objects from there.

Regards,

Ravi

[Former Member]

Yep, I've tried that. I get the message:

"There are no inactive objects in your workspace to be activated"

Is it possible that the objects are in a different workspace?

Is there a way to see the workspaces and maybe chg workspace definition or something?

Mike

[Ravi_Channe]

Well, that depends upon the owner of the objects. Since you transported the objects, the owner of the objects could be the Transport / Import user.

Can you please also check if the underlying tables for the attribute views are active.

It is also possible that if the objects collected on the export were inactivated due to the change in the underlying table changes, then it might result in the situation of having active and inactive objects in the repository.

I hope you are working in the Modeler perspective. As per the documentation:

If your development is based on Repository / workspace, then you should be able to see the object in your default workspace.

I'd suggest you to refer to the section 6.7 Activating objects in HANA Modeling Guide for the different scenarios for activation. It may help you under the issue in a better way.

Regards,

Ravi

[Former Member]

OK, so I think the scenario I want is "Revert to Active" ..... After I do this the object is only in the "_SYS_REPO"."ACTIVE_OBJECT" table

The only issue is I HAVE 500 OF THEM so I need some kind of mass action .... make sence, have you seen something like this?

[Former Member]

Hi Michael,

Before move them, were they activated? besides, Whether your dev system is based on different package in one HANA server?

Regards,

Jerry

[Former Member]

Jerry,

They were activated in Sys DI5 instance 82. Sys DI3 instance 84 was created and moved using the developer mode , same package structure everything!!!

Mike

[Former Member]

Michael,

I tested to move source files (view) using development mode, it has no problem and not error found, I am not sure your issue.

But in my memory, I moved source file to different package, such as .hdb*, it has same issue with you, I remebered that I did small change for related files to commit and activate.

As my understood, your views have already activated, so you cannot active them on same package and system again.

Did you check detail error information in log file?

Regards,

Jerry