Friday, September 22, 2017

Goldengate OGG-03533 Conversion from character set

Oracle DB :
OGG : 12.2

My replicat ABEBDED with below error and I did research in Oracle support and internet but couldn’t able to find the exact solution so after spending lot of time troubleshooting finally I got a solution and I want to share it with you today

Error from replicat report file or ggserr.log:

2017-09-22 14:53:27  ERROR   OGG-03533  Conversion from character set us7ascii of source column DESCRIPTION to character set UTF-8 of target column DESCRIPTION failed because the source column contains a character 'a0' at offset 21 that is not available in the target character set.


Add “REPLACEBADCHAR SPACE” parameter in replicat
START replicat
Once Issue resolved Remove the parameter from the replicat


Post a Comment

Auto Scroll Stop Scroll