Skip to main content

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.

Support Article

Multiple queries on pr4_rule_property related to Connect REST

SA-35267

Summary



Administrators see the following query executing around 250000 times in a 12 hour span, and ALERT log entries are seen for the query:

SELECT pyPropertyName AS "pyPropertyName", pyPageClass AS "pyPageClass", pyPropertyMode AS "pyPropertyMode" FROM MYSCHEMA.pr4_rule_property "property" WHERE (pxObjClass = 'Rule-Obj-Property') AND (pyClassName = ?) AND (pyRuleAvailable = 'Yes') Total


Error Messages



PEGA0005 and PEGA0042 alerts.


Steps to Reproduce



Not Applicable


Root Cause



A defect in Pegasystems’ code or rules where Connect REST calls resulted in multiple queries against the pr4_rule_property table.

Resolution



Apply Hfix-28691

Suggest Edit

Published March 26, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us