Error with \sqlci.ps1 for the DLM Automation 2: Build

Rae

I'm trying to get us set up to use continuous integration using the Redgate tools with TFS, but I'm getting the following error when running the CI build:

******************************************************************************
Starting: Build Staging
******************************************************************************
==============================================================================
Task : Redgate DLM Automation 2: Build
Description : Build and test databases with Redgate's DLM Automation
Version : 2.0.10
Author : Redgate Software
Help : [More Information](https://documentation.red-gate.com/display/DLMA2/DLM+Automation+2+documentation)
==============================================================================
Preparing task execution handler.
Executing the powershell script: \\##############\_tasks\RedgateDlmAutomationBuild_7345fe1b-d099-46f0-a0d1-7292cd17feee\2.0.10\DlmAutomationBuild.ps1
System.Management.Automation.CommandNotFoundException: The term '\sqlci.ps1' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input)
at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke)
at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync)
at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
at Microsoft.TeamFoundation.DistributedTask.Handlers.LegacyVSTSPowerShellHost.VSTSPowerShellHost.Main(String[] args)
LegacyVSTSPowerShellHost.exe completed with return code: -1.

---

What I replaced with hashes is a local network path that is correct when I access it via file explorer. The network path has no spaces in it and the length of what I've removed is 65 characters.

The file it's looking for, sqlci.ps1, exists in the same folder as DlmAutomationBuild.ps1.

We're on TFS Version 15.117.26714.0 and I upgraded the build agent last week.

Can anyone help at all? I've been trying to resolve the problem, but I'm out of ideas.

Sergio R

This error was caused by DLM Automation not being installed on the build agent.

Thank you,