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 issue in Report Definition

SA-72638

Summary



When performing Export to Excel from a report definition, error occurs intermittently. Additionally, all the rows are not exported.


Error Messages


 

There has been an issue. Please consult your system administrator.


Steps to Reproduce


 

Export to Excel in the report definition.


Root Cause



A defect in Pegasystems’ code or rules.

The issue occurred due to the following:
  1. HTTP interaction exceeded the elapsed time alert threshold of 1000 ms: 5262 ms.
  2. Out of heap space.
  3. Caused by: java.lang.IllegalArgumentException: The maximum length of cell contents (text) is 32,767 characters

Resolution



Perform the following local-change:

1. HTTP interaction exceeded the elapsed time alert threshold of 1000 ms: 5262 ms. This indicates that the query took long to run. Perform the below steps for this issue,

        (i). Open the report definition > Data Access Tab.
        (ii). Increase the values for the following parameters:

  • Maximum elapsed time in seconds
  • Maximum elapsed time in seconds for export
        Reduce the values for the following parameter:
  • Maximum number of rows.

2. According to the length exception, there is a limit in Excel itself (apparently as enforced by the Apache utility).

        (i). Ensure that cells do not exceed that limit. 
        (ii). Run the report manually (examine the data if needed). 
        (iii). Truncate the data if required, or export to CSV if data is essential.

Published February 24, 2019 - Updated December 2, 2021

Was this useful?

100% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

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