Share via

Synapse pipeline failed while calling another pipeline. This has been failing intermittently since last 2-3 days. This code has been running good since past 18 months. But started getting this issue recently

Rajendra Dhabale 0 Reputation points
2023-09-16T14:59:38.35+00:00

We have daisy chaining of Synapse pipelines, and this has been running smoothly in our production environment since last 18 months. Recently we've started noticing this issue. When a pipeline is called from another pipeline, we get this error message:

ErrorCode=FailedToGetAccessTokenByMI,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to get MI access token.

Usually, we just restart the entire process and move on. But this happened frequently in last few days. Yesterday 5 times in a day -- which is not acceptable to our clients.

We are under region US-E2

Can someone please tell us what's the root cause and next actions steps to mitigate this recurring issue.

Thanks,

Rajendra

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.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vinodh247 41,971 Reputation points MVP Volunteer Moderator
    2023-09-16T16:49:25.61+00:00

    HI
    Rajendra Dhabale    ,

    Thanks for reaching out to microsoft Q&A.

    This looks like access token error from managed identity. Pls try to check the linked service and do a test connection. This might also be a error from azure side, if thats the case you will have to raise a case with ms support to confirm that.

Your answer

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