DB2 Replicat Abends With error " SQL error -330 Character conversion"
(Doc ID 2400534.1)
Last updated on FEBRUARY 17, 2020
Applies to:
Oracle GoldenGate - Version 12.1.3.0.0 and laterInformation 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 <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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |