Replicat Abends With Key Column <COL_NAME> (0) Is Missing From Update On Table <SCHEMA.TABLENAME>
(Doc ID 2963276.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.2 and laterInformation in this document applies to any platform.
Symptoms
Replicat is abended with the below errors:
Oracle GoldenGate Delivery for Oracle process started, group <REP_NAME> discard file opened: 2023-03-13 12:55:15.109389
Key column XXXXX_ID (0) is missing from update on table <SCHEMA.TABLENAME>
Missing 1 key columns in update for table <SCHEMA.TABLENAME>.
Current time: 2023-03-13 12:55:24
Discarded record from action ABEND on error 0
Aborting transaction on <trail path> beginning at seqno 4 rba 390,790,486
error at seqno 4 rba 390790486
Problem replicating <SCHEMA.TABLENAME> to <SCHEMA.TABLENAME>.
Mapping problem with unified update record (target format) SCN:101.21.XXXXXXX...
*
Since Extract is unable to captured the Key cols for an update after deleting
trandata for a table and re-adding the trandata for a schema:
1. add trandata <schema.tablename>
2. delete trandata <schema.tablename>
3. add schematrandata <schemaname>
2023/05/31 03:57:16.000.000 GGSUnifiedUpdate Len 41 RBA 2555
Name: <SCHEMA.TABLENAME> (TDR Index: 1)
After Image: Partition x0c G
s
1200 0000 0600 0500 0000 0100 3008 0005 0000 0001 | ............0.......
0030 0600 0500 0000 0100 3608 0006 0000 0002 0036 | .0........6........6
33 | 3
Before Image Len 22 (x00000016)
BeforeColumnLen 18 (x00000012)
Column 6 (x0006), Len 5 (x0005)
0000 0100 30 | ....0 >>>>>>>>>>>>>>>>Key cols 0 is not captured with before image
Column 8 (x0008), Len 5 (x0005)
0000 0100 30 | ....0
After Image Len 19 (x00000013) >>>>>>>>>>>>>>>>Key cols 0 is not captured with after image
Column 6 (x0006), Len 5 (x0005)
0000 0100 36 | ....6
Column 8 (x0008), Len 6 (x0006)
0000 0200 3633 | ....63
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |