nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Birt Viewer Problem

karvesh

Dear All 
 
I am new to the BIRT realm.. I just installed eclipse indigo version with the BIRT designer. I then created a report and got it connected to a mysql database at design time. When i preview the report in the IDE, it works all fine and all the data appear. 
 
I then decided to use the report using BIRT Report Viewer obtained from birt-runtime-3_7_0. So i installed Tomcat 5.5 and in its webapp folder i hosted the BIRT Viewer Folder. I reran tomcat and the example test report supplied with the viewer worked fine. So i decided to try my report created using the IDE. What i did is that i copied and pasted the report file, called lstMembers.rptdesign, in the report viewer folder, just next to the test report called test.rptdesign. 
 
I read somewhere that i needed to copy the drivers in the WEB-INF\lib folder of the viewer. So i pasted the file mysql-connector-java-5.1.17-bin there and reran tomcat. 
 
Yet, When i ran the report using the url: 
http://localhost:8081/WebViewerExample/run?__report=lstMembers.rptdesign 
 
I get the following error: 
 
 
The following items have errors: 
 
Table (id = 38): 
- 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.dbprofile. 
org.eclipse.datatools.connectivity.oda.OdaException ; 
java.lang.NullPointerException (Element ID:38) 
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.dbprofile. 
org.eclipse.datatools.connectivity.oda.OdaException ; 
java.lang.NullPointerException (Element ID:38) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1206) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1185) 
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.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) 
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) 
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) 
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) 
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92) 
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180) 
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77) 
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:929) 
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973) 
at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131) 
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.handleGetPageAll(BirtDocumentProcessor.java:183) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
at java.lang.reflect.Method.invoke(Unknown Source) 
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(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
at java.lang.reflect.Method.invoke(Unknown Source) 
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:647) 
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) 
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) 
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.dbprofile. 
org.eclipse.datatools.connectivity.oda.OdaException ; 
java.lang.NullPointerException 
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:1897) 
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80) 
... 57 more 
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile. 
org.eclipse.datatools.connectivity.oda.OdaException ; 
java.lang.NullPointerException 
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:409) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:319) 
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) 
... 61 more 
Caused by: org.eclipse.datatools.connectivity.oda.OdaException ; 
java.lang.NullPointerException 
at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:113) 
at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:57) 
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) 
... 71 more 
Caused by: java.lang.NullPointerException 
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:76) 
at org.eclipse.datatools.enablement.internal.mysql.connection.JDBCMySQLConnectionFactory.createConnection(JDBCMySQLConnectionFactory.java:28) 
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) 
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359) 
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659) 
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:644) 
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38) 
at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45) 
at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59) 
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114) 
at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163) 
at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56) 
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) 
 
Can anyone please please help me here? 
I have tried hard to get it to work but i simply cant figure out what the problem is 
Please help..

Find more posts tagged with

Comments

Paul A

Karvesh, 
 
I'm new too!!! 
 
I am using the MS SQL Server JDBC Drivers for my reports. I thought I might have the same predicament as yourself. 
 
I have latest version of Tomcat - Tomcat 7. I have been using the BIRT Designer 3.7 and developing some ODA drivers in Eclipse Indigo SDK. 
 
If you look in the plugins folder you will notice a org.eclipse.birt.report.data.oda.jdbc_3.7.0.v20110602 folder. Inside of this there is a drivers folder. 
 
I simply copied the drivers folder (not the contents) and put it under C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\birt-web-viewer\WEB-INF\lib. So now you have: 
 
C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\birt-web-viewer\WEB-INF\lib\drivers 
 
NOTE: The drivers folder should contain the my sql driver, sql server, etc. 
 
Dont forget to restart Tomcat just incase. 
 
Hopefully your reports will work in BIRT web viewer now. 
 
 
Andez

karvesh

Dear Andez 
thanks a lot for the reply 
I tried it and it worked fine!! Thanks a lot.. 
Till now i have had to use the php java bridge in order to get birt working within my php application. 
 
Nonetheless, its good that i have the birt viewer running too as well now.. I can use it in parallel. 
 
Thanks again Andez.. I really appreciate. 
 
Karvesh 
 
 
<blockquote class='ipsBlockquote' data-author="'Paul A'" data-cid="81383" data-time="1312968458" data-date="10 August 2011 - 02:27 AM">
Karvesh, 
 
I'm new too!!! 
 
I am using the MS SQL Server JDBC Drivers for my reports. I thought I might have the same predicament as yourself. 
 
I have latest version of Tomcat - Tomcat 7. I have been using the BIRT Designer 3.7 and developing some ODA drivers in Eclipse Indigo SDK. 
 
If you look in the plugins folder you will notice a org.eclipse.birt.report.data.oda.jdbc_3.7.0.v20110602 folder. Inside of this there is a drivers folder. 
 
I simply copied the drivers folder (not the contents) and put it under C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\birt-web-viewer\WEB-INF\lib. So now you have: 
 
C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\birt-web-viewer\WEB-INF\lib\drivers 
 
NOTE: The drivers folder should contain the my sql driver, sql server, etc. 
 
Dont forget to restart Tomcat just incase. 
 
Hopefully your reports will work in BIRT web viewer now. 
 
 
Andez </blockquote>