ANGLINA1 Member since 2005 10 posts
American Express
Posted: February 10, 2020
Last activity: February 11, 2020

Upgrading to PRPC 8.x on Oracle 12c hanging on RulesetCleanup

While upgrading any version of PRPC to 8.* on ORACLE 12c and you have chosen to do a ruleset clean-up configured in the using below option. # RUN RULESET CLEANUP?

# Generate and execute an SQL script to clean old rulesets and their rules from the system.

# To generate the script and not execute it use the cleanup.bat/sh script.


The process uses the option in to create and execute the following file PRPC-RulesetCleanup.sql which causes the upgrade process to hang for hours. After evaluating the issue, it was discovered that two statements were the cause of the issue. The sql is looking for a pzinskey column on the pr_engineclasses which does not exist. Oracle does not through an error it just goes into a loop and eventually you will have to kill the thread.

PEGA need to correct the below two SQL that gets generated in the PRPC-RulesetCleanup.sql.


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

DELETE FROM Schema.pr_engineclasses WHERE (PZCODESETVERSION is not null AND PZCODESETVERSION < '08') AND (PZCODESET = 'pega-enginecode');


Hope this helps going forward until PEGA fixes the matter.

Pega Platform 8.3.1 System Administration
Share this page LinkedIn