Post pega upgrade to 8.4.0, the file listener that runs for 16 mins earlier started running for more than 90 minutes and causing time out issue which makes the remaining 7 file listeners to fail in the batch.
I see the below alert:
Database operation took more than the threshold of 100 ms: 2.702 ms SQL: select 1 from XYZ.pr_sys_app_hierarchy_flat where pzTopAppHash = ? and pzAppHash = ?*”
and much more similar pr_sys_app_hierarchy_flat alert.
***Edited by Moderator Marissa to update Content Type from Discussion to Question***