• Font Size
  • S
  • M
  • L

Search via FAQ No.


  • No : 30639
  • Open Date : 2019/09/02 12:00
  • Print
NEW

[DataSpider Servista] java.sql.SQLException: There is no more data to read from the socket

The following error has occurred.
 
java.sql.SQLException: There is no more data to read from the socket.
 
Please tell me about the cause and a way to resolve this problem.
 
Category : 

Answer

■Error Condition
 
This error occurs when you try to read or write data or destroy a component pool of global resources after a session between DataSpiderServer and a connection destination is disconnected.
 
■Probable cause
 
In the past case, this error occurred because the session was disconnected due to a timeout from either the network or the connection destination, or security software restrictions.
 
■Checkpoint and Workaround
 
Based on the past case, we will guide you on where to check and how to resolve the problem in the following:
  • Check the timeout of either network or the connection destination
Please make sure that the timeout setting of the network or the connection destination is set shorter than the read and write processing time or the active time of a component pool of the global resource.
 
Note: For the active time of the global resource component pools, please refer to the help described in “Reference Information”.
 
If there is a setting that applies, set it to extend the time until the timeout.
 
  • Confirm applications that disconnect sessions, such as security software
Please make sure if there is an application, such as security software, that disconnects sessions with an active time longer than a certain time in the same environment.
 
If there is an application that applies, set it to extend the session disconnecting time.
 
  • Confirm the reproduction situation of the event
If there are no problems with a network or environment timeout settings, security software, or any other application that disconnects the session, please re-execute the process in which the error occurred and check whether the problem reoccurs.
 
If this does not happen again, there may be a temporary problem in the network or the connection destination. In this case, please check whether the network or the connection destination had a problem with sessions disconnecting
 
If the problem occurs again, there may be a problem with the product due to the specific process. Please summarize the process details and procedures, and inquire about it.
 
■Noted
 
When investigating problems that have occurred in the network or the connection destination, it is necessary to respond accordingly to the specifications of the network or the connection destination. For this reason, please contact the developer of the network or the connection destination.
 
In addition, when the product side investigation is necessary, please contact us regarding the error conditions (process contents and procedures).
 
*Since we can only confirm "I was trying to connect after the session was disconnected" from the inquired error message, a condition that causes the error is needed for the investigation.
 
 
■Supplementary
 
When this error occurs in the process of destroying a component pool of the global resource, the following warning may also be output during the time of
 "There is no more data to read from the socket."
 
| WARN | ds.kernel.mgr.dpc | Failed at the resource component DESTROY processing.
 
 
Reference information
  • [Global Resource]-[Component Pool]-[The life time of a component maintained in a pool]