Topic
  • 7 replies
  • Latest Post - ‏2013-02-21T06:04:05Z by Tarunkumartarun
SystemAdmin
SystemAdmin
3556 Posts

Pinned topic Jdbc Inbound adapter problem with Oracle database

‏2011-12-15T13:39:05Z |
I have configured the JDBC Inbound adapter, It was not picking the data from event table,It is throwing the below exception.
12/15/11 3:06:21:269 MST 00000049 JDBCRA001 E com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand retreiveBO CWYBS0497E: The Resource Bundle com.ibm.j2ca.jdbc.LogMessages using Locale en_US cannot be loaded.
12/15/11 3:06:21:279 MST 00000049 JDBCRA001 E com.ibm.j2ca.jdbc.JDBCRecord getNext Exception Occured When Event is not null.
com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

12/15/11 3:06:21:294 MST 00000049 ExceptionUtil E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "onNotification" on bean "BeanId(MWWR6ESB_PublishProductServiceApp#MWWR6ESB_PublishProductServiceEJB.jar#export.JDBCInboundPMMEventInterfaceEIS, null)". Exception data: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:130)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: com.ibm.despi.exception.DESPIException: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:111)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
... 19 more
Caused by: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
... 20 more
Wrapped by:
com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:481)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:130)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
... 18 more
Caused by: com.ibm.despi.exception.DESPIException: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:111)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
... 19 more
Caused by: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
... 20 more
12/15/11 3:06:21:300 MST 00000049 JDBCRA001 E com.ibm.j2ca.extension.eventmanagement.internal.EventSender sendEvent() Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy64@c900c9
javax.resource.ResourceException: Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy64@c900c9
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:256)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: com.ibm.ejs.container.UnknownLocalException: ; nested exception is: com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:481)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
... 10 more
Caused by: com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
... 19 more
Caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:130)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
... 18 more
Caused by: com.ibm.despi.exception.DESPIException: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:111)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
... 19 more
Caused by: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
... 20 more

javax.resource.ResourceException: Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy64@c900c9
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:256)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
Caused by: com.ibm.ejs.container.UnknownLocalException: ; nested exception is: com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:481)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
... 10 more
Caused by: com.ibm.websphere.sca.ServiceRuntimeException: commonj.connector.runtime.DataBindingException: Failed in population return object: caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
... 19 more
Caused by: commonj.connector.runtime.DataBindingException: Failed in population return object
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:130)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
... 18 more
Caused by: com.ibm.despi.exception.DESPIException: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:111)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
... 19 more
Caused by: com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
... 20 more

12/15/11 3:06:21:303 MST 00000049 JDBCRA001 A com.ibm.j2ca.extension.eventmanagement.internal.EventSender deliverEvent() CWYBS0504E: Failed to send event. Error: javax.resource.ResourceException: Caught SelectorException/DataBindingException exception while delivering event to endpoint: $Proxy64@c900c9 Explanation=The event list could not be sent to the endpoint. UserAction=Verify that the target application is online, and that the event exists in the enterprise information system (EIS).
12/15/11 3:06:35:229 MST 00000049 JDBCRA001 E com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand retreiveBO CWYBS0497E: The Resource Bundle com.ibm.j2ca.jdbc.LogMessages using Locale en_US cannot be loaded.
12/15/11 3:06:35:239 MST 00000049 JDBCRA001 E com.ibm.j2ca.jdbc.JDBCRecord getNext Exception Occured When Event is not null.
com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

com.ibm.j2ca.base.exceptions.RecordNotFoundException: No matching records found, error code:
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.retrieveBO(DBRetrieveCommand.java:176)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.doRetrieve(DBRetrieveCommand.java:111)
at com.ibm.j2ca.dbadapter.core.runtime.commands.DBRetrieveCommand.executeInternal(DBRetrieveCommand.java:73)
at com.ibm.j2ca.jdbc.commands.JDBCRetrieveCommand.execute(JDBCRetrieveCommand.java:57)
at com.ibm.j2ca.jdbc.JDBCRecord.getNext(JDBCRecord.java:96)
at com.ibm.j2ca.dbadapter.core.emd.databinding.DBDataBinding.getDataObject(DBDataBinding.java:103)
at com.ibm.wsspi.sca.j2c.inbound.J2CInboundImpl.invoke(J2CInboundImpl.java:274)
at com.ibm.wsspi.sca.j2c.inbound.InboundListenerImpl.onNotification(InboundListenerImpl.java:32)
at sun.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1018)
at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:747)
at $Proxy64.onNotification(Unknown Source)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.deliverEvent(EventSender.java:236)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.doSendEvent(EventSender.java:339)
at com.ibm.j2ca.extension.eventmanagement.internal.EventSender.sendEvent(EventSender.java:213)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.sendEvents(EventListSender.java:134)
at com.ibm.j2ca.extension.eventmanagement.internal.EventListSender.run(EventListSender.java:104)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:136)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:782)
at com.ibm.ws.asynchbeans.ExecutionContextImpl.go(ExecutionContextImpl.java:85)
at com.ibm.ejs.j2c.work.AsyncWorkProxy.run(AsyncWorkProxy.java:90)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

