SQL error 1403: ogg synchronization, 1403ogg
An error occurred while synchronizing data to the target:
09:33:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repraca. prm: process abending.
09:39:33 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr. prm: replicat repraca starting.
09:39:33 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr. prm: replicat repraca restarted automatically.
09:39:33 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, repraca. prm: replicat repraca starting.
09:39:33 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, repraca. prm: SQL statement executed successfully.
09:39:33 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, repraca. prm: SQL statement executed successfully.
09:39:33 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repraca. prm: replicat repraca started.
09:39:33 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repraca. prm: No unique key is defined for table MET_NUI_ALLERGEN. All viable
Columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
09:39:33 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repraca. prm: Aborting BATCHSQL transaction. Detected inconsistent result: ex
Ecuted 1 operations in batch, resulting in 0 affected rows.
09:39:33 WARNING OGG-01137 Oracle GoldenGate Delivery for Oracle, repraca. prm: BATCHSQL susponded, continuing in normal mode.
09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca. prm: Repositioning to rba 1933837 in seqno 4.
09:39:33 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, repraca. prm: Aborted grouped transaction on 'his. MET_NUI_ALLERGEN ', Database
The error 1403 ().
09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca. prm: Repositioning to rba 1933837 in seqno 4.
09:39:33 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, repraca. prm: SQL error 1403 mapping HIS. MET_NUI_ALLERGEN to HIS. MET_NUI_ALLE
RGEN.
09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca. prm: Repositioning to rba 1933837 in seqno 4.
09:39:33 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, repraca. prm: Error mapping from HIS. MET_NUI_ALLERGEN to HIS. MET_NUI_ALLERGEN
.
09:39:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repraca. prm: process abending.
09:42:33 WARNING OGG-00947 Oracle GoldenGate Manager for Oracle, mgr. prm: Lag for replicat repraca is 00:11:17 (checkpoint updated 00:02:59 ag
O ).
Logdump find data change information
Logdump 519> sfh
___________________________________________________________________
Hdr-Ind: E (x45) Partition:. (x04)
UndoFlag:. (x00) BeforeAfter: A (x41)
RecLength: 396 (x018c) IO Time: 09:28:15. 994.354
IOType: 115 (x73) OrigNode: 255 (xff)
TransInd:. (x03) FormatType: R (x52)
SyskeyLen: 0 (x00) Incomplete:. (x00)
AuditRBA: 21 AuditPos: 214992528
Continued: N (x00) RecCount: 1 (x01)
09:28:15. 994.354 GGSPK Update Len 396 RBA 1933837 -- manually Update the Update statement and skip this statement...
Name: HIS. MET_NUI_ALLERGEN
After Image: Partition 4G s
00c5 0000 000b 0000 0007 3230 3635 3630 3700 | ...... 0100...
0500 0000 0131 0002 0008 0000 0004 4139 3939 | ...... 1 ...... a999 ..
000a 0000 0006 b0d7 bcd3 bada 0004 0005 0000 | ....................
3300 0500 0500 0000 0131 0006 ffff 0004 0000 | 3 ...... 1 ..........
000a 0000 0006 3030 3134 3832 0008 0015 0000 | ...... 3230 ...... 20
3135 2d30 352d 3134 3a31 343a 3534 3a31 3500 0900 | 15-05-14: 14: 54: 15...
04ff ff00 0000 0a00 1500 0030 3030 312d 3031 2d30 | ...... 0001-01-0
Before Image Len 199 (x000000c7)
KeyLen 197 (x000000c5)
KeyCol 0 (x0000), Len 11 (x000b)
0000 0007 3230 3635 37 |... 3630
KeyCol 1 (x0001), Len 5 (x0005)
0000 0001 31 |... 1
KeyCol 2 (x0002), Len 8 (x0008)
0000 0004 4139 3939 |... A999
KeyCol 3 (x0003), Len 10 (x000a)
0000 0006 b0d7 bcd3 bada | ..........
KeyCol 4 (x0004), Len 5 (x0005)
0000 0001 33 |... 3
KeyCol 5 (x0005), Len 5 (x0005)
0000 0001 31 |... 1
KeyCol 6 (x0006), Len 4 (x0004)
Ffff 0000 | ....
KeyCol 7 (x0007), Len 10 (x000a)
0000 0006 3030 3134 3832 |... 001482
KeyCol 8 (x0008), Len 21 (x0015)
0000 3230 3135 2d30 352d 3134 3a31 343a 3534 3a31 |...: 14: 54: 1
35 | 5
KeyCol 9 (x0009), Len 4 (x0004)
Ffff 0000 | ....
KeyCol 10 (x000a), Len 21 (x0015)
0000 3030 3031 2d30 312d 3031 3a30 303a 3030 3a30 | .. 0001-01-01: 00: 00: 0
30 | 0
KeyCol 11 (x000b), Len 6 (x0006)
0000 0002 4441 |... DA
KeyCol 12 (x000c), Len 13 (x000d)
0000 0009 4147 3336 3831 38 |... agw.1008
KeyCol 13 (x000d), Len 10 (x000a)
0000 0000 0000 0000 | ..........
KeyCol 14 (x000e), Len 4 (x0004)
Ffff 0000 | ....
After Image Len 197 (x000000c5)
Column 0 (x0000), Len 11 (x000b)
0000 0007 3230 3635 37 |... 3630
Column 1 (x0001), Len 5 (x0005)
0000 0001 32 |... 2 --------------------- modify this location
Column 2 (x0002), Len 8 (x0008)
0000 0004 4139 3939 |... A999
Column 3 (x0003), Len 10 (x000a)
0000 0006 b0d7 bcd3 bada | ..........
Column 4 (x0004), Len 5 (x0005)
0000 0001 33 |... 3
Column 5 (x0005), Len 5 (x0005)
0000 0001 31 |... 1
Column 6 (x0006), Len 4 (x0004)
Ffff 0000 | ....
Column 7 (x0007), Len 10 (x000a)
0000 0006 3030 3134 3832 |... 001482
Column 8 (x0008), Len 21 (x0015)
0000 3230 3135 2d30 352d 3134 3a31 343a 3534 3a31 |...: 14: 54: 1
35 | 5
Column 9 (x0009), Len 4 (x0004)
Ffff 0000 | ....
Column 10 (x000a), Len 21 (x0015)
0000 3030 3031 2d30 312d 3031 3a30 303a 3030 3a30 | .. 0001-01-01: 00: 00: 0
30 | 0
Column 11 (x000b), Len 6 (x0006)
0000 0002 4441 |... DA
Column 12 (x000c), Len 13 (x000d)
0000 0009 4147 3336 3831 38 |... agw.1008
Column 13 (x000d), Len 10 (x000a)
0000 0000 0000 0000 | ..........
Column 14 (x000e), Len 4 (x0004)
Ffff 0000 | ....
GGS tokens:
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 4158 365a 4141 3741 414b 6957 6e41 4251 0001 | AAAX6ZAA7AAKiWnABQ ..
TokenID x4c 'l' LOGCSN Info x00 Length 10
3235 3931 3637 3033 3930 | 2591670390
TokenID x36 '6' TRANID Info x00 Length 9
3230 322e 3133 2e38 36 | 202.13.86
Logdump 520>
Key commands
>pos &>ghdr on>detail data>ggstoken detai
Alter replicat REPRACA, extrba 1934359.
Manually update the table and skip the transaction. The problem is solved temporarily.