0

*** Verification of the deployment plan failed. Error SQL72031: This deployment may encounter errors during execution because changes to [localuser] are blocked by [db_datareader]'s dependency in the target database.

I tried to use Azure Devops to deploy to Production Azure Data warehouse, but I am getting the above error.

Please help!

burberry398
  • 31
  • 2
  • Hi @burberry398, How are thing going? Is the suggestion in my answer helpful to you? Please try it, and if you have any progress, feel free to tell me. – Bright Ran-MSFT Dec 22 '20 at 08:39
  • @BrightRan-MSFT thank you, I am able to solve the problem! – burberry398 Dec 23 '20 at 01:07
  • Hi @burberry398, Glad to hear that you solve the problem. If possible, could you please post an answer as the summary of the reason and solution for the problem? This may be very helpful to other people who have the similar problems when they are looking for an answer. Thanks very much. – Bright Ran-MSFT Dec 24 '20 at 06:37

1 Answers1

0

There is ticket about the similar problem: SSDT Publish errors on Creating Publish Preview

As the explanation, your sqlproj may be not included in a stored procedure in the target database that references a table that would be altered by deploying your sqlproj.

You can try to add the stored procedure from the target database to your sqlproj.

You also can refer here to try deploying Azure SQL Data Warehouse to the Azure SQL Server on your local machine.

And here also is a similar case as reference: Error while Updating .mdf database

Bright Ran-MSFT
  • 5,190
  • 1
  • 5
  • 12