Data fetched from Oracle database instance through mid-servers are not loaded properly and fails with "JDBCProbe SEVERE *** ERROR *** No more data to read from socket"


Description

Data fetched from Oracle Database instance through mid-servers are not loaded properly, and below error is genrated in the ECC quque and MID server logs

JDBCProbe SEVERE *** ERROR *** No more data to read from socket

Release or Environment

ANY

Cause

1. The JDBC connection is established between the Server hosting the MID server (where the JDBC driver is installed) and the Oracle Database.
2. This error means that the JDBC driver was not able to read more data from the connection established towards the database.
3. The fact that this fails only at some specific time seems to indicate that something is happening at that time at database level that produce this outcome.

Additional Information

Below is the information that we have found about this type of error. One includes reference to MOS Article ID 1083922.1 Article ID 423982.1 for more troubleshooting details on the "no more data from socket" error.

a) java.sql.SQLRecoverableException: No more data to read from socket
https://community.oracle.com/thread/2257261

b) Oracle SQLException: No more data to read from socket
https://community.oracle.com/thread/1323079

c) 'No more data from socket' error.
http://www.dba-oracle.com/t_sqlexception_17410_no_more_data.htm

Unfortunately there is nothing else that we can do from ServiceNow perspective to find this problem's cause as this seems to be an issue related to ORACLE.

You need to involve your Oracle Support .