MQSeries.net :: View topic - FFA 7 CWYFF0021F: The adapter cannot run the SQL statement.

Question · Posted: Thu Mar 03, 2011 6:46 am Post subject:

FFA version 7.X:

Problem it always process the number of record/information given in poll period, say if the poll period is say 5 then it consumes just 5 such record/information separated by delimiter, then throws below exception. We see that our Data base is up not sure why we are getting the Exception from migrated version.

Did any one face this similar problem trying to google it, but did not get any result similar result.

com.ibm.j2ca.flatfile.FlatFileEventStoreWithXid getEvents CWYFF0021F: The adapter cannot run the SQL statement. Explanation=The adapter cannot run the SQL statement. For inbound event processing to function, the database needs to be active. UserAction=Ensure that the database is active.

com.ibm.j2ca.extension.utils.persistencestore.EventPersistenceDBImpl batchStore() CWYBS0650I: An SQL Exception occurred with the message [jcc][t4][102][10040][3.57.110] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4228, SQLSTATE=null, while trying to batchStore(). Explanation=The SQL query to do the above operation failed with the above mentioned message. UserAction=Check that the table and the corresponding columns exist in the database and that the connection exists in your J2EE server. Contact your database administrator to verify the connection properties. Try again with the changed connection properties.

E J2CA0081E: Method cleanup failed while trying to execute method cleanup on ManagedConnection WSRdbManagedConnectionImpl@67ae67ae from resource jdbc/DB2FFA. Caught exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: Cannot call 'cleanup' on a ManagedConnection while it is still in a transaction..
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:251)
at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.<init>(DataStoreAdapterException.java:200)
at com.ibm.ws.rsadapter.AdapterUtil.createDataStoreAdapterException(AdapterUtil.java:443)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanupTransactions(WSRdbManagedConnectionImpl.java:4567)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup(WSRdbManagedConnectionImpl.java:4017)
at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1528)
at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:506)
at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1845)
at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:2380)
at com.ibm.ejs.j2c.ConnectionEventListener.connectionClosed(ConnectionEventListener.java:369)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processConnectionClosedEvent(WSRdbManagedConnectionImpl.java:1830)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.closeWrapper(WSJdbcConnection.java:904)
at com.ibm.ws.rsadapter.jdbc.WSJccConnection.closeWrapper(WSJccConnection.java:752)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:240)
at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.java:193)
at com.ibm.j2ca.extension.utils.persistencestore.EventPersistenceDBImpl.closeConnection(EventPersistenceDBImpl.java:1904)
at com.ibm.j2ca.extension.utils.persistencestore.EventPersistenceDBImpl.storeEvents(EventPersistenceDBImpl.java:1048)
at com.ibm.j2ca.extension.utils.persistencestore.EventPersistence.storeEvents(EventPersistence.java:249)
at com.ibm.j2ca.flatfile.FlatFileEventStoreWithXid.getEvents(FlatFileEventStoreWithXid.java:437)
at com.ibm.j2ca.extension.eventmanagement.internal.EventManager.getEvents(EventManager.java:393)
at com.ibm.j2ca.extension.eventmanagement.internal.EventManager.pollForEvents(EventManager.java:280)
at com.ibm.j2ca.base.internal.PollEventManagerWorker.run(PollEventManagerWorker.java:112)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:137)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:268)
at java.security.AccessController.doPrivileged(AccessController.java:202)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:768)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:86)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:91)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)

Thanks for your help
Ques