Start-AzSynapseTrigger PowerShell command throwing misleading exception in CI/CD pipeline

Behera, Mamatamayi 20 Reputation points
2024-02-29T17:17:41.9633333+00:00

Hi, The "Restart Triggers" task in our Azure Synapse Analytics deployment pipeline started failing consistently with below error and providing "Sleep" time between the previous task and start triggers task did not resolve the issue. This happens for random triggers and not a particular one. Error: Resource cannot be updated during provisioning"} As a workaround, I removed the "Restart Triggers" task and added inline powershell script to start the triggers after deployment with 3 mins of sleep time between triggers. The Triggers start successfully. However, I see below error in the log. Is there a fix for this? When I run the same script in Azure CLI, I don't have this error: This has been reported before. Is there a way to get past this?User's image

Thanks!

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.
4,921 questions
{count} votes

Accepted answer
  1. Bhargava-MSFT 31,021 Reputation points Microsoft Employee
    2024-02-29T22:20:24.33+00:00

    Hello Behera, Mamatamayi,

    From the error message, can you upgrade az.synapse version to 3.0.5?

    run these cmds from your home directory (/home/youruser)

    `Install-Module -Name Az.Synapse -RequiredVersion 3.0.5

    Get-Module -ListAvailable

    Start-AzSynapseTrigger -WorkspaceName <wspcnamegoeshere> -Name <triggernamegoeshere>

    Get-Module -Name Az.Synapse`

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most 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.