Community
Participate
Working Groups
I'am trying to generate a report from Putty using the .sh script that i located in my birt-runtime-osgi-4_2_2/ReportEngine instalation. My report is using stored procedures to get data. I got 3 parameters, 2 parameters for the procedure and one to redirect to my Ojdbc driver. When i run my report the .sh script generates an empty pdf file without any data. I also get an error for all of my procedures. I will only paste one of them (becose all of them have the same message): Sep 07, 2018 3:53:01 PM org.eclipse.birt.data.engine.odaconsumer.Connection prepareOdaQuery SEVERE: Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet). [{call READ_SAMMANDRAG_STDDET_PRC_NEW(?,?)} ] org.eclipse.datatools.connectivity.oda.consumer.helper.OdaHelperException: The established connection to the data source is not active. at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaObject.newOdaException(OdaObject.java:548) at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.newQuery(OdaConnection.java:562) at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:285) at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareStatement(Connection.java:197) at org.eclipse.birt.data.engine.executor.DataSource.prepareStatement(DataSource.java:302) at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:282) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:459) at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:346) at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455) at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190) at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178) at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:153) at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:634) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1941) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) at org.eclipse.birt.report.engine.api.ReportRunner.runAndRenderReport(ReportRunner.java:245) at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner.java:168) at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.java:127)