TeamCity Plugin QueryBatchTimeout Parameter

ChrisM

I am getting a timeout error when building my project through the DLMAutomation plugin for TeamCity. The documentation says to increase the QueryBatchTimeout parameter (or set it to zero), but I can't see anywhere to do this. Does anyone know how to change this parameter in TeamCity? The documentation tells you what to do , but gives no clue on how to do it!!

Alex B

Hi Chris,

I know we answered your support query, but for others I wanted to put it here as well!

I'm guessing it's this documentation page you're looking at. Unfortunately there is currently no way to set this in the TeamCity plugin itself.

You can directly edit the powershell script in the DLMA installation folder on the build agent to add -QueryBatchTimeout 0 to the implementation of the cmdlets . The cmdlets themselves are stored in a .dll - you'll be editing the sqlci.ps1 file in the root of the installation directory C:\Program Files (x86)\Red Gate\DLM Automation 2​ (by default). This is what the plugins use to mimic the previous behaviour of the now retired tool SQL CI.

In this file you should see the functions build/test/sync/publish and within those you can see the DLM Automation cmdlets being used. It's there you'll add the -QueryBatchTimeout 0​ to the cmdlets being used in this file for the action relating to where you're seeing the issue.

Kind regards,
Alex

joshuawferguson

Can we please get this as an option in the TeamCity plugin? I understand the workaround, but it would be much easier just to specify the value in the plugin.

RichardL

Hi @joshuawferguson

Thanks again for your post.

You can make suggestions on our DLM Automation uservoice page below if you like.

https://redgate.uservoice.com/forums/267000-dlm-automation

Kind regards