[#12146] - Link Report to File Data Source such as JSON

Category:
Bug report
Priority:
High
Status:
New
Project: Severity:
Major
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

We have created File Data Source which is JSON and when connecting a report to this DataSource getting following Error:
"ERROR ErrorPageHandlerAction,http-nio-8080-exec-2:118 - Error UID 81d2e0fc-c758-4635-b3c7-1b792c11bc58
com.jaspersoft.jasperserver.api.JSExceptionWrapper: com.jaspersoft.jasperserver.api.common.virtualdatasourcequery.VirtualDataSourceException: Teiid Virtual Data Source Query Service - unsupported data source: JSON_WorkerReport"
To follow up with article https://community.jaspersoft.com/documentation/tibco-jasperreports-serve... is not possible because description in article looks different then actual DataSource creation:
1. Paragraph 5 in example "New Data Source" and "Set Data Source Type and Properties" from the article above says the input box "Query" is optional, but it's not. It's mandatory (please see attached screen "OptionalQuery.JPG");
2. The report connected to data source, see attached "Link_DataSource_to_Report.JPG";
3.JSON_datafile.JPG and JSON_datasource.JPG also attached.
We tried to use methodology from https://www.youtube.com/watch?v=uv0vxeh7GxI to create a JSON Data Source and it has the same error as listed above.

AttachmentSize
Image icon optionalquery.jpg80.84 KB
Image icon json_datasource.jpg62.22 KB
Image icon json_datafile.jpg92.71 KB
v7.2
JasperReports Server
felded53's picture
Joined: Dec 1 2010 - 8:08am
Last seen: 1 year 5 months ago

2 Comments:

#1
AttachmentSize
Image icon link_datasource_to_report.jpg65.52 KB
#2

It i9s solved? How? I am getting the same error:
com.jaspersoft.jasperserver.api.common.virtualdatasourcequery.VirtualDataSourceException: Teiid Virtual Data Source Query Service - unsupported data source: jsonDS

Feedback