Timeout error in executing Process Report

Question

Hello,
yesterday we lowered our process report timeout limit from 5000 to the standard 2000 ms but now we see a lot of errors in our log. The errore are like the following.
2021-06-01 12:43:00,375 [Appian Work Item - 147135 - execution00 : ExpressionGroupRequest] ERROR com.appiancorp.expr.server.fn.query.QueryProcessAnalytics - La generazione del report &egrave; stata annullata dal sistema dopo 2748 ms. Il limite di tempo per generare un report &egrave; 2000 ms. (APNX-1-4275-008)com.appiancorp.suiteapi.common.exceptions.AppianException: The report generation was cancelled by the system after 2748 ms. The time limit for generating a report is 2000 ms. (APNX-1-4275-008)

Is there a way to identify which is the report which is throwing this error in order to improve its performance? We have a lot of process reports in our environment and they all seem efficient. I think that the issue is caused by some filter in some queryProcessAnalytics rule, but how to identify which?
This error doesn't seem to affect user experience and we have no process errors.
Any hint would be greatly appreciated.
Lorenzo

gayathris111098 · Accepted Answer

Hi Appian maintains some logs especially analytics engine log db_PAX_XXXX-XX-XX.log and the timestamp of when the issue was reproduced. You can try there.

theresaa0002 · Answer

if the reports are running from process model, you can check out the process instance that ran around 12:43 AM on 6/1/2021 and see which node stalled. Are your reports running in processes?

Sign up

Login with SSO

Login to the community

Login with SSO