Hi Nagendra,

Ideally SMA should be used to clear the cache if instructed or advised by Pega GCS. DB cache truncation is not advised by Pegasystems unless there is no alternative and it is strongly advised by Pegasystems. Pls perform a full DB backup before clearing the cache table from DB. Better to check with Pega GCS.

DB Query for cache cleaning:

TRUNCATE TABLE PEGA_RULES.PR_SYS_APPCACHE_DEP;

TRUNCATE TABLE PEGA_RULES.PR_SYS_APPCACHE_ENTRY;

TRUNCATE TABLE PEGA_RULES.PR_SYS_APPCACHE_SHORTCUT;

TRUNCATE TABLE PEGA_RULES.PR_SYS_CACHE_DEP;

TRUNCATE TABLE PEGA_RULES.PR_SYS_CACHE_IMPL;

TRUNCATE TABLE PEGA_RULES.PR_SYS_CACHE_ENTRY;

TRUNCATE TABLE PEGA_RULES.PR4_RULE_SYSGEN;

TRUNCATE TABLE PEGA_RULES.PR_ASSEMBLEDCLASSES;

Steps from SMA:

1. Access the System Management Application.
2. Click Advanced > Declarative Rules Management > Clear