My Oracle Support Banner

Reverse Engineer a CSV File Reports 'ORA-01400: cannot insert NULL into ("<WORK_SCHEMA>"."SNP_REV_COL"."COL_NAME")' (Doc ID 2569193.1)

Last updated on JULY 30, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Information in this document applies to any platform.

Symptoms

When trying to reverse engineer a large CSV file using Oracle Data Integrator (ODI), it fails with below error:

com.sunopsis.dwg.SQLWorkReposException: ORA-01400: cannot insert NULL into ("<WORK_SCHEMA>"."SNP_REV_COL"."COL_NAME")
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
   at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
   at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
   at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
   at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
   at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:5136)
   at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1519)
   at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:353)
   at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:178)
   at com.sun.proxy.$Proxy32.executeUpdate(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor154.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$StatementInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:173)
   at com.sun.proxy.$Proxy33.executeUpdate(Unknown Source)
   at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:689)
   at com.sunopsis.dwg.dbobj.generated.GeneratedSnpRevCol.insertAction(GeneratedSnpRevCol.java:1183)
   at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3649)
   at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3679)
   at com.sunopsis.dwg.dbobj.SnpTable.createRevCol(SnpTable.java:641)
   at com.sunopsis.dwg.dbobj.SnpTable.fileDataStoreReversePhase1(SnpTable.java:1137)
   ...

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


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