|
| Re: Error in cross tab [message #722692 is a reply to message #722202] |
Tue, 06 September 2011 14:19   |
|
What version of BIRT are you using in the deployed environment?
Jason
On 9/4/2011 11:44 PM, Martin wrote:
> Hi,
>
> Can somebody help me?
> I create report using cross tab, no problem when i preview it.
> Data and format is running ok, but when we deploy in jboss server
> and run the report. error encountered: see below message:
>
> 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.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver. at
> org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1109)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1073)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:88)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
> at
> org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
> at
> org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
> at
> org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:231)
> at
> org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)
> at
> org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1164)
> at
> org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)
> at
> org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
> at
> org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:57)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:53)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
> at
> org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:592) at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
> at
> org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:592) at
> org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
> at
> org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
> at
> org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at
> org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at
> org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at
> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at
> org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:225)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:112)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
> at java.lang.Thread.run(Thread.java:595)Caused by:
> org.eclipse.birt.report.data.adapter.api.AdapterException: 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.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver. at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:490)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:114)
> at
> org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:248)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1736)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:77)...
> 64 moreCaused by: org.eclipse.birt.data.engine.core.DataException:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver. at
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:169)
> at
> org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:210)
> at
> org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:197)
> at
> org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:386)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:305)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:479)...
> 69 moreCaused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException:
> Cannot load JDBC Driver class: oracle.jdbc.OracleDriver. at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:682)
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:790)
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:202)
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:168)
> at
> org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:179)
> at
> org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:136)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
> at
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)...
> 79 more
> --------------------------------------------------------------------------------
>
> org.eclipse.birt.report.engine.api.EngineException: An exception
> occurred during processing. Please see the following message for
> details:exception.errorCannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver.Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver. at
> org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1109)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.doPrepareQuery(AbstractDataEngine.java:210)
> at
> org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doPrepareQuery(DataGenerationEngine.java:73)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:167)
> at
> org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:109)
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59)
> at
> org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:76)
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59)
> at
> org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:51)
> at
> org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:229)
> at
> org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)
> at
> org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1164)
> at
> org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)
> at
> org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
> at
> org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:57)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:53)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
> at
> org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:592) at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
> at
> org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:592) at
> org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
> at
> org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
> at
> org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at
> org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at
> org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at
> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at
> org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:225)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:112)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
> at java.lang.Thread.run(Thread.java:595)Caused by:
> org.eclipse.birt.report.data.adapter.api.AdapterException: An exception
> occurred during processing. Please see the following message for
> details:exception.errorCannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver.Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver. at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.prepare(DataRequestSessionImpl.java:523)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.doPrepareQuery(AbstractDataEngine.java:203)...
> 64 moreCaused by: org.eclipse.birt.data.engine.core.DataException:
> exception.errorCannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver.Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver. at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.materializeCube(DataRequestSessionImpl.java:597)
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.prepare(DataRequestSessionImpl.java:1048)
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.prepare(DataRequestSessionImpl.java:509)...
> 65 moreCaused by:
> org.eclipse.birt.report.data.adapter.api.AdapterException: Cannot open
> the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver.Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver. at
> org.eclipse.birt.report.data.adapter.impl.DataSetIterator.executeQuery(DataSetIterator.java:87)
> at
> org.eclipse.birt.report.data.adapter.impl.DataSetIterator.(DataSetIterator.java:101)
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimension(DataRequestSessionImpl.java:987)
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimensions(DataRequestSessionImpl.java:916)
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.createCube(DataRequestSessionImpl.java:652)
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.materializeCube(DataRequestSessionImpl.java:588)...
> 67 moreCaused by: org.eclipse.birt.data.engine.core.DataException:
> Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.OracleDriver. at
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:169)
> at
> org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:210)
> at
> org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:197)
> at
> org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:386)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:305)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:158)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:141)
> at
> org.eclipse.birt.report.data.adapter.impl.DataSetIterator.executeQuery(DataSetIterator.java:83)...
> 72 moreCaused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException:
> Cannot load JDBC Driver class: oracle.jdbc.OracleDriver. at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:682)
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:790)
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:202)
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:168)
> at
> org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:179)
> at
> org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:136)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235)
> at
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:157)...
> 84 more
> --------------------------------------------------------------------------------
>
> org.eclipse.birt.report.engine.api.EngineException: Can't find the
> prepared query
> mailto:org.eclipse.birt.data.engine.olap.impl.query.CubeQueryDefinition@3f8e347.
> at
> org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorContext.executeQuery(ExecutorManager.java:432)
> at
> org.eclipse.birt.report.item.crosstab.core.re.executor.BaseCrosstabExecutor.executeQuery(BaseCrosstabExecutor.java:103)
> at
> org.eclipse.birt.report.item.crosstab.core.re.executor.CrosstabReportItemExecutor.execute(CrosstabReportItemExecutor.java:102)
> at
> org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:61)
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)
> at
> org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)
> at
> org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)
> at
> org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:231)
> at
> org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)
> at
> org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1164)
> at
> org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:155)
> at
> org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
> at
> org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:57)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:53)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
> at
> org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:592) at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
> at
> org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:592) at
> org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
> at
> org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
> at
> org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at
> org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at
> org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at
> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at
> org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:225)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:112)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at
> org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
> at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
> at java.lang.Thread.run(Thread.java:595)Caused by:
> org.eclipse.birt.report.engine.api.EngineException: Can't find the
> prepared query
> mailto:org.eclipse.birt.data.engine.olap.impl.query.CubeQueryDefinition@3f8e347.
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteCube(DteDataEngine.java:161)
> at
> org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteCube(DataGenerationEngine.java:92)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)
> at
> org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorContext.executeQuery(ExecutorManager.java:422)...
> 66 more
|
|
|
|
| Re: Error in cross tab [message #723546 is a reply to message #722872] |
Thu, 08 September 2011 18:41 |
|
Do you have the oracle driver in the
WebViewerExample\WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_2.3.2.r232_v20090212\drivers
directory?
Jason
On 9/6/2011 10:43 PM, Martin wrote:
> Hi Jason,
>
> thanks for the reply.
> pls see below version we are using:
>
> BIRT 2.3.1
> Java 5
> Eclipse 3.4.1
> apache-ant-1.6.3
> jboss-4.2.3
>
> thanks/martin090711
|
|
|
|
|
| Re: Error in cross tab [message #724569 is a reply to message #724401] |
Mon, 12 September 2011 15:14 |
|
Martin,
That is not the drivers directory for 2.3.1. This would work in the
latest version of BIRT, but in 2.3 you have to put it in the specific
directory. We added an option to set this in script as well but I am
not certain it will work in 2.3. In the beforeOpen script of the
datasource add:
reportContext.getAppContext().put("OdaJDBCDriverClassPath",
"/wm9/Infor/wm/jboss-4.2.3.GA/server/WMTST-wmbirt1/lib");
Jason
On 9/12/2011 5:40 AM, Martin wrote:
> hi jason,
>
> any update on this.
>
> thanks/martin091211
|
|
|
|
| Re: Error in cross tab [message #725010 is a reply to message #724753] |
Tue, 13 September 2011 17:57 |
|
What data source are you using? Text based sql query? connection profile?
Jason
On 9/13/2011 12:50 AM, Martin wrote:
> Hi Jason,
>
> Still encounter same problem:
>
> org.eclipse.birt.report.engine.api.EngineException: An exception
> occurred during processing. Please see the following message for
> details:exception.errorCannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver class:
> oracle.jdbc.driver.OracleDriver.Cannot open the connection for the
> driver: org.eclipse.birt.report.data.oda.jdbc.Cannot load JDBC Driver
> class: oracle.jdbc.driver.OracleDriver.
>
> any other option we need to do?
> Pls advise.
>
> note: no error encounter using table but when we use crosstab that the
> problem occur
>
> thank you very much.
> martin091311
|
|
|
|
| Re: Error in cross tab [message #725136 is a reply to message #725126] |
Wed, 14 September 2011 04:42 |
|
Any chance you could copy the report and try it with a standard jdbc
data source not in a profile?
Jason
On 9/13/2011 11:33 PM, MartinE wrote:
> Hi Jason,
>
> Connection Profile is the data source we're using.
>
> thanks/martin091411
|
|
|
|
| Re: Error in cross tab [message #725349 is a reply to message #725170] |
Wed, 14 September 2011 14:56 |
|
Make sure you make a copy of the report.
You should be able to create a new data source and choose jdbc and do
not use the connection profile radial. Enter the driver, db url,
username and password. Your existing data source will be named
something like Data Source. The new one will be named Data Source 1.
Delete Data Source and rename Data Source 1 to Data Source.
Jason
On 9/14/2011 2:59 AM, MartinE wrote:
> hi jason,
>
> can you help me or send me instruction how to do it?
>
> thanks/martin091411
|
|
|
|
|
|
| Re: Error in cross tab [message #726778 is a reply to message #726651] |
Mon, 19 September 2011 14:37 |
|
Did you try using normal JDBC connection instead of a connection profile?
Jason
On 9/19/2011 3:21 AM, MartinE wrote:
> hi jason,
>
> any idea we can try? pls advise.
>
> thanks/martin091911
|
|
|
|
| Re: Error in cross tab [message #727152 is a reply to message #726932] |
Tue, 20 September 2011 14:28 |
|
This should work. Can you try the attached example report that uses the
sampledb?
Jason
On 9/19/2011 9:36 PM, MartinE wrote:
> Hi Jason,
>
> Yes, what i wondering is in normal report we can preview and deploy it
> to server
> but when we tried to use crosstab in the report, we can preview but when
> we deploy to server that error occurred.
>
> fyi-tks/martin082011
|
|
|
|
| Re: Error in cross tab [message #727618 is a reply to message #727338] |
Wed, 21 September 2011 16:28 |
|
What version of BIRT are you using?
Jason
On 9/20/2011 10:00 PM, MartinE wrote:
> hi jason,
>
> error encountered running sample report:
>
> the report file of version 3.2.17 is not supported.
>
> fyi-tks/martin092111
|
|
|
|
|
|
| Re: Error in cross tab [message #728640 is a reply to message #728327] |
Fri, 23 September 2011 15:12 |
|
Martin,
I can not run your attached reports to test them. Can you try one more
sample? It is attached.
Jason
On 9/22/2011 9:59 PM, MartinE wrote:
> hi jason,
>
> still same error encountered:
>
> the report file of version 3.2.17 is not supported.
> ===
> i attached sample report i develop, 1-using tab and other using crosstab
> 1. JFC_Bulk_Picklist.rptdesign (used table)- successfully run in local(report design) and in server.
>
> 2. JFC_Daily_Bread_test.rptdesign (used crosstab) - successfully run in local (report design and failed in server.
>
> note: same birt development and same server deploy.
>
> thanks/martin092311
|
|
|
|
| Re: Error in cross tab [message #729604 is a reply to message #729391] |
Mon, 26 September 2011 15:46 |
|
Martin,
I am not certain what is happening with your report. You could open a
bugzilla entry to have others on the dev team look at it.
Jason
On 9/26/2011 1:27 AM, MartinE wrote:
> Hi Jason,
>
> It works! the sample you send to me.
> It can view both local and in the server.
> What probably the problem in my crosstab reports?
>
> thanks/martin092611
|
|
|
|
|
| Re: Error in cross tab [message #730510 is a reply to message #730387] |
Wed, 28 September 2011 14:21 |
|
Give it a day or two more. Someone on the dev team should look at it.
The error looks like it can not find the oracle driver or the driver is
in the classpath more than once. This is a guess though. One thing I
did notice is that you are using JNDI on the report that works and not
on the one that is failing. You may also want to post the two reports
to the bugzilla entry.
Jason
On 9/28/2011 5:46 AM, MartinE wrote:
> hi jason,
>
> already log in bugzilla with ref#358995
> but no one get the issue.
>
> pls help.
>
> thanks/martin092811
|
|
|
|
] 
Search
Help
Register
Login
Home
