Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » New User :)
New User :) [message #930723] Tue, 02 October 2012 15:24 Go to next message
Ignacio Rodriguez is currently offline Ignacio Rodriguez
Messages: 8
Registered: October 2012
Junior Member
Hi,

I'm new user of Birt, and I'm tried to use Birt for one app, I write the steps:

- I have installed the version eclipse complet (All in one).
- Then I have downloaded my app of the cvs, in this app, I have the reports and web app too.
- The report was been done with 3.2.17 versión, my versión of birt is 3.2.23, I don't know if this will have problems.

My problem is that when I go to report designe perspective, and I have tried launch a report (click botton right and then Run reprt), appear the following error:

org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.

...
...
Caused by: java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcDriver.getProtocol(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.knownURL(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.acceptsURL(Unknown Source)
at java.sql.DriverManager.getDriver(Unknown Source)

Thanks in advance!!
Re: New User :) [message #930870 is a reply to message #930723] Tue, 02 October 2012 18:15 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

That error looks like you have not added the jdbc driver to the datasources. Create a new data source and select jdbc data source, click next then click on manage drivers button. Add the appropriate jar.

Jasojn
Re: New User :) [message #931541 is a reply to message #930870] Wed, 03 October 2012 09:51 Go to previous messageGo to next message
Ignacio Rodriguez is currently offline Ignacio Rodriguez
Messages: 8
Registered: October 2012
Junior Member
Hi, but the driver is correct, and my problem is the same. Sad




Re: New User :) [message #931565 is a reply to message #930870] Wed, 03 October 2012 10:17 Go to previous messageGo to next message
Ignacio Rodriguez is currently offline Ignacio Rodriguez
Messages: 8
Registered: October 2012
Junior Member
Could be possible that the problem to be the version of birt?
Re: New User :) [message #931603 is a reply to message #930870] Wed, 03 October 2012 10:49 Go to previous messageGo to next message
Ignacio Rodriguez is currently offline Ignacio Rodriguez
Messages: 8
Registered: October 2012
Junior Member
Hi!!

Now I'm copy the jdbc driver, and know the exception is:


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.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null. (Element ID:2761)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
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:46)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
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.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:262)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)
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:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1813)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
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.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
... 73 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:177)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
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:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
... 78 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null.
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:211)
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:250)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
... 88 more
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.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null. (Element ID:2751)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
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:46)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
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.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:262)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)
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:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1813)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
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.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
... 73 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:177)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
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:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
... 78 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null.
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:211)
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:250)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
... 88 more
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.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null. (Element ID:2819)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
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:46)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
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.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:262)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)
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:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1813)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
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.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
... 73 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null.
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:177)
at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
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:145)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)
... 78 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, The url cannot be null.
at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:211)
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:250)
at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
... 88 more
org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
exception.error
Error happens when create hierarchy:Empresa.NewTabularHierarchy.
Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) || || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902.
Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) ||' ' || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902. (Element ID:1)
at org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorContext.executeQuery(ExecutorManager.java:451)
at org.eclipse.birt.report.item.crosstab.core.re.executor.BaseCrosstabExecutor.executeQuery(BaseCrosstabExecutor.java:122)
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:62)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)
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.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:262)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86)
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)
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:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
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:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1813)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
exception.error
Error happens when create hierarchy:Empresa.NewTabularHierarchy.
Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) || || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902.
Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) ||' ' || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteCube(DteDataEngine.java:233)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteCube(DataGenerationEngine.java:96)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:272)
at org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorContext.executeQuery(ExecutorManager.java:441)
... 75 more
Caused by: org.eclipse.birt.data.engine.core.DataException: exception.error
Error happens when create hierarchy:Empresa.NewTabularHierarchy.
Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) || || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902.
Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) ||' ' || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.materializeCube(DataRequestSessionImpl.java:773)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:633)
... 79 more
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Error happens when create hierarchy:Empresa.NewTabularHierarchy.
Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) || || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902.
Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) ||' ' || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimension(DataRequestSessionImpl.java:1466)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimensions(DataRequestSessionImpl.java:1325)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.createCube(DataRequestSessionImpl.java:824)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.materializeCube(DataRequestSessionImpl.java:765)
... 80 more
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) || || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = COREORI03 or D_MYT_MTY_NK = COPARNE02) and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902.
Failed to prepare the query execution for the data set: documentos
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[select FILA, EMPRESA, sum(F_DOC_DOC_NUMBER) as F_DOC_DOC_NUMBER, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha from ( select TORDEN.FILA, b.D_ORG_DESC EMPRESA , F_DOC_DOC_NUMBER , f_doc_time_id , D_MYT_CUSTOMS_DES , SUBSTR(d.D_TIM_MONTH_DESC,0,3) ||' ' || SUBSTR (d.D_TIM_YEAR,3,2) fecha from DWH_F_DOCUMENT a, DWH_D_ORGANIZATION b, DWH_D_MESSAGE_TYPE m, DWH_D_TIME d, (SELECT ROWNUM AS FILA, EMPRESA, TOTAL FROM (select a.F_DOC_RECIVER_ID EMPRESA , Sum(F_DOC_DOC_NUMBER) TOTAL from DWH_F_DOCUMENT a where a.f_doc_time_id >= 2 and a.f_doc_time_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) AND a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) ) group BY A.F_DOC_RECIVER_ID ORDER BY TOTAL DESC) /*WHERE ROWNUM <11*/ ) TORDEN where a.F_DOC_RECIVER_ID = b.D_ORG_ORG_ID AND TORDEN.EMPRESA = a.F_DOC_RECIVER_ID and a.f_doc_time_id = d.d_tim_tim_id and d.d_tim_tim_id >= 2 and d.d_tim_tim_id <= 36 and a.F_DOC_RECIVER_ID in ( select D_ORG_COL_ORG_ID from DWH_D_ORG_COL where D_ORG_COL_COL_ID = 2 /* Transitario */ ) and a.F_DOC_MSG_TYPE_ID in ( select D_MTY_MTY_ID from DWH_D_MESSAGE_TYPE where (D_MYT_MTY_NK = 'COREORI03' or D_MYT_MTY_NK = 'COPARNE02') and D_MYT_CUSTOMS_ID in (1) and a.F_DOC_MSG_TYPE_ID = m.D_MTY_MTY_ID ) ORDER BY TORDEN.FILA ) group by FILA, EMPRESA, f_doc_time_id, D_MYT_CUSTOMS_DES, fecha ]
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "ORDER" at line 1, column 902.
;
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "ORDER" at line 1, column 902.
at org.eclipse.birt.report.data.adapter.impl.DataSetIterator.executeQuery(DataSetIterator.java:88)
at org.eclipse.birt.report.dat
Re: New User :) [message #931833 is a reply to message #931603] Wed, 03 October 2012 15:14 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you post the report? According the error you did not put a url in for the jdbc data source.
Edit the data source (not the data set) and verify that the url is set.

Jason
  • Attachment: dburl.png
    (Size: 60.14KB, Downloaded 105 times)
Re: New User :) [message #940093 is a reply to message #931833] Thu, 11 October 2012 09:59 Go to previous messageGo to next message
Ignacio Rodriguez is currently offline Ignacio Rodriguez
Messages: 8
Registered: October 2012
Junior Member
Hi Jason,

Yo was in the correct, the problem was the driver, but know I hve another problem...

I launch the report in the server all is correct, but if I launch the report in my local host to appear this error:

Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-00936: falta una expresión

An the database is the same!!

Thanks !!

Re: New User :) [message #941657 is a reply to message #940093] Fri, 12 October 2012 19:00 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Do you mean you try to deploy the report to the Viewer and it does not work? Make sure the driver is also in the Viewer's WEB-INF/lib directory.

Jason
Previous Topic:MS Excel data connection to BIRT report not working => SOLVED!!
Next Topic:Resize page footer dynamically (based on current page number)
Goto Forum:
  


Current Time: Thu Oct 02 00:36:36 GMT 2014

Powered by FUDForum. Page generated in 0.02508 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software