Failed to compress the database


---------------------------
Compress Database
---------------------------
Failed to compress the database.
Underlying DBMS error[ORA-00001: unique constraint (MJEC.R416_SDE_ROWID_UK) violated
][SDE.DEFAULT]
---------------------------
OK
---------------------------

In M_N/Table based Relationship fields "RID" Field having duplicates. So add relation ships to ArcMAP. Export to excel and find the duplicate RID's and delete those relation ships in table. Still compressing problem check all the  M_N/Table based  relationships. Delete duplicate RID's. After compressing SDE. Given what ever deleted the duplicate RID relationships by Manually.

Also you can check the which is having the duplicate field and table name. Then you can check the the number for error number in below executed command. for example 416 in


SELECT registration_id,table_name,ROWID_COLUMN FROM sde.table_registry WHERE owner = 'MJEC'

Comments

Popular posts from this blog

SDE Lineages count and some commands

Label In ARCGIS

Strengths for Appraisals