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

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.

OriginalPostID-213190

  Discussion posts and replies are publicly visible

Parents
  • 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.
Reply
  • 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.
Children
No Data