Failed to get MI access token.

SHARAD SONWANE 0 Reputation points
2024-02-21T12:59:58.12+00:00

I have 25 pipelines running but all are failing from yesterday due to this error: ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Failed to get MI access token. The error message is: One or more errors occurred... Account: 'xxxxxxxxxx'. FileSystem: 'configurations'. Path: 'tablelist/rnd.xlsx'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to get MI access token. The error message is: One or more errors occurred..,Source=Microsoft.DataTransfer.Common,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Request MI token failed: The type initializer for 'Microsoft.DataTransfer.MsiStoreService.Client.MsiStoreServiceClientHelper' threw an exception.,Source=Microsoft.DataTransfer.MsiStoreServiceClient,'

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,218 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,842 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,914 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Karni Gupta (MSFT) 85 Reputation points Microsoft Employee
    2024-02-21T13:52:56.37+00:00

    Hi Sharad,

    As I understand from the description, your pipelines are failing because they are unable to fetch access token of the MI which is likely causing an authentication issue.

    I'm assuming it already has a minimum of Storage Blob reader access on ADLS since it was working before. Please correct me if that assumption is wrong.

    Sometimes, Microsoft Entra ID is too busy to handle the requests and as a result, the runs might fail. Therefore, my recommendation would be to -

    1. Verify if the default linked services are able to connect with linked ADLS account. You will find the "Validate" option when you click and edit the linked service.
    2. Check if any existing runs are still queued and if there are any long running jobs. If they are running longer than expected, I would suggest killing the job.
    3. Re-run the pipelines one by one after some time or preferably tomorrow to see if it is working.

    Document Reference : https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-azure-data-lake

    If you find my answer helpful, please consider marking it as the ‘Answer’ and giving it an ‘Upvote’ using the thumbs-up option. This can also benefit other community members who may have the same question.

    Thanks,

    Karni.G

    1 person found this answer helpful.

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.