Skip to main content

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

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Troubleshooting: Unexpected large numbers of queries to pr_engineclasses table causes unnecessary DB traffic (HFix-4114)

Updated on September 25, 2019


As a database administrator (DBA), you run a Top SQL database report to identify the SQL statements that are producing the highest load on the system. The report reveals an unexpected and excessive number of queries to the pr_engineclasses table coming from PRPC 6.1 SP2.

Problematic Query Syntax

select pzbinarycontent, pzstate

from pr_engineclasses

where pzpackage = ? and pzclass = ? and pzjar = ? and pzcodeset = 'pega-enginecode' and pzcodesetversion = ?

ORDER BY pzpatchdate DESC

HFix-4114 for PRPC 6.1 SP2 changes the implementation to eliminate the unnecessary queries to the pr_engineclasses table which were causing excessive DB traffic.

Suggested Approach

  1. Contact Pegasystems Global Customer Support (GCS) and request HFix-4114.jar for PRPC 6.1 SP2.
  2. Follow the instructions in the ReadMe.txt file included with the hotfix.
IMPORTANT: You must contact Pega GCS to obtain HFix-4114.jar for PRPC 6.1 SP2, because the nature of this update precludes it from being installed with the Update Manager.
  • Previous topic Troubleshooting: JVM hangs on conclusion cache read or update (HFix-10223 replaces HFix-8969)
  • Next topic Known Issues

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. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us