Cannot Define Data Version In GTM 6.3.3 - Source Version Field Is Missing (Doc ID 1664207.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms

 When attempting to Add and define a new Data Version, the following error occurs.

 -- Error

java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."GTM_DATA_VERSION"."SOURCE_VERSION")

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
at glog.util.jdbc.SqlUpdate.processBatch(SqlUpdate.java:147)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:246)
at glog.util.jdbc.SqlUpdate.resetArguments(SqlUpdate.java:168)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:93)
at glog.util.beandata.BeanDataInserter.insertDBBatch(BeanDataInserter.java:380)
at glog.util.beandata.BeanDataInserter.insertDB(BeanDataInserter.java:321)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:205)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:241)
at glog.util.beandata.BeanDataInserter.insert(BeanDataInserter.java:178)
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: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:123)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper.compareAndStore(GenericContainerUtilSessionServerSideEJBWrapper.java:306)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.compareAndStore(Unknown Source)
at glog.webserver.update.AbstractUpdate.callGenericContainer(AbstractUpdate.java:359)
at glog.webserver.update.GenericContainerXMLUpdate.process(GenericContainerXMLUpdate.java:131)
at glog.server.xmlupdate.XMLUpdateSessionBean.updateAndTrack(XMLUpdateSessionBean.java:244)
at glog.server.xmlupdate.XMLUpdateSessionServerSideEJBWrapper.updateAndTrack(XMLUpdateSessionServerSideEJBWrapper.java:394)
at glog.server.xmlupdate.XMLUpdateSessionHome_x72wrp_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at glog.server.xmlupdate.XMLUpdateSessionHome_x72wrp_EOImpl.updateAndTrack(Unknown Source)
at glog.server.xmlupdate.XMLUpdateSessionHome_x72wrp_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)


 -- Steps
 The issue can be reproduced at will with the following steps.

1, Navigate to Trade Master Data > Power Data > Data Loading > Data Verson
2. Create New
3. Input the following info:

Data Version ID
Content Type ID
Content Source ID
Source Date

4. Click Finished
5. The following error is displayed:

java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("GLOGOWNER"."GTM_DATA_VERSION"."SOURCE_VERSION")

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