Version 2.8.1 - master.dacpac reference is not found

[rapolas-oag]

Version: 2.8.1 Deployment on Docker image mcr.microsoft.com/mssql/server:2019-latest Sqlpackage version tested with 150.* and the latest 162.3.566.1

sqlpackage returns error:

Initializing deployment (Start) 2024-08-30 12:41:29 *** No file was supplied for reference master.dacpac; deployment might fail. When package was created, the original referenced file was located C:\Users\username.nuget\packages\microsoft.sqlserver.dacpacs.master\150.1.1/tools/master.dacpac. 2024-08-30 12:41:29 Initializing deployment (Failed)

Notes:

• master.dacpac is in the same directory as dacpac of database I want to deploy;
• master is referenced:

  <Project Sdk="MSBuild.Sdk.SqlProj/2.8.1">
   ...
  <ItemGroup>
      <PackageReference Include="Microsoft.SqlServer.Dacpacs.Master" DacpacName="master" DatabaseVariableLiteralValue="master" Version="150.1.1" />
  </ItemGroup>
  </Project>

• issue gone once <Project Sdk="MSBuild.Sdk.SqlProj/2.8.1"> was changed to <Project Sdk="MSBuild.Sdk.SqlProj/2.7.2">

[ErikEJ]

How about 2.8.0 ?

[rapolas-oag]

@ErikEJ After changing version from 2.7.2 to 2.8.0, deployment which was working as expected in Docker started to fail again.

Error:

2024-09-02 11:56:31 Initializing deployment (Start)
2024-09-02 11:56:31 2024-09-02 08:56:31.53 spid53      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2024-09-02 08:56:31.55 spid53      Using 'xplog70.dll' version '2019.150.4355' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2024-09-02 08:56:31.73 spid53      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2024-09-02 08:56:31.75 spid53      Using 'xpstar.dll' version '2019.150.4355' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
*** No file was supplied for reference master.dacpac; deployment might fail. When package was created, the original referenced file was located C:\Users\user\.nuget\packages\microsoft.sqlserver.dacpacs.master\150.1.1/tools/master.dacpac.
2024-09-02 11:56:34 Initializing deployment (Failed)
2024-09-02 11:56:35 *** An error occurred during deployment plan generation. Deployment cannot continue.
2024-09-02 11:56:35 Error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded.