Database Object for ZXXXtable is inconsistent:(Primary index)

[anjali216]

Hi,

I have created the ZXX table and activated successfully. But am unable to activate when the new fields are added in the table. So, I have checked in SE14->Extras->Database check and the below error is displayed-

"Database Object for ZXXXtable is inconsistent:(Primary index)"

"Indexes Inconsistent with DDIC Source".

So i have tried 'Activate & adjust database" in index page in se14 and received the below error

"ZXXX~0 could not be removed"

"Index ZXXX~0 could not be deleted".

Could you please help me to resolve the issue.

[lutzi3]

Did you try to force activation by RADMASG0_C3 (see https://blogs.sap.com/2020/10/26/mass-activating-multiple-objects-in-background/) ?

[S_Sriram]

Hi Geetanjali

If possible restart the SAP and database instance and try to reimport the new filed added change request, it may solve your issues

Regards

SS

[S_Sriram]

Hi Geetanjali

Check this SAP note 2702083

Regards

SS

[anjali216]

Thank you so much. I will check with Basis team on this

[anjali216]

Hi Lutz,

Thank you so much for your response. We tried force activation, however still getting the same error "Index could not be deleted". Do you have idea how to delete primary index from Database.