BINDING.JCA-12511

BINDING.JCA-12511

DB interaction failure in some of the servers, even after the deployment was successful, any DB actions from nodes other than primary node failed with following error:

#### <[ACTIVE] ExecuteThread: '89' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <18ad0897b9b46ad4:-2bb4c844:13db9225527:-7ffd-000000000009dd5c> <1364640266308>

#### <[ACTIVE] ExecuteThread: '89' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <18ad0897b9b46ad4:-2bb4c844:13db9225527:-7ffd-000000000009dd5c> <1364640266316>

BINDING.JCA-12511

JCA Binding Component connection issue.

JCA Binding Component is unable to create an outbound JCA (CCI) connection.

servicebus WSDL/TestSerivce/Test/ServiceEngines/DBAdapter [ DBAdapter_ptt::DBAdapter(DBAdapterInput_msg,DBAdapterOutputCollection) ] - : The JCA Binding Component was unable to establish an outbound JCA CCI connection due to the following issue: BINDING.JCA-12561

JCA Resource Adapter location error (WebLogic).

Unable to locate the JCA Resource Adapter via .jca binding file element

The JCA Binding Component is unable to startup the Resource Adapter specified in the element:  location='eis/DB/TestDB'.

The reason for this is most likely that either

1) the Resource Adapters RAR file has not been deployed successfully to the WebLogic J2EE Application server or

2) the JNDI setting in the WebLogic JCA deployment descriptor has not been set to eis/DB/TestDB. In the last case you might have to add a new 'connector-factory' entry (connection) to the deployment descriptor.

Please correct this and then restart the WebLogic Application Server

Please make sure that the JCA connection factory and any dependent connection factories have been configured with a sufficient limit for max connections. Please also make sure that the physical connection to the backend EIS is available and the backend itself is accepting connections.

        at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFPort_JCA$JCAConnectionPool.createJCAConnectionFactory(WSIFPort_JCA.java:1625)

        at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFPort_JCA$JCAConnectionPool.newPoolObject(WSIFPort_JCA.java:1487)

        at oracle.tip.adapter.sa.impl.fw.common.ObjectPool.checkOut(ObjectPool.java:177)

        at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFPort_JCA$JCAConnectionPool.checkOut(WSIFPort_JCA.java:1696)

        at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFPort_JCA.obtainJCAConnection(WSIFPort_JCA.java:1016)

        at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.performOperation(WSIFOperation_JCA.java:406)

        at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeOperation(WSIFOperation_JCA.java:365)

        at oracle.tip.adapter.sa.impl.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.java:324)

        at oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.invokeWsifProvider(JCABindingReferenceImpl.java:344)

        at oracle.tip.adapter.sa.impl.JCABindingReferenceImpl.request(JCABindingReferenceImpl.java:256)

        at com.bea.wli.sb.transports.jca.binding.JCATransportOutboundOperationBindingServiceImpl.invoke(JCATransportOutboundOperationBindingServiceImpl.java:150)

        at com.bea.wli.sb.transports.jca.JCATransportEndpoint.sendRequestResponse(JCATransportEndpoint.java:209)

        at com.bea.wli.sb.transports.jca.JCATransportEndpoint.send(JCATransportEndpoint.java:170)

        at com.bea.wli.sb.transports.jca.JCATransportProvider.sendMessageAsync(JCATransportProvider.java:575)

        at sun.reflect.GeneratedMethodAccessor497.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at com.bea.wli.sb.transports.Util$1.invoke(Util.java:83)

        at $Proxy143.sendMessageAsync(Unknown Source)

In weblogic console, under testing tab of DBAdapter.rar all outbound connection pools were not visible. The issue is that updated Plan.xml is not replicated to all other nodes. You have to manually copy the Plan.xml containing all outbound connection pool to all server instance nodes. 

Perform below steps in server:

ORACLE_HOME/soa/Plan.xml

• Copy the Plan.xml containing all outbound connection pool to all nodes
• Update the connector application DBAdapter.rar
• Restart DBAdapter.rar and Application server instance