I have followed your tutorial. Everythng works perfectly fine until I update any value in the source database, the replicat stops with error, WARNING OGG-00869 [SQL error 0 (0x0)][Oracle][ODBC PostgreSQL Wire Protocol driver]Invalid character value. Error in parameter 2. Kidly support on this this was my query in sqlplus SQL> update customers set cust_mobile=11223344 where cust_no=1015; 1 row updated. SQL> commit; Commit complete.
@myhungryman Жыл бұрын
Pls share download link of gg 19c for postgresql
@andelakshmipathi23893 жыл бұрын
2021-05-31 01:16:02 WARNING OGG-00869 Oracle GoldenGate Delivery, repint.prm: [SQL error 0 (0x0)][Oracle][ODBC PostgreSQL Wire Protocol driver]Numeric value out of range. Error in parameter 4. getting issue and replicat got abended
@andelakshmipathi23893 жыл бұрын
Please send me your any contact for solving my issue
@andelakshmipathi23893 жыл бұрын
[oracle@pg7 dirrpt]$ more diskg.dsc Oracle GoldenGate Delivery process started, group REPINT discard file opened: 2021-05-31 01:56:14.315547 Current time: 2021-05-31 01:56:14 Discarded record from action ABEND on error 0 [SQL error 0 (0x0)][Oracle][ODBC PostgreSQL Wire Protocol driver]Numeric value out of range. Error in parameter 4. Aborting transaction on /pg_home/app/12.2.0/gg/dirdat/rt beginning at seqno 0 rba 2197 error at seqno 0 rba 2197 Problem replicating SOURCE.CUSTOMERS to target.customers Mapping problem with insert record (target format)... * cust_no = 1 000000: 31 |1 | cust_name = smith 000000: 73 6d 69 74 68 |smith | cust_email = smith@gmail.com 000000: 73 6d 69 74 68 40 67 6d 61 69 6c 2e 63 6f 6d |smith@gmail.com | cust_mobile = 7624115521 000000: 37 36 32 34 31 31 35 35 32 31 |7624115521 | cust_addr = Banglore 000000: 42 61 6e 67 6c 6f 72 65 |Banglore | * Process Abending : 2021-05-31 01:56:14 [oracle@pg7 dirrpt]$