What Should I Do If Error "invalid utf-8 character string" Is Reported When CSV Data Is Inserted into the MySQL Database?

Symptom

The migration job fails to be executed, and message "invalid utf-8 character string" is displayed.

Fault Analysis

The error may be caused by the data format. Check the log to confirm the issue.

Solution

1. Check the sqoop logs in the background. The error may be caused by the incorrect source data type and format.
2. Analyze the source data type. It is found that dirty data exists and the source data type is incorrect.
3. Configure dirty data dump on the CDM console and rerun the job. The job is successfully executed, and the dirty data type in the OBS bucket is incorrect.