DB2 Replicat Abends With error " SQL error -330 Character conversion" (Doc ID 2400534.1)

Last updated on FEBRUARY 17, 2020

Applies to:

Symptoms

 Replicat is abends with below error :

2017-12-11 10:33:50 WARNING OGG-03060 Source column ADDR1 has more characters than target column ADDR1 can hold. Some source characters will not be mapped during source column character validation of character set UTF-8.

2017-12-11 10:33:50 WARNING OGG-03060 Source column ADDR2 has more characters than target column ADDR2 can hold. Some source characters will not be mapped during source column character validation of character set UTF-8.

Discard file has below error :

Oracle GoldenGate Delivery for DB2 for i process started, group REP03 discard file opened: 2017-12-11 10:26:32.593456 Current time: 2017-12-11 10:33:50 [SQL error -330 (0xfffffeb6)]Character conversion cannot be performed. Operation failed at seqno 0 rba 2459 Discarding record on action DISCARD on error -330 Problem replicating <yourlib>.<table> to <yourlib>.<table> [SQL
error -330 (0xfffffeb6)]Character conversion cannot be performed. Mapping problem with insert record (target format)... * UNINO = YK51114421 000000: 59
4b 35 31 31 31 34 34 32 31 |YK51114421 | YEAR = 2017 000000: 32 30 31 37 |2017 |

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.