Unable to run sdegdbrepair -o diagnose_tables in the production database

[SrijanaTuladhar]

We're able to run "sdegdbrepair -o diagnose_tables" in the development database but can not run in the production database.
It takes a long time to run in the production database (SDE 9.3 sp1, ORACLE 10G) causing it to hang the tool, so it never finishes the process. As a result, other sessions gets hang and slows down the SDE database performance, so we have to kill the sessions before it finishes the process.  The result from the command I last ran:

$ sdegdbrepair -o diagnose_tables -d ORACLE10G -u sde -p *************

ESRI ArcSDE Server Repair Utility Wed Feb 27 13:22:24 2013
----------------------------------------------------------------
Diagnose Tables: 166 multiversioned tables examined,
                 0 multiversioned tables had orphaned, duplicate, missing or redundant rows.
Error: Underlying DBMS error (-51).
Error: Unable to list orphaned rows.

We also tried to run in our test database (SDE 10.1, ORACLE 11G), we get the following error:

-bash-4.1$ sdegdbrepair -o diagnose_tables -d ORACLE11G -u sde -p ***************

ESRI ArcSDE Server Repair Utility Thu Feb 28 12:55:54 2013
----------------------------------------------------------------
Error: UTF-8 (-1020).
Error: Unable to list orphaned rows.

Any help/suggestions would be appreciated. Thanks in advance!

[VinceAngelo]

Since sdeerno.h has:

#define SE_PASSWORD_EXPIRING (-1020) /* User password will expire soon */

I'm guessing that the command-line utilities haven't been configured to handle this warning.

Try again after you re-set your password to clear the expiration...

- V

[SrijanaTuladhar]

Thanks Vince.

We didn't realize that the password expires for SDE user in our new Oracle 11G environment that was set up recently. Anyway once we change the password, we passed that error. However, we are still getting the following error below. Any suggestions? Thanks for your help.

-bash-4.1$ sdegdbrepair -o diagnose_tables -d ORACLE11G -u sde -p ****

ESRI ArcSDE Server Repair Utility Thu Feb 28 14:51:09 2013
----------------------------------------------------------------
Error: Target state not found in the STATES table (-172).
Error: Unable to list orphaned rows.

[VinceAngelo]

The error code is consistent with the text:

#define SE_STATE_NOEXIST            (-172)  /* A specified state is not in the VERSION_STATES table. */

I think Tech Support is your next step at this point.

- V

[SrijanaTuladhar]

Ok.  Thanks again for your help!