Failed to compress the database

[LigiaGafitescu]

Hello,
I made some modifications in the database (deleted some fields from ArcCatalog) but they're still there (both ArcCatalog & PostgreSQL). So I tried to compress the gdb.
When trying to compress the database I get this error:
---------------------------
Compress Database
---------------------------
Failed to compress the database.
Underlying DBMS error [ERROR:  duplicate key value violates unique constraint "r60_sde_rowid_uk"
DETAIL:  Key (objectid)=(1) already exists.
::SQL state: 23505] [sde.DEFAULT]
---------------------------


I did find this article explaining what to do, but it's not for the arcgis 10.1 version. Plus, I have difficulties in writing commands, as I'm not an IT professional. Is the procedure the same as it is explained in this article?

As I said we use arcgis 10.1 SP1 with an PostgreSQL sde geodatabase.

Thank you a lot for suggestions!

[EmadAl-Mousa]

Hi,

i had the same issue but with (ArcSDE 9.3.1). use this link as a guide to you:
http://support.esri.com/en/knowledgebase/techarticles/detail/35298

also, i explained the same esri document based on my situation in this link: http://forums.arcgis.com/threads/76742-Failed-to-compress-the-database.-Underlying-DBMS-error-ORA-00...

you need to know the feature class that have duplicate records, and then use the command sdegdbrepair.

please update us if it works with you or not ?

Regards,
Emad