Share via

Pipeline Start IR step authentication failed error

Anuj Shrestha 1 Reputation point
2021-01-08T10:07:40.497+00:00

I have setup an Azure SSIS IR on my trial subscription. I am trying to setup a pipeline to execute my SSIS package on a schedule i n the data factory.

I am following the below link for the setup. https://learn.microsoft.com/en-us/azure/data-factory/how-to-schedule-azure-ssis-integration-runtime

I run into an error when i try to debug the pipeline.

{"error":{"code":"AuthorizationFailed","message":"The client 'xxx' with object id 'xxx' does not have authorization to perform action 'Microsoft.DataFactory/factories/integrationruntimes/start/action' over scope '/subscriptions/{subscription id}/resourcegroups/xxxx/providers/Microsoft.DataFactory/factories/solverdatafactory/integrationruntimes/xxxx' or the scope is invalid. If access was recently granted, please refresh your credentials."}}

I have assigned roles - contributor and data factory contributor to my user for the data factory.

additionally, the IR also takes ages to restart. I am using a 3rd party SSIS powerpack to user a REST API connector to pull data from an API.

SO first thing is I need the pipeline to work and also the IR to restart within a practical timeframe or esle the ADF is basically not helpful if it takes hours for the IR to restart . This is beacuse IR is very expensive and we cant have to running all the time.

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Anuj Shrestha 1 Reputation point
    2021-01-21T01:56:38.91+00:00

    @Saurabh Sharma - Thanks for the followup. I didnt try this since I decided not to use ADF.

    Was this answer helpful?


  2. Saurabh Sharma 23,866 Reputation points Microsoft Employee Moderator
    2021-01-14T23:17:04.65+00:00

    @Anuj Shrestha Thanks for using Microsoft Q&A !!

    As per the error it looks like permissions issue and you need to provide managed identity of your data factory a contributor role to itself as directed in the documented ( please check step 5).

    Please can you check the permissions again if you haven't done that and try to debug the pipeline.

    56872-image.png

    Was this answer helpful?


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.