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?  
LeonPavesic's avatar
LeonPavesic
Silver Contributor
Oct 06, 2023

Hi yddcw,

The error message "ReplaceAllIpFirewallRulesOperationQueued" in Azure Synapse typically indicates that there is a pending operation to replace all IP firewall rules in your Synapse workspace. To address this issue, please follow these steps:

  1. Check for Ongoing Operations: Make sure there are no ongoing operations related to firewall rules in your Synapse workspace. It's essential to ensure that no other changes are currently being applied.

  2. Wait for Completion: If there are ongoing operations, patiently wait for them to complete. These operations can take some time, especially if you're making significant changes.

  3. Retry the Operation: After ensuring that there are no ongoing operations, attempt to update the firewall rules again using the Azure Portal, Azure CLI, or your preferred method.


Configure IP firewall rules - Azure Synapse Analytics | Microsoft Learn


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)

  • 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