SYMPTOM:
After executing a ’PURGE CACHING' script in Strategy Administrator - Command Manager 9.x and 10.x, users are not able to access any History List message.
When opening a History List message, the following error is shown:
Cached report result not found in server report cache. It may be deleted by server administrator.
CAUSE:
This issue occurs because the script deletes all caches regardless of the cache type. This means that caches linked to History List messages are deleted too. The full syntax for the command is as follows:
PURGE CACHING IN ( PROJECTS | "<project_name>");
As can be seen from the syntax there is no syntax for separating Matching, History, or both types of caches.
ACTION:
Instead of using the 'PURGE' command, use the 'EXPIRE' command in Strategy Administrator - Command Manager 8.x, as shown below:
EXPIRE ( REPORT CACHES | REPORT CACHE "<cache_name>") IN PROJECT "<project_name>";
The 'EXPIRE' command will not delete the caches that are linked to History List messages, instead all caches will have the expired flag set which will clean up all 'Matching' caches and leave 'History' caches still available, as shown below:
