Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Export to Excel retrieves only one result from report definition

SA-68967

Summary



The exported Excel file contains a single record when the report results are large (more than 10000).


Error Messages



Not Applicable


Steps to Reproduce

  1. Run a report definition which fetches 5K or 10K records.
  2. Navigate to Actions.
  3. Click Export to Excel. Verify the number of records in the downloaded Excel file


ROOT CAUSE 

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.


Resolution



Perform either of the two local-changes:
  1. Open the report definition Data Access tab.
  2. Increase the duration of the 'Maximum elapsed time in seconds for export' column to 120.
Or,

Change the pyExportNumberOfRecordsAtATime system setting to 20000.
Suggest Edit

Published January 3, 2019 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us