ArcSDE - unable to compress state tree

[EyadHammad]

Good day,

i have been doing compress operations for years and i never stumbled about the issue i am reporting

sdeversion -o compress command is unable to compress state tree. below is what is reported

Error: Underlying DBMS error (-51).

Error: Unable to compress state tree.

ORA-00942: Table or view does not exist

i am running ArcSDE 931 on Oracle 11g R2 on Windows Server 2008

it is basically either the table or view does not exists or SDE does not see it. the question is what table or view am i looking for ? and what could have caused this to happen suddenly ?

appreciate any help

regards,

[AndréVinko]

Dear Eyad Hammad,

The sdeversion command does not consider any viewss residing in the sde owner's schema. In consequence the missing db object should be a table only. In that case two possibilities are possible:

• the table is missing for real. In that case enabling log debug output
  • for the SDE service in file dbinit.sde, then service restart is required
  • for direct connect the same settings may be set by variables
  • have a look at the ESRI document: ArcGIS Desktop Help 9.3 - the dbinit.sde file
• or the user doing the compression does not have the required privileges. Please cross check your settings with this ESRI document: ArcGIS Server for the Java Platform 9.3 Help

Please let me know what brought the solution for your case.

Kind regards
Dear