My Oracle Support Banner

Replicat Abends With ODBC error: SQLSTATE 23000 native database error -3811 (Doc ID 2232215.1)

Last updated on MARCH 19, 2019

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


GoldenGate replicat abend caused by "[Teradata Database] Column '<COLUMN>' is NOT NULL. Give the column a value."

Source Context :
  SourceModule : [ggdb.odbc.util]
  SourceID : [/scratch/aime1/adestore/views/aime1_stuya22/oggcore/OpenSys/src/gglib/ggdbodbc/odbcutil.c]
  SourceFunction : [ODBCUTIL_check_err(RETCODE, SQLHENV, SQLHDBC, SQLHSTMT, short, const char *, ...)]
  SourceLine : [1930]

2017-01-01 14:18:17 ERROR OGG-00551 Database operation failed: Preparing statement (INSERT INTO "<OWNER>"."<OBJECT>). ODBC error: SQLSTATE
 23000 native database error -3811. [Teradata][ODBC Teradata Driver][Teradata Database] Column '<COLUMN>' is NOT NULL. Give the column a value.

However on source (Oracle Database) is not enable to insert Null.


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

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