Rule Ins Key of Rule Cache Management
Hi Team,
I need to know where the Rule Ins Key and also all the Rule Cache management details are stored (in which database table). Kindly Please suggest a solution.
***Edited by Moderator: Marissa to update categories***
Pegasystems Inc.
IN
Is there any specific reason on why you are looking for table mapping for these details ? Rule Cache management details can be accessed via SMA and reports can be downloaded from there.
Pegasystems Inc.
US
Hi Birundha,
It is from SMA > Advanced > Rule Cache Management (it contains instance cache report / rule resolution report / rule identities report)
Regards
Mahesh
Cognizant
IN
Hi mahesh, I need to find out where the rule ins key is stored (in which database table) . Will i get it from these reports? I already checked these three databse tables and no rule ins key is found (pr_sys_cache_dep , pr_sys_cache_entry , pr4_log_rule_usage). Please suggest a solution asap.
Regards,
Birundha
Pegasystems Inc.
US
Hi Birundha,
What is the purpose of knowing rule ins key related to the cache tables, may i know your exact requirement behind knowing the rule ins key.
Regards
Mahesh
Cognizant
IN
We are trying to build up statistics on rule execution report. Log-RuleUsage(pr4_log_rule_usage) and Log-RuleUsage-Details(pr4_log_rule_usage_details) does have pxUseCount, pxLastUse, pxFamilyName, pxClassName etc fields. From there Rule Name and Rule
Type could be figured out, but if multiple rule exist with same name for same rule type in different Classes and Rule sets it's getting difficult to identify rule uniquely. We are looking forward the way to find out Rule Ins Key. If it could be captured along with other details it would be very helpful.
Basically we are trying to generate a report which will explain which rules are being executed and which are not. If executed then how many times and what was last accessed date time.
Step To Reproduce:
1. Select Log-RuleUsage/ Log-RuleUsage-Details class in App Explorer and click on instances
2. Open any instance from there and take a note on fields like pxUseCount, pxLastUse, pxFamilyName, pxClassName
3. But could not locate Rule Ins Key there
In SMA
1. Click on Advanced > Rule Cache Management
2. Under "Rule Cache Detail" Rule Type and Rule Name input fields are there
3. Once provided Rule pxObjClass and Rule Name and clicked on "Rule Cache Detail" it's pulling out details from Cache along with Rule Ins Key
4. Which table these details are being captured.
We are trying to build up statistics on rule execution report. Log-RuleUsage(pr4_log_rule_usage) and Log-RuleUsage-Details(pr4_log_rule_usage_details) does have pxUseCount, pxLastUse, pxFamilyName, pxClassName etc fields. From there Rule Name and Rule
Type could be figured out, but if multiple rule exist with same name for same rule type in different Classes and Rule sets it's getting difficult to identify rule uniquely. We are looking forward the way to find out Rule Ins Key. If it could be captured along with other details it would be very helpful.
Basically we are trying to generate a report which will explain which rules are being executed and which are not. If executed then how many times and what was last accessed date time.
Step To Reproduce:
1. Select Log-RuleUsage/ Log-RuleUsage-Details class in App Explorer and click on instances
2. Open any instance from there and take a note on fields like pxUseCount, pxLastUse, pxFamilyName, pxClassName
3. But could not locate Rule Ins Key there
In SMA
1. Click on Advanced > Rule Cache Management
2. Under "Rule Cache Detail" Rule Type and Rule Name input fields are there
3. Once provided Rule pxObjClass and Rule Name and clicked on "Rule Cache Detail" it's pulling out details from Cache along with Rule Ins Key
4. Which table these details are being captured.
5. From Log-RuleUsage we can get Rule Type and Rule Name. Is there any way to get Rule Ins Key from Cache the way it's working in SMA
Regards,
Birundha M
Pegasystems Inc.
US
Hi Birundha,
Thanks for sharing your requirement clearly. I had cross checked with our product specialists and came up with two suggestions from them:
- You can enhance com.pega.pegarules.management.internal.RuleCacheManagement MBean by using the provided operations as shown in attachment.
- Else kindly raise an enhancement request with the product team for your requirement.
Hope this information might be helpful to you.
Regards
Mahesh
Cognizant
IN
Hi Mahesh
Thanks for your response
Our objective is to get Use Count, Last Used DateTime from Log-RuleUsage instances. But there is no
"Applies To Class", "Ruleset" and "Ins Key" details available for a Rule in list of attributes of
Log-RuleUsage instances. So it's getting difficult to identify from Log-RuleUsage instances which
rule it's associated with. Is this possible to include those three columns along with existing
attributes for Log-RuleUsage/ Log-RuleUsage-Detail instances as part of an product enhancement request.
Regards,
Birundha
Pegasystems Inc.
IN
Hi Birundha,
Please let us know if you would like for us to raise an enhancement request on your behalf.
Regards,