Numeric Overflow - Error When Querying LOCATION_ACTIVITY_TIME_SEQ (Doc ID 749662.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle Transportation Management - Version: 5.5 to 5.5.06.03 - Release: 5.5 to 5.5
Information in this document applies to any platform.
***Checked for relevance on 19-May-2010***
Affects Integration into OTM

Symptoms

-- Problem Statement:

Inbound TransOrder transmissions are failing with the following Exception:

java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:7465)
at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:103)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:521)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getInt(I)I(Unknown Source)
at glog.util.jdbc.noserver.NoQueryFilter.getInt(NoQueryFilter.java:58)
at glog.util.jdbc.noserver.SqlQuery.getInt(SqlQuery.java:217)
at glog.integration.application.location.LocationRoleWrapper.setSequence(LocationRoleWrapper.java:153)
at glog.integration.application.location.LocationRoleWrapper.mapChildren(LocationRoleWrapper.java:126)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.map(XmlBaseWrapper.java:165)
at glog.integration.xmlbasewrapper.XmlBaseWrapperList.map(XmlBaseWrapperList.java:71)
at glog.integration.application.location.LocationWrapper.mapChildren(LocationWrapper.java:401)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.map(XmlBaseWrapper.java:165)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:274)
at glog.integration.application.location.LocationRefWrapper.persistViaContainer(LocationRefWrapper.java:46)
at glog.integration.application.order.TransOrderLineWrapper.toObLineData(TransOrderLineWrapper.java:268)
at glog.integration.application.order.TransOrderLineWrapper.mapSelf(TransOrderLineWrapper.java:171)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.map(XmlBaseWrapper.java:163)
at glog.integration.xmlbasewrapper.XmlBaseWrapperList.map(XmlBaseWrapperList.java:71)
at glog.integration.application.order.TransOrderLineDetailWrapper.mapChildren(TransOrderLineDetailWrapper.java:58)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.map(XmlBaseWrapper.java:165)
at glog.integration.application.order.TransOrderWrapper.mapChildren(TransOrderWrapper.java:96)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.map(XmlBaseWrapper.java:165)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:274)
at glog.integration.application.order.TransOrderWrapper.persistViaContainer(TransOrderWrapper.java:549)
at glog.integration.application.order.OrderInterface.persistTransorder(OrderInterface.java:160)
at glog.integration.application.order.OrderInterface.persistIndivXML(OrderInterface.java:139)
at glog.integration.application.order.OrderInterface.persistXML(OrderInterface.java:120)
at glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:185)
at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:210)

In reviewing the logs, the following SQL statement is prior to this Exception:

select max(location_activity_time_seq) from location_activity_time where location_gid = ? and location_role_gid = ?;

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