Please help me resolving this issue.

Thanks in advance.
  • Tarunkumartarun
    Tarunkumartarun
    6 Posts

    Re: Jdbc Inbound adapter problem with Oracle database

    ‏2012-10-08T13:20:13Z  
    I also faced the same problem .
  • SystemAdmin
    SystemAdmin
    3556 Posts

    Re: Email outbound adapter problem

    ‏2012-10-29T07:44:36Z  
    I also faced the same problem .
    I am also facing the same issue but with Email Adapter.Any clue if any one has resolve this issue...

    I am getting below exception:-
    10/28/12 4:51:57:370 CDT 00000062 EMARA001 I com.ibm.j2ca.email.EmailManagedConnection createManagedConnection CWYBS0497E: The Resource Bundle com.ibm.j2ca.email.LogMessages using Locale en_US cannot be loaded.
    10/28/12 4:51:57:531 CDT 00000062 EMARA001 I com.ibm.j2ca.email.EmailInteraction execute CWYBS0497E: The Resource Bundle com.ibm.j2ca.email.LogMessages using Loc
    ale en_US cannot be loaded.
    Thanks in advance
  • Tarunkumartarun
    Tarunkumartarun
    6 Posts

    Re: Email outbound adapter problem

    ‏2012-10-29T07:50:57Z  
    I am also facing the same issue but with Email Adapter.Any clue if any one has resolve this issue...

    I am getting below exception:-
    10/28/12 4:51:57:370 CDT 00000062 EMARA001 I com.ibm.j2ca.email.EmailManagedConnection createManagedConnection CWYBS0497E: The Resource Bundle com.ibm.j2ca.email.LogMessages using Locale en_US cannot be loaded.
    10/28/12 4:51:57:531 CDT 00000062 EMARA001 I com.ibm.j2ca.email.EmailInteraction execute CWYBS0497E: The Resource Bundle com.ibm.j2ca.email.LogMessages using Loc
    ale en_US cannot be loaded.
    Thanks in advance
    HI PSaxena

    Do u have any idea about XSL transformation.

    Thanks
    Tarun
  • SystemAdmin
    SystemAdmin
    3556 Posts

    Re: Email outbound adapter problem

    ‏2012-10-30T11:08:14Z  
    HI PSaxena

    Do u have any idea about XSL transformation.

    Thanks
    Tarun
    Hi Tarun,

    Yes,I have an idea of XSLT transformation.Please let me know how can I help you.
  • Tarunkumartarun
    Tarunkumartarun
    6 Posts

    Re: Email outbound adapter problem

    ‏2012-10-31T09:53:48Z  
    Hi Tarun,

    Yes,I have an idea of XSLT transformation.Please let me know how can I help you.
    Hi PSaxena,

    Thank you very much for giving +ve response . I am sending one .rar file please find that . In this one pdf file is there and one .zip file .i followed the instruction given in pdf but i didnt find 'ProfileToCustomer_res_1-out.xml'file wherever it should be according to tutorial .

    This is the 2nd part of 5th chapter in given pdf . can u help me to find out why i m not getting this file.
    tarunbathla786@gmail.com is my id please add me there if u dont have nay problem so,we can share knowledge frequently

    Thank you
    Tarun
  • JayLopez
    JayLopez
    2 Posts

    Re: Jdbc Inbound adapter problem with Oracle database

    ‏2012-12-06T18:27:36Z  
    Having a similar issue with an oracle database. Did you resolve? If yes,how?
  • Tarunkumartarun
    Tarunkumartarun
    6 Posts

    Re: Jdbc Inbound adapter problem with Oracle database

    ‏2013-02-21T06:04:05Z  
    • JayLopez
    • ‏2012-12-06T18:27:36Z
    Having a similar issue with an oracle database. Did you resolve? If yes,how?
    HI Experts,

    Can you please send me the steps for retriving data from db2 threw Process Designer (lombardi)

    Thanks