hi,
I am running sdegdbrepair -o diagnose_tables daily to know the status of table. One day I found below result.
ESRI ArcSDE Server Repair Utility Wed Apr 24 06:56:42 2013
----------------------------------------------------------------
35235 rows referencing nonexistent states found in User1.A172 (User1.Layer1)
27678 rows referencing nonexistent states found in User1.D172 (User1.Layer1)
15 rows referencing nonexistent states found in User1.A231 (User1.Layer2)
Diagnose Tables: 145 multiversioned tables examined,
2 multiversioned tables had orphaned, duplicate, missing or redundant rows.
I tried running sdegdbrepair as below for first layer
sdegdbrepair -o repair_tables -d ORACLE11G -r User1.Layer1 -V ALL -u sde-adminusrname -p password -D databasename
and I got below error:
Error: Underlying DBMS error (-51).
Error: Unable to complete repairing orphaned rows.
I had ensured that no other user is working on this database and ensured to remove all existing locks also.
Can someone point me into right direction to resolve this?