SQL Error 1403:ogg Synchronization

Source: Internet
Author: User
Tags sql error

Synchronization Target failed Error:

2015-05-21 09:33:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, Repraca.prm:PROCESS abending.
2015-05-21 09:39:33 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, Mgr.prm:REPLICAT Repraca starting.
2015-05-21 09:39:33 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, Mgr.prm:REPLICAT Repraca restarted Automat Ically.
2015-05-21 09:39:33 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, Repraca.prm:REPLICAT Repraca starting.
2015-05-21 09:39:33 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, Repraca.prm:SQL statement executed succes Sfully.
2015-05-21 09:39:33 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, Repraca.prm:SQL statement executed succes Sfully.
2015-05-21 09:39:33 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, Repraca.prm:REPLICAT Repraca started.
2015-05-21 09:39:33 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, Repraca.prm:No unique key was defined for Table Met_nui_allergen. All viable
Columns'll is used to represent the key, and may not guarantee uniqueness. Keycols May is used to define the key.
2015-05-21 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.
2015-05-21 09:39:33 WARNING OGG-01137 Oracle GoldenGate Delivery for Oracle, Repraca.prm:BATCHSQL suspended, Continuin G in normal mode.
2015-05-21 09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca.prm:Repositioning to RBA 1933837 In Seqno 4.
2015-05-21 09:39:33 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, repraca.prm:Aborted grouped transaction o N ' his. Met_nui_allergen ', Database
Error 1403 ().
2015-05-21 09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca.prm:Repositioning to RBA 1933837 In Seqno 4.
2015-05-21 09:39:33 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, Repraca.prm:SQL error 1403 mapping he. Met_nui_allergen to his. Met_nui_alle
RGEN.
2015-05-21 09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca.prm:Repositioning to RBA 1933837 In Seqno 4.
2015-05-21 09:39:33 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, Repraca.prm:Error mapping from the his. Met_nui_allergen to his. Met_nui_allergen
.
2015-05-21 09:39:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, Repraca.prm:PROCESS abending.
2015-05-21 09:42:33 WARNING OGG-00947 Oracle GoldenGate Manager for Oracle, MGR.PRM:LAG for Replicat Repraca is 00:11: (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:2015/05/21 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)


2015/05/21 09:28:15.994.354 GGSPKUpdateLen 396 RBA 1933837--UPDATE statement Issue manual update, skip the statement ...
Name:his. Met_nui_allergen
After Image:partition 4 G s
00c5 0000 000b 0000 0007 3230 3635 3630 3700 0100 | .......... 2065607 ...
0500 0000 0131 0002 0008 0000 0004 4139 3939 0003 | ..... 1........a999.
000a 0000 0006 b0d7 bcd3 bada 0004 0005 0000 0001 | ....................
3300 0500 0500 0000 0131 0006 0004 ffff 0000 0007 | 3........1 .....
000a 0000 0006 3030 3134 3832 0008 0015 0000 3230 | ...... 001482......20
3135 2d30 352d 3134 3a31 343a 3534 3a31 3500 0900 | 15-05-14:14:54:15 ...
04ff ff00 0000 0a00 0030 3030 312d 3031 2d30 | ........... 0001-01-0
Before Image Len 199 (X000000C7)
Keylen 197 (X000000C5)
KeyCol 0 (x0000), Len (x000b)
0000 0007 3230 3635 3630 37 | .... 2065607
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 (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 (x000a)
0000 0006 3030 3134 3832 | .... 001482
KeyCol 8 (x0008), Len (x0015)
0000 3230 3135 2d30 352d 3134 3a31 343a 3534 3a31 | 2015-05-14:14:54:1
35 | 5
KeyCol 9 (x0009), Len 4 (x0004)
FFFF 0000 | ....
KeyCol (x000a), Len (x0015)
0000 3030 3031 2d30 312d 3031 3a30 303a 3030 3a30 | 0001-01-01:00:00:0
30 | 0
KeyCol (x000b), Len 6 (x0006)
0000 0002 4441 | .... DA
KeyCol (x000c), Len (x000d)
0000 0009 4147 3336 3831 3030 38 | .... AG3681008
KeyCol (x000d), Len (x000a)
0000 0000 0000 0000 0001 | ..........
KeyCol (x000e), Len 4 (x0004)
FFFF 0000 | ....


After Image Len 197 (X000000C5)
Column 0 (x0000), Len (x000b)
0000 0007 3230 3635 3630 37 | .... 2065607
Column 1 (x0001), Len 5 (x0005)
0000 0001 32 | ..... 2-------------------Change this place
Column 2 (x0002), Len 8 (x0008)
0000 0004 4139 3939 | .... A999
Column 3 (x0003), Len (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 (x000a)
0000 0006 3030 3134 3832 | .... 001482
Column 8 (x0008), Len (x0015)
0000 3230 3135 2d30 352d 3134 3a31 343a 3534 3a31 | 2015-05-14:14:54:1
35 | 5
Column 9 (x0009), Len 4 (x0004)
FFFF 0000 | ....
Column Ten (x000a), Len (x0015)
0000 3030 3031 2d30 312d 3031 3a30 303a 3030 3a30 | 0001-01-01:00:00:0
30 | 0
Column One (x000b), Len 6 (x0006)
0000 0002 4441 | .... DA
Column (x000c), Len (x000d)
0000 0009 4147 3336 3831 3030 38 | .... AG3681008
Column (x000d), Len (x000a)
0000 0000 0000 0000 0001 | ..........
Column (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 updating the table, skipping the transaction, and temporarily resolving the problem


SQL Error 1403:ogg Synchronization

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.