TCP Provider Issue

Question

Hello Team,

I am transferring data from Azure SQL DB to AzureSQL DB via the Azure data factory pipeline. But for a few days, it ran perfectly. After that I am getting errors for the few tables :

Answer 1

Hello @Rohit Kulkarni ,

Thanks for the question and using MS Q&A platform.

From the past experiences I have noticed this error usually occurs when there are transient network issues.

Here are few suggestions which helped others resolve similar issues. I would recommend to try these and see if that helps in your case.

• Check if the connection policy for your Azure SQL is Redirect. If not please try changing connection policy to Redirect and see if that helps. For more info about connection policy please refer to this doc - Azure SQL Connection policy
• To implement a retry logic in your ADF pipeline. It is strongly recommended that your client program (ADF in this case) has retry logic so that it could reestablish a connection after giving the transient fault time to correct itself. We recommend that you delay for 5 seconds before your first retry. Retrying after a delay shorter than 5-seconds risks overwhelming the cloud service. For each subsequent retry the delay should grow exponentially, up to a maximum of 60 seconds.

Here is a document which has steps to resolve transient connectivity issues: Steps to resolve transient connectivity issues

• Check the Microsoft Azure Service Dashboard for any known outages that occurred during the time during which the errors were reported by the application.
• Applications that connect to a cloud service such as Azure SQL Database should expect periodic reconfiguration events and implement retry logic to handle these errors instead of surfacing application errors to users.
• As a database approaches its resource limits, it can seem to be a transient connectivity issue. See Resource limits.

If connectivity problems continue consistently, or if the duration for which your application encounters the error exceeds 60 seconds or if you see multiple occurrences of the error in a given day, please file a support a ticket so that a support engineer can take a deeper look in to it.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators