My integration runtime is stopping, but it takes already more than an hour and I see errors in the ADF monitor:
Error 1: Last operation 'Stop' get the status 'Failed'. Error Code: PoolDeleteFailedDueToLockOrReference Error Message: Activity ID: a67615ac-94ff-4547-9244-728d3ae5b25e
Error 2: Error
Code: VNetResourceGroupLockedDuringStop Error Message: We are unable to clean
up unneeded resources when stopping your IR. Please unlock the resource group
containing your VNet and/or remove any reference to the resources created for
your IR, and then retry to stop your IR.
Error 3: Error
Code: IntegrationRuntimeStoppingLongerThanUsual Error Message: Your integration
runtime is taking longer than usual to stop, so please retry to stop it.
It suggests to retry to stop the SSISIR, but the start and stop buttons are greyed out. How do I retry the stop?
Stop and start are greyed out |
Solution
The Azure portal interface does not support restart at the moment, however you can restart an SSISIR that is already stopping with PowerShell!
#PowerShell code # Login with your Azure account (popup will open) Login-AzureRmAccount # Your subscription name (needed if you have more than one subscription) $SubscriptionName = "xxxxxxx" # Change the current and default Azure subscription Select-AzureRmSubscription -SubscriptionName $SubscriptionName Get-AzureRmSubscription -SubscriptionName $SubscriptionName # Force stopping SSISIR Stop-AzureRmDataFactoryV2IntegrationRuntime -DataFactoryName "MyDataFactoryNae" -Name "SSISxxxxxxxIR" -ResourceGroupName "MyResourceGroup" -Force
Other steps you should take if the PowerShell does not stop the Integration Runtime:
- Check if there are lockes on the Resource Group or individual items (like ADF, VNET or SSISDB).
- If you are using a VNET, check whether it works. (Create a new SSISIR and then press validate on the VNET step)
- If there are no locks and the VNET is valid, but the Integration Runtime is still stopping then contact the Azure help + support desk either via Twitter of via an official support request in the portal.
1) Check for locks |
2) Validate VNET |
3) Add support request (in worst case) |
Update: there is a new "retry stop" option available. Click on the Author (pencil) button on the left and then on connection in the left bottom corner. Now open the Integration Runtimes tab and click on the new "retry stop" button. (I hope they will add this option in the monitor as well)
Retry stopping the SSIS IR |