[error]Path does not exist: D:\a\1\s\CFG.database.1.0.12447.nupkg

Cristiane

I am trying to set up the pipeline on Azure DevOps + SQL Change Automation but I'm this error.

##[error]Schema validation failed:

##[error]Unable to process command '##vso[artifact.upload artifactname=Database Build Artifact;containerfolder=Database Build Artifact;]D:\a\1\s\CFG.database.1.0.12447.nupkg' successfully. Please reference documentation (http://go.microsoft.com/fwlink/?LinkId=817296)

##[error]Path does not exist: \a\1\s\CFG.database.1.0.12447.nupkg

LOG:

Starting: RedgateSqlChangeAutomationBuild

==============================================================================

Task : Redgate SQL Change Automation: Build

Description : Build and test databases with Redgate SQL Change Automation

Version : 4.0.2012161408

Author : Redgate Software

Help : [More Information](https://www.red-gate.com/sca/ps/help)

==============================================================================

Setting ErrorActionPreference to "Stop" because no -ErrorAction argument was provided

Invoke-DatabaseBuild, SQL Change Automation 4.3.21279.27554, Copyright © Red Gate Software Ltd 2014-2021

INFORMATION - Use of SQL Change Automation requires licensing in line with the Redgate End User License Agreement.

See Red-gate.com/EULA for more information.

Validating SQL Change Automation project \a\1\s\GDP-CFG\GDP-CFG.sqlproj.

##[warning] DbBuildTask: ERROR \a\1\s\GDP-CFG\Programmable Objects\procfwkReporting\Views\WorkerParallelismOverTime.sql(0,0): 'STRING_AGG' is not a recognized built-in function name.

Cleaning shadow database [sql_change_automation_e485f255-2bab-457a-a183-5c1c36c53570]

Skipping Shadow clean; [sql_change_automation_e485f255-2bab-457a-a183-5c1c36c53570] does not exist

##[error]Schema validation failed:

##[error]Unable to process command '##vso[artifact.upload artifactname=Database Build Artifact;containerfolder=Database Build Artifact;]D:\a\1\s\CFG.database.1.0.12447.nupkg' successfully. Please reference documentation (http://go.microsoft.com/fwlink/?LinkId=817296)

##[error]Path does not exist: \a\1\s\CFG.database.1.0.12447.nupkg

##[error]Exit code 1 returned from process: file name 'C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe', arguments '-NoLogo -Sta -NoProfile -NonInteractive -ExecutionPolicy Unrestricted -Command ". ([scriptblock]::Create('if ([Console]::InputEncoding -is [Text.UTF8Encoding] -and [Console]::InputEncoding.GetPreamble().Length -ne 0) { [Console]::InputEncoding = New-Object Text.UTF8Encoding $false } if (!$PSHOME) { $null = Get-Item -LiteralPath ''variable:PSHOME'' } else { Import-Module -Name ([System.IO.Path]::Combine($PSHOME, ''Modules\Microsoft.PowerShell.Management\Microsoft.PowerShell.Management.psd1'')) ; Import-Module -Name ([System.IO.Path]::Combine($PSHOME, ''Modules\Microsoft.PowerShell.Utility\Microsoft.PowerShell.Utility.psd1'')) }')) 2>&1 | ForEach-Object { Write-Verbose $_.Exception.Message -Verbose } ; Import-Module -Name 'D:\a\_tasks\RedgateSqlChangeAutomationBuild_7345fe1b-d099-46f0-a0d1-7292cd17feee\4.0.2012161408\ps_modules\VstsTaskSdk\VstsTaskSdk.psd1' -ArgumentList @{ NonInteractive = $true } -ErrorAction Stop ; $VerbosePreference = 'SilentlyContinue' ; $DebugPreference = 'SilentlyContinue' ; Invoke-VstsTaskScript -ScriptBlock ([scriptblock]::Create('. ''D:\a\_tasks\RedgateSqlChangeAutomationBuild_7345fe1b-d099-46f0-a0d1-7292cd17feee\4.0.2012161408\SqlChangeAutomationBuild.ps1'''))"'.

My Yml file:

# Starter pipeline

# Start with a minimal pipeline that you can customize to build and deploy your code.

# Add steps that build, run tests, deploy, and more:

# https://aka.ms/yaml

trigger:

- main

pool:

  vmImage: vs2017-win2016

steps:

- task: RedgateSqlChangeAutomationBuild@4

  inputs:

    operation: 'Build SQL Change Automation Project'

    sqlProj: 'GDP-CFG/GDP-CFG.sqlproj'

    packageName: 'GDP-CFG.database'

    tempServerTypeBuild: 'localDB'

    nugetPackageVersionSelector: 'Specific'

    nugetPackageVersion: '1.0'

    nugetPackageVersionUseBuildId: true

    requiredVersionOfDlma: 'latest'

DanC

hi @Cristiane

I believe we're in contact directly in support, but for the benefit of others, for the issue is with the syntax here:

Objects\procfwkReporting\Views\WorkerParallelismOverTime.sql(0,0): 'STRING_AGG' is not a recognized built-in function name.