Friday, August 24, 2018

How to resolve Goldengate ERROR OGG-01296 Error mapping from source to target

My source and target columns match. I see the length size of all the columns compared to source and target matches as well. I made sure all the indexes and pk and fk exist on source and target. Yet the replicat is not working.

2018-08-24 18:32:01  ERROR   OGG-01296  Error mapping from FNOLUSER.VRS_PREDICTIVE_MODEL to FNOLUSER.VRS_PREDICTIVE_MODEL.

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************

Last record for the last committed transaction is the following:
___________________________________________________________________
Trail name :  /u01/app/ogg/12c/dirdat/dbname/exdbname2/bb000000
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)
RecLength  :   199 (x00c7)    IO Time    : 2018-08-24 16:46:05.000000
IOType     :     5  (x05)     OrigNode   :   255  (xff)


Solution: I enabled the supplemental logging on the source side.
ALTER TABLE fnoluser.VRS_PREDICTIVE_MODEL ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

No comments:

Post a Comment