Topic
  • No replies
dasnani
dasnani
1 Post

Pinned topic Error in outbound Oracle EBS module when using Websphere adapter for EBS

‏2010-05-17T16:44:59Z |
Hi,

I am writing a flow when an event in Siebel triggers an update in a EBS database table. I was able to get the Siebel inbound module working fine but when I try to write to the Oracle EBS table, I am getting this error below. Is there any adapter related configuration that needs to be done on the Oracle EBS side to be able to use the adapter? I am under the impression that any adapter related configuration needs to be doen only if I am receoving an Inbound message from Oracle EBS but may be wrong. Please advise as soon as possible.

5/17/10 11:30:22:978 CDT 000000fe FfdcProvider I com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on C:\IBM\WID7_WTE\runtimes\bi_v7\profiles\qwps\logs\ffdc\server1_45364536_10.05.17_11.30.22.9004195276557145301100.txt com.ibm.ejs.j2c.MCWrapper.getConnection 873
5/17/10 11:30:22:978 CDT 000000fe MCWrapper E J2CA0021E: An exception occurred while trying to get a Connection from the Managed Connection resource UC1_BASICFLOW_EBS_OUT/INTF/OracleOutboundInterface_CF : javax.resource.ResourceException: Closed Connection
at com.ibm.j2ca.oracleebs.runtime.OracleManagedConnection.initWBIConnection(OracleManagedConnection.java:258)
at com.ibm.j2ca.oracleebs.runtime.OracleManagedConnection.getWBIConnection(OracleManagedConnection.java:617)
at com.ibm.j2ca.base.WBIManagedConnection.getConnection(WBIManagedConnection.java:266)
at com.ibm.ejs.j2c.MCWrapper.getConnection(MCWrapper.java:2082)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:707)
at com.ibm.j2ca.base.WBIConnectionFactory.getConnection(WBIConnectionFactory.java:74)
at com.ibm.ws.sca.binding.j2c.J2CInterfaceBindingImpl.invoke(J2CInterfaceBindingImpl.java:147)
at com.ibm.ws.sca.binding.j2c.handler.J2CImportHandler.invokeDynamicImport(J2CImportHandler.java:1314)
at com.ibm.ws.sca.binding.j2c.handler.J2CImportHandler.processBase(J2CImportHandler.java:402)
at com.ibm.ws.sca.binding.j2c.handler.J2CNativeImportHandler.processMessage(J2CNativeImportHandler.java:118)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessageWithPCI(MessageDispatcherImpl.java:764)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1605)
at com.ibm.ws.sca.internal.message.impl.ManagedMessageImpl.process(ManagedMessageImpl.java:955)
at com.ibm.ws.sca.uow.handler.UOWNativeWASStrategyImpl.transactionAnyActivitySessionAny(UOWNativeWASStrategyImpl.java:297)
at com.ibm.ws.sca.uow.handler.JoinUOWNativeHandler.processMessage(JoinUOWNativeHandler.java:169)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessageWithPCI(MessageDispatcherImpl.java:764)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1605)
at com.ibm.ws.sca.internal.proxy.impl.ProxyInvocationHandlerImpl.invoke(ProxyInvocationHandlerImpl.java:1043)
at com.ibm.ws.sca.internal.proxy.impl.ProxyInvocationHandlerImpl.invoke(ProxyInvocationHandlerImpl.java:717)
at $Proxy64.invoke(Unknown Source)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.invokeTargetComponentSync(NativeMediationImplementationHandler.java:1223)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.processSyncReqRespMessage(NativeMediationImplementationHandler.java:228)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.processSyncRequestWithResponse(NativeMediationImplementationHandler.java:747)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.syncOneWayToSyncReqResp(NativeMediationImplementationHandler.java:593)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.processMessage(NativeMediationImplementationHandler.java:296)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessageWithPCI(MessageDispatcherImpl.java:753)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1605)
at com.ibm.ws.sca.internal.message.impl.ManagedMessageImpl.process(ManagedMessageImpl.java:955)
at com.ibm.ws.sca.uow.handler.UOWNativeWASStrategyImpl.transactionGlobalActivitySessionAny(UOWNativeWASStrategyImpl.java:709)
at com.ibm.ws.sca.uow.handler.JoinUOWNativeHandler.processMessage(JoinUOWNativeHandler.java:180)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessageWithPCI(MessageDispatcherImpl.java:764)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1605)
at com.ibm.ws.sca.internal.binding.handler.SCAExportMessageHelper.processMessage(SCAExportMessageHelper.java:327)
at com.ibm.ws.sca.internal.binding.handler.spi.impl.ExportSCAInvoker.invoke(ExportSCAInvoker.java:63)
at com.ibm.ws.container.binding.classicsca.ejb.EJBDefaultBindingServiceProvider$EJBDefaultBindingServiceInvoker.invoke(EJBDefaultBindingServiceProvider.java:57)
at com.ibm.ws.container.binding.classicsca.ejb.EJBDefaultBindingServiceProvider$EJBDefaultBindingServiceInvoker.invoke(EJBDefaultBindingServiceProvider.java:40)
at com.ibm.ws.container.binding.ejb.BaseContainerBeanImpl.invoke(BaseContainerBeanImpl.java:44)
at com.ibm.wsspi.container.binding.sca.remote.ServiceRemoteBean_16812.processMessage(Unknown Source)
at com.ibm.wsspi.container.binding.sca.remote.EJSRemoteCSLGENERICINTF_TO_EBSINTFExport_29762085.processMessage(EJSRemoteCSLGENERICINTF_TO_EBSINTFExport_29762085.java)
at com.ibm.ws.sca.internal.binding.handler.SCAImportBindingHandler.processMessageLocal(SCAImportBindingHandler.java:622)
at com.ibm.ws.sca.internal.binding.handler.SCAImportBindingHandler.access$000(SCAImportBindingHandler.java:91)
at com.ibm.ws.sca.internal.binding.handler.SCAImportBindingHandler$1.run(SCAImportBindingHandler.java:1027)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.ws.sca.internal.binding.handler.SCAImportBindingHandler.processClassicMessage(SCAImportBindingHandler.java:1024)
at com.ibm.ws.sca.internal.binding.handler.SCAImportBindingHandler.processMessage(SCAImportBindingHandler.java:305)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessageWithPCI(MessageDispatcherImpl.java:764)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1605)
at com.ibm.ws.sca.internal.message.impl.ManagedMessageImpl.process(ManagedMessageImpl.java:955)
at com.ibm.ws.sca.uow.handler.UOWNativeWASStrategyImpl.transactionAnyActivitySessionAny(UOWNativeWASStrategyImpl.java:297)
at com.ibm.ws.sca.uow.handler.JoinUOWNativeHandler.processMessage(JoinUOWNativeHandler.java:169)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessageWithPCI(MessageDispatcherImpl.java:764)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1605)
at com.ibm.ws.sca.internal.proxy.impl.ProxyInvocationHandlerImpl.invoke(ProxyInvocationHandlerImpl.java:1043)
at com.ibm.ws.sca.internal.proxy.impl.ProxyInvocationHandlerImpl.invoke(ProxyInvocationHandlerImpl.java:717)
at $Proxy63.invoke(Unknown Source)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.invokeTargetComponentSync(NativeMediationImplementationHandler.java:1223)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.processSyncReqRespMessage(NativeMediationImplementationHandler.java:228)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.processSyncRequestWithResponse(NativeMediationImplementationHandler.java:747)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.asyncOneWayToSyncOneWay(NativeMediationImplementationHandler.java:514)
at com.ibm.wbiserver.mediation.NativeMediationImplementationHandler.processMessage(NativeMediationImplementationHandler.java:328)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1740)
at com.ibm.ws.sca.internal.message.impl.ManagedMessageImpl.process(ManagedMessageImpl.java:946)
at com.ibm.ws.sca.uow.handler.UOWNativeWASStrategyImpl.transactionGlobalActivitySessionAny(UOWNativeWASStrategyImpl.java:709)
at com.ibm.ws.sca.uow.handler.JoinUOWNativeHandler.processMessage(JoinUOWNativeHandler.java:180)
at com.ibm.ws.sca.internal.message.impl.MessageDispatcherImpl.processMessage(MessageDispatcherImpl.java:1751)
at com.ibm.ws.sca.internal.message.impl.ManagedMessageImpl.process(ManagedMessageImpl.java:946)
at com.ibm.ws.sca.internal.async.impl.AbstractAsyncInboundHandler.processMessage(AbstractAsyncInboundHandler.java:121)
at com.ibm.wsspi.sca.async.bean.impl.ServiceSIBusMessageBean.processMessage(ServiceSIBusMessageBean.java:317)
at com.ibm.wsspi.sca.async.bean.impl.ServiceSIBusMessageBean.access$000(ServiceSIBusMessageBean.java:58)
at com.ibm.wsspi.sca.async.bean.impl.ServiceSIBusMessageBean$1.onMessage(ServiceSIBusMessageBean.java:91)
at com.ibm.wbiserver.manualrecovery.ejb.RecoveryMDBHandler.processMessage(RecoveryMDBHandler.java:161)
at com.ibm.wbiserver.manualrecovery.ejb.RecoveryMDBHandler.onMessage(RecoveryMDBHandler.java:100)
at com.ibm.wsspi.sca.async.bean.impl.ServiceSIBusMessageBean.onMessage(ServiceSIBusMessageBean.java:162)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.ibm.ws.container.binding.jms.TransactionalMessageEndpoint.invokeBusinessMethod(TransactionalMessageEndpoint.java:381)
at com.ibm.ws.container.binding.jms.TransactionalMessageEndpoint.invoke(TransactionalMessageEndpoint.java:458)
at $Proxy62.onMessage(Unknown Source)
at com.ibm.ws.sib.ra.inbound.impl.SibRaEndpointInvokerImpl.invokeEndpoint(SibRaEndpointInvokerImpl.java:157)
at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:900)
at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:550)
at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:399)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)
Caused by: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.pool.OraclePooledConnection.getConnection(OraclePooledConnection.java:284)
at oracle.jdbc.xa.OracleXAConnection.getConnection(OracleXAConnection.java:89)
at com.ibm.j2ca.oracleebs.runtime.OracleManagedConnection.initializeConnectionFromXAProps(OracleManagedConnection.java:792)
at com.ibm.j2ca.oracleebs.runtime.OracleManagedConnection.initWBIConnection(OracleManagedConnection.java:237)
... 84 more