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. 






Comments

Post a Comment

Popular posts from this blog

Create Blank/Empty MXD with Same Symbology

Image
Create an Empty MXD in ArcGIS 10 with same symbology from previously used for accessing data . Follow the below steps. 1. Open the ArcCatalog -> Go to the MXD ( Which you want create blank from the Existing MXD)  Right click and select the Set Data Source 2. In the above snap shot you can identify Output File - It changes the name of "Copy of" and then click a Select all option next click Replace button then Replace with button make it as Null (Remove the path). Then it will create a new MXD with a Copy of name.Please check the below snap shot
Read more

ARC2EARTH Installation Problem in ArcGIS 10

If you unable to add the Arc2Earth tool bar in ArcGIS 10. Registration problem for the tool. So that need to register the tool. Go to Run command and enter like below 1st Step For 64-Bit cd C:\Program Files (x86)\Common Files\ArcGIS\bin 2nd step ESRIRegAsm /p:Desktop "C:\Program Files (x86)\Arc2Earth LLC\Arc2Earth\KMLExporter.dll" For 32 -Bit cd C:\Program Files\Common Files\ArcGIS\bin 2nd step ESRIRegAsm /p:Desktop "C:\Program Files\Arc2Earth LLC\Arc2Earth\KMLExporter.dll" Now Registration Succeeded prompt will come. Close all existing ArcGIS browser. Then Open the new browser. add the the arc2earth tool bar. It should come.
Read more