Tables and indices missing in database MAIN_POSTPROC/RUN_RSDB02CK_END_DMO phase

[Former Member]

Hi,

We are currently upgrading our BW system from NW7.4 SP13 to NW7.5 SP05 and also migrating to HANA 2.0 from DB2 using DMO. We are in the MAIN_POSTPROC/RUN_RSDB02CK_END_DMO and we are getting the following error.

2EETG001 Secondary index "/BIC/F100065-050" does not exist in the database
2EETG001 Secondary index "/BIC/F100065-060" does not exist in the database
2EETG001 Secondary index "/BIC/F100065-070" does not exist in the database
2EETG001 Secondary index "/BIC/F100066-020" does not exist in the database
2EETG001 Secondary index "/BIC/F100066-030" does not exist in the database
2EETG001 Secondary index "/BIC/F100066-040" does not exist in the database
2EETG001 Secondary index "/BIC/F100066-050" does not exist in the database
2EETG001 Secondary index "/BIC/F100066-060" does not exist in the database
2EETG001 Secondary index "/BIC/F100066-070" does not exist in the database
2EETG001 Secondary index "/BIC/F100066-080" does not exist in the database
2EETG033 Table "/BIC/B0000010000" does not exist in the database
2EETG033 Table "/BIC/B0000056000" does not exist in the database
2EETG033 Table "/BIC/B0000057000" does not exist in the database
2EETG033 Table "/BIC/B0000076000" does not exist in the database
2EETG033 Table "/BIC/B0000077000" does not exist in the database
2EETG033 Table "/BIC/B0000078000" does not exist in the database
2EETG033 Table "/BIC/B0000089000" does not exist in the database
2EETG033 Table "/BIC/B0000091000" does not exist in the database
2EETG033 Table "/BIC/B0000106001" does not exist in the database
2EETG033 Table "/BIC/B0000108000" does not exist in the database
2EETG033 Table "/BIC/B0000109001" does not exist in the database
2EETG033 Table "/BIC/B0000112000" does not exist in the database
2EETG033 Table "/BIC/B0000120000" does not exist in the database


These are only some examples of table and indices for which we got this error.We checked in DB02 and found that there are 203 missing secondary indices and 138 missing tables.For indices we have found the following note "1820508 - DBA Cockpit: Missing infocube indexes" but for tables we found nothing.Please help.

Thanks and Regards,

Ananya

[former_member245712]

Hi Ananya ,

We had similar issue in our migration, do you have any solution?

[Former Member]

Hi Ananya,

What action have you taken for the missing tables?

Regards,

[former_member259104]

Hi

Look at:

SAP Note: 2428343 - RUN_RSDB02CK_END_DMO - Secondary index "/BIC/E****" / "/BIC/F****" does not exist in the database

Hope it helps

Thanks

Henri

[RolandKramer]

Hi,

Did you had a look to the following Document - SAP First Guidance – Using the new DMO to migrate to BW on HANA

More Information about the SAP BW Migration

Best Regards Roland Kramer, PM SAP EDW

[RafkeMagic]

those look like PSA tables to me... have you removed a source system maybe?

[Former Member]

Hi Raf,

My question was about the missing tables.These tables are present in ABAP dictionary and not in database.We can go ahead create those tables from SE14 but those will be only empty tables.I could not find any suitable SAP note or document on this.Please help if you have any idea on this.

Thanks and Regards,

Ananya

[RafkeMagic]

shouldn't you ask yourself the following question: do those indexes still make sense on a HANA database?