Failed to compress the database

LigiaGafitescu — Thu, 28 Feb 2013 06:17:15 GMT

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!

Re: Failed to compress the database

EmadAl-Mousa — Fri, 01 Mar 2013 12:37:52 GMT

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-00001-unique-constraint?p=269368#post269368

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

topic Re: Failed to compress the database in Data Management Questions

Failed to compress the database

Re: Failed to compress the database