GoldenGate Column Mappings are Ignored When Replicating Oracle VARCHAR2 To Nvarchar, OGG-01154 SQL error 2627 mapping (Doc ID 1456474.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Symptoms


OGG v11.1.1.0.78 replicat abends with following error when replicating from Oracle varchar2 to SQL SERVER nvarchar.

Message 1 of 1 - Message: Cannot insert the value NULL into column 'COLUMN_NAME', table '<schema>.<table_name>'; column does not allow nulls. INSERT fails. Server: ADCDBPRO03 Procedure: Native Error: 515,515 State: 2,23000 Class: 16 Line Number: 1 Source: Microsoft SQL Server Native Client 10.0 Description: The statement has been terminated.

WARNING OGG-01154 SQL error 2627 mapping <schema>.<table_name> to <schema>.<table_name>  [SQL error 2627 (0xa43)]The statement has been terminated.

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