Question

1
Replies
581
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.