HI Shweta,

Please go through this link. It might help.

https://collaborate.pega.com/discussion/remove-duplicate-values-pagelist-using-same-pagelist

Thanks,

Neha

Hello Shweta,

Please have a look on the below link :

https://community.pega.com/support/support-articles/unable-delete-private-checkout-rules

Let me know if it helps.

Hi Shwetaaa,

This issue we have faced few times. I'm not sure about the root cause of this but I've noticed I can access the rule when I use a different node in same environment. So it might be some node specific cache issue. As an escape route you can either delete this rule using an admin activity or executing a delete query in database directly if you have the permission.

Thanks 

Sumit Kumar Bhowmik

Hi

Can you check your tracer or log to see what is going wrong and share your observation ?

You can login with the person who has this rule checked out and use bulk actions to delete check out if rule is not opening directly.

Let us know if this helps.

Do Revalidate and save of that particular rule. It might be corrupted

Hi Shweta,

There should be unlock option in Actions tab of that rule, you will be able to delete that once you unlock it.

Srini

You  should login with the same credentials to whom it had checked out.

Hi All,

The rule is no longer exist and got corrupted. I do not have database access where i can delete the rule record neither pzInskey of the rule. In this senario any advice to delete the rule.?

Thanks,

Shweta

Hi Shweta,

Please use connect-sql rule for deleting the corrupted rule on giving pzInskey from pr4_rule. Let me know, if anything else required.

Thanks,

Prudhvi

Hi Shwetha,

@Prudhvi_N, We cannot create Connect-SQL on internal tables. 

@shwetha, Can you please let us know if you have tried to know who checked out the particular record and ask them to check out or discard the rule. 

If you can't find them, I'm afraid you'll have to delete the rule entry in pr4_rule and also delete the same from the table pwbv4_rule_locking. All checked out rules are present in the user specific ruleset. The ruleset of the checked out rule will be operator ID. Using the above statement we can find the checked out rule and delete it.

Hi Chatr,

We have to delete the rule entry from pr4_rule_property table, not pr4_rule.  Under circumstances, we can use connect-sql for internal tables as well.

Thanks,

Prudhvi

Hi Prudhvi,

Just wondering, did Shweta mention that the corrupted rule is a property? (If she mentioned that the rule is a property I'm pretty sure there is some problem with PDN loading comments in my login). Coz, only property rules will be saved under pr4_rule_property table. As the size of properties, flows etc are large, for faster query execution we save some rule types in separate tables rather than pr4_rule. If the corrupted rule is a property, then yes, we have to delete it from pr4_rule_property table.

Now, coming to the connect-SQL rule, They are meant for external database tables. Yes, we can create the connector directly using the create menu on internal tables and we can execute them. But that is not a recommended approach. If you use connector and metadata wizard to create the connector, it will not allow you to create the connector on tables which contain keys starting with px,py,pz.

Please go through the following help document where the use of connect-SQL is provided (https://community.pega.com/sites/default/files/help_v721/procomhelpmain.htm)

Hi did Revalidate and Save didnt work ?

Hi,

Try clearing up the cache and do a 'revalidate and save'. If doesn't work check the error/exception in the tracer.

Please try it in a private window. It may be because of cache.

Hi Thanks all for providing the answer. I have tried the below approaches:-

1) I have tried "revalidate and save" option.

2) tried login with the same user who has checkedout the rule but no luck as rule doesnt exit. Getting below error

There has been an issue; please consult your system administrator.

3) This is a report defination rule.

Thanks

Hi Thanks all for providing the answer. I have tried the below approaches:-

1) I have tried "revalidate and save" option.

2) tried login with the same user who has checkedout the rule but no luck as rule doesnt exit. Getting below error

There has been an issue; please consult your system administrator.

3) This is a report defination rule.

Thanks

Hi Shwethaa,

Raise a Pega Product support SR for the same

Hello!

Let us know if you do log an SR for this and its ID. That way we can track it and follow-up this discussion with the resolution.

Regards,
Lochan  |  Community Moderator  |  Pegasystems Inc.

We had similar issue as some of the rules got corrupted. Since we wanted to use the same name as the rule was being referred in multiple places, we had to delete and recreate the rule. We wrote a simple activity with following steps to delete the rule.

1. Open the object (obj-open) , pass the rule name and class name of the rule instance type for example to delete a data flow open class Rules-Decision-DDF

2. Obe-Delete

Attached a screenshot for reference..