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

Last updated on APRIL 18, 2017

Applies to:

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

Symptoms

GoldenGate replicat abend caused by "[Teradata Database] Column 'TPO_CANAL' 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 "P_STG_CRED_OWNER_V"."VW_TIT...). ODBC error: SQLSTATE
 23000 native database error -3811. [Teradata][ODBC Teradata Driver][Teradata Database] Column 'TPO_CANAL' is NOT NULL. Give the column a value.

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

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