Share via

Azure SQL Data warehouse deployment issue

Rohit 256 Reputation points
2023-06-13T09:15:28.8333333+00:00

Hello All,

We are trying to deploy the Azure SQL Data Warehouse via CI-CD Pipeline, we are using "Azure SQL Database deployment" task in the CI-CD Pipeline. The deployment is getting stuck at "Initializi Deployment (start)", even if we do not stop the deployment for an hour it would still be on the same stage. There has been no change to the Pipelines recently (earlier everything used to work correctly)

Also, the deployment of Azure SQL Database (on the same server) via CI-CD Pipeline using the same task is successful.

We have tried to deploy the data warehouse using Azure SQL Data Warehouse deployment", this has also failed.
We have also tried to deploy the bits via Visual Studio on a different database on a new server, the deployment was successful.

User's image

Can someone help/guide me on how to resolve the issue? Any inputs on this is also really appreciated.

Azure Synapse Analytics
Azure Synapse Analytics

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

Answer accepted by question author
  1. Nandan Hegde 36,716 Reputation points MVP Volunteer Moderator
    2023-09-21T10:35:33.5966667+00:00

    Hey,

    we too were facing the same issue and based on our support tkt with MSFT,

    the issue seems to be a bug in the latest SQL package as to when comparing the mdoels, it gets stuck in external tables comparision.

    So as a resolution till the time there is a fix, you can exclude the external tabales while publishing the DACPAC

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.