Issue with Azure Integration Runtime and Linked services

Madhukar Muddasani 10 Reputation points
2023-06-16T16:46:09.49+00:00

Hello ,

I am seeing below error when i see the Event viewer logs on which Azure Integration run time is installed .

I also see My linked service connection is failing .

TestConnection failed, error message: 'Type=Microsoft.DataTransfer.SecurityValidation.Exceptions.HostValidationException,Message=Access to msm-cgm is denied, resolved IP address is fe80::b3a9:613a:9d23:f49f%8, network type is OnPremise,Source=Microsoft.DataTransfer.SecurityValidation,StackTrace= at Microsoft.DataTransfer.SecurityValidation.HostValidator.HandleDisallowedHostWithLogging(Action1 writeLog, Boolean throwException, Tuple3 args, Boolean isOnPrem) at Microsoft.DataTransfer.SecurityValidation.HostValidator.IsAllowedHost(String host, NetworkType networkType, Boolean enableLocalMachineAccessFromOnPremise, Action1 writeAccessDeniedLog, Action1 writeDnsFailureLog, Boolean throwExceptionUponValidationFailure) at Microsoft.DataTransfer.SecurityValidation.HostValidator.IsAllowed(String hostOrUri, NetworkType networkType, Boolean enableLocalMachineAccessFromOnPremise, Action1 writeAccessDeniedLog, Action1 writeDnsFailureLog, Boolean throwExceptionUponValidationFailure) at Microsoft.DataTransfer.Common.HostValidationRuntimeCommonHelper.ValidateHostWithLogging(String host, Guid jobId, Guid activityId, ComputeType computeType, Boolean enableLocalMachineAccessFromOnPremise, Boolean disableLocalFolderPathValidation, Boolean throwExceptionUponValidationFailure, Boolean supportLocalFolderPathValidation, Boolean shouldValidateFolderPath) at Microsoft.DataTransfer.Runtime.FileServerConnectionSettings..ctor(IDictionary2 properties, Boolean skipHostValidation) at Microsoft.DataTransfer.Runtime.FileServerConnection..ctor(IDictionary2 properties) at Microsoft.DataTransfer.Runtime.FileServerConnector.CreateConnection(IDictionary2 properties) at Microsoft.DataTransfer.Runtime.Provider.HybridRuntimeConnection.Initialize(ConnectionSetting connectionSettings, PluginRegistration plugins, String dataFactoryName, String dataFactoryId, String dataFactoryRegionAbbrev, String linkedIRCredential, AzureCloudType azureCloudType, String miStoreVersion, DataTransferCredentials credentials) at Microsoft.DataTransfer.Runtime.Provider.HybridRuntimeConnection..ctor(ConnectionSetting connectionSettings, PluginRegistration plugins, IMemoryLimit memoryLimit, String dataFactoryName, String dataFactoryId, String dataFactoryRegionAbbrev, String linkedIRCredential, AzureCloudType azureCloudType, String miStoreVersion, DataTransferCredentials credentials) at Microsoft.DataTransfer.TransferTask.InteractiveTaskFactoryV2.ConnectorTestConnection(ConnectionSetting connectionSetting, TestConnectionV2Response response) at Microsoft.DataTransfer.TransferTask.InteractiveTaskFactoryV2.TestConnection(TestConnectionV2Request request, TestConnectionV2Response response, CancellationToken token) at Microsoft.DataTransfer.TransferTask.InteractiveTask2.Execute(),'. Log ID: Error

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} votes

5 answers

Sort by: Most helpful
  1. Patrick DeLine 30 Reputation points
    2023-06-20T11:21:04.39+00:00

    This was the solution for us:

    C:\Program Files\Microsoft Integration Runtime\5.0\Shared> .\dmgcmd.exe -elma
    
    5 people found this answer helpful.
    0 comments No comments

  2. QuantumCache 20,366 Reputation points Moderator
    2023-06-20T00:56:08.3+00:00

    @Madhukar Muddasani

    @Jeremy Banas, As per the offline discussion, the below steps would be helpful in resolving the issue!!!

    Set up or manage an existing self-hosted IR.

    Dmgcmd.exe is included in the self-hosted installer. It's typically located in the C:\Program Files\Microsoft Integration Runtime\4.0\Shared\ folder. This application supports various parameters and can be invoked via a command line using batch scripts for automation.

    Open a PowerShell and run the below command: 

     

    dmgcmd -elma

    This should be resolving your issue!!

    User's image

    3 people found this answer helpful.

  3. Jack Sha 0 Reputation points
    2023-06-25T06:00:19.3166667+00:00

    I'm using a network shared folder path like \serverA\foldername. But still have this problem.


  4. Koen Ubbink 1 Reputation point
    2023-06-28T11:11:28.17+00:00

    Same issue per 23-06-2023, seems to be related to the SHIR update 5.29.8535.1.

    0 comments No comments

  5. GYANENDRA KUMAR PATEL 0 Reputation points
    2023-11-27T08:16:15.3366667+00:00

    Even we encountered the same issue post IR version upgrade to (5.32.8600.2) version, running (C:\Program Files\Microsoft Integration Runtime\5.0\Shared> .\dmgcmd.exe -elma) on SHIR VM fixed the issue.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.