Delete script deletes Pega 8 rules
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.
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
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.
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.
A defect in Pegasystems’ code or rules.
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.
0% found this useful