Error on sink data to MySQL - communications link failure

2024-09-19T11:24:37.3633333+00:00

I've got a Pipeline with some Data Flow activities that runs in parallel.

User's image

I've got the error on last night's execution and I'd like some help to understand why and how to prevent it from happenning.

Job failed due to reason: at Sink 'EnviaFerias': Communications link failure The last packet successfully received from the server was 7,905,186 milliseconds ago. The last packet sent successfully to the server was 7,905,186 milliseconds ago."

All dataflows have the same standard:

  1. Source Activity: Get data from a SQL Server dataset using a query
  2. Order Activity: define received data order using column RegisterDate
  3. AlterRow Activity: to INSERT, UPDATE or DELETE data based on key column ID
  4. Sink Acitivy: to sendo transformed data into MySQL

Error happened on marked line below.

User's image

User's image

User's image

All other dataflows runned successfully.

Also, would it be possible to run only those that failed instead of the entirely Pipeline?

Best Regards.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
818 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,593 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.