What Should I Do If Error "Invoke DLI service api failed" Is Reported When the Data Migration from MySQL to DLI Is About to Complete?

Symptom

When the migration of 40 million data records from MySQL to DLI is about to complete, the following error is displayed.

Fault Analysis

1. According to the error message, the error may be caused by the write operation on DLI. However, as some log screenshots are lacking, go to the CDM cluster and view the job log.

   

2. According to the error analysis, the queue type may be incorrect (the correct type is SQL queue). Data is first written to an OBS file and then imported to a DLI table through foreign table mapping. The data has been basically imported, but an error is reported during the final mapping because an incorrect queue is used (the DLI SQL queue should be used).

Solution

Contact the user to check that the selected queue is not an SQL queue and that no SQL queue is available. Let the user purchase a DLI SQL queue to perform the migration.