TCP/IP connection failure

Raj0125 511 Reputation points

Hi All,

We have 50+ pipe lines running as per the schedule on daily basis in ADF.But we are getting very frequently (monthly twice or thrice) pipelines are failing due to TCP/IP Error.But next day run its running fine with out any issues.
One of the Data flow in pipeline withe error but next day run its completed successfully.

Operation on target DF_CF_Prouct_service_All failed: {"StatusCode":"DF-MSSQL-InvalidFirewallSetting","Message":"Job failed due to reason: The TCP/IP connection to the host has failed. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.","Details":"java.lang.RuntimeException: Cannot connect to SQL database:.

Please suugest any resolution for the issue frequently happening.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,121 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

    Hello @Raj0125 ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is how to get rid of the intermittent error of timeout , please do let us know if its not accurate.
    As I see the whole cloud architecture , there can be many things which can go wrong and that the issues is not intermittent adds more complexity to the troubleshooting . You can work with the MS support that they do have access to all the logs and may help find out whatss going wrong .

    As per me a simple fix worth trying can be , definitely add retry in the copy activities , this will give you some extra buffer so that the activity will try 3/5/X times before declaring that as a failure .

    Please do let me if you have any queries.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png 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