I am getting error in adhoc view editor when using topic with input control as datasource.
I have drag and drop some field as column, using "Table" as layout, when I preview the data by "Sample Data" or "Full Data", the screen always prompt "An error occurred while performing the previous request".
Below is part of the exception message captured from server log:
ad hoc controller exception: An error occurred while performing the previous request. java.lang.NullPointerException at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator$1.handleClauseChunk(SQLGenerator.java:556) at net.sf.jasperreports.engine.util.JRQueryParser.parseClause(JRQueryParser.java:208)
If I remove the input control from topic, the adhoc view editor works and data can be displayed.
Product Edition: Professional for AWS
Product Version: 6.3.0
Can anyone let me know how to fix this issue?
Thank you in advance.
Posted on November 10, 2016 at 6:20pm
It looks like the topic is not configured correctly.
How did you create the topic? From a JasperReport or with a domain?
If it was from a report, does the report run on its own in JasperReports Server?
If it was from a domain, does a new Ad hoc View from the domain work?
You could post an export of the topic here and I could see whether there was anything obviously wrong.