Question3Replies45Views AkashS1762 Member since 2016 26 posts VirtusaPolaris Posted: April 17, 2019Last activity: April 17, 2019 Closed pyInteractionHistory is not loadingHi,When I am opening interaction history Configure->Decisioning->Monitoring->Interaction History in Pega 8.1.3, no record is loaded.I can see below errors in the log file"An error occured on executing the query for the report definition - There was a problem getting a list: code: 1013 SQLState: 72000 Message: ORA-01013: user requested cancel of current operation."Why suddenly it is taking long time to load? Before that it was working fine.Thanks,Akash Pega Marketing Low-Code App Development ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year agoKevinZheng_GCS PEGA replied to AkashS1762This is because IH table accumulates as more IH history is collected. The SQL error simply means that it takes long time complete the report. Regular archiving and cleanup of the IH table should be performed. Here is an example: https://community.pega.com/support/support-articles/archive-process-interaction-history-data-slowing-performance Posted: 1 year agoAkashS1762 VirtusaPolaris replied to KevinZheng_GCSHi Kevin, I removed pagin from pyInteractionsHistory and set no of records to fetch as 50. Still facing the same issue. In that scenario also, the reason is same? Thanks Posted: 1 year agoKevinZheng_GCS PEGA replied to AkashS1762To be sure, capture the actual long running query. Then execute it from an independent sql client/explain plan, the normal troubleshooting steps (work with your DBA).