Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Troubleshooting database requests

Updated on July 8, 2022

The Pega Platform database performance is a major factor in overall system performance, affecting response time for interactive, browser-based users, turnaround time for services, and throughput. You can use tools provided by Pega Platform to help you debug, trace, and analyze requests from the server to the Pega Platform database.

You can do the following:

  • Use the Clipboard tool to view the pyReportContentPage page. It shows the pxSQLStatementPre and pxSQLStatementPost properties that contain the SQL statement that ran. These values are available after your run a report definition rule. The pxResultCount property shows the number of rows returned. Use the Clipboard tool to view these values.
  • Use the Detail window of the Performance tool to view statistics for each user interaction since sign-on. For example, you can see the elapsed time (in seconds) that this user spent retrieving non-rule-resolved instances from the database.
  • Use the Database Trace facility, accessed from the Performance tool Summary display, to create a trace of all database requests from your session.
  • Generate a complete trace of all database requests by enabling the database/dumpStats entry in the prconfig.xml file or dynamic system settings.
  • Use the Alert log to can find those database operations that required an unusually long time to process.
  • Starting a database trace

    The Database Trace tool produces a text file containing the SQL statements, rule cache hit statistics, timings, and other data that reflect your requestor session's interactions with the Pega Platform database or other relational databases. You can select the database options that are traced. Familiarity with SQL is required to interpret the output.

  • Preventing truncated property values

    When data values to commit to the database contain more characters than the corresponding column width in the database table, they are truncated when the object is committed to the database table. The system puts a warning message in the Pega log, truncates the data to the column width minus 1, adds a plus sign (+) to the end of the value, and saves the revised data.

  • Debugging database schemas

    By default, Pega Platform displays extensive details about SQL operations on the Pega Platform database that fail. This information is used for debugging.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us