No more data to read from socket

, ,
1

Hi All,

I got this error while inserting into the DB, All records get inserted but this perticular record not get inserted. Any body help me about this error.

  1. There is no data issue.
  2. Connectvity fine

Please help me out solving this error. Please see the following error.

No more data to read from socket" No more data to read from socket at com.wm.adk.WmAdapter.createAdapterConnectionException(WmAdapter.java:263) at com.wm.adapter.wmjdbc.connection.ConnectionInfo.handleSQLException(Unknown Source) at com.wm.adapter.wmjdbc.services.CustomSQL.execute(Unknown Source) at com.wm.adk.cci.interaction.WmInteraction.execute(WmInteraction.java:70) at com.wm.pkg.art.ns.AdapterServiceNode.invokeService(AdapterServiceNode.java:616) at com.wm.pkg.art.ns.ARTNSService.baseInvoke(ARTNSService.java:47) at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:587) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:229) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:199) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:407) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:503) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:367) at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246) at com.wm.app.b2b.server.BaseService.invoke(BaseService.java:157) at com.wm.lang.flow.FlowInvoke.invoke(FlowInvoke.java:324) at com.wm.lang.flow.FlowState.invokeNode(FlowState.java:581) at com.wm.lang.flow.FlowState.step(FlowState.java:438) at com.wm.lang.flow.FlowState.invoke(FlowState.java:403) at com.wm.app.b2b.server.FlowSvcImpl.baseInvoke(FlowSvcImpl.java:1749) at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:587) at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44) at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:229) at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49) at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:199) at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39) at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:407) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:503) at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:325) at com.wm.app.b2b.server.dispatcher.trigger.Trigger.invokeService(Trigger.java:291) at com.wm.app.b2b.server.dispatcher.trigger.Trigger.processMessage(Trigger.java:195) at com.wm.app.b2b.server.dispatcher.trigger.DefaultTriggerTaskHelper.process(DefaultTriggerTaskHelper.java:206) at com.wm.app.b2b.server.dispatcher.trigger.TriggerTask.run(TriggerTask.java:228) at com.wm.util.pool.PooledThread.run(PooledThread.java:105) at java.lang.Thread.run(Thread.java:534) com.wm.util.BasisException: [117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service 117. com.wm.adk.error.AdapterConnectionException: [ADA.1.316] Cannot execute the SQL statement

2

Were you inserting into a blob or clob column by chance?

3

Hi All,

    I am facing similar issue : 

   ORA-17410: No more data to read from socket 

    Using Wm6.5, in a day 2-4 transactions fail  with the above error.
    But if resubmitted once, then Successfully goes.


    Ideas are really appreciated.

Thanks
samson

4

is the issue resolved. I’m also missing such error when there is huge transactions.