DB error connection object closed

Avinash02 · 2011-10-13T02:57:34+00:00

Hi all, Plz help me with this error i tried many things to remove this error but everything in vain And this error is coming in production. The following error comes when i am trying to run the report with JNDI datasource DB is MSSQL 2005 driver is sqljdbc4.jar <hr></hr> ReportDesign (id =…

Avinash02

Hi all,

Plz help me with this error i tried many things to remove this error but everything in vain
And this error is coming in production.

The following error comes when i am trying to run the report with JNDI datasource DB is MSSQL 2005
driver is sqljdbc4.jar

ReportDesign (id = 1):
+ An exception occurred during processing. Please see the following message for details:
exception.error
Error happens when create hierarchy:Group2.NewTabularHierarchy2.
Failed to prepare the query execution for the data set: Set1
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet).
[SELECT
*
FROM
MR_ORDERS MRO
]
Error preparing SQL statement.
SQL error #1: Invalid state, the Connection object is closed.

I tried to shutdown the server & start it again , while running for first time it gives the out put but as soon as i tried to run it again it gives me the above error.

plz help as soon as possible.

Thanks & Regards,
Avi

Find more posts tagged with

Comments

mwilliams

Hi Avi,

Can you click the '+' and expand the error and attach the stack in here?

Avinash02

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="84092" data-time="1318531247" data-date="13 October 2011 - 11:40 AM">
Hi Avi, 
 
Can you click the '+' and expand the error and attach the stack in here? </blockquote>
 
Hi Micheal, 
 
Below is the stack trace.... Also 1 more info i want to share is that JNDI consist of URL,USERNAME,PASSWORD 
& URL is something like - jdbc:jtds:sqlserver://machine1:1433/mydb;useCursors=true 
I don't understand why that extra parameter(useCursors) is used. 
 
 
 
org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details: 
Failed to prepare the query execution for the data set: Set1 
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet). 
[SELECT 
* 
 
FROM MR_ORDERS MRO 
] 
Error preparing SQL statement. 
SQL error #1: Invalid state, the Connection object is closed. 
 
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1215) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1179) 
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.HTMLPageLM.layout(HTMLPageLM.java:90) 
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99) 
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258) 
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:252) 
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85) 
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1307) 
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:39) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
at java.lang.reflect.Method.invoke(Method.java:585) 
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.GeneratedMethodAccessor352.invoke(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
at java.lang.reflect.Method.invoke(Method.java:585) 
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:710) 
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) 
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182) 
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262) 
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) 
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) 
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446) 
at java.lang.Thread.run(Thread.java:595) 
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details: 
Failed to prepare the query execution for the data set: Set1 
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet). 
[SELECT 
* 
 
FROM MR_ORDERS MRO 
] 
Error preparing SQL statement. 
SQL error #1: Invalid state, the Connection object is closed. 
 
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:580) 
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:74) 
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265) 
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1875) 
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80) 
... 63 more 
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: Set1 
Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet). 
[SELECT 
* 
 
FROM MR_ORDERS MRO 
] 
Error preparing SQL statement. 
SQL error #1: Invalid state, the Connection object is closed. 
 
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:343) 
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:448) 
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:560) 
... 68 more 
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the following query for the data set type (org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet). 
[SELECT 
* 
 
FROM MR_ORDERS MRO 
] 
Error preparing SQL statement. 
SQL error #1: Invalid state, the Connection object is closed. 
 
at org.eclipse.birt.data.engine.odaconsumer.Connection.throwDataException(Connection.java:363) 
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:308) 
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareStatement(Connection.java:204) 
at org.eclipse.birt.data.engine.executor.DataSource.prepareStatement(DataSource.java:268) 
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:274) 
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:413) 
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:339) 
... 73 more 
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Error preparing SQL statement. 
SQL error #1: Invalid state, the Connection object is closed. 
; 
java.sql.SQLException: Invalid state, the Connection object is closed. 
at org.eclipse.birt.report.data.oda.jdbc.Statement.prepare(Statement.java:146) 
at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement.prepare(BidiStatement.java:52) 
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doPrepare(OdaQuery.java:229) 
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.prepare(OdaQuery.java:186) 
at org.eclipse.birt.data.engine.odaconsumer.Connection.prepareOdaQuery(Connection.java:300) 
... 78 more 
Caused by: java.sql.SQLException: Invalid state, the Connection object is closed. 
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1699) 
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2439) 
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:449) 
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:444) 
at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:243) 
at org.eclipse.birt.report.data.oda.jdbc.Statement.prepare(Statement.java:142) 
... 82 more

mwilliams

Do you have any issues accessing your database from any other tools? Is this only an issue in BIRT? Based on the error, it would seem that your server is timing out or something. You don't write any code to connect to you database right, you're simply using a JDBC dataSource? Let me know.