2 Replies Latest reply on Aug 21, 2012 1:27 AM by Hung Le

    TM ART 4.1 Report Errors

    Hung Le

      hi,

       

      have updated TM ART 3.9 to 4.1

       

      The TM ART 4.1 Reports show following errors

       

      The following items have errors:

       

       

      Data (id = 137):
      + 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: Cannot load JDBC Driver class: net.sourceforge.jtds.jdbc.Driver.
      exception.error ( 1 time(s) )  detail : 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: Cannot load JDBC Driver class: net.sourceforge.jtds.jdbc.Driver.  at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1199)  at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1178)  at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)  at org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:75)  at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)  at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)  at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)  at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)  at org.eclipse.birt.report.engine.layout.html.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:90)  at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)  at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)  at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)  at com.segue.scc.chartengine.BirtServerServlet.executeReport(BirtServerServlet.java:166)  at com.segue.scc.chartengine.BirtServerServlet.writeStream(BirtServerServlet.java:181)  at com.segue.scc.chartengine.BirtServerServlet.doPost(BirtServerServlet.java:255)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)  at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)  at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)  at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)  at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)  at java.lang.Thread.run(Unknown Source)  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: Cannot load JDBC Driver class: net.sourceforge.jtds.jdbc.Driver.  at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:636)  at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)  at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)  at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1890)  at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)  ... 39 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: Cannot load JDBC Driver class: net.sourceforge.jtds.jdbc.Driver.  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:208)  at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:406)  at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:316)  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:616)  ... 43 more  Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: net.sourceforge.jtds.jdbc.Driver.  at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:760)  at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.registerDriver(JDBCDriverManager.java:879)  at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterDriver(JDBCDriverManager.java:862)  at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:246)  at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:212)  at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:237)  at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:162)  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)  ... 53 more    

      .

      .

      ,

       

       

      Already trying with the new Birt 2.6.2 but the errors are the same

       

      It seems that TM ART 4.1 has problem with loading the JDBC Driver net.sourceforge.jtds.jdbc.Driver.

       

      Regards

      Hung Le