Stop-AzSynapseTrigger powershell command no longer working

Question

Hi,

Recently the Stop-AzSynapseTrigger powershell command has stopped working for us.

It's giving the following error:

PS C:\Users\user1>  Stop-AzSynapseTrigger -WorkspaceName "workspace-name" -Name "my-trigger"
Stop-AzSynapseTrigger : {}
At line:1 char:2
+  Stop-AzSynapseTrigger -WorkspaceName "workspace-name" -Name "my- ...
+  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : CloseError: (:) [Stop-AzSynapseTrigger], Exception
    + FullyQualifiedErrorId : Microsoft.Azure.Commands.Synapse.StopAzureSynapseTrigger
 

It was working fine until about 1 month back, but now its throwing this error.

Other powershell commands like Stop-AzSynapsePipelineRun, Invoke-AzSynapsePipeline, etc are working fine.

Please suggest the fix.

Answer 1

Hello @Follow,

Welcome to the MS Q&A platform.

The product group has confirmed that this is a bug currently being fixed with priority.

As a workaround, you may use REST API.

Here is the REST API code for your reference:

# Get token for data plane
$token = Get-AzAccessToken -ResourceUrl https://dev.azuresynapse.net
$authHeader = @{
    'Content-Type'  = 'application/octet-stream'
    'Authorization' = 'Bearer ' + $token.Token
}

$workspaceName = "<your-worksapce-name>"
$triggerName = "<your-trigger-name>"

# start trigger
Invoke-WebRequest -Method POST -Uri "https://${workspaceName}.dev.azuresynapse.net/triggers/${triggerName}/stop?api-version=2020-12-01" -Headers $authHeader

I hope this helps. Please let us know if you have any further questions.

Answer 2

Hi

Any updates on this please? I am facing the same error.

Thanks

Answer 3

Do we have an ETA for the bug fix?