TCP/IP connection failure

Raj0125 511 Reputation points
2022-11-14T04:43:25.3+00:00

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.

Error:
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
    2022-11-15T03:36:36.88+00:00

    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.
    Thanks
    Himanshu


    • 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