Connection Is Intermittently Closed In Between Transaction When Integrated SOA Gateway (ISG) Services Are Being Invoked (Doc ID 2009088.1)

Last updated on DECEMBER 19, 2016

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.2.3 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

Symptoms

E-Business Suite (EBS) - 12.2.x (Where x is 3 or 4) 
Service Oriented Architecture (SOA) - 11.1.1.7 and Patch 17507959 (For EBS 12.2.3) OR Patch 20504227 (For EBS 12.2.4)

Current Behavior:
When the Simple Object Access Protocol (SOAP) Services that are generated through Integrated SOA Gateway (ISG) are called, the Connections are intermittently getting lost during the Create or Update Operations of the Webservices.
The transactions that are using this connection fail with the following in the SOA Diagnostics logs:

...

[2015-02-10T13:40:05.467+08:00] [soa_server1] [ERROR] [] [oracle.soa.mediator] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ORACLE] 
[ecid: 682edc87dfec24b3:fa07b82:14b6d2069a0:-8000-000000000001c4f0,0] [APP: soa-infra] [J2EE_APP.name: soa-infra] [J2EE_MODULE.name: fabric] 
[WEBSERVICE.name: ESB_QUERY_PKG_Service] [WEBSERVICE_PORT.name: ESB_QUERY_PKG_Port] [composite_instance_id: 695063] [component_instance_id: 695062] 
[composite_name:ESB_QUERY_PKG!1.0] [component_name: ESB_QUERY_PKG_BPEL] 
oracle.apps.fnd.isg.monitor.callout.SOAPAuditUtil.updateResponse Connection has already been closed. ... ... 
[2015-02-09T16:00:03.469+08:00] [soa_server1] [ERROR] [] [oracle.soa.mediator] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ORACLE] 
[ecid: 682edc87dfec24b3:fa07b82:14b6d2069a0:-8000-000000000000136e,0] [APP: soa-infra] [J2EE_APP.name: soa-infra] [J2EE_MODULE.name: fabric] 
[WEBSERVICE.name: ESB_QUERY_PKG_Service] [WEBSERVICE_PORT.name: ESB_QUERY_PKG_Port] [composite_instance_id: 690217] [component_instance_id: 690217] 
[composite_name: ESB_QUERY_PKG!1.0] [component_name: ESB_QUERY_PKG_BPEL] 
oracle.apps.fnd.isg.monitor.callout.SOAPAuditUtil.createRequest Connection has already been closed. 
[2015-02-09T16:00:03.478+08:00] [soa_server1] [ERROR] [] [oracle.soa.mediator] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ORACLE] 
[ecid: 682edc87dfec24b3:fa07b82:14b6d2069a0:-8000-000000000000136e,0] [APP: soa-infra] [J2EE_APP.name: soa-infra] [J2EE_MODULE.name: fabric] 
[WEBSERVICE.name: ESB_QUERY_PKG_Service] [WEBSERVICE_PORT.name: ESB_QUERY_PKG_Port] [composite_instance_id: 690217] [component_instance_id: 690217] 
[composite_name:ESB_QUERY_PKG!1.0] [component_name: ESB_QUERY_PKG_BPEL] 
oracle.apps.fnd.isg.monitor.callout.SOAPAuditUtil.createRequestjava.sql.SQLException: Connection has already been closed.
[[ at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:62) 
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:100) 
at weblogic.jdbc.wrapper.PoolConnection.setAutoCommit(PoolConnection.java:151) 
at oracle.apps.fnd.isg.monitor.SOAPAuditUtil.createRequest(SOAPAuditUtil.java:39) 
at oracle.apps.fnd.isg.monitor.SOAPAudit.auditRequest(SOAPAudit.java:149)

...

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms