Issue while deploying DB using DACPAC powershell

Dear Team,

Same dacpac working fine in IT & UAT environment using runtime variables, but when i deploy same to regression (new environment) im getting issue, here the error details , please help on this

Info 17:36:46
This build will deploy: SQL to Server: XXXXX\XXX and Database: XXXX
Error 17:36:48
Exception calling “Deploy” with “4” argument(s): "Could not deploy package."
Error 17:36:48
At D:\Octopus\Applications\XXX
Error 17:36:48
Regression\XXXData\1.0.5596.35349_5\Deploy.ps1:25 char:1
Error 17:36:48

  • $d.Deploy($dp, $DBName, $true, $options)
    Error 17:36:48

Error 17:36:48
+ CategoryInfo : NotSpecified: (:slight_smile: [], ParentContainsErrorRecordE
Error 17:36:48
xception
Error 17:36:48
+ FullyQualifiedErrorId : DacServicesException
Fatal 17:36:48
PowerShell script returned a non-zero exit code: 1
Tentacle version 2.6.5.1010

Hi,

Thanks for reaching out. Could you enable these troubleshooting variables, then create a new release and send us the raw log? This’ll help us get a better glimpse at what might be going on.

I’ve set this thread as private so only you and our staff can see its content.

Thanks

Dalmiro

Hi,
Thanks for your quick response.

i have attached the file. Please check it.

ServerTasks-3126.log.txt (7 KB)

Hi,

Thanks for the log. Did you create a new release after setting up the variables OctopusPrintVariables and OctopusPrintEvaluatedVariables? After setting those to true, your deployment log should have shown a lot more info about the values of the variables. If you dont create a new release, the changes wont take effect.

Your deployment seems to be failing when running the Deploy.ps1 file inside of your package

Failed: Deploy.ps1
Running PowerShell script: D:\Octopus\Applications\WPS Regression\WPSData\1.0.5596.35349_8\Deploy.ps1
Exception calling "Deploy" with "4" argument(s): "Could not deploy package."

Could you share me that script so i can take a look at it?

Thanks

Dalmiro