My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.