Support Article
Delete script deletes Pega 8 rules
SA-103910
Summary
The Delete script which the Pega application generates to remove Pega rules prior to Pega Platform 8, also deletes the Pega Platform 8 rules. As a result, the rules are inaccessible. Since the rules do not display in the Records Explorer and the App Explorer, the Elastic Search does not work correctly.
For example,
The below Pega generated script statement deletes Pega Platform 8 rules without an additional When condition for the pr4_rule_vw table, which is WHERE PYRULESETVERSION < '08'.
DELETE FROM PEGA_DP3_RULES_A.pr4_rule_vw
WHERE PZINSKEY IN
(SELECT PZINSKEY
FROM PEGA_DP3_RULES_A.pr_engineclasses
WHERE (PZCODESETVERSION is not null
AND PZCODESETVERSION < '08')
AND (PZCODESET = 'pega-enginecode'));
This occurs post upgrading Pega Platform 7.1.8 to Pega Platform 8.3.1 during the after-action Unit Testing and CleanUp.
Error Messages
Not Applicable
Steps to Reproduce
- Have the upgrade produce the Delete script .
- Change the DELETE to SELECT *. All the Pega 8 rules are deleted along with the earlier version of the Pega rules.
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Perform the following local-change:
Add the front end of the SQL with ‘WHERE PYRULESETVERSION < '08'.
This feature is implemented in Pega Platform 8.3.2.
Published July 25, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.