You are here: > ESRI Forums > arcgis server forums > Thread Replies

ArcGIS Server Forums

ArcGIS Server ArcSDE: General questions forum

Unable to compress Geodatabase   Francisco Caldeira Mar 17, 2008
Re: Unable to compress Geodatabase   Chris Carpenter Apr 04, 2008
Re: Unable to compress Geodatabase   Francisco Caldeira Apr 04, 2008
Re: Unable to compress Geodatabase   Francisco Caldeira Apr 07, 2008
Re: Unable to compress Geodatabase   Chris Carpenter Apr 07, 2008
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Unable to compress Geodatabase 
Author Francisco Caldeira 
Date Mar 17, 2008 
Message I have a Geodatabse (ArcSDE 9.2 SP4 + Oracle 10.2.0.2) wich as a line feature class edited through ArcGis Server aplication.

Every nigth a script runs the compress the geodatabase command with the fallowing sintaxe.

sdeversion -o compress -i esri_sde -u xxx -p xx -N

I try run the command 5 times or less to achieve state lineages = 0.

But I'm getting this error all the time:


ArcSDE 9.2 for Oracle10g Build 1206 Fri Oct 19 08:31:29 2007

Version Administration Utility

---------------------------------------------------

Error: Underlying DBMS error (-51).

Error: Unable to compress state tree.

ORA-00001: unique constraint (VDIM.A640_PK) violated

11:01

[Fri Mar 14 11:01:37 2008] [8006] [pt-lnx08.ine.pt] DB_registered_table_trim_state (VDIM.BSA_BGRI2011,26213) Execute error (1).

Error when updating kept rows in adds table.

[Fri Mar 14 11:01:37 2008] [8006] [pt-lnx08.ine.pt] Warning: Unable to trim state 26197->26213 for table VDIM.BSA_BGRI2011, error = -51

[Fri Mar 14 11:01:37 2008] [8006] [pt-lnx08.ine.pt] DBMS error code: 1

ORA-00001: unique constraint (VDIM.A640_PK) violated

I run the command sdegdbrepair but the problem remains.

sde@pt-lnx08 etc]$ sdegdbrepair -o diagnose_metadata -d ORACLE10G -p xxx



ESRI ArcSDE Server Repair Utility Fri Mar 14 11:02:52 2008

--------------------------------------------------------------

All versions reference valid states.



State 26008 has a parent id of 8272, which is invalid.



All lineage entries have valid state ids.



All states have valid parent ids.



[sde@pt-lnx08 etc]$ sdegdbrepair -o diagnose_tables -d ORACLE10G -p xxx



ESRI ArcSDE Server Repair Utility Fri Mar 14 11:03:04 2008

--------------------------------------------------------------

Diagnose Tables: 71 multiversioned tables examined,

0 multiversioned tables had orphaned, duplicate, missing or redundant rows.

[sde@pt-lnx08 etc]$

11:03

[sde@pt-lnx08 etc]$ sdegdbrepair -o repair_tables -d ORACLE10G -p xxx



ESRI ArcSDE Server Repair Utility Fri Mar 14 11:05:28 2008

--------------------------------------------------------------

Repair Instance Delta Tables, Are you sure? (Y/N): y

Repair operation completed without error.

11:05

[sde@pt-lnx08 etc]$ sdegdbrepair -o repair_tables -d ORACLE10G -p xxx



ESRI ArcSDE Server Repair Utility Fri Mar 14 11:05:28 2008

--------------------------------------------------------------

Repair Instance Delta Tables, Are you sure? (Y/N): y

Repair operation completed without error.

11:06

sdeversion -o compress -i esri_sde -u xxx -p xxx -N





ArcSDE 9.2 for Oracle10g Build 1206 Fri Oct 19 08:31:29 2007

Version Administration Utility

---------------------------------------------------

Error: Underlying DBMS error (-51).

Error: Unable to compress state tree.

ORA-00001: unique constraint (VDIM.A640_PK) violated

Does anyone have any ideas?

Cheers
Francisco Caldeira 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Unable to compress Geodatabase 
Author Chris Carpenter 
Date Apr 04, 2008 
Message I am experiencing the exact same problem. Did you find any resolution to this? 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Unable to compress Geodatabase 
Author Francisco Caldeira 
Date Apr 04, 2008 
Message Hi Cris,

Today were testing ArcSDE 9.2 with SP5, next monday I will try to compress the Database and post a reply if you want.
ESRI Portugal have no ideia what's the problem, and ESRI Int. doesn´t know either.

Cheers
Francisco 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Unable to compress Geodatabase 
Author Francisco Caldeira 
Date Apr 07, 2008 
Message Good new Chris, were able to compress now the Geodatabase with SP5 and Oracle 10.2.0.4.
ESRI Portugal asked me to downgrade the Oracle 10.2.0.2 because causes some kind of problem with ST_GEOMETRY. We think that is not a problem, we only installed Oracle 10.2.0.4 for integrety of the Oracle BD issues.

Regards
Francisco 
   
Report Inappropriate Content • Top • Print • This Forum is closed for replies.    
Subject Re: Unable to compress Geodatabase 
Author Chris Carpenter 
Date Apr 07, 2008 
Message Thanks for the update. I was able to compress too but not using the service pack. I found some duplicated objectid's in a versioned polygon feature class. I went in and deleted them and still could not compress. Then I ran the sdegdbanalze and repair versioned table tools and this seemed to do the trick. I stopped and started the SDE service and then was able to compress. Next on my list is to upgrade service packs. Thanks! -Chris