We are currently using 9.9 version of CentraSite . For “reporting” in CentraSite we are making use of Mediator Tables as a datasource for the custom reports . The report is created using BIRT and deployed successfully to CentraSite from Desginer.
When we try to execute the report from Business UI , we are getting the below error.
“org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile. org.eclipse.datatools.connectivity.oda.OdaException ; java.lang.ClassNotFoundException: com.softwareag.common.jdbc.driver.OracleProxyDriver”
I placed the ojdbc jar in the redist directory as I was not sure where else it should be placed and tired executing the report but still throws the same error.
Please suggest what other configurations are suppose to be done to make the datatsource (JDBC ) connection profile of the report to establish connection from CentraSite.