Query Process Analytics getting time out

shailjas over 8 years ago

Hi,
We have a task report, even if the filters are applied to the report it is fetching all the data.
Since the number of active tasks for the application is more than 1000, it increases the CPU utilization.
We are receiving some warning logs because of this.
snippets from the logs : "Total: Total (Report named 'CIC Tasks Report' (report document id 14972), maximum report time 2000ms) affected 694 rows"
To reduce this we are thinking of reducing the unnecessary columns from the report and to increase the timelimit in custom.properties for this.
Can someone help regarding this.

Discussion posts and replies are publicly visible

Parents

0 Alok Mohare
Appian Employee
over 8 years ago

Review the following link from our Documentation to tackle the issue of Portal Reports that are timing out.
forum.appian.com/.../Report_Performance_Details.html

Do not increase the Report timeout limit in custom.properties. This may cause further degradation in performance.

My suggestion would be to work on optimizing the existing report that you have.
forum.appian.com/.../Report_Performance_Details.html

You can check the "Report Performance Details" to figure out what columns take the most amount of time to populate and work on optimizing the expressions within those columns.

Hope this helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Alok Mohare
Appian Employee
over 8 years ago

Review the following link from our Documentation to tackle the issue of Portal Reports that are timing out.
forum.appian.com/.../Report_Performance_Details.html

Do not increase the Report timeout limit in custom.properties. This may cause further degradation in performance.

My suggestion would be to work on optimizing the existing report that you have.
forum.appian.com/.../Report_Performance_Details.html

You can check the "Report Performance Details" to figure out what columns take the most amount of time to populate and work on optimizing the expressions within those columns.

Hope this helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data