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

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.
 at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator$1.handleClauseChunk(
 at net.sf.jasperreports.engine.util.JRQueryParser.parseClause(
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
Joined: Jun 22 2016 - 9:17pm
Last seen: 6 years 7 months ago

1 Answer:

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.



swood_1's picture
Joined: Nov 15 2012 - 10:47am
Last seen: 3 years 4 weeks ago