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

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

RaeRae Posts: 3 New member
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. :(


Sign In or Register to comment.