Error details Error code 9054 Details Failed to connect to Integration Runtime or connection is broken unexpectedly.

Question

Error details

Error code9054

DetailsFailed to connect to Integration Runtime or connection is broken unexpectedly. Please retry the operation later. If the issue persists, please contact Microsoft support for further assistance. Activity ID: 87132187-3f94-42d7-9ff6-82e4b575fe59

Activity ID87132187-3f94-42d7-9ff6-82e4b575fe59

I have checked and confirmed the following

Summary of Executed PowerShell Commands and Results

1. Subnet Delegation Verification

Command:

powershell
Copy
Get-AzVirtualNetworkSubnetConfig -Name "libertythrift-subnet" -VirtualNetwork (Get-AzVirtualNetwork -Name "libertythrift-vnet" -ResourceGroupName "LM_ThriftCart_PowerBI") | Select-Object Name, Delegations

Result:

pgsql
Copy
Name                 Delegations
----                 -----------
libertythrift-subnet {}

Interpretation: The subnet libertythrift-subnet initially had no delegations.

Action Taken: Delegation was added to the subnet for Azure Data Factory Integration Runtime.

Command:

powershell
Copy
$subnet = Get-AzVirtualNetworkSubnetConfig -Name "libertythrift-subnet" -VirtualNetwork (Get-AzVirtualNetwork -Name "libertythrift-vnet" -ResourceGroupName "LM_ThriftCart_PowerBI")
$vnet = Get-AzVirtualNetwork -Name "libertythrift-vnet" -ResourceGroupName "LM_ThriftCart_PowerBI"
$subnet.Delegations = New-AzDelegation -Name "df-delegation" -ServiceName "Microsoft.DataFactory/factories/integrationRuntimes"
Set-AzVirtualNetwork -VirtualNetwork $vnet

Outcome: Delegation successfully added.

---

2. Network Security Group (NSG) Outbound Rules Verification

Command:

powershell
Copy
Get-AzNetworkSecurityGroup -Name "libertythrift-nsg" -ResourceGroupName "LM_ThriftCart_PowerBI" | Get-AzNetworkSecurityRuleConfig | Where-Object {$_.Direction -eq "Outbound"} | Format-Table Name, Access, Protocol, DestinationPortRange, Priority

Result:

pgsql
Copy
Name               Access Protocol DestinationPortRange Priority
----               ------ -------- -------------------- --------
Allow-MySQL-Out    Allow  Tcp      {3306}               100
Allow-Postgres-Out Allow  Tcp      {5432}               110
Allow-DNS-Out      Allow  Udp      {53}                 120
Allow-HTTPS-Out    Allow  Tcp      {443}                130
Allow-HTTP-Out     Allow  Tcp      {80}                 140

Interpretation: Outbound rules for essential services (MySQL, PostgreSQL, DNS, HTTPS, HTTP) are correctly configured.

---

3. NAT Gateway Association Verification

Command:

powershell
Copy
(Get-AzVirtualNetworkSubnetConfig -Name "libertythrift-subnet" -VirtualNetwork (Get-AzVirtualNetwork -Name "libertythrift-vnet" -ResourceGroupName "LM_ThriftCart_PowerBI")).NatGateway.Id

Result:

bash
Copy
/subscriptions/a47d2b48-f5cf-4a70-9635-2e2edcd385a4/resourceGroups/LM_ThriftCart_PowerBI/providers/Microsoft.Network/natGateways/libertythrift-nat

Interpretation: The subnet libertythrift-subnet is correctly associated with the NAT Gateway libertythrift-nat.

---

4. Route Table Configuration Verification

Command:

powershell
Copy
Get-AzRouteTable -Name "libertythrift-udr" -ResourceGroupName "LM_ThriftCart_PowerBI" | Get-AzRouteConfig | Format-Table Name, AddressPrefix, NextHopType, NextHopIpAddress

Result:

nginx
Copy
Name             AddressPrefix   NextHopType NextHopIpAddress
----             -------------   ----------- ----------------
default-internet 0.0.0.0/0       Internet
powerbi-range1   20.190.128.0/18 Internet
powerbi-range2   40.126.0.0/18   Internet
intra-vnet       10.0.0.0/8      VnetLocal

Interpretation: The route table libertythrift-udr has appropriate routes for internet access and internal network communication.

---

5. DNS Configuration Verification

Command:

powershell
Copy
Get-AzVirtualNetwork -Name "libertythrift-vnet" -ResourceGroupName "LM_ThriftCart_PowerBI" | Select-Object -ExpandProperty DhcpOptions

Result:

css
Copy
DnsServers DnsServersText
---------- --------------
{}         []

Interpretation: The virtual network libertythrift-vnet is using Azure's default DNS servers, as no custom DNS servers are specified.

---

6. Integration Runtime (IR) Configuration Verification

Configuration Details:

json
Copy
{
    "name": "libertythrift-ir",
    "properties": {
        "type": "Managed",
        "typeProperties": {
            "computeProperties": {
                "location": "Central US",
                "vNetProperties": {
                    "subnetId": "/subscriptions/a47d2b48-f5cf-4a70-9635-2e2edcd385a4/resourceGroups/LM_ThriftCart_PowerBI/providers/Microsoft.Network/virtualNetworks/libertythrift-vnet/subnets/libertythrift-subnet"
                },
                "dataFlowProperties": {
                    "computeType": "General",
                    "coreCount": 8,
                    "timeToLive": 0
                }
            }
        }
    }
}

Interpretation: The Integration Runtime libertythrift-ir is correctly configured to use the libertythrift-subnet within the libertythrift-vnet.

---

7. Deployment Status

Command:

powershell
Copy
New-AzResourceGroupDeployment -ResourceGroupName "LM_ThriftCart_PowerBI" -TemplateFile "C:\terraform\iac\libertythrift_linked_services_rebuild.json" -TemplateParameterFile "C:\terraform\iac\libertythrift_linked_services_rebuild.parameters.json"

Result:

yaml
Copy
DeploymentName          : libertythrift_linked_services_rebuild
ResourceGroupName       : LM_ThriftCart_PowerBI
ProvisioningState       : Succeeded
Timestamp               : 5/15/2025 9:01:34 PM
Mode                    : Incremental

Interpretation: The deployment of linked services was successful.

---

📌 Summary

All configurations, including subnet delegation, NSG rules, NAT Gateway association, route table settings, DNS configuration, and Integration Runtime setup, have been verified and are correctly configured. Despite these configurations, the Integration Runtime is still experiencing connectivity issues. Further investigation may be required to identify and resolve the underlying cause.