Could not install any query object in BI Content

[Former Member]

Hello Experts,

I can not install from BI Content any structures, ristrict key figure, variable,... in QUERY ELEMENTS. I got error messages as below:

Object 8ZTK2SR8MGFDI9UJHKWYVTJU3 (Query,ELEM) could not be collected for object 4JMSPX7EYPBYN1WH33TSF65KB (Query,ELEM)

Object 4889D49LT1LIYU1PBHSH2V5KG (Query) could not be collected for object  ()

Object '089XDL63FC5JW5CSDK6DBHTWQ' (ELEM) of type 'Query' is not available in version 'D'

Maintenance of object 'ELEM' of type '3RYHFTRUQO8YL974X80G89UGF' is not yet available

And I could not find any solution in this forum. Could you please help me fix it?

My BW server:

-SAPKW730009

-SAPK-73704INBICONT

-SAPK-73704INBICONTXT

Thanks in advance.

ThanH.

[haripriya_pampana · Accepted solution]

Please refer to the below SAP Note :

1593665 - Missing Element Id when transporting query elements - "Error Activating Element .....".

Thanks

HP

[RamanKorrapati]

Hi Than,

Before isntalling please collect objects which you required into right side pane, simulate and then try to install.

Just try to install one object any query related one and try it.

Thanks

[Former Member]

hi all,

Thanks for your rely soon!

I even selected "Grouping-->In Dataflow Before and Aftrwds" and "Collection Mode-->Collect Automatically", above error messages still appear.

Thank in advance.

ThanH.

[former_member182470]

Do this like this. Grouping-->Dataflow afterwards and Collect mode-->Collect automatically.

Make sure all checkboxes are ticked under your query and click on Simulate installation. If it is ok, then click on Install.

[Former Member]

hi Suman,

I have experienced in BW field for many years, but it's strange with me. I even could not install variable 0FPER(SAP exit variable) although I can do it in another system normally.

Thanks,

ThanH.

[former_member182470]

Have you upgraded to BW 7.3 recently? All the relevant Patches/Kernel updates exists in your system?

Do you have sufficient authorization to install BI content? Try with other user id in your system.

[former_member182470]

Hi,

While installing your standard dataflow objects like Multiproviders, Cubes, TR/DTPs, didn't you get the queries installed along with them? You should use Collect objects automatically.

Are you trying to install the query elements which does not have their corresponding Infoarea, Infoproviders etc..? This might be the reason for those errors.

Regards,

Suman

[anilkumar_kalkivai]

Hi Than,

Some objects are dependent on other objects.

Try collecting all the dependent objects.

Regards,

Anil.