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 Asif,
Thanks for your message. I have gone through on this link already. However i could see there are few additional tables in our database.
I will go through the additional tables along with the above queries to delete the rulesets.
Thanks,
Veera
Accepted Solution
Hello again,
we have gone through the list of tables and found few more listed below. By deleting the rules from these tables we were able to complete our task.
| pr4_fieldvalue |
| pr4_rule |
| pr4_rule_declarepages |
| pr4_rule_file |
| pr4_rule_file_binary |
| pr4_rule_flow |
| pr4_rule_html_property |
| pr4_rule_library |
| pr4_rule_message |
| pr4_rule_property |
| pr4_rule_ruleset |
| pr4_rule_section |
| pr4_rule_shortcut |
| pr4_rule_vw |
Thanks,
Veera
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