posted 18 years ago
iam trying to deploy an JMS application in websphere server 6.0.
it is deployes properly and if u send a message to that application then it is showing the following message . it is receving the message and it is processing and while putting through a bean in to the database the following error is occured.It is not entering in to that bean itself.
DataAccessReq E PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@4d82c80b
[6/30/05 12:44:52:906 IST] 0000003b DataAccessReq E PMGR0000E: Call stack:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@4d82c80b
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeCreate(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbPostCreate(Unknown Source)
at com.realsoftinc.vonc.messagenotificationlog.ConcreteMessageNotificationLog_3eaf638c.ejbPostCreate(ConcreteMessageNotificationLog_3eaf638c.java:436)
at com.realsoftinc.vonc.messagenotificationlog.EJSCMPMessageNotificationLogHomeBean_3eaf638c.create_Local(EJSCMPMessageNotificationLogHomeBean_3eaf638c.java:192)
at com.realsoftinc.vonc.messagenotificationlog.EJSLocalCMPMessageNotificationLogHome_3eaf638c.create(EJSLocalCMPMessageNotificationLogHome_3eaf638c.java:69)
at com.realsoftinc.vonc.cdrlog.CDRLogBean.logMessage(CDRLogBean.java:82)
at com.realsoftinc.vonc.cdrlog.EJSLocalStatelessCDRLog_58518bda.logMessage(EJSLocalStatelessCDRLog_58518bda.java:40)
at com.realsoftinc.vonc.notificationengine.NotificationEngineBean.processUsers(NotificationEngineBean.java:744)
at com.realsoftinc.vonc.notificationengine.NotificationEngineBean.messageProcess(NotificationEngineBean.java:264)
at com.realsoftinc.vonc.notificationengine.NotificationEngineBean.sendNotification(NotificationEngineBean.java:131)
at com.realsoftinc.vonc.notificationengine.EJSLocalStatelessNotificationEngine_c7199059.sendNotification(EJSLocalStatelessNotificationEngine_c7199059.java:43)
at com.realsoftinc.vonc.sendmessage.SendMessageBean.onMessage(SendMessageBean.java:53)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:985)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:713)
at $Proxy0.onMessage(Unknown Source)
at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:307)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:302)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:434)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink BIT VARYING 'X'0a2052756c65204465736372697074696f6e203a200a2074657374696e67206576656e7420736572766963650a0a7072696f726974793d22637269746963616c223b646174653d22547565204465632031342031343a35333a3231204953542032303034223b7372633d2253554e534f4c223b66696c653d226a756e6b223b6c696e653d2230223b6d636e616d653d226d6176657269636b34223b6d736769643d2241444d435053303033223b6d73673d224e756d62657220283029206f662070726f6365737320222f7573722f6c69622f6c70736368656422206c657373207468616e204d696e696d756d20636f756e742028312922'' to length 1000.DSRA0010E: SQL State = 22001, Error Code = 20,000
at db2j.ai.j.generateCsSQLException(Unknown Source)
at db2j.ai.g.wrapInSQLException(Unknown Source)
at db2j.ai.g.handleException(Unknown Source)
at db2j.ai.c.handleException(Unknown Source)
at db2j.ai.e.handleException(Unknown Source)
at db2j.ai.m.executeStatement(Unknown Source)
at db2j.ai.p.executeStatement(Unknown Source)
at db2j.ai.p.executeUpdate(Unknown Source)
at com.realsoftinc.vonc.messagenotificationlog.websphere_deploy.CLOUDSCAPE_V50_1.MessageNotificationLogBeanFunctionSet_3eaf638c.Create(MessageNotificationLogBeanFunctionSet_3eaf638c.java:177)
at com.realsoftinc.vonc.messagenotificationlog.websphere_deploy.CLOUDSCAPE_V50_1.MessageNotificationLogBeanFunctionSet_3eaf638c.execute(MessageNotificationLogBeanFunctionSet_3eaf638c.java:1786)
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:486)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeCreate(WSRelationalRAAdapter.java:320)
... 22 more
can anyone help me.
Thanx in advance.