to be able to check which activities still be used I am looking for an algorithm to check the cache (table) if and when they has been used. We are working at Pega 7.2.2. and see some strange things in our environment:
I see the activities are (still) in the PR_SYS_CACHE_IMPL in the PegaData schema (with was used before split schema but seems to be not cleared or removed during the upgrade from 6.2 to 7.2.2. But I don't see any activity record in the same table in the PegaRules schema. I am able to see some of them in the pr_sys_rule_impl table but those are very less than compared to the PR_ASSEMBLEDCLASSES. So I am a little bit confused what can help me to check if the activity has been used (compiled) in our Production environment.
Anyone who can help me with this?
***Edited by Moderator Marissa to add Capability tags***
With split schema, all caching related tables should be coming from PegaRules schema. If there are data in PR_SYS_CACHE_IMPL from PegaData, those data maybe old and not needed. For 7.2.2 and later, the caching of Activity rule type is done via PR_SYS_RULE_IMPL (VTable). So if you are looking for a table to check if an Activity is used by an application or not, this is the table to check. But please note, not finding any data related to an Activity in PR_SYS_RULE_IMPL doesn’t mean the application is not using that activity. It only means the system have not used it yet. For example, the activity is only used when a condition is met and application never went down that path yet.
As for PR_ASSEMBLEDCLASSES, it is expected for this table to have more rows. This table is used to store the generated Java and compiled classes. This is not a rule assembly caching table like PR_SYS_RULE_IMPL (VTable), PR_SYS_APPCACHE_XXX (ABA), or PR_SYS_CACHE_XXX (legacy) tables.