Missing Database Index Production Server

[Former Member]

Hi,

We are getting Missing Database Index ZPP_EXCAVAT_DET5~0 in production server. For missing database index we are getting in se14 it is showing Exists in the database.While we are using t -code in Db02 there we are getting

ZPP_EXCAVAT_DET5~0 u2013 missing database index.

Had Followd as per note 1248769 but not working Please Suggest

Regards

Priyanka M Jain.

[vinod_vemuru2]

Hi,

There might be some database inconsistency. Ask your BASIS team to regenerate the INDEXes for that table. If possible, try to replicate in development or test system and then in production system. Ideally it should solve the issue.

Thanks,

Vinod.

[Former Member]

Dear Vinod,

Tried Following Steps as

. Call transaction SE14.

. Enter the name of the table and choose "Edit".

. Choose "Indexes".

. Select the index and choose "Choose (F2)".

. If you choose "Activate and adjust", the system creates the index again and it is consistent.

. Check the object log of this activation.

. If an error occurs, eliminate the cause and reactivate the index.

But could not create the index

Following Error Occured

SQL STATEMENT COULD NOT BE EXECUTED

INDEX COULD NOT BE CREATED COMPLETELY IN THE DATABASE

INDEX ZPP_EXCAVET_DET5-0 Could NOT BE CREATED

[vinod_vemuru2]

Hi,

This process is does by ABAP person i hope. Regenerating the INDEX is different which basis team does. Please check with them once. If this also doesn't help, only option i can think off is, delete and recreate the INDEX with the same name again .

Thanks,

Vinod.