Siebel ePharma Handheld Guide for Windows-Powered Devices > Troubleshooting >

SQLTrace

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, set the EnableSqlTrace parameter in the .cfg file. By default, EnableSqlTrace=FALSE, and SQL tracing is disabled. Set EnableSqlTrace=TRUE to enable tracing. Log entries are written to the hhsync.*.log server log file.

NOTE:  SQL tracing only logs SQL statements for one user at time. SqlTrace is applied to the first user who synchronizes after tracing is enabled.

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 ePharma Handheld Guide for Windows-Powered Devices 
 Published: 18 July 2003