Question
Report Definition not fetching all the records from the table without pagination
Hi Team,
We need to query around 80,000 of data from DB and process those records alos export the data into excel as well, we have used Report Definition to fetch the values, we are able to fetch the entire records when we use Pagination enabled, but for our legacy application needs an entire data result set to copy into another page reference to process the data, we are not able to fetch more than 10,000 records without pagination. We are getting timed out ,same for export to excel as well more than 10,000 records count to load we are getting timed out.
We have updated the Reports Settings(DesignerStudio->Reports-Setting) and in Report Definition Data Access tab as well.
Maximum number of rows to retrieve 50000
Maximum elapsed time (in seconds) for database query 300
Please provide any suggestion for the above need, we are using Pega 7.4 version.
Thanks,
Dhilip
Thanks for your suggestion,Yes we are able to fetch more than 50K of records from DB view, but the same amount of data we are not able to display it in excel and pdf when we select export to excel and export to pdf.
In report setting its 200000 for retrieve and Maximum elapsed time gave 300 number of rows export at a time 5000.
below the Maximum record count were displayed in excel and pdf.
For Export to Excel : 10,000
For Export to PDF : 4,500
Is there any option to retrieve entire data into excel and pdf.
Thanks,
Dhilip
Could you please check the value for the pyExportMaxRecords System Settings if it is 10,000 and change it to the required number.
I hope all the columns are optimized, which will help you with better performance.
Include all descendant classes that can be unchecked, if not relevant.
Exclude any formatting configured in the report columns
Another alternative (preferably not recommended) is to create a DB view and configure Report on the same