topic Re: Missing Database Index Production Server in Application Development and Automation Discussions

Missing Database Index Production Server

Former Member — Sat, 13 Feb 2010 04:34:08 GMT

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.

Re: Missing Database Index Production Server

vinod_vemuru2 — Sat, 13 Feb 2010 12:20:46 GMT

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.

Re: Missing Database Index Production Server

Former Member — Sat, 13 Feb 2010 12:37:28 GMT

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

Re: Missing Database Index Production Server

vinod_vemuru2 — Sat, 13 Feb 2010 12:50:09 GMT

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.