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