Unable to run Spectrum Jaspersoft CABI report because the report has returned more than 200,000 rows

book

Article ID: 194557

calendar_today

Updated On:

Products

CA Spectrum CA eHealth

Issue/Introduction

When running a report the following error is encountered:

"The query for the report has been canceled because it returned more than 200,000 rows. You will have to modify the report to reduce the number of rows returned."

Cause

200,000 rows are the Jaspersoft Server Setting default.

Environment

Release : 10.3.2 10.4 10.4.1 10.4.2

Component : Spectrum Core / SpectroSERVER

Resolution

Increase the value for Ad Hoc Dataset Row Limit within the Jaspersoft Admin Page:
 
 
 

Attachments