ADG Extract Missing First Column (Column 0) To Capture

(Doc ID 2395953.1)

Last updated on MAY 16, 2018

Applies to:

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

Symptoms

using ADG mode of Extract process. Extract process misses the first column (Column 0) to capture from the table.

Trandata is enabled on all columns for this table. The column has been seen in the Logminer output.

Due to this replicat process is abending with the below error.

Process Abending : 2018-03-19 08:54:41

Oracle GoldenGate Delivery for Oracle process started, group R_FADB_A discard
file opened: 2018-03-19 09:01:22.991466
Key column COLUMN_NAME (0) is missing from update on table
SCHEMA.TABLE
Missing 1 key columns in update for table SCHEMA.TABLE.
Current time: 2018-03-19 09:01:25
Discarded record from action ABEND on error 0

Aborting transaction on /u01/app/oracle/product/ogg_12_3_10/dirdat/ra
beginning at seqno 78012 rba 87931465
error at seqno 78012 rba 87936531
Problem replicating SCHEMA.TABLE to SCHEMA.TABLE
Mapping problem with compressed update record (target format)...

 

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