DB2 Replicat Abends With error " SQL error -330 Character conversion"

(Doc ID 2400534.1)

Last updated on MAY 24, 2018

Applies to:

Oracle GoldenGate - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

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 OETAIDMS.MUNIFILE to OETAIDMS.MUNIFILE [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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms