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 karthiksaik over 8 years ago

You can select and hit with query only few columns that your are displaying in the report so that the report wont hit on all the columns this will reduce the time taken to fetch.

selection: a!querySelection(
columns: {
a!queryColumn(field: "Column1"),
a!queryColumn(field: "Column2")
}
),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 karthiksaik over 8 years ago

You can select and hit with query only few columns that your are displaying in the report so that the report wont hit on all the columns this will reduce the time taken to fetch.

selection: a!querySelection(
columns: {
a!queryColumn(field: "Column1"),
a!queryColumn(field: "Column2")
}
),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data