Siebel Service Handheld Guide > Troubleshooting >


Use SQLTrace for diagnostic purposes if you encounter serious configuration errors or performance problems and cannot otherwise diagnose the problem. The problem may quickly become apparent in the log entries from SQL tracing.

To enable SQL tracing

  1. Log into srvrmgr prompt.
  2. At the DOS prompt, run server manager (srvmgr) from the <siebsrvr/bin> directory:
    srvrmgr /g gateway /e enterprise /u sadmin /p sadmin
  3. Run: change evtloglvl ObjMgrSqlLog=4 for comp [OMName], where [OMName] = the OM name (for example, ServiceCEObjMgr_enu).
  4. Log entries are written as described in Log Files.

    CAUTION:  When SQL tracing is enabled, synchronization is severely and adversely affected. Therefore, it is recommended that you turn SQL tracing on for a limited time to diagnose a specific problem, then turn SQL tracing off.

Siebel Service Handheld Guide