search cancel

Getting error when trying to run a CABI/Jasper report Ad hoc report


Article ID: 144359


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


I'm seeing errors when I try to run a report in CABI that only has maybe 13 rows of data but I get an error telling me:

"Data was truncated. System row limit exceeded: 200000."

I'm trying to find out why this error is happening when I'm basically pulling a report of all windows servers in our environment with over 90% CPU usage.
I'd like to see more details of the error if possible so I can make the needed changes to lower the row limit, if needed.



UIM 8.x 9.x
CABI 3.X 4.x


Jasperserver has a row limit set by default for 200000 of adhoc reporting.
This is configurable to change.


the limits you are running into are part of the jasperserver report engine that CABI is based on.

Please see the below two links on how to change these values:

And while you are at it, you probably need to extend the query timeout :