We have set up the below environment across 3 LoD VMs.
MS SQL Server 2012
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,