English

Error: SDE_Oracle Error: ### during sdesetup

Error Message

If SDEVERBOSE is turned on when the ArcSDE command sdesetup runs, the application will display errors on the console as it looks for pre-existing tables, sequences, and packages. These errors are also trapped and handled by the program; they are not fatal. However, the messages are numerous and might be misleading in that it may seem sdesetup failed, when in fact, it ran correctly.

Below are some examples of errors that may display:

"SDE_Oracle Error: 942
ORA-00942: table or view does not exist"

"SDE_Oracle Error: 2289
ORA-02289: sequence does not exist"

"db_sda_execute_stmt::OCIStmtExecute (6550)
.SDE_Oracle Error: 6550
ORA-06550: line 1, column 27:
PLS-00201: identifier 'SDE.SDE_UTIL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"

Cause

The 'set SDEVERBOSE=1' option is set in the $SDEHOME/etc/dbinit file on the ArcSDE server. This line signals the ArcSDE server to write non-fatal error messages to the $SDEHOME/etc/sde.errlog and to the console that would normally not be issued. This option is generally used for debugging.

Note:
This article is specific to sdesetup. The errors cited above are safe to ignore. If errors are encountered in a production environment, contact ESRI Support Services.

Solution or Workaround

  1. Comment out the SDEVERBOSE statement in the $SDEHOME/etc/dbinit file.
  2. Stop and restart the ArcSDE service.
    <a href='http://support.esri.com/en/knowledgebase/techarticles/detail/19717' target='_blank'>[O] Windows Services panel</a>
  3. Run the sdesetup command with the appropriate options.

    Note:
    Refer to the ArcSDE Developer Help ArcSDE Administrator Command References for proper usage of the sdesetup command.


    Contact ESRI Support Services if errors are encountered after disabling SDEVERBOSE and rerunning the sdesetup.