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 è stata annullata dal sistema dopo 2748 ms. Il limite di tempo per generare un report è 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
Discussion posts and replies are publicly visible
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.
db_PAX_XXXX-XX-XX.log
Thank you very much, this helps a lot! In these logs you can find the name of the process report which thows the error and also the column(s) or filter(s) which evaluation takes too much time!