My Oracle Support Banner

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 and later
Information in this document applies to any platform.


OGG v11. 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!

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