Oracle Database 12.1.0.2
Solaris 11.4
Hello Team,
replication for a table is abending with error below
Process Abending : 2019-10-02 06:36:37
ora12c@dware1:/ogg/ora12c/dirrpt$ cat REPLOGGT3.dsc
Oracle GoldenGate Delivery for Oracle process started, group REPLOGGT discard file opened: 2019-10-02 05:36:26.870260
Current time: 2019-10-02 05:36:28
Discarded record from action ABEND on error 1403
OCI Error ORA-01403: no data found, SQL <UPDATE "CBSOGG"."WF_TODOITEM" x SET x."NOTES_V" = :a3 WHERE x."WORK_ID_N" = :b0>
Aborting transaction on /ogg/ora12c/dirdat/cd beginning at seqno 306 rba 63,650,132
error at seqno 306 rba 63650397
Problem replicating CLM_TT.WF_TODOITEM to CBSOGG.WF_TODOITEM.
Record not found
Mapping problem with unified update record (target format) SCN:46.45.36873...
*
WORK_ID_N = 1589713
000000: 31 35 38 39 37 31 33 |1589713 |
NOTES_V = Incident created 3408820 For the trouble ticket 1306446
000000: 49 6e 63 69 64 65 6e 74 20 63 72 65 61 74 65 64 |Incident created|
000010: 20 33 34 30 38 38 32 30 20 46 6f 72 20 74 68 65 | 3408820 For the|
000020: 20 74 72 6f 75 62 6c 65 20 74 69 63 6b 65 74 20 | trouble ticket |
000030: 31 33 30 36 34 34 36 |1306446 |
WORK_ID_N = 1589713
000000: 31 35 38 39 37 31 33 |1589713 |
NOTES_V = Incident created 3408821 For the trouble ticket 1306446
000000: 49 6e 63 69 64 65 6e 74 20 63 72 65 61 74 65 64 |Incident created|
000010: 20 33 34 30 38 38 32 31 20 46 6f 72 20 74 68 65 | 3408821 For the|
000020: 20 74 72 6f 75 62 6c 65 20 74 69 63 6b 65 74 20 | trouble ticket |
000030: 31 33 30 36 34 34 36 |1306446 |
*
Process Abending : 2019-10-02 05:36:33
ora12c@dware1:/ogg/ora12c/dirrpt$ cd ..
ora12c@dware1:/ogg/ora12c$ ./logdump
Oracle GoldenGate Log File Dump Utility for Oracle
Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432
Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.
Logdump 29 >exit
ora12c@dware1:/ogg/ora12c$ cd dirdat/
ora12c@dware1:/ogg/ora12c/dirdat$ ls
aa aa000000271 aa000000278 aa000000285 aa000000292 aa000000299 aa000000306 cd cd000000275 cd000000282 cd000000289 cd000000296 cd000000303 cd000000310
aa000000265 aa000000272 aa000000279 aa000000286 aa000000293 aa000000300 aa000000307 cd000000269 cd000000276 cd000000283 cd000000290 cd000000297 cd000000304 cd000000311
aa000000266 aa000000273 aa000000280 aa000000287 aa000000294 aa000000301 aa000000308 cd000000270 cd000000277 cd000000284 cd000000291 cd000000298 cd000000305 cd000000312
aa000000267 aa000000274 aa000000281 aa000000288 aa000000295 aa000000302 aa000000309 cd000000271 cd000000278 cd000000285 cd000000292 cd000000299 cd000000306 cd000000313
aa000000268 aa000000275 aa000000282 aa000000289 aa000000296 aa000000303 aa000000310 cd000000272 cd000000279 cd000000286 cd000000293 cd000000300 cd000000307 cd000000314
aa000000269 aa000000276 aa000000283 aa000000290 aa000000297 aa000000304 aa000000311 cd000000273 cd000000280 cd000000287 cd000000294 cd000000301 cd000000308 cd000000315
aa000000270 aa000000277 aa000000284 aa000000291 aa000000298 aa000000305 aa000000312 cd000000274 cd000000281 cd000000288 cd000000295 cd000000302 cd000000309 cd000000316
ora12c@dware1:/ogg/ora12c/dirdat$ pwd
/ogg/ora12c/dirdat
ora12c@dware1:/ogg/ora12c/dirdat$ cd ..
ora12c@dware1:/ogg/ora12c$ ./logdump
Oracle GoldenGate Log File Dump Utility for Oracle
Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432
Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.
Logdump 29 >open /ogg/ora12c/dirdat/cd000000306
Current LogTrail is /ogg/ora12c/dirdat/cd000000306
Logdump 30 >pos 63650397
Reading forward from RBA 63650397
Logdump 31 >detail data
Logdump 32 >ggstoken detail
Logdump 33 >sfh
2019/10/01 16:16:06.000.123 GGSUnifiedUpdate Len 158 RBA 63650397
Name: CLM_TT.WF_TODOITEM (TDR Index: 9)
After Image: Partition 12 G m
0000 004d 0000 000a 0000 0000 0000 0018 41d1 0002 | ...M............A...
003b 0000 0037 496e 6369 6465 6e74 2063 7265 6174 | .;...7Incident creat
6564 2033 3430 3838 3230 2046 6f72 2074 6865 2074 | ed 3408820 For the t
726f 7562 6c65 2074 6963 6b65 7420 3133 3036 3434 | rouble ticket 130644
3600 0000 0a00 0000 0000 0000 1841 d100 0200 3b00 | 6............A....;.
0000 3749 6e63 6964 656e 7420 6372 6561 7465 6420 | ..7Incident created
3334 3038 3832 3120 466f 7220 7468 6520 7472 6f75 | 3408821 For the trou
Before Image Len 81 (x00000051)
BeforeColumnLen 77 (x0000004d)
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0018 41d1 | ........A.
Column 2 (x0002), Len 59 (x003b)
0000 0037 496e 6369 6465 6e74 2063 7265 6174 6564 | ...7Incident created
2033 3430 3838 3230 2046 6f72 2074 6865 2074 726f | 3408820 For the tro
7562 6c65 2074 6963 6b65 7420 3133 3036 3434 36 | uble ticket 1306446
After Image Len 77 (x0000004d)
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0018 41d1 | ........A.
Column 2 (x0002), Len 59 (x003b)
0000 0037 496e 6369 6465 6e74 2063 7265 6174 6564 | ...7Incident created
2033 3430 3838 3231 2046 6f72 2074 6865 2074 726f | 3408821 For the tro
7562 6c65 2074 6963 6b65 7420 3133 3036 3434 36 | uble ticket 1306446
Trandata has been enabled for that table. Replication was working fine for that table since past 2 weeks.
Kindly advise whether I should enable auditing to catch if someone has deleted some rows on target?
Regards,
Joe
GGS tokens:
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 424d 3256 4142 5641 4143 446f 3041 4348 0001 | AABM2VABVAACDo0ACH..
Logdump 34 >