Siebel Medical 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.

NOTE:  SQLTrace can also be enabled for Companion Synchronization too.

To enable SQL tracing

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.

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, MedicalCEObjMgr_enu).
4. Log entries are written as described in Siebel Handheld Application Log Files.