Jasper Studio Data source connectivity issue

Products

• Support Offerings
• Clarity PPM SaaS

Issue/Introduction

Jasper Studio connectivity using CA JDBC Driver is returning the below error.

net.sf.jasperreports.engine.JRException: java.sql.SQLException: Datasource '/ca_ppm/data_sources/CA_PPM_DWH_BEAN' not found in the repository.Please check 'datasource' path in the JDBC URL.
 at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:126)
 at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:120)
 at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:155)
 at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51)
 at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Datasource '/ca_ppm/data_sources/CA_PPM_DWH_BEAN' not found in the repository.Please check 'datasource' path in the JDBC URL.
 at com.jaspersoft.web.rest.JasperRestConnector.validateAdapterConfiguration(JasperRestConnector.java:596)
 at com.jaspersoft.jdbc.driver.JasperDriver.connect(JasperDriver.java:62)
 at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:164)
 at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:124)
 ... 4 more

Environment

Release : 15.9.1

Component :

Resolution

Issue is related to wrong role being added to the user which is used for connecting to jasper data source.

We need to add ROLE_ADMINISTRATOR role while setting up the user in advanced reporting.