Azure Data Factory Integration Runtime Going Into Limited State

Pratik Somaiya 4,201 Reputation points
2021-09-14T05:11:22.447+00:00

My team have created an IR in an on-premises VM and we are trying to create a Linked Service to an on-prem DB using that IR

Whenever we click on Test Connection in the Linked Service, the connection fails and IR goes into a limited state

We also whitelisted the IPs provided by Microsoft for IR ADF and also checked the network traces and all seems fine there

Also, we stopped and restarted the IR, uninstalled and installed it again but still the problem resists

Have anyone faced a similar kind of issue?

As this has been a long time we are facing this issue which has now become a blocker for us

Thanks!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,933 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Byju Koshy 1 Reputation point
    2022-11-22T10:44:14.297+00:00

    Hi All,

    After searching over internet found this thread for the same issue.
    We are having a similar setup Integrated runtime(IR) service hosted on on-prem server and its going into limited connectivity with ADF multiple times in the day.

    This issue has started few days back. We were using public endpoints to connect to ADF, once the issue started we switched to private endpoints as we have a VPN tunnel also. Even after checking the traffic at both gateways (on-prem and azure) traffic is moving but still this issue happens multiple time in the day. And at the time of the limited availability also we have the reachability of the IR server to ADF's private endpoint.

    Is there anything which I can check further. As we are also analyzing the packet capture at IR server. looking for any guidance here.

    Regards,
    Byju

    0 comments No comments

  2. Jonnada, Vishnu Kiran 0 Reputation points
    2023-02-07T11:36:18.4433333+00:00

    I ran into same issue. Our organization has firewall rules preventing specific ports or url's from outside network. We added Data factory services tags with internet facing in Route table, and IR then connected successfully.

    0 comments No comments