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

System hanging on Ruleset Cleanup

SA-89168

Summary



While executing an upgrade, the process hangs on performing a ruleset Cleanup from the setupdatabase.properties. The upgrade process hangs on the Delete statement in the below step in the PRPC-RulesetCleanup.sql.

DELETE FROM RULES.pr4_rule_vw WHERE PZINSKEY IN (SELECT PZINSKEY FROM RULES.pr_engineclasses WHERE (PZCODESETVERSION is not null AND PZCODESETVERSION < '08') AND (PZCODESET = 'pega-enginecode'));


Error Messages



Not Applicable


Steps to Reproduce



Execute the upgrade process.


Root Cause



A defect in Pegasystems’ code or rules.

The generated SQL statement was incorrect. The pr_engineclasses did not have the pzInsKey. Hence, the process took long to complete. The Delete statement incorrectly deleted rows from the pr4_rule_vw table.


Resolution



Perform the following local-change: 

Kill the Delete at the database level and the upgrade will continue correctly.

As a post upgrade step, execute the prpcUtils.sh Expose command using the below properties set in prpcUtils.properties to populate the pr4_rule_vw table. Specify the database credentials details in the properties file similar to the upgrade process. expose.classes.included=Rule- 
expose.included.descendent=true 
expose.reindex=false 
expose.reindexType=full 
expose.update.rule.summary=true
Suggest Edit

Published December 2, 2021

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