My Oracle Support Banner

"java.sql.BatchUpdateException: No more data to read from socket", Error While Processing Inbound ShipmentStatus XML (Doc ID 2317928.1)

Last updated on OCTOBER 23, 2017

Applies to:

Oracle Transportation Management - Version 6.4.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to process an inbound ShipmentStatus XML through the integration UI the following error occurs.

Business Process Automation -> Integration -> Integration Manager -> Upload an XML/CSV Tranmission

ERROR
-----------------------
2017-09-20 16:32:52.319 701215 Error Exception [ap1-001804] [SQL_STATEMENT] insert into ie_ss_stop (i_rec_no,i_transaction_no,stop_sequence,port_location_function_code,location_refnum_qual_gid,location_id_value,location_name,event_city,event_state,event_country,splc_code,latitude,longitude,terminal_name,gate_pier_door_number,time_zone_gid,eventdate,aei_indicator,partition_key,reference_position,stop_type,location_gid,domain_name,erpc) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) at [26749869, 100432281, 2, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, XXXXXXXXX, null]
  java.sql.BatchUpdateException: No more data to read from socket

java.sql.BatchUpdateException: No more data to read from socket
  at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296)
  at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
  at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:216)
  at glog.util.jdbc.noserver.SqlPreparedStatement.executeBatch(SqlPreparedStatement.java:99)
  at glog.util.jdbc.SqlUpdate.processBatch(SqlUpdate.java:240)
  at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:346)
  at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:261)
  at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:160)
  at glog.util.beandata.BeanDataInserter.insertDBBatch(BeanDataInserter.java:399)
  at glog.util.beandata.BeanDataInserter.insertDB(BeanDataInserter.java:325)
  at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:207)
  at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:244)
  at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:180)
  at glog.util.persistence.BeanDataPersistenceExecutor.insertPerformed(BeanDataPersistenceExecutor.java:97)
  at glog.util.persistence.PersistenceExecutor.persistencePerformed(PersistenceExecutor.java:91)
  at glog.util.persistence.WaterFallInsertion.performedInsertion(WaterFallInsertion.java:264)
  at glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:106)
  at glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:137)
  at glog.util.persistence.WaterFallInsertion.persist(WaterFallInsertion.java:49)
  at glog.util.persistence.PersistenceManager.execute(PersistenceManager.java:122)
  at glog.util.genericcontainer.GenericContainerUtilSessionBean.store(GenericContainerUtilSessionBean.java:37)
  at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper.store(GenericContainerUtilSessionServerSideEJBWrapper.java:48)
  at glog.util.genericcontainer.GenericContainerUtilSessionBean.compareAndStore(GenericContainerUtilSessionBean.java:74)
  at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper.compareAndStore(GenericContainerUtilSessionServerSideEJBWrapper.java:177)
  at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.__WL_invoke(Unknown Source)
  at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:34)
  at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.compareAndStore(Unknown Source)
  at glog.integration.xmlbasewrapper.XmlBaseWrapper.persist(XmlBaseWrapper.java:292)
  at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistContainerSelf(XmlBaseWrapper.java:328)
  at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:399)
  at glog.integration.application.shipmentstatus.ShipmentStatusInterface.persistShipmentStatus(ShipmentStatusInterface.java:290)
  at glog.integration.application.shipmentstatus.ShipmentStatusInterface.persistXML(ShipmentStatusInterface.java:250)
  at glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:278)
  at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:224)
  at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:356)
  at glog.server.workflow.transproc.TransProc.execute(TransProc.java:111)
  at glog.server.workflow.SimpleWorkflow.execute(SimpleWorkflow.java:23)
  at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
  at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper.execute(WorkflowSessionNonTransServerSideEJBWrapper.java:40)
  at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.__WL_invoke(Unknown Source)
  at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:34)
  at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(Unknown Source)
  at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:356)
  at glog.server.workflow.Trigger.trigger(Trigger.java:122)
  at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:145)
  at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:100)
  at glog.util.event.EventThread.run(EventThread.java:86)
  at java.lang.Thread.run(Thread.java:745)
 [publishWait - 3]

Alert log file shows the error:

ORA-07445: core dump [qcsIsColInFro()+358]

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.