Communication Issue Between ExaLogic And Exadata Results ASAP Unable To Process Orders In NEP/JNEP (Doc ID 2121539.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Communications ASAP - Version 7.2.0 and later
Information in this document applies to any platform.

Symptoms

There is a communication issue between ExaLogic (ASAP/WLS) and Exadata (DB), which results in ASAP unable to process orders in the NEP. The connection issue is faced between two components (SARM and NEP) of ASAP after an  IDLE time.

We captured the DATA Traffic/flow between ASAP and Database and found a few re-transmissions and lost segments happening (using Wireshark).

After some idle time the NEP is unable to process the orders and the new ones are not getting processed. In most of the cases, a restart of NEP/JNEP resolved the issue temporarily.

JNEP diag:

>> 065052.416:Connection handler vieuasade00-41752:LOW :com.mslv.activation.cartridge.xxx.axiros.axess.x3_2.sip_line.add.generated.AddSip_lineProxy:
Logging 0 info parameters.
>> 065052.416:Connection handler vieuasade00-41752:LOW :<<static>>:
SSP_info_parm_n_log_array entry
>> 065052.417:Connection handler vieuasade00-41752:PROG:<<static>>:
Error: Failed to execute SSP_log for SRQ_ID 271074, IO Error: Connection reset
>> 065052.417:Connection handler vieuasade00-41752:PROG:<<static>>:
java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1025)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4710)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at com.mslv.activation.jinterpreter.Log.SSP_info_parm_n_log_array(Log.java:304)
at com.mslv.activation.jinterpreter.Log.log(Log.java:718)
at com.mslv.activation.jinterpreter.Log.logWithInfoParam(Log.java:599)
at com.mslv.activation.jinterpreter.NEConnection.flushLogWithInfoParams(NEConnection.java:745)
at com.mslv.activation.jinterpreter.JProcessor.flushLogsWithInfoParams(JProcessor.java:272)
at com.mslv.activation.jinterpreter.JInterpConnection.runClassMethod(JInterpConnection.java:244)
at com.mslv.activation.jinterpreter.JInterpConnection.handleMessage(JInterpConnection.java:131)
at com.mslv.activation.server.ConnectionHandler.run(ConnectionHandler.java:251)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at oracle.net.ns.DataPacket.send(DataPacket.java:199)
at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:211)
at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:227)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:175)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:100)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:122)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:78)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1179)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
... 13 more

>> 065052.417:Connection handler vieuasade00-41752:LOW :<<static>>:
SSP_info_parm_n_log_array exit

>> 065052.595:Connection handler vieuasade00-41752:PROG:<<static>>:
Failed to establish connection to the SARM database: Closed Connection: OraclePooledConnection.getConnection() - SQLException Ocurred:Invalid or Stale Connection found in the Connection Cache

 

Changes

 

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