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) .