Uploading AS.CSV Files In 6.3.1 All Numeric Fields Create An Error Similar to: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."ITINERARY"."TOTAL_COST")

(Doc ID 1565018.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.3.1 to 6.3.1 [Release 6.3]
Information in this document applies to any platform.

Symptoms

On OTM version 6.3.1 when uploading an as.csv file with numeric data the following error occurs.

ERROR
-----------------------

java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."ITINERARY"."TOTAL_COST")

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
at glog.util.jdbc.noserver.SqlPreparedStatement.executeUpdate(SqlPreparedStatement.java:36)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:250)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:166)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:91)
at glog.util.remote.BeanManagedEntityBean.executeUpdate(BeanManagedEntityBean.java:801)
at glog.util.remote.BeanManagedEntityBean$1.execute(BeanManagedEntityBean.java:199)
at glog.util.remote.BeanManagedEntityBean.dbModify(BeanManagedEntityBean.java:1074)
at glog.util.remote.BeanManagedEntityBean.doCreate(BeanManagedEntityBean.java:195)
at glog.util.remote.BaseEntityBean$1.doIt(BaseEntityBean.java:456)
at glog.util.remote.BaseEntityBean.ejb(BaseEntityBean.java:799)
at glog.util.remote.BaseEntityBean.ejbCreator(BaseEntityBean.java:454)
at glog.ejb.itinerary.db.ItineraryBeanDB.ejbCreate(ItineraryBeanDB.java:137)
at glog.ejb.itinerary.ItineraryHomeStub.create(ItineraryHomeStub.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at glog.integration.clientapi.ClientAPIImpl.insert(ClientAPIImpl.java:779)
at glog.integration.clientapi.ClientAPISessionBean.insert(ClientAPISessionBean.java:27)
at glog.integration.clientapi.ClientAPISessionServerSideEJBWrapper.insert(ClientAPISessionServerSideEJBWrapper.java:122)
at glog.integration.clientapi.ClientAPISessionHome_o35c8t_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.integration.clientapi.ClientAPISessionHome_o35c8t_EOImpl.insert(Unknown Source)
at glog.integration.clientapi.ClientAPISessionHome_o35c8t_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:667)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:522)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:518)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)





7 - Took the file and set all costs to be 1.0, the name of the file is: 04Itinerary_with_cost.as.csv

8 - With file 04Itinerary_with_cost.as.csv repeated steps 2 through to 5.

9 - The  error was gained

10 - Took the file and removed from the header line: ,totalCost
Also removed the cost and currenty code from each line.
The name of this file is: 04Itinerary_removed_cost.as.csv

11 - With file 04Itinerary_removed_cost.as.csv repeated steps 2 through 5.

There was no error and the screen displayed.
 

12 - Navigated to: Shipment Management > Itinerary Management > Itinerary Manager.

13 - Searched for the Itinerary.

14 - The Itinerary was presend in OTM and had been uplaoded.



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