GG Golden Gate Error OGG-00918 Key column is missing from map.

==================
General
==================
Golden Gate REPLICAT process is in status ABENDED
The error is:
OGG-00918 Key column is missing from map.

Checking the table in question on both sites:
- Table structure is same.
- Table has Primary Key.
- Data is not being replicated.
What can be the issue?

==================
Solution
==================

Try to drop and re-create the TRANDATA for the table in question

Site B

 

 GGSCI (qanfv-2-dbs-01 as ogg@igt) 9> DELETE TRANDATA LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY

2020-04-06 07:52:45  INFO    OGG-15142  Logging of supplemental redo log data disabled for table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY.

2020-04-06 07:52:45  INFO    OGG-15139  TRANDATA for scheduling columns has been disabled on table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY.

Site A

GGSCI (qanfv-1-dbs-1b as ogg@igt) 10> DELETE TRANDATA LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY

2020-04-06 07:52:57  INFO    OGG-15141  Logging of supplemental redo log data is already disabled for table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY.

2020-04-06 07:52:57  INFO    OGG-15139  TRANDATA for scheduling columns has been disabled on table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY.

Seems that TRANDATA was not in place to the table in question on site A.

This caused REPLICAT process to fail on site B. 

On Both Sites add TRANDATA and start Replication

GGSCI (qanfv-1-dbs-1b as ogg@igt) 11> ADD TRANDATA LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY

2020-04-06 07:53:37  INFO    OGG-15132  Logging of supplemental redo data enabled for table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY.

2020-04-06 07:53:37  INFO    OGG-15133  TRANDATA for scheduling columns has been added on table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY.

2020-04-06 07:53:37  INFO    OGG-15135  TRANDATA for instantiation CSN has been added on table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY.

2020-04-06 07:53:37  INFO    OGG-10471  ***** Oracle Goldengate support information on table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY *****

Oracle Goldengate support native capture on table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY.

Oracle Goldengate marked following column as key columns on table LAB_QANFV_ALLQQ.PSMS_VE_LOST_AND_FOUND_HISTORY: REC_SEQ.