Problems with creating a database release

Böðvar

Hey all

In hopes of some help I'm posting this here.

I'm trying out the deployment process with Octopus by following this guide and when trying out the deployment itself I'm prompted with the following in the task log:

Join-Path : Cannot bind argument to parameter 'Path' because it is null.

July 6th 2018 14:37:36

Error

At C:\Octopus\Work\20180706143733-15850-50\Script.ps1:39 char:47

July 6th 2018 14:37:36

Error

+ ... h (Join-Path (Join-Path $DLMAutomationDeploymentResourcesPath $projec ...

July 6th 2018 14:37:36

Error

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

July 6th 2018 14:37:36

Error

+ CategoryInfo : InvalidData: (:) [Join-Path], ParentContainsErro

July 6th 2018 14:37:36

Error

rRecordException

July 6th 2018 14:37:36

Error

+ FullyQualifiedErrorId : ParameterArgumentValidationErrorNullNotAllowed,M

July 6th 2018 14:37:36

Error

icrosoft.PowerShell.Commands.JoinPathCommand

July 6th 2018 14:37:36

Error

July 6th 2018 14:37:36

Fatal

The remote script failed with exit code 1

I'm unsure if this path is the export path, which is set btw, or if it's some other path I'm unsure of?

Andrea_Angella

Have you managed to solve your issue?

We released a new updated version of the step templates at the end of last week that might work for you.

This is the latest published documentation on how to setup SQL Change Automation with Octopus: https://documentation.red-gate.com/sca3/automating-database-changes/add-ons/octopus-deploy/use-the-sql-change-automation-step-templates

If you have any issue, please don't hesitate to contact our support team and we can have a more in-depth look at your issue.

Thanks for using SQL Change Automation!