GoldenGate Column Mappings are Ignored When Replicating Oracle VARCHAR2 To Nvarchar, OGG-01154 SQL error 2627 mapping
Last updated on FEBRUARY 06, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
OGG v22.214.171.124.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.
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