Forum Discussion

yddcw's avatar
yddcw
Copper Contributor
Oct 06, 2023

Error "ReplaceAllIpFirewallRulesOperationQueued" in Synapse

Failed to update firewall rules for Azure Synapse workspace. I can't add any IP or remove it in Synapse's firewall rules. I've tried using the Azure CLI too. Has anyone ever experienced this?  
yddcw's avatar
yddcw
Copper Contributor
Oct 06, 2023

Thanks for the answer LeonPavesic . I have identified in logs that there are several operations with the status "started". Some of them are more than 1 month old, but the one that actually started to cause problems started on Tuesday. Do you know any method to kill these requests? 

LeonPavesic's avatar
LeonPavesic
Silver Contributor
Oct 09, 2023

Hi yddcw,

thanks for the update.

To kill the requests with the status "started", you can use the Azure CLI. To do this, follow these steps:

  1. Open a terminal window.
  2. Navigate to the directory where you have installed the Azure CLI.
  3. Log in to Azure by running the following command:

 

az login​

 

  • List all the ongoing operations by running the following command:

 

az synapse operation list --resource-group <resource-group-name> --workspace-name <workspace-name>​

 

  • Identify the operation that is causing the problem.
  • Kill the operation by running the following command:

 

az synapse operation cancel --resource-group <resource-group-name> --workspace-name <workspace-name> --operation-id <operation-id>​

 

Replace <resource-group-name>, <workspace-name>, and <operation-id> with the actual values.

Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.


If the post was useful in other ways, please consider giving it Like.


Kindest regards,


Leon Pavesic
(LinkedIn)

Resources