Friday, September 22, 2017

Goldengate OGG-03533 Conversion from character set



Oracle DB : 12.1.0.2
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.

Solution:

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


0 comments:

Post a Comment

Auto Scroll Stop Scroll