FLUSH CACHES in database
Hi,
Can i have a list of tables for PEGA 8.8.3 to truncate to flush all PEGA caches?
A customer have a lot of pk violation for pr_assembledclasses_pk in pr_assembledclasses table....
I want to clean all caches to fix this problem.
Regards,
***Edited by Moderator Rupashree S. to add Capability tags***
Accepted Solution
Updated: 29 May 2024 13:48 EDT
Pegasystems Inc.
GB
@tankm If the issue only relates to static content, than you can follow the steps given here.
You shouldn't have to flush cache tables in Pega 8.8.3.
The symptoms you describe should be investigated by our support team:
"A customer have a lot of pk violation for pr_assembledclasses_pk in pr_assembledclasses table...."
---> Please have them log a support issue with GCS via the MSP, rather than truncate system tables.
Please provide the INC ticket here so that we can help track it.
ORA-00001: unique constraint Errors when monitoring
Do not modify or truncate critical System tables
Managing inactive branches in branched application development [SDR-A1]
Troubleshooting Rule Utility Function issues
@tankm If the issue only relates to static content, than you can follow the steps given here.
You shouldn't have to flush cache tables in Pega 8.8.3.
The symptoms you describe should be investigated by our support team:
"A customer have a lot of pk violation for pr_assembledclasses_pk in pr_assembledclasses table...."
---> Please have them log a support issue with GCS via the MSP, rather than truncate system tables.
Please provide the INC ticket here so that we can help track it.
ORA-00001: unique constraint Errors when monitoring
Do not modify or truncate critical System tables
Managing inactive branches in branched application development [SDR-A1]
Troubleshooting Rule Utility Function issues
Deleting the DB cache after the rules import is mandatory?
Also please see:
If the information detailed in Changing the default keystore caching settings Pega 8.X Cache Settings , Preassembling rules in an application , Savable data pages and Cache Exceeds Limit. could be improved, please could you use the 'Feedback' button on one of those articles in order to put forward your suggestion?
That is the the most direct way to contact our documentation team for the relevant subjects.
Note: Two enhancement requests exist for this in case you wish to discuss these further with your Pega AE:
FDBK-111449 (No 'Cache management' documentation for Pega 8, Infinity '23)
FDBK-111448 (Need ability to clear lookuplist cache from UI in Pega 8)