Error: java.sql.SQLRecoverableException: No more data to read from socket) entry in server.logs.

Error: java.sql.SQLRecoverableException: No more data to read from socket) entry in server.logs.

book

Article ID: KB0093411

calendar_today

Updated On:

Products Versions
TIBCO BusinessWorks ProcessMonitor -
Not Applicable -

Description

Description:
When TIBCO BusinessWorks ProcessMonitor (BWPM) is configured with an Oracle database, sometimes the following error is seen in the server.logs due to error (ORA-07445) occurred in Oracle database and BWPM. 

*************************

2015-01-16 11:07:57,971 INFO [Dataprovider:dpQueue_0.thread] dataprovider: dpQueue_0: consumer on queue created
2015-01-16 11:09:42,548 ERROR [Dataprovider:dpQueue_0.thread] com.faizsiegeln.njams.jdbcmodule.GenericJDBC_Module: java.sql.BatchUpdateException: No more data to read from socket
2015-01-16 11:09:42,548 ERROR [Dataprovider:dpQueue_0.thread] com.faizsiegeln.njams.jdbcmodule.GenericJDBC_Module: java.sql.SQLRecoverableException: No more data to read from socket
2015-01-16 11:09:42,548 ERROR [Dataprovider:dpQueue_0.thread] com.faizsiegeln.njams.jdbcmodule.GenericJDBC_Module: unable to process logmessage after 1 retries SEFAZ-DES: No more data to read from socket
2015-01-16 11:09:42,550 ERROR [Dataprovider:dpQueue_0.thread] dataprovider: sql exception in DpWorker occured
java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:75)
at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:641)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3928)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3934)
at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:125)
at com.sun.proxy.$Proxy5.commit(Unknown Source)
at com.faizsiegeln.njams.jdbcmodule.GenericJDBC_Module.submitToDB(GenericJDBC_Module.java:257)
at com.faizsiegeln.njams.dataprovider.DpWorker.writeMessage(DpWorker.java:508)
at com.faizsiegeln.njams.dataprovider.DpWorker.run(DpWorker.java:268)
at java.lang.Thread.run(Thread.java:744)

******************************************

Symptoms:
The following error is logged in the server.logs due to error (ORA-07445) occurring  in Oracle database and BWPM

**********************************

2015-01-16 11:07:57,971 INFO [Dataprovider:dpQueue_0.thread] dataprovider: dpQueue_0: consumer on queue created
2015-01-16 11:09:42,548 ERROR [Dataprovider:dpQueue_0.thread] com.faizsiegeln.njams.jdbcmodule.GenericJDBC_Module: java.sql.BatchUpdateException: No more data to read from socket
2015-01-16 11:09:42,548 ERROR [Dataprovider:dpQueue_0.thread] com.faizsiegeln.njams.jdbcmodule.GenericJDBC_Module: java.sql.SQLRecoverableException: No more data to read from socket
2015-01-16 11:09:42,548 ERROR [Dataprovider:dpQueue_0.thread] com.faizsiegeln.njams.jdbcmodule.GenericJDBC_Module: unable to process logmessage after 1 retries SEFAZ-DES: No more data to read from socket
2015-01-16 11:09:42,550 ERROR [Dataprovider:dpQueue_0.thread] dataprovider: sql exception in DpWorker occured
java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:75)
at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:641)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3928)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3934)
at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:125)
at com.sun.proxy.$Proxy5.commit(Unknown Source)
at com.faizsiegeln.njams.jdbcmodule.GenericJDBC_Module.submitToDB(GenericJDBC_Module.java:257)
at com.faizsiegeln.njams.dataprovider.DpWorker.writeMessage(DpWorker.java:508)
at com.faizsiegeln.njams.dataprovider.DpWorker.run(DpWorker.java:268)
at java.lang.Thread.run(Thread.java:744)

**********************************

 Also at database side oracle thread dump will be created with details like below:

***********************
Fri Jan 16 11:14:34 2015Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x76B4E05, LpxFSMEvNext()+21509] [flags: 0x0, count: 1]
Errors in file /oracletrace/trace/diag/rdbms/des01/des011/trace/des011_ora_12984.trc (incident=177594):
ORA-07445: exception encountered: core dump [LpxFSMEvNext()+21509] [SIGSEGV] [ADDR:0x0] [PC:0x76B4E05] [Address not mapped to object] []
Incident details in: /oracletrace/trace/diag/rdbms/des01/des011/incident/incdir_177594/des011_ora_12984_i177594.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Jan 16 11:14:37 2015
Sweep [inc][177594]: completed

*************************************



Cause:
This is caused because of Oracle internal issue (ORA-07445) .

Issue/Introduction

Error: java.sql.SQLRecoverableException: No more data to read from socket) entry in server.logs.

Resolution

The workaround is as follows (according to Oracle Support):

Alter session set events= '31156 trace name context forever, level 0x400';

Customer's DBA should create a logon trigger to alter the sessions used by TIBCO BusinessWorks ProcessMonitor(BWPM) to resolve issue.



Additional Information

This is a confirmed Oracle Bug 11666959. See https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=8gssinzj5_4&_afrLoop=3497 53948882132 for further details (requires Oracle Support Account).