When a task is processing CDC data, the internal replicate engine uses "Linux iconv" API to convert the incoming delta records. If the conversion fails, following warning and error is displayed in the logs:
Convert the data to hexadecimal and identify the characters that cannot be converted and remove those.
Reload the table
Cause
The change data converted to hexadecimal contained character value "FCFC", which could not be converted to Unicode.
To validate whether the issue is caused by the data itself, we can also use third-party tool such as DBeaver to check if throws the same error when selecting the data from source DB.