Question

1
Replies
553
Views
SrinivasK3814 Member since 2018 1 post
Consolidated Edison Company of New York Inc
Posted: 2 years ago
Last activity: 2 years 6 months ago
Closed

Rules clean up Scripts after skimming

Hi All,

We are planning a major Infrastructure Upgrade along with Pega Upgrade from 7.2 to 7.3 for our Application. We have a huge code base and we are planning to a major version Skim and code base cleanup. I have verified for some DB scripts in PDN and I found the below. Can anyone help me if the below are fine?

DELETE FROM RULES.pr_sys_decchg WHERE PXRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PXRULESET LIKE 'Pega-%';
DELETE FROM RULES.pr4_rule_property WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';
DELETE FROM RULES.pr4_rule_file WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';
DELETE FROM RULES.pr4_fieldvalue WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';
DELETE FROM RULES.pr4_rule WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';

DELETE FROM RULES.pr4_rule_flow WHERE PYRULESETVERSION < '05-04' AND PXOBJCLASS LIKE 'Rule-%' AND PYRULESET LIKE 'Pega-%';

It would be really helpful if some one share me the list of scripts in correct order of execution for Code base clean up after skimming?

***Updated by moderator: Lochan to move post from Applications to PSC***

System Administration Data Integration Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn