Goldengate Replication Abend With Mapping Error, column contains binary data (Doc ID 1642809.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Goal

To resolve:

ERROR   OGG-01296  Error mapping from $CEQ4.Q4DATA.ADTLOG to CARECAST_Q4.ADTLOG.

Following is taken from discard file:
Mapping error to target column:  DISCH_OLD_DICT_USE

DISCH-OLD-ADM-SERVICE = SUR
000000: 53 55 52 20                                     |SUR             |
DISCH-OLD-DICT-USE = SUR
000000: 53 55 52 20                                     |SUR             |
 

When replicat writes the discard and a valid column value is not present, it re-uses an old one. This is a separate issue
 

Solution

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