Question
Delete ruleset version query for 7.3 PRPC
Hi,
Recently we have upgraded from 6.3 to 7.3 (Split Schema).
We run into the same issue in 6.3 while deleting the ruleset version. Please refer the previous post.
https://pdn.pega.com/community/product-support/question/unable-delete-rsv-63-sp1-version
We had got the deletion queries to delete the rules from different tables.
https://pdn.pega.com/how-delete-ruleset-using-sql-statements/how-delete-ruleset-using-sql-statements
However we see additional tables after upgrade to 7.3 (pr4_rule_section, pr4_rule_flow etc..)
do we have a new queries list for latest version please?
Thanks,
Veera
***Updated by moderator: Lochan to add Categories***
Hi VeeraSaddala,
Thanks for posting on PSC.
In one of the latest Support article, I have found an updated table list for Pega 7.2.2. It's much latest than PRPC 4.x as mentioned in the above link. So, I think they are enough though not sure.
SQL> delete from pr4_base where pyRuleSet = ‘AbcdEfg’ and pyRuleSetVersion = ’01-01-04’
SQL> delete from pr4_fieldvalue where pyRuleSet = ‘AbcdEfg’ and pyRuleSetVersion = ’01-01-04’
SQL> delete from pr4_rule where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
SQL> delete from pr4_rule_file where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
SQL> delete from pr4_rule_flow where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
SQL> delete from pr4_rule_property where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
SQL> delete from pr4_rule_sysgen where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
SQL> delete from pr4_rule_vw where pyRuleSet = 'AbcdEfg' and pyRuleSetVersion = '01-01-04'
Reference:-https://pdn.pega.com/support-articles/sql-query-required-delete-particular-ruleset-version
Hope it helps, if it does kindly notify for larger Pega audience.
Regards,
Asif