An Azure platform as a service offer that is used to deploy web and cloud applications.
Hi logtag & thx for join me at Q&A platform,
fact that you've completed around 100 successful swaps with the same configuration, and now every attempt fails almost immediately, makes this worth investigating as a possible Azure control-plane or networking issue.
One important detail: Cloud Services (Extended Support) swaps are primarily networking operations. Azure switches the public IP associations between the deployments' load balancers. So the updated SQL query in ur worker role is unlikely to be responsible, especially if the failure happens before the swap actually starts.
You've already confirmed that both resources have provisioningState: Succeeded and their swappableCloudService references are correct. That's useful, but those checks alone don't guarantee the swap prerequisites are satisfied.
I'd verify that every role instance in both deployments is actually Running, not just that the cloud service resources show Succeeded. Also compare the public IP configurations on both sides. If one deployment uses a reserved/static IP, the other must meet the corresponding swap requirements. Guest OS updates, automatic healing, or an overlapping compute operation can also prevent a swap even when no user-initiated deployment is running.
The next thing I'd investigate is the actual ARM response behind the portal error. Open browser Developer Tools, reproduce the failure, and inspect the Network tab for the failed request. The swap uses the Microsoft.Network operation setLoadBalancerFrontendPublicIpAddresses, so a failure there could expose a more specific error code, HTTP status, or correlation ID than the generic portal message.
I wouldn't recommend repeatedly recreating the staging deployment at this point. You've already tried that without improvement, and it risks introducing more variables without identifying the failure.
If the request is rejected immediately and the backend response doesn't explain why, I'd open an Azure support case and ask for Cloud Services (Extended Support) and Azure Networking engineering to investigate the failed VIP swap operation. Provide the UTC timestamp, both cloud service resource IDs, associated load balancer and public IP resource IDs, and the request/correlation ID. Ask whether the failure is coming from swap validation, load balancer frontend reassignment, or a service-side regression.
One other thing worth planning for: Cloud Services (Extended Support) is scheduled for retirement on March 31, 2027. That doesn't explain this failure, and Microsoft should still investigate it, but I'd avoid investing too much in rebuilding the existing deployment architecture without considering the migration timeline.
Could u check whether the failed request appears under Microsoft.Network in the Activity Log, and whether its response contains an error code beyond the generic portal message? That would be the most useful next clue.
rgds,
Alex
p.s. if my answer is help - pls mark it as an answer