Unable to retrieve data from Jaspersoft Studio

Document ID : KB000093604
Last Modified Date : 01/05/2018
Show Technical Document Details
Issue:
Unable to retrieve data from Jaspersoft Studio
Jaspersoft Studio 6.2 and trying to run simply queries and get the following error: 
Error: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: data.
Resolution:
Install Jaspersoft Studio 6.4.2 and its corresponding adapter under the Files from CA folder on the case attachments on the Support site.
Configure the Data Adapter to use the version ojdbc8-12.2.0.1.0.jar provided in Jasper Studio 6.4.2.2.
Please find link to the section in the documentation that mentions how to install and configure Jaspersoft Studio. 
https://docops.ca.com/ca-ppm-saas/15-3/en/advanced-reporting-with-jaspersoft/jaspersoft-studio-professional-ca-jdbc-adapter/