Understanding Self-Hosted Integration Runtime

Azure Data Factory (ADF) uses Self-Hosted Integration Runtime (SHIR) to connect to on-premises data sources, private network resources, and VPN-connected systems. When the IR loses connectivity, pipelines fail with cryptic error messages. This guide covers every common connectivity problem and its resolution.

Understanding the Root Cause

Resolving Integration Runtime Connectivity Problems in Azure Data Factory requires more than applying a quick fix to suppress error messages. The underlying cause typically involves a mismatch between your application’s expectations and the service’s actual behavior or limits. Azure services enforce quotas, rate limits, and configuration constraints that are documented but often overlooked during initial development when traffic volumes are low and edge cases are rare.

When this issue appears in production, it usually indicates that the system has crossed a threshold that was not accounted for during capacity planning. This could be a throughput limit, a connection pool ceiling, a timeout boundary, or a resource quota. The error messages from Azure services are designed to be actionable, but they sometimes point to symptoms rather than the root cause. For example, a timeout error might actually be caused by a DNS resolution delay, a TLS handshake failure, or a downstream dependency that is itself throttled.

The resolution strategies in this guide are organized from least invasive to most invasive. Start with configuration adjustments that do not require code changes or redeployment. If those are insufficient, proceed to application-level changes such as retry policies, connection management, and request patterns. Only escalate to architectural changes like partitioning, sharding, or service tier upgrades when the simpler approaches cannot meet your requirements.

Impact Assessment

Before implementing any resolution, assess the blast radius of the current issue. Determine how many users, transactions, or dependent services are affected. Check whether the issue is intermittent or persistent, as this distinction changes the urgency and approach. Intermittent issues often indicate resource contention or throttling near a limit, while persistent failures typically point to misconfiguration or a hard limit being exceeded.

Review your Service Level Objectives (SLOs) to understand the business impact. If your composite SLA depends on this service’s availability, calculate the actual downtime or degradation window. This information is critical for incident prioritization and for justifying the engineering investment required for a permanent fix versus a temporary workaround.

Consider the cascading effects on downstream services and consumers. When Integration Runtime Connectivity Problems in Azure Data Factory degrades, every service that depends on it may also experience failures or increased latency. Map out your service dependency graph to understand the full impact scope and prioritize the resolution accordingly.

Common Error Messages

Could not connect to net.tcp://localhost:8060/ExternalService.svc/
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
Self-hosted integration runtime is in an error state. Error details: No further error message.
The self-hosted integration runtime node has been offline for more than the allowed time.

Checking SHIR Status

# Check IR status via Azure CLI
az datafactory integration-runtime show \
  --factory-name myDataFactory \
  --resource-group myRG \
  --name mySelfHostedIR \
  --query "{state:properties.state, nodes:properties.nodes[].{name:nodeName, status:status, version:version}}" -o json

# List all integration runtimes
az datafactory integration-runtime list \
  --factory-name myDataFactory \
  --resource-group myRG \
  -o table

On the SHIR Machine

# Check IR service status
Get-Service -Name DIAHostService | Select-Object Status, StartType

# Check IR configuration
& "C:\Program Files\Microsoft Integration Runtime\5.0\Shared\dmgcmd.exe" -Status

# View diagnostic logs
& "C:\Program Files\Microsoft Integration Runtime\5.0\Shared\dmgcmd.exe" -Diagnose

# Test connectivity to Azure
Test-NetConnection -ComputerName myDataFactory.frontend.datamovement.azure.com -Port 443
Test-NetConnection -ComputerName login.microsoftonline.com -Port 443

# Check ports used by IR (default: 8060 for internal communication)
netstat -an | findstr "8060"

Network Connectivity Requirements

Endpoint	Port	Purpose
*.servicebus.windows.net	443	Command and control channel
*.frontend.datamovement.azure.com	443	Data movement
login.microsoftonline.com	443	Azure AD authentication
download.microsoft.com	443	Auto-update downloads
*.core.windows.net	443	Azure Storage access

# Test all required endpoints
$endpoints = @(
    "myDataFactory.frontend.datamovement.azure.com",
    "login.microsoftonline.com",
    "download.microsoft.com"
)
foreach ($ep in $endpoints) {
    $result = Test-NetConnection -ComputerName $ep -Port 443
    Write-Host "$ep : $($result.TcpTestSucceeded)"
}

Proxy Configuration

<!-- C:\Program Files\Microsoft Integration Runtime\5.0\Shared\diahost.exe.config -->
<system.net>
  <defaultProxy enabled="true" useDefaultCredentials="true">
    <proxy
      usesystemdefault="true"
      proxyaddress="http://proxy.example.com:8080"
      bypassonlocal="true"
    />
    <bypasslist>
      <add address="localhost" />
      <add address="169.254.169.254" />
    </bypasslist>
  </defaultProxy>
