[Bug] Publish-DbaDacPackage is suddenly failing for me.

[jstexasdba]

Environmental information

Name Value

---

PSVersion 5.1.14393.3471
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.14393.3471
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

Name : dbatools Path : C:\Program Files\WindowsPowerShell\Modules\dbatools\dbatools.psd1 Version : 1.0.111

SQL Server:

Source Server: Microsoft SQL Azure (RTM) - 12.0.2000.8 Apr 9 2020 16:39:55 Copyright (C) 2019 Microsoft Corporation

Destination Server: Microsoft SQL Server 2017 (RTM-CU15-GDR) (KB4505225) - 14.0.3192.2 (X64) Jun 15 2019 00:45:05 Copyright (C) 2017 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor)

Report

I have been running publish-dbadacpackage for months now without and issue. I was initially running on 1.0.87 and it started to bombing out this Morning 20200522 . I downloaded 1.0.109 and 1.0.111 and I get the same results. I have been using the command to restore my Azure SQL DB to my Azure VM.

Publish-DbaDacPackage -Type Bacpac -SqlInstance $DestinationServer -Database $DestinationDB -Path $bacpac.path -DacOption $option2 -SqlCredential $uawarehousecred

Exception calling "ImportBacpac" with "4" argument(s): "Object reference not set to an instance of an object."

When using SQLPackage.exe I get an error The Element or Annotation class SqlSimpleColumn does not contain the Property class SensitivityLabel.

Also, when I try to restore one of the backup files from the generated one, I get the same failure as SQLPackage.exe

Host used

• [x] powershell.exe

Errors Received

In Powershell I get the following error: Exception calling "ImportBacpac" with "4" argument(s): "Object reference not set to an instance of an object."

When using SQLPackage.exe I get error: The Element or Annotation class SqlSimpleColumn does not contain the Property class SensitivityLabel.

Steps to Reproduce

When I run the publish command it just started failing this morning.

Expected Behavior

Maybe something in dacFX binaries changed? I do not know, but when I run through the SSMS GUI, I can backup and restore bacpac without an issue and I would expect the function to do the same.

Actual Behavior

Errors listed above

[wsmelton]

What build of SSMS?

[jstexasdba]

17.9.1, 18.4, and 18.5. I was initially on 17.91 when I first built it and then once it failed yesterday, I started with the updates and via functions still failed, however manual worked from start to finish. However, even with 17.9.1 and cannot restore from the bacpac that was exported from the function even manually. As of now, everything has to be done through the GUI.

[nvarscar]

Can you check if version below 1.0.97 has the same problems? This is when the dlls were updated last time.

[jstexasdba]

Sure, I will try to get to it on Monday.

[joshcorr]

@jstexasdba were you able to get it working? I am tracking another issue with DLLs, and could be connected.

[github-actions[bot]]

🚧🚨 This issue is being marked as stale due to 90 days of inactivity. If you would like this issue to remain open:

• Verify the issue/bug is reproduced in the latest version of the module
• Verify the environmental info provided is still accurate
• Add any additional steps you followed to reproduce if necessary 🚨🚧 ⌛️ This issue will be closed in 30 days ⌛️

[andreasjordan]

I will close this for now, but you can reopen it if this is still an issue with the current version.

[potatoqualitee]

Please let us know if it worked, @jstexasdba