Replicat abends with GGS WARNING 162 and Error 218 and looking in the discard file at the record in error have Blank key values
Last updated on JANUARY 13, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168 and later
Information in this document applies to any platform.
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)...
ADDRESS = 1, My Rd
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’;
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