PowerShell Runbook failing on Azure Automation Account

Question

PowerShell Runbook failing on Azure Automation Account

Vivek Komarla Bhaskar 956

Hi, The following error is displayed when I run the PowerShell Runbook that I created on my Azure Automation account to enable/disable SFTP on my Azure storage account (gen2). Could you please help me with this? Screenshot 2024-01-26 at 12.14.20

Screenshot 2024-01-21 at 23.32.49

Answer accepted by question author

0 additional answers

Your answer

Answer 1

tbgangav-MSFT 10,431 Moderator

Hi @Vivek Komarla Bhaskar ,

I believe you have either of the below 2 ways to overcome the issue:

If you connect to Azure using Az PowerShell cmdlet Connect-AzAccount then use Az PowerShell cmdlet Set-AzStorageAccount to enable and disable sftp.
As per this update as Az CLI is now supported in Azure Automation PowerShell 7.2 runtime runbooks so if you want to use Az CLI command az storage account update to enable or disable sftp then before using it, connect to Azure using Az CLI command az login.

If you still face any issues while trying either of the ways, let me know.

Vivek Komarla Bhaskar 956 Reputation points

2024-01-27T14:41:15.74+00:00

Hi, I haven't worked with PowerShell before, so could you please update my script according to your suggestion.
tbgangav-MSFT 10,431 Reputation points Moderator

2024-01-30T16:02:36.95+00:00
Hi @Vivek Komarla Bhaskar , This example has the command to be used i.e., script would look like:

Connect-AzAccount -Identity #Set the required values $resourceGroupname = "xxxxxx" $storageAccountName = "yyyyyy" #Enable SFTP Set-AzStorageAccount -ResourceGroupName $resourceGroupname -AccountName "mystorageaccount" -EnableSftp $true #Wait for an hour Start-Sleep -Seconds 3600 #Disable SFTP Set-AzStorageAccount -ResourceGroupName $resourceGroupname -AccountName $storageAccountName -EnableSftp $false

As you have added a command to sleep for an hour so just wanted to let you know that it might have some impact because for long-running Azure Automation tasks it's recommended to use a Hybrid Runbook Worker. For more information, refer this article.
Vivek Komarla Bhaskar 956 Reputation points

2024-02-01T14:31:28.9333333+00:00

Hi tbgangav-MSFT Thank you. It is now working, and I have also set up a hybrid worker. The only issue I have now is that the runbook isn't publishing. Despite trying to publish several times, the runbook authorization status still shows as New.
tbgangav-MSFT 10,431 Reputation points Moderator

2024-02-02T14:57:24.26+00:00

Hi @Vivek Komarla Bhaskar , I was also able to reproduce the issue while trying to publish from Azure Portal. However, as a workaround I was able to publish using Azure PowerShell approach. I am reaching out to our internal product team to confirm the same and get more details around it. Will keep you updated as I hear more information.
Vivek Komarla Bhaskar 956 Reputation points

2024-02-05T09:30:59.9066667+00:00

Thank you. Please keep me posted. Can you confirm that your script works completely? When executing the script, I only see enable SFTP working. Disable SFTP does not work for me.
tbgangav-MSFT 10,431 Reputation points Moderator

2024-02-05T15:31:20.1733333+00:00

Hi @Vivek Komarla Bhaskar , When you say Disable SFTP does not work, are you seeing any error?
Vivek Komarla Bhaskar 956 Reputation points

2024-02-05T15:37:30.2933333+00:00

Hi @tbgangav-MSFT No error, after enabling the sftp service the scipt isn't disabling the service. I tested this with reducing the wait time to 2 mins
tbgangav-MSFT 10,431 Reputation points Moderator

2024-02-05T16:14:42.35+00:00

Hi @Vivek Komarla Bhaskar , It doesn't look like an Azure Automation level issue. Try the same script from a local machine or from cloud shell and see how it works. If it works as expected in such environments, then increasing wait time or having 2 separate runbooks for enabling and disabling might help.
Vivek Komarla Bhaskar 956 Reputation points

2024-02-14T10:45:34.3766667+00:00

Hi Do you have any update, please?
Vivek Komarla Bhaskar 956 Reputation points

2024-02-16T12:25:36.93+00:00

It's all working now. Azure has fixed the problem with publish

Share via

PowerShell Runbook failing on Azure Automation Account

0 additional answers

Your answer