Ad-Hoc View "Error 400" when exporting into CSV Format

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Jaspersoft Ad-Hoc View fails when exporting into CSV Format

Error Message: Error 400 Please contact your System Administrator:

Environment

Release: All
Component: Clarity Jaspersoft

Cause

This is due to a limit in the number of pages that can be exported. See more details from:  Ad Hoc Views and Custom Report Development

Note: For GCP, the limit is 1000 pages. 

Export Ad Hoc Views and Reports

The maximum number of report pages that you can generate is 500 pages for both scheduled and unscheduled reports. The limit applies to all reports and ad-hoc views that are exported using paginated options such as Excel (Paginated) and XLSX (Paginated). The limit is not applicable to the ad-hoc views exported using non-paginated export options such as Excel and XLSX. The following image shows the export options that have a limit to the maximum number of pages that are exported."

Resolution

Limit the data range on the Jaspersoft Ad-Hoc View and then export into CSV format successfully.

Important! This limit applies to each output format that you select. As a best practice, we recommend that you filter the report to limit the output data. Do not use reports to extract large volumes of data.