Hi all,
After much effort, I have my ‘NuGet-wrapped’ DACPAC mostly deploying to the database server. However it fails near the start of the process. We’re using V2020.1.12
There are a few exceptions shown, but I can’t find how to turn these into things I can change:
| == Failed: Step 1: SQL - Report on DACPAC from Package Parameter ==
16:03:34 Fatal | The step failed: Activity SQL - Report on DACPAC from Package Parameter on a Worker failed with error ‘The remote script failed with exit code 1’.
16:03:34 Verbose | SQL - Report on DACPAC from Package Parameter completed
16:03:34 Verbose | Loading the target server dacpac for report and scripting. Filename: D:\DeploymentTools\Octopus\Work\20200922150303-9135-118\DACPACPackage\SQLDabcdef.ProjectA.20200922150304.dacpac
16:03:34 Verbose | Gathering generic database scoped configuration option
16:03:34 Verbose | Gathering users
16:03:34 Info | Gathering roles
16:03:34 Info | Gathering application roles
16:03:34 Info | Generating deploy report against server: SQLabcdef, database: projectA
16:03:34 Info | Gathering role memberships
16:03:34 Info | Gathering filegroups
16:03:34 Info | Gathering full-text catalogs
16:03:34 Info | Gathering assemblies
16:03:34 Info | Gathering certificates
16:03:34 Info | Gathering asymmetric keys
16:03:34 Verbose | Gathering symmetric keys
16:03:34 Verbose | Gathering encrypted symmetric keys
16:03:34 Verbose | An exception of type System.Management.Automation.MethodInvocationException was thrown.
16:03:34 Verbose | Gathering schemas
Can you help, or tell me where to look for more detail? The DBA says the last action on the database is “SELECT @@VERSION”. The following actions must be on the dacpac created from the target server?
Thanks