ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » FFA 7 CWYFF0021F: The adapter cannot run the SQL statement.

Post new topic  Reply to topic
 FFA 7 CWYFF0021F: The adapter cannot run the SQL statement. « View previous topic :: View next topic » 
Author Message
Question
PostPosted: Tue Mar 01, 2011 7:42 am    Post subject: FFA 7 CWYFF0021F: The adapter cannot run the SQL statement. Reply with quote

Newbie

Joined: 27 Feb 2011
Posts: 4

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
Back to top
View user's profile Send private message
Question
PostPosted: Thu Mar 03, 2011 6:46 am    Post subject: Reply with quote

Newbie

Joined: 27 Feb 2011
Posts: 4

Hi All,

This issue was with IBM FFA

FF Adapter Fixpack 7.0.0.3.& WID WID to 7.0.0.3_IF01 has a fix as per IBM.


Thanks
Ques
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » FFA 7 CWYFF0021F: The adapter cannot run the SQL statement.
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.