My Oracle Support Banner

ADG Extract Missing First Column (Column 0) To Capture (Doc ID 2395953.1)

Last updated on JUNE 05, 2019

Applies to:

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


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
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)...





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.