Long Running SQL Statements Leads To "Socket Read Timed Out" Exceptions In SOA Suite Server (Doc ID 2261913.1)

Last updated on MAY 09, 2017

Applies to:

Oracle SOA Suite - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.7.0 version, Fabric

Long running SQL statements leads to "Socket read timed out" exceptions in SOA suite server

<Feb 20, 2017 9:44:17 AM UTC> <Error> <Default> <BEA-000000> <exception happened while executing post-undeploy.
oracle.net.ns.NetException: Socket read timed out
at oracle.bpm.bpmn.engine.ejb.impl.BPMNEngineBean.onComponentOverwrite(BPMNEngineBean.java:201)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
...
Caused By: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: IO Error: Socket read timed out
Error Code: 17002
Call: SELECT * FROM (SELECT /*+ FIRST_ROWS */ a.*, ROWNUM rnum FROM (SELECT CIKEY AS a1, AG_MILESTONE_PATH AS a2, AG_ROOT_ID AS a3, AT_COUNT_ID AS a4, AT_DETAIL_ID AS a5, AT_EVENT_ID AS a6, CACHE_VERSION AS a7, CMPST_ID AS a8, COMPONENT_NAME AS a9, COMPONENTTYPE AS a10, COMPOSITE_LABEL AS a11, COMPOSITE_NAME AS a12, COMPOSITE_REVISION AS a13, CONVERSATION_ID AS a14, CREATION_DATE AS a15, CREATOR AS a16, DOMAIN_NAME AS a17, ECID AS a18, EXT_INT1 AS a19, EXT_STRING1 AS a20, EXT_STRING2 AS a21, METADATA AS a22, MODIFIER AS a23, MODIFY_DATE AS a24, OUTCOME AS a25, PARENT_ID AS a26, PARENT_REF_ID AS a27, PRIORITY AS a28, PROCESS_TYPE AS a29, ROOT_ID AS a30, SCOPE_CSIZE AS a31, SCOPE_REVISION AS a32, SCOPE_USIZE AS a33, STAGE AS a34, STATE AS a35, STATUS AS a36, TENANT_ID AS a37, TEST_CASE AS a38, TEST_RUN_ID AS a39, TEST_RUN_NAME AS a40, TEST_SUITE AS a41, TITLE AS a42 FROM CUBE_INSTANCE WHERE ((((((DOMAIN_NAME = ?) AND (COMPOSITE_NAME = ?)) AND (COMPONENT_NAME = ?)) AND (COMPOSITE_REVISION = ?)) AND (COMPONENTTYPE = ?)) AND (STATE IN (?, ?))) ORDER BY CREATION_DATE DESC) a WHERE ROWNUM <= ?) WHERE rnum > ?
bind => [9 parameters bound]
Query: ReadAllQuery(referenceClass=CubeInstanceVO sql="SELECT * FROM (SELECT /*+ FIRST_ROWS */ a.*, ROWNUM rnum FROM (SELECT CIKEY AS a1, AG_MILESTONE_PATH AS a2, AG_ROOT_ID AS a3, AT_COUNT_ID AS a4, AT_DETAIL_ID AS a5, AT_EVENT_ID AS a6, CACHE_VERSION AS a7, CMPST_ID AS a8, COMPONENT_NAME AS a9, COMPONENTTYPE AS a10, COMPOSITE_LABEL AS a11, COMPOSITE_NAME AS a12, COMPOSITE_REVISION AS a13, CONVERSATION_ID AS a14, CREATION_DATE AS a15, CREATOR AS a16, DOMAIN_NAME AS a17, ECID AS a18, EXT_INT1 AS a19, EXT_STRING1 AS a20, EXT_STRING2 AS a21, METADATA AS a22, MODIFIER AS a23, MODIFY_DATE AS a24, OUTCOME AS a25, PARENT_ID AS a26, PARENT_REF_ID AS a27, PRIORITY AS a28, PROCESS_TYPE AS a29, ROOT_ID AS a30, SCOPE_CSIZE AS a31, SCOPE_REVISION AS a32, SCOPE_USIZE AS a33, STAGE AS a34, STATE AS a35, STATUS AS a36, TENANT_ID AS a37, TEST_CASE AS a38, TEST_RUN_ID AS a39, TEST_RUN_NAME AS a40, TEST_SUITE AS a41, TITLE AS a42 FROM CUBE_INSTANCE WHERE ((((((DOMAIN_NAME = ?) AND (COMPOSITE_NAME = ?)) AND (COMPONENT_NAME = ?)) AND (COMPOSITE_REVISION = ?)) AND (COMPONENTTYPE = ?)) AND (STATE IN (?, ?))) ORDER BY CREATION_DATE DESC) a WHERE ROWNUM <= ?) WHERE rnum > ?")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1494)
...
Caused By: java.sql.SQLRecoverableException: IO Error: Socket read timed out
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:967)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
...
Caused By: oracle.net.ns.NetException: Socket read timed out
at oracle.net.ns.Packet.receive(Packet.java:341)
at oracle.net.ns.DataPacket.receive(DataPacket.java:108)
at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:317)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:262)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:187)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:104)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:126)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:82)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1178)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:314)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

 

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