Details
I am facing 2 kinds of error one is No more data to read from socket and Broken pipe line.
1.No more data to read from socket
ERROR DESCRIPTION : com.wm.adk.error.AdapterServiceException: [ADA.1.316] Cannot execute the SQL statement “UPDATE SCHEMA.TABLENAME SET ID = ?, DESC = ?, CONTENT = ?, SID = ? WHERE ID = ?”. “(17410) No more data to read from socket” No more data to read from socket at com.wm.util.BasisRuntimeException.(BasisRuntimeException.java:256) …
2.Broken pipe
ERROR DESCRIPTION : com.wm.adk.error.AdapterServiceException: [ADA.1.316] Cannot execute the SQL statement “UPDATE SCHEMA.TABLENAME SET ID = ?, DESC = ?, CONTENT = ?, SID = ? WHERE ID = ?”. “(17002) Io exception: Broken pipe” Io exception: Broken pipe at com.wm.adk.error.AdapterException.(AdapterException.java:299)
Note : The scenario we are facing the issue when the Adapter service is trying to update the attachment table with BLOB data
Connection properties
Transaction type:local_Transaction
Other properties: driverType=Thin
Enable connection pool:true
Minimum pool size:0
Maximum pool size:10
pool increment size:1
Block time out:1000
Expire timeout:1000
startup Retry:0
startup Blockoff timeout:30
Can any body has faced this issues what could be the reason and solution for the issue…Please give your comments…ASAP…