</system.net>

# After editing the config, restart the IR service
Restart-Service -Name DIAHostService

# Verify proxy settings
& "C:\Program Files\Microsoft Integration Runtime\5.0\Shared\dmgcmd.exe" -EnableProxy http://proxy.example.com:8080

Resilience Patterns for Long-Term Prevention

Once you resolve the immediate issue, invest in resilience patterns that prevent recurrence. Azure’s cloud-native services provide building blocks for resilient architectures, but you must deliberately design your application to use them effectively.

Retry with Exponential Backoff: Transient failures are expected in distributed systems. Your application should automatically retry failed operations with increasing delays between attempts. The Azure SDK client libraries implement retry policies by default, but you may need to tune the parameters for your specific workload. Set maximum retry counts to prevent infinite retry loops, and implement jitter (randomized delay) to prevent thundering herd problems when many clients retry simultaneously.

Circuit Breaker Pattern: When a dependency consistently fails, continuing to send requests increases load on an already stressed service and delays recovery. Implement circuit breakers that stop forwarding requests after a configurable failure threshold, wait for a cooldown period, then tentatively send a single test request. If the test succeeds, the circuit closes and normal traffic resumes. If it fails, the circuit remains open. Azure API Management provides a built-in circuit breaker policy for backend services.

Bulkhead Isolation: Separate critical and non-critical workloads into different resource instances, connection pools, or service tiers. If a batch processing job triggers throttling or resource exhaustion, it should not impact the real-time API serving interactive users. Use separate Azure resource instances for workloads with different priority levels and different failure tolerance thresholds.

Queue-Based Load Leveling: When the incoming request rate exceeds what the backend can handle, use a message queue (Azure Service Bus or Azure Queue Storage) to absorb the burst. Workers process messages from the queue at the backend’s sustainable rate. This pattern is particularly effective for resolving throughput-related issues because it decouples the rate at which requests arrive from the rate at which they are processed.

Cache-Aside Pattern: For read-heavy workloads, cache frequently accessed data using Azure Cache for Redis to reduce the load on the primary data store. This is especially effective when the resolution involves reducing request rates to a service with strict throughput limits. Even a short cache TTL of 30 to 60 seconds can dramatically reduce the number of requests that reach the backend during traffic spikes.

SSL/TLS Certificate Issues

Error: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

# Check if corporate proxy is intercepting SSL traffic
# Test certificate chain
$uri = "https://myDataFactory.frontend.datamovement.azure.com"
$request = [System.Net.HttpWebRequest]::Create($uri)
$request.GetResponse() | Out-Null
$cert = $request.ServicePoint.Certificate
Write-Host "Issuer: $($cert.Issuer)"
Write-Host "Subject: $($cert.Subject)"

# If the issuer is your corporate proxy CA, install the root CA cert
# Import to Trusted Root Certification Authorities
Import-Certificate -FilePath "C:\certs\corporate-root-ca.cer" -CertStoreLocation "Cert:\LocalMachine\Root"

Memory and Performance Issues

# Check SHIR resource usage
$process = Get-Process -Name diahost -ErrorAction SilentlyContinue
if ($process) {
    Write-Host "Memory: $([math]::Round($process.WorkingSet64 / 1MB, 2)) MB"
    Write-Host "CPU Time: $($process.TotalProcessorTime)"
}

# Check concurrent activities
& "C:\Program Files\Microsoft Integration Runtime\5.0\Shared\dmgcmd.exe" -GetConcurrentJobsLimit

# Scale out with high availability — add additional nodes
az datafactory integration-runtime regenerate-auth-key \
  --factory-name myDataFactory \
  --resource-group myRG \
  --name mySelfHostedIR \
  --key-name authKey1

JRE Missing for Parquet/ORC

Error: Java Runtime Environment is not installed. Please install a 64-bit JRE.

When copying data in Parquet, ORC, or Avro format, SHIR requires a 64-bit JRE (Java 8+). Install OpenJDK or Oracle JDK and set the JAVA_HOME environment variable.

# Set JAVA_HOME after installing JRE
[Environment]::SetEnvironmentVariable("JAVA_HOME", "C:\Program Files\Microsoft\jdk-17.0.8", "Machine")

# Restart the IR service
Restart-Service -Name DIAHostService

Understanding Azure Service Limits and Quotas

