What are the challenges you face when working across database platforms? Take the survey
Options

TeamCity Plugin QueryBatchTimeout Parameter

ChrisMChrisM Posts: 10 New member
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!!
Tagged:

Comments

  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Options
    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.
  • Options
    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
    Customer Support
    Redgate Software
Sign In or Register to comment.