Question
Virtusa
AU
Last activity: 1 Mar 2017 2:02 EST
AES distorted view
Hi All,
We have setup AES about an year ago and it was up and running (even though it was quite slow). But off late we are observing that the view is distorted. I have attached the screenshot, please let me know if anyone faced this kind of issue before and how it got resolved.
Note: We are using pega 7.1.7
Cheers,
Satya
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
US
Hi satyakanth,
This could be caching related issue.
Have you tried the following?
- stop the application server.
- Delete the files from the temp directory including marker file (Pega 7.1.7).
- Restart the application server.
Thanks,
Susan
Pegasystems Inc.
US
Hi satyakanth,
Then you need do a further cleanup.
Can you truncate the following tables to clear the ABA cache?
Please do a Database back up before you truncate the below tables.
- stop the application server.
- Delete the files from the temp directory including marker file (Pega 7.1.7).
- Truncate the below tables from the database:
- pr_sys_appcache_dep
- pr_sys_appcache_entry
- pr_sys_appcache_shortcut
- pr4_rule_sysgen
- pr_assembledclasses
- Restart the application server and verify the problem.
Thanks,
Hi satyakanth,
Then you need do a further cleanup.
Can you truncate the following tables to clear the ABA cache?
Please do a Database back up before you truncate the below tables.
- stop the application server.
- Delete the files from the temp directory including marker file (Pega 7.1.7).
- Truncate the below tables from the database:
- pr_sys_appcache_dep
- pr_sys_appcache_entry
- pr_sys_appcache_shortcut
- pr4_rule_sysgen
- pr_assembledclasses
- Restart the application server and verify the problem.
Thanks,
Susan
Virtusa
AU
Thank you for your response Susan!
I'll ask our DBA to perform these steps as I don't have write access to DB. Will let you know once done.
Cheers,
Satyakanth
Virtusa
AU
Hello Susan,
We truncated all the tables but even then the problem persists. And in the logs we had plenty of exceptions as following-
Open during urgency update failed for assignment ASSIGN-INTERNAL PEGAAES-WORK-ACTION DB-20713!PZINTERNALCASEFLOW
And in PDN I also found this link - https://collaborate.pega.com/question/question-article-aes-error-opeaes-error-open-during-urgency-update-failed-assignmentn
So, raised an SR for the same.
Cheers,
Satyakanth
Pegasystems Inc.
IN
Hi Satyakanth,
Thank you for updating your post with this information. Do you mind letting us know the SR ID here? We will tag that with this post and track it until closure!