Every Azure service operates within defined limits and quotas that govern the maximum throughput, connection count, request rate, and resource capacity available to your subscription. These limits exist to protect the multi-tenant platform from noisy-neighbor effects and to ensure fair resource allocation across all customers. When your workload approaches or exceeds these limits, the service enforces them through throttling (HTTP 429 responses), request rejection, or degraded performance.

Azure service limits fall into two categories: soft limits that can be increased through a support request, and hard limits that represent fundamental architectural constraints of the service. Before designing your architecture, review the published limits for every Azure service in your solution. Plan for the worst case: what happens when you hit the limit during a traffic spike? Your application should handle throttled responses gracefully rather than failing catastrophically.

Use Azure Monitor to track your current utilization as a percentage of your quota limits. Create dashboards that show utilization trends over time and set alerts at 70 percent and 90 percent of your limits. When you approach a soft limit, submit a quota increase request proactively rather than waiting for a production incident. Microsoft typically processes quota increase requests within a few business days, but during high-demand periods it may take longer.

For services that support multiple tiers or SKUs, evaluate whether upgrading to a higher tier provides the headroom you need. Compare the cost of the upgrade against the cost of engineering effort to work around the current limits. Sometimes, paying for a higher service tier is more cost-effective than building complex application-level sharding, caching, or load-balancing logic to stay within the lower tier’s constraints.

Disaster Recovery and Business Continuity

When resolving service issues, consider the broader disaster recovery and business continuity implications. If Integration Runtime Connectivity Problems in Azure Data Factory is a critical dependency, your Recovery Time Objective (RTO) and Recovery Point Objective (RPO) determine how quickly you need to restore service and how much data loss is acceptable.

Implement a multi-region deployment strategy for business-critical services. Azure paired regions provide automatic data replication and prioritized recovery during regional outages. Configure your application to failover to the secondary region when the primary region is unavailable. Test your failover procedures regularly to ensure they work correctly and meet your RTO targets.

Maintain infrastructure-as-code templates for all your Azure resources so you can redeploy your entire environment in a new region if necessary. Store these templates in a geographically redundant source code repository. Document the manual steps required to complete a region failover, including DNS changes, connection string updates, and data synchronization verification.

Linked Service Connection Testing

# Test connection through the IR
az datafactory linked-service show \
  --factory-name myDataFactory \
  --resource-group myRG \
  --name myLinkedService \
  --query "{type:properties.type, ir:properties.connectVia.referenceName}" -o json

Auto-Update Failures

# Check current version
& "C:\Program Files\Microsoft Integration Runtime\5.0\Shared\dmgcmd.exe" -Version

# Disable auto-update if causing downtime
& "C:\Program Files\Microsoft Integration Runtime\5.0\Shared\dmgcmd.exe" -DisableAutoUpdate

# Manually update
& "C:\Program Files\Microsoft Integration Runtime\5.0\Shared\dmgcmd.exe" -Update

Capacity Planning and Forecasting

The most effective resolution is preventing the issue from recurring through proactive capacity planning. Establish a regular review cadence where you analyze growth trends in your service utilization metrics and project when you will approach limits.

Use Azure Monitor metrics to track the key capacity indicators for Integration Runtime Connectivity Problems in Azure Data Factory over time. Create a capacity planning workbook that shows current utilization as a percentage of your provisioned limits, the growth rate over the past 30, 60, and 90 days, and projected dates when you will reach 80 percent and 100 percent of capacity. Share this workbook with your engineering leadership to support proactive scaling decisions.

Factor in planned events that will drive usage spikes. Product launches, marketing campaigns, seasonal traffic patterns, and batch processing schedules all create predictable demand increases that should be accounted for in your capacity plan. If your application serves a global audience, consider time-zone-based traffic distribution and scale accordingly.

Implement autoscaling where the service supports it. Azure autoscale rules can automatically adjust capacity based on real-time metrics. Configure scale-out rules that trigger before you reach limits (at 70 percent utilization) and scale-in rules that safely reduce capacity during low-traffic periods to optimize costs. Test your autoscale rules under load to verify that they respond quickly enough to protect against sudden traffic spikes.

Summary

SHIR connectivity issues stem from network access (firewall blocking outbound 443 to Azure endpoints), proxy configuration (SSL interception breaking trust), missing prerequisites (JRE for Parquet/ORC formats), and resource constraints (memory/CPU on the IR machine). Always start diagnosis with dmgcmd.exe -Diagnose, verify outbound connectivity with Test-NetConnection, and check that corporate proxies aren’t intercepting SSL certificates. For high availability, deploy multiple IR nodes in a logical group.

For more details, refer to the official documentation: What is Azure Data Factory?, Linked services in Azure Data Factory and Azure Synapse Analytics.