Question

1
Replies
567
Views
Close popover
Srinivas Kolusu (SrinivasK3814)
Consolidated Edison Company of New York Inc

Consolidated Edison Company of New York Inc
US
SrinivasK3814 Member since 2018 1 post
Consolidated Edison Company of New York Inc
Posted: April 25, 2018
Last activity: April 26, 2018
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 Upgrades
Moderation Team has archived post