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 22.214.171.124.0 and later
Information in this document applies to any platform.
OGG v126.96.36.199.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!