Please help me to fix this error 2200

Jackson Jacob 1

"ErrorCode=UserErrorAzureMysqlNetBatchWriteTimeOut,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=batch write time out, more than 00:00:30,Source=Microsoft.DataTransfer.Runtime.AzureMySqlNetConnector,''Type=System.Threading.Tasks.TaskCanceledException,Message=A task was canceled.,Source=,'",
"failureType": "UserError",

Please help me to fix this error!

HarithaMaddi-MSFT 10,136 Reputation points

2020-09-11T13:23:43.4+00:00
Hi @Jackson Jacob ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

From the error message, it appears that there is an issue with timeout while connecting to database. Please try passing the policy with connection timeout as higher value. If issue persists, please share pipeline run id, region of data factory and pipeline design with us to investigate further.

"Policy": { "concurrency": 1, "timeout": "01:00:00" }

Ref: https://stackoverflow.com/questions/46312237/mysql-timeout-with-azure-data-factory-copy
HarithaMaddi-MSFT 10,136 Reputation points

2020-09-14T07:46:49.887+00:00

Hi @Jackson Jacob ,

We have not received a response from you. Please let us know if above suggestion is helpful. Otherwise, please share more details with us and we will continue to engage with you on the issue.
HarithaMaddi-MSFT 10,136 Reputation points

2020-09-15T08:16:16.097+00:00

Hi @Jackson Jacob ,

We still have not heard back from you. Following up to check if above suggestion is helpful. Otherwise, do share more details with us and we will continue to engage with you on the issue.

Share via

Please help me to fix this error 2200

Your answer