Siebel Service Handheld Guide > Troubleshooting >

Using SQLTrace with Siebel Handheld Applications

Use SQLTrace for diagnostic purposes if you encounter serious configuration errors or performance problems and cannot otherwise diagnose the problem. The problem can 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 Siebel Handheld Application 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 Copyright © 2007, Oracle. All rights reserved.