Missing Tables & Indexes in ECC6.0 EHP07 after Installation

[Former Member]

Hi All,

Greetings!!

We have successfully installed ECC6.0 EHP07 with HANA 1.0 SP07 Database on SUSE Linux. But after the complete installation, we could able to see many tables and indexes are missing in DB02.

I have attached the error screenshot for your reference.

Please help us with some suggestion or solution.

Regards,

Ela

[Former Member]

Hi All,

Thanks for your replies.

The issue had been resolved by creating missing indexes in db02.

Regards,

Ela

[Former Member]

Hi Ela,

This is not uncommon as some tables will only be created when/if they are needed.

Regards,

Graham

[Former Member]

HI Chezhian,

By looking at the screen shot of DB02, there are only some secondary indexes missing which are not custom indexes.

You can as well rebuild them from DB02 or using BR*Tools.

Please send the complete screen shot to investigate further.

Thanks

Pavan

[hugo_amo]

Hi Chezhian,

Maybe the note 1248769 (http://service.sap.com/sap/support/notes/1248769) can help you.

Regards,

Hugo