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.
LinkedIn
Copied!

Table of Contents

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

Summary

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.
Did you find this content helpful?

Have a question? Get answers now.

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