SAP BW on HANA - table config for index error

[Former Member]

Hi Gurus!

After migration from BW ORA to BW on HANA we are facing this error message:

"Table config for index SAP<SID>:0BW:BIA:SAP<SID>:<cubename> en is not valid" while executing all queries via RSRT.

The error comes from store procedure SYS.TREXVIADBSL.

Our cubes are compressed so only the "E" fact tables contain data. All indexes except "P" index are OK (P - is definied in ABAP layer but missing in HANA DB.) Actually is not possible to create {in HANA directly} this index which contain all dimensions of cube.

Have you any idea where is the problem?

Thanks a lot in advance for your help!

Michal

[Former Member]

Hi Michal,

I hope views have not created, well manual Workaround is to create views by using program RSDDB_LOGINDEX_CREATE for the info provider.

you can refer the blog :

If issue persists for all the info providers apply 1869218 and run the post migration job RS_BW_POST_MIGRATION with step 12.

Regards,

Rajesh

[ram_makkena]

Hi Rajesh,

Thank you very muck for the information. Its working for me.

Regards,

Ram M

[Former Member]

Hello Michal

Any update on your earlier post. We are facing similar problem. Appreciate your help of resolution.

Regards

Iniyan

[former_member425694]

Hi Iniyan

Try to run program RSDU_TABLE_CONSISTENCY (first run store issue, second repair). This helped us.

Martin.

[Former Member]

Hi,

It seems that previously the cube is placed in BIA.

First deleted the BIA Index and Cube Primary Index.

after that create the Primary Index Again which will resolve your problem.

Regards

Jagan