| 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 |