Receive this error when exporting to pdf: ERROR: Error occurred during report generation...exceeded the limit of 600 maximum pages.

book

Article ID: 36111

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Problem:

Using Adhoc view.  Unable to export to PDF and receive this error:

"Server Error: error occurred during report generation"

Error from the jasperserver.log:-
ERROR AsyncThumbnailCreatorImpl,pool-16-thread-2:59 - net.sf.jasperreports.engine.JRRuntimeException: Error occurred during report generation.
net.sf.jasperreports.engine.JRRuntimeException: Error occurred during report generation.
Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.governors.MaxPagesGovernorException: Report "xxxxxxxxxxxxxReport_tableDataset_xxxxxxxxxxxxx_xxxxxx" exceeded the limit of 600 maximum pages.

 


Steps To Reproduce:

1. In Clarity click on 'Home' -> 'Advanced Reporting'
2. Under 'Adhoc Views' click on 'Create'
3. Select 'Resource Management' and click on 'Choose Data...'
4. Expand 'Resources in the Source column and drag over:
Resource Name
Resource Type
Click on 'OK' button
5. Set the format from Cross-tab to Table
6. Move 'Resource Name' and 'Resource Type' to the 'Columns' field
7. Click on the export icon and select 'As PDF'


Expected Result: For the data to be exported successfully into a pdf file.
Actual Result: The data doesn't get exported to pdf file, instead they receive this error:


"Server Error


Error occurred during report generation"



Resolution:
Log into the Jaspersoft server and go into the Adhoc View Options and change it to:

Ad Hoc Filter List of Values Row Limit
Please change it to 100,000

Ad Hoc Dataset Row Limit
Please change it to 100,000

Ad Hoc Query Timeout (seconds)
Please leave it as 360

This setting requires a restart of the Jaspersoft server



Environment

Release: ESPCLA99000-14.3-Clarity-Extended Support Plus
Component:

Resolution

Please Update This Required Field

Attachments

1558534243769TEC1365031.zip get_app