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 SpectrumCA 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."
Environment
Release : 10.3.2 10.4 10.4.1 10.4.2
Component : Spectrum Core / SpectroSERVER
Cause
200,000 rows are the Jaspersoft Server Setting default.
Resolution
Increase the value for Ad Hoc Dataset Row Limit within the Jaspersoft Admin Page: