Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » New User :)

Show: Today's Messages :: Show Polls :: Message Navigator

New User :) [message #930723]

Tue, 02 October 2012 15:24

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!!

Report message to a moderator

Re: New User :) [message #930870 is a reply to message #930723]

Tue, 02 October 2012 18:15

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

Report message to a moderator

Re: New User :) [message #931541 is a reply to message #930870]

Wed, 03 October 2012 09:51

Ignacio Rodriguez

Messages: 8
Registered: October 2012

Junior Member

Hi, but the driver is correct, and my problem is the same. Sad

Report message to a moderator

Re: New User :) [message #931565 is a reply to message #930870]

Wed, 03 October 2012 10:17

Ignacio Rodriguez

Messages: 8
Registered: October 2012

Junior Member

Could be possible that the problem to be the version of birt?

Report message to a moderator

Re: New User :) [message #931603 is a reply to message #930870]

Wed, 03 October 2012 10:49

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

Report message to a moderator

Re: New User :) [message #931833 is a reply to message #931603]

Wed, 03 October 2012 15:14

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 402 times)

Report message to a moderator

Re: New User :) [message #940093 is a reply to message #931833]

Thu, 11 October 2012 09:59

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 !!

Report message to a moderator

Re: New User :) [message #941657 is a reply to message #940093]

Fri, 12 October 2012 19:00

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 11:49:53 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter