Issue:
In TIBCO Jaspersoft® Studio, after adding a query filter to the domain query and clicking on the filter values list button, a "java.lang.RuntimeException: exception getting dataset from cache" error was thrown.
At this same time, the jasperserver.log file captured the following :
Caused by: com.jaspersoft.commons.util.QueryExecutionTooManyRowsException: jsexception.QueryExecutionTooManyRowsException
Arguments: 1000000,
at com.jaspersoft.commons.util.JSControlledResultSetDataSource.next(JSControlledResultSetDataSource.java:38)
at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:422)
... 152 more
Note: The filter values list button is the button with the three dots which has a tooltip of "Click to select value".
Solution:
The current behaviour is that the filter values list for a domain query filter cannot be displayed if the total number of filter values exceeds the "Ad Hoc Dataset Row limit".
However, increasing the number for "Ad Hoc Dataset Row limit" to a much larger number can lead to performance degradation affecting not just the performance of displaying the filter values but also system-wide performance issues in running server based Ad Hoc reports.
It does not make sense in limiting the TIBCO Jaspersoft® Studio capabilities to get data through the "Ad Hoc Dataset Row limit" and hence this issue was filed as a defect (JS-34347).
As a workaround, instead of displaying the full list of filter values, first work out the condition operator type and the value you want to query against and then input the value into the query filter. To put it simply, you would want to avoid clicking on the filter values list button to select the value.
Related Articles:
JS-34347: Adding filter values to domain query in Studio errors with QueryExecutionTooManyRowsException if filter values exceeds Ad Hoc Dataset Row Limit
JS-32734: Domain-based reports cannot be previewed in studio if their query returns larger result set than Ad hoc result set limit
ref: 01666369
Recommended Comments
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now