Error in adhoc view when using topic with input control as datasource

0

hi all,

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.
ky's picture
ky
3
Joined: Jun 22 2016 - 9:17pm
Last seen: 3 years 1 month ago

1 Answer:

0

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.

Sherman

 

swood_1's picture
813
Joined: Nov 15 2012 - 10:47am
Last seen: 5 days 13 hours ago
Feedback