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
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?
Hello Teresa,
thanks for your hint. Unfortunately this is not the case. We have very little process reports which are executed by a process model.
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!