ORA-00001;unique constraint error

If you get above - ORA-00001;unique constraint error R****_sde_ROWID_UK violated

connect the sde server and get the ROWID numbers using below statements. Please enter one by one relationship with having table and match the number with error number. That relationship having the duplicate indexid (RID field).

example

sdetable -o describe_reg -t MJEC.SupportStructure_Fuse -u sde -p sde answer 418

sdetable -o describe_reg -t MJEC.SupportStructure_Switch -u sde -p sde answer 426

sdetable -o describe_reg -t MJEC.SupptStruct_MiscNetworkFeat -u sde -p sde answer 422

sdetable -o describe_reg -t MJEC.SupptStruct_PFCorrectEquip -u sde -p sde answer 424

sdetable -o describe_reg -t MJEC.SupptStruct_Streetlight -u sde -p sde answer 423

sdetable -o describe_reg -t MJEC.SupptStruct_Transformer -u sde -p sde answer 416

sdetable -o describe_reg -t MJEC.SupptStruct_VoltBoostTrans -u sde -p sde answer 425

Snapshot shows the 416. 416 is regarding to MJEC.SupptStruct_Transformer. So in the table having the duplicate Index number. So delete those duplicate index. Compress works will fine.