Clicking on the last page/record returns an error attached.

Hello All,

I have created a Portal All task report, and then created a tempo report of that Portal report using a!queryProcessAnalytics. All the filters and pagination is working fine, but when I click on to get the last page/record then it returns an error attached.

Let me know what could be the error, is it something to do with Engine, which is not able to fetch the last page.

Note: The task report has nearly 20000 rows.

Regards,
Vinit.

Portal Report Error.docx

OriginalPostID-155336

OriginalPostID-155336

  Discussion posts and replies are publicly visible

Parents
  • Mean while I present a psuedocode, I would like to give a hint - As and when the a!queryprocessAnalytics see the 10000+ index, it starts throwing an error. So the call to a!queryprocessAnalytics should be always shielded from sending an 10000+ index by opting for alternate approaches such as which we are discussing here. Simply speaking, as and when your pagingInfo is set to an index greater than 10000+, you should do as follows:
    1. Fetch the whole dataset by calling a!queryProcessAnalytics iteratively (with the filters present on interface and with the filters obtained from the grouping report)
    2. Using the todatasubset with the pagingInfo used in the grid, you should obtain the required data and provide it back to the grid.

    In this way we should shield the actual a!queryProcessAnalytics call to original report by making use of the filters (user defined filters and with filters obtained from grouping report).
Reply
  • Mean while I present a psuedocode, I would like to give a hint - As and when the a!queryprocessAnalytics see the 10000+ index, it starts throwing an error. So the call to a!queryprocessAnalytics should be always shielded from sending an 10000+ index by opting for alternate approaches such as which we are discussing here. Simply speaking, as and when your pagingInfo is set to an index greater than 10000+, you should do as follows:
    1. Fetch the whole dataset by calling a!queryProcessAnalytics iteratively (with the filters present on interface and with the filters obtained from the grouping report)
    2. Using the todatasubset with the pagingInfo used in the grid, you should obtain the required data and provide it back to the grid.

    In this way we should shield the actual a!queryProcessAnalytics call to original report by making use of the filters (user defined filters and with filters obtained from grouping report).
Children
No Data