Replicat abends with GGS WARNING 162 and Error 218 and looking in the discard file at the record in error have Blank key values (Doc ID 1203383.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

Replicat failing on update or delete operation with: 

2010-08-23 10:46:47 GGS ERROR 218 Error mapping from GGATE.TDTEST to GG_WORK_DB.TDTEST.

When you look in the discard file for your replicat you see that your Key field for a update are blank(in the below example CUSTID is the key for the TDTEST table.

Aborting transaction on ./dirdat/vo beginning at seqno 0 rba 1184
error at seqno 0 rba 1184
Problem replicating GGATE.TDTEST to GG_WORK_DB.TDTEST
Mapping problem with compressed update record (target format)...
*
CUSTID =
ADDRESS = 1, My Rd

Changes

Since the key field is blank for and update or delete, please check in your source system if Supplemental logging was enabled for the table and database level.
--
GGSCI> dblogin userid <user> password <pwd>
GGSCI > info trandata GGATE.TDTEST

Logging of supplemental redo log data is disabled for table GGATE.TDTEST.
--

Trandata should not be disabled

NOTE FOR Oracle RDBMS:   if supplemental logging has been added to a table not using the ADD TRANDATA command it is possible that OGG will report it as DISABLED even when it is not. 
Please check for supplemental logging using the following query, so show if it is enabled, and the columns in the supplemental logging. Please replace XXX with your schema , and YYY with the table name
Select * from dba_log_groups where owner=’XXX’ and table_name =’'YYY';
select * from dba_log_group_columns where owner ='XXX' and table_name=’YYY’;

Cause

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