Export to Excel retrieves only one result from report definition
The exported Excel file contains a single record when the report results are large (more than 10000).
Steps to Reproduce
- Run a report definition which fetches 5K or 10K records.
- Navigate to Actions.
- Click Export to Excel. Verify the number of records in the downloaded Excel file
In Pega 7.3, the default number of records retrieved from the database and written to the Excel document at a time is 5000. Additionally, according to Export to Excel implementation, if the query to export data takes long, only the timeout after a row is written is checked. If the deadline has passed, the file is truncated and exported as is. As a result, only one row displays.
Perform either of the two local-changes:
- Open the report definition Data Access tab.
- Increase the duration of the 'Maximum elapsed time in seconds for export' column to 120.
Change the pyExportNumberOfRecordsAtATime system setting to 20000.