ADG Extract Missing First Column (Column 0) To Capture
Last updated on MAY 16, 2018
Applies to:Oracle GoldenGate - Version 126.96.36.199.0 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)...
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