Question

1
Replies
458
Views
 Jacky Yap (yapj1)
PEGA
Sr. System Architect
Pegasystems Inc.
SG
yapj1 Member since 2015 32 posts
PEGA
Posted: January 17, 2018
Last activity: January 18, 2018
Posted: 17 Jan 2018 22:22 EST
Last activity: 18 Jan 2018 9:59 EST
Closed

Using Report Definition for custom aggregation, any limitation? E.g. 10K records?

Hi,

I am using Report Definition to get a list of records that satisfy a given criteria for my custom aggregation and computation (by looping through this list). This is not meant for displayed in the Report Browser.

So far, there is no issue, but I would like to know whether the number of records returned would be truncated? E.g. if the number of returned records is 20000 (for example).

I understand that there is a "Maximum number of rows to retrieve" in the Data Access tab, is there a limit to this entry? Or is this capped by the "pyMaxRecords" in the DSS?

If I were to set "Maximum number of rows to retrieve" as 0, would it enable me to get all the data for iteration?

Thanks and regards,

Jacky

Low-Code App Development Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 18 Jan 2018 9:59 EST
Mohammad Asif Hasan (Asif Hasan)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi,


Thanks for posting on PSC.


There would be performance overhead if you're retrieving all the records in memory or to the clipboard(It will cache it).


As per my knowledge, there isn't any limitation for the "Maximum number of rows to retrieve" in the report definition.You can retrieve all records.


It can be configured from "Reporting: Settings" landing page as well. Navigate, Designer Studio->Reporting->Settings->Settings.


Tune it according to your requirement, it will be applied at the application level. Make sure, you provide tuned "Maximum Elapsed time" in comparison with the number of rows to be retrieved, as database transaction would fail if SQL runs for more time than configured and end up throwing an error.


Hope it helps you to configure your requirement, kindly notify by marking this post as answered/helpful if it does.


Regards,


Asif