How to export a Analyze Report with over 10,000 rows.

How to export a Analyze Report with over 10,000 rows.

Symptoms:

Get an error when trying to export an Analyze report which has over 10,000 rows -

"Unable to render report table. The table contains more than 10,000 rows"
ReportError.JPG

 

Solution:

1. Go to User Console Server and stop User Console service.

2. Open the file - "User Console Installation Directory\User Console\Solution\system\analyzer\analyzer.properties"

3. Update the value of the below nodes  to increase the render size -

# Max number of rows to export in a PDF or XLSX export
renderer.export.max.rows=10000 

 

RowLimit.JPG

4. Start User Console service.

 

 

Please note that

1) The recommended value is 10000 for this field and increasing this value might lead to performance issues.

2) This workaround only works when exporting in a PDF or XLSX file. There is no limitation for csv file.

Was this article helpful? Yes No
No ratings
Version history
Revision #:
3 of 3
Last update:
‎Mar 26, 2020 12:20 PM
Updated by:
 
Contributors