Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLPackage.exe - Lock request time out period exceeded Expand / Collapse
Author
Message
Posted Thursday, June 27, 2013 11:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, December 14, 2014 12:07 PM
Points: 342, Visits: 834
We are using SQLPackage.exe to publish our .sqlproj to production via Bamboo. On production there is a lot more contention in the database so certain operations take a bit longer to complete. It appears there is a default timeout value of 30 seconds when using SQLPackage.exe and when an operation takes longer than 30 seconds the operation fails with the following message:

*** Could not deploy package.
Warning SQL72030: If this deployment is executed, changes to [dbo].[TableA] might introduce run-time errors in [dbo].[TableA].[_dta_stat_1750297295_13_1].
Error SQL72014: .Net SqlClient Data Provider: Msg 1222, Level 16, State 56, Line 1 Lock request time out period exceeded.


When I use the /script option, generate the script, and run the script in the SSMS console the operation completes successfully (just takes a few minutes).

Is there any way to configure the lock timeout for SQLPackage.exe? I only see timeout values for establishing connections to the source and destinations but not for the actual execution of the commands.

Thank you in advance!
Post #1468268
Posted Monday, December 1, 2014 9:46 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, December 12, 2014 10:49 AM
Points: 11, Visits: 146
I found this while looking into the same issue.

http://blogs.msdn.com/b/sqlblog/archive/2014/11/13/timeout-expired-while-publishing-to-sql-database-via-ssdt.aspx


Derik Hammer
@SQLHammer
www.sqlhammer.com
Post #1640361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse