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