AnsweredAssumed Answered

Clarity 14.2 on MSSQL Server 2012 and Jasper Server - Unable to run the OOTB jasper reports from Jasper Server UI

Question asked by manva04 Employee on Jun 22, 2015
Latest reply on Jun 24, 2015 by manva04

hi Experts,


Good Morning!


We have set up the below environment across 3 LoD VMs.


Clarity 14.2

MS SQL Server 2012

Jasper Server


Integration of Jasper with Clarity 14.2 is also done.


After installation is completed, we are unable to run the OOTB jasper reports from Jasper Server (logged in as superuser as well as jasperadmin).

Both default Bean data sources (CA PPM BEAN, CA PPM DWH BEAN) connection test failed in Jasper server.

Also, when opened these OOTB reports from Jasper studio, it shows that there are compilation errors.


we also checked CSA configuration for Reporting > Jasper Server, Dataware house. Both status is Available.


But we are able to run the same OOTB reports from Clarity UI > Advanced Reporting.


When Jasper server log is checked, below is the error message.

"2015-06-20 23:13:54,039 ERROR JDBCProxyDataSourcePool,http-apr-8080-exec-9:157 - ::org.apache.jasper.JasperException: Dynamic Proxy Data Source Pool can only be used at a Tenant Level context.. Null Data Source will be returned".


we checked the MS SQL Server 2012 database.

Both niku as well as ppm_dwh databases have sample data and we are able to query them in SQL studio.


Please let us know if we are missing any steps.


Thanks and Regards,