Azure Synapse Studio CICD using YAML pipelines

colinrippeyfinarneColinrippeyfinarne

thanks a lot for pointing this out. It was working earlier, but these issues were occurring later.  Coincidentally just few hours ago I saw this GitHub link while searching regarding the error and I was about to post this comment and you made my job easier :). 

Adding another point, I have observed the behavior of the code that it is throwing error message but does the job.
Let us take an example of stop-trigger code inside a foreach loop, it stops the first trigger in the list and throws the below error message

"The requested operation requires an element of type 'Object', but the target element has type 'String'"

, then the for-each loop in the code stops because of the error and it won't complete its job.

Result: Only a single trigger is stopped

small fix: I added a try catch inside the for each loop in start and stop triggers code and it worked (refer code below):

- task: AzurePowerShell@5
  displayName: Stop Triggers
  inputs:
    azureSubscription: '$(azureSubscription)'
    ScriptType: 'InlineScript'
    Inline: |
      $triggersSynapse = Get-AzSynapseTrigger -WorkspaceName "$(DeployWorkspaceName)" ; 
      $triggersSynapse | ForEach-Object { Try{Stop-AzSynapseTrigger -WorkspaceName "$(DeployWorkspaceName)" -Name $_.name} Catch{}  }
    azurePowerShellVersion: 'LatestVersion'

- task: AzurePowerShell@5
  displayName: Restart Triggers
  inputs:
    azureSubscription: '$(azureSubscription)'
    ScriptType: 'InlineScript'
    Inline: '$triggersSynapse = Get-AzSynapseTrigger -WorkspaceName "$(DeployWorkspaceName)" ; $triggersSynapse | ForEach-Object { Try{Start-AzSynapseTrigger -WorkspaceName "$(DeployWorkspaceName)" -Name $_.name} Catch{ Write-Output "Started Trigger"+$_.name  } }'
    azurePowerShellVersion: 'LatestVersion'