Upload ActualShipment Created Error: Java.lang.ClassCastException: java.lang.String at glog.util.jdbc.noserver.SqlColumn$14.fromDB(SqlColumn.java:335) (Doc ID 1461103.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.2.5 to 6.2.6 [Release 6.2]
Information in this document applies to any platform.

Symptoms

On OTM version 6.2.5

When sending in a Shipment Actual the first time the Delivery stop of the shipment is being changed to a Pickup stop and the second time the same XML is sent in the following error is seen:

ERROR
-----------------------
Exception java.lang.ClassCastException: java.lang.String

java.lang.ClassCastException: java.lang.String
  at glog.util.jdbc.noserver.SqlColumn$14.fromDB(SqlColumn.java:335)
  at glog.util.jdbc.SqlColumn.convertFromDB(SqlColumn.java:56)
  at glog.ejb.execution.db.ShipmentRemarkPK.getAppValue(ShipmentRemarkPK.java:83)
  at glog.ejb.execution.db.ShipmentRemarkData.setShipmentRemarkPK(ShipmentRemarkData.java:87)
  at glog.ejb.execution.db.ShipmentRemarkData.setPk(ShipmentRemarkData.java:83)
  at glog.business.shipment.TShipment.addTChildren(TShipment.java:1362)
  at glog.business.shipment.TShipment.(TShipment.java:829)
  at glog.business.planningstructure.PlanningObjectLoader.getTShipment(PlanningObjectLoader.java:348)
  at glog.business.shipmentactual.ShipmentActualExecutor.execute(ShipmentActualExecutor.java:198)
  at glog.business.shipmentactual.ShipmentActualExecutor.execute(ShipmentActualExecutor.java:142)
  at glog.business.shipmentactual.ShipmentActualSessionBean.executeShipmentActual(ShipmentActualSessionBean.java:104)
  at glog.business.shipmentactual.ShipmentActualSessionServerSideEJBWrapper.executeShipmentActual(ShipmentActualSessionServerSideEJBWrapper.java:85)
  at glog.business.shipmentactual.ShipmentActualSessionHome_4tsowh_EOImpl.executeShipmentActual(ShipmentActualSessionHome_4tsowh_EOImpl.java:59)
  at glog.integration.application.shipment.ShipmentWrapper.invokeShipmentActualSession(ShipmentWrapper.java:1175)
  at glog.integration.application.shipment.ShipmentWrapper.invokeShipmentActualSession(ShipmentWrapper.java:1156)
  at glog.integration.application.shipment.ShipmentWrapper.persistViaShipmentActualSession(ShipmentWrapper.java:1215)
  at glog.integration.application.shipment.ShipmentWrapper.persistContainerSelf(ShipmentWrapper.java:1371)
  at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:352)
  at glog.integration.application.shipment.ShipmentInterface.persistIndivXML(ShipmentInterface.java:262)
  at glog.integration.application.shipment.ShipmentInterface.persistXML(ShipmentInterface.java:190)
  at glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:196)
  at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:224)
  at glog.server.workflow.transproc.TransProc.execute(TransProc.java:110)
  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:38)
  at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java:278)
  at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:352)
  at glog.server.workflow.Trigger.trigger(Trigger.java:122)
  at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:147)
  at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:98)
  at glog.util.event.EventThread.run(EventThread.java:87)
  at java.lang.Thread.run(Thread.java:619)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Shipment in OTM.
2. Send in an Actual Shipment XML.
3. Send in the XMl a second time.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms