We have a Task Report which uses a!queryProcessAnalytics(). On our Production instance, this report is unable to retrieve results

johng373 over 8 years ago

We have a Task Report which uses a!queryProcessAnalytics(). On our Production instance, this report is unable to retrieve results due to receiving the following error: "The report generation was cancelled by the system after 3890 ms. The time limit for generating a report is 2000 ms. (APNX-1-4275-008)]".

Our Production instance has a very large amount of Tasks. I found another note on the forum which mentioned to increase the timeout on the "server.conf.processcommon.MAXIMUM_REPORT_MS". Is this still recommended for 7.11 and if so, are there any potential drawbacks to increasing this timeout? Or, is there a better way to have a report handle a Task Report with a very large amount of data?

Thanks in advance.

Discussion posts and replies are publicly visible

Parents

0 vinitl522
A Score Level 2
over 8 years ago

Hi All, We have All Task Report iin production where we have 70000 rows, outt of which 9000 are of in Assigned and Accepted state..... We have this report in SAIL, and when we try to apply filter by Assigned to Filter, then it does not fetches any result, and at backend we have observed that, time out error for report. How we can resolve this error.

Note: We are fetching the records in batches.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 vinitl522
A Score Level 2
over 8 years ago

Hi All, We have All Task Report iin production where we have 70000 rows, outt of which 9000 are of in Assigned and Accepted state..... We have this report in SAIL, and when we try to apply filter by Assigned to Filter, then it does not fetches any result, and at backend we have observed that, time out error for report. How we can resolve this error.

Note: We are fetching the records in batches.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data