VS Online中的Azure Sql数据库部署任务无法部署Dacpac文件，错误“执行脚本时锁定请求超时...” [英] Azure Sql Database Deployment task in VS Online failed to deploy Dacpac file with error "Lock request timeout when executing script..."

问题描述

VS Online中的Azure Sql数据库部署任务无法部署Dacpac文件，错误为

错误SQL72014：.Net SqlClient数据提供程序：消息1222，级别16 ，状态56，第3行超出锁定请求超时时间。

错误SQL72045：脚本执行错误。 执行的脚本：

WAITFOR DELAY '00：00.010';

ALTER TABLE [dbo]。[TEST] WITH NOCHECK

   添加约束[FK_Test1_Table2] FOREIGN KEY（[TestId]）REFERENCES [dbo]。[Test1]（[Id]）"。 

我们尝试添加/ p： DeployDatabaseInSingleUserMode = True和/ p：CommondTimeout = 1800但不起作用。

我们还尝试在preDeployment.script中设置LOCK_TIMEOUT。它既不起作用。

解决方案

感谢您与Microsoft论坛联系。我们很乐意回答您的问题。

您可以查看以下链接：  https://www.visualstudio.com/en-us/docs/release/examples/azure/azure-web-apps- and-sql-db ，已提到
"如何部署SQL DACPAC"。我建议你再试一次。

另外，你可以查看以下讨论类似问题的主题：

https://social.msdn.microsoft.com/Forums/en-US/dd0ddb27-97b3-45fb-9e41-84cdb9f0f3b6/how-to-identifytroubleshoot-error-sql72014net-sqlclient -data-providermsg-1222-level-16-state？forum = transactsql

我希望回复能帮助您解决查询问题。如果您需要进一步的帮助，请回复该主题，因为我们随时可以提供您的查询。

问候，

_____________________________________________________________________________________

如果帖子回答了您的问题，请点击 该帖子标记为答案  投票为有用

Azure Sql Database Deployment task in VS Online failed to deploy Dacpac file with error

Error SQL72014: .Net SqlClient Data Provider: Msg 1222, Level 16, State 56, Line 3 Lock request time out period exceeded.
Error SQL72045: Script execution error.  The executed script:
WAITFOR DELAY '00:00.010';

ALTER TABLE [dbo].[TEST] WITH NOCHECK
    ADD CONSTRAINT [FK_Test1_Table2] FOREIGN KEY ([TestId]) REFERENCES [dbo].[Test1] ([Id])". 

We have tried to add /p:DeployDatabaseInSingleUserMode=True and /p:CommondTimeout=1800 but doesn't work.

We also tried to set LOCK_TIMEOUT in preDeployment.script. It doesn't work neither.

解决方案

Hi,

Thank you for contacting Microsoft forums. We are pleased to answer your query.

You can check this link: https://www.visualstudio.com/en-us/docs/release/examples/azure/azure-web-apps-and-sql-db which has been mentioned "How to deploy SQL DACPAC". I would suggest you, try it again.

Also, you can check the below thread where the similar issue has been discussed: https://social.msdn.microsoft.com/Forums/en-US/dd0ddb27-97b3-45fb-9e41-84cdb9f0f3b6/how-to-identifytroubleshoot-error-sql72014net-sqlclient-data-providermsg-1222-level-16-state?forum=transactsql

I hope that the reply will assist you in getting your query addressed. In case you require further assistance, please do reply to the thread as we are always available to your queries.

Regards,

_____________________________________________________________________________________

If a post answers your question, please click Mark as Answer on that post and Vote as Helpful

这篇关于VS Online中的Azure Sql数据库部署任务无法部署Dacpac文件，错误“执行脚本时锁定请求超时...”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！