MSBuild.Sdk.SqlProj: [Question]: Generate Script fails when external dacpacs are referred in the project
Reference csproj
<Project Sdk="MSBuild.Sdk.SqlProj/2.7.2">
<Import Project="..\..\common.project.props" />
<PropertyGroup>
<TargetFramework>netstandard2.0</TargetFramework>
<SqlServerVersion>Sql150</SqlServerVersion>
<SuppressTSqlWarnings>71558,71502,71562</SuppressTSqlWarnings>
<TargetName>WinchkDatabase</TargetName>
<AppendTargetFrameworkToOutputPath>false</AppendTargetFrameworkToOutputPath>
<GenerateCreateScript>True</GenerateCreateScript>
<IncludeCompositeObjects>True</IncludeCompositeObjects>
<RunSqlCodeAnalysis>True</RunSqlCodeAnalysis>
</PropertyGroup>
<ItemGroup>
<None Include="SchemaComparisons\SchemaComparison.scmp" />
<None Include="shared.publish.xml" />
<None Include="SchemaComparisons\FromCashMoneyToProject.scmp" />
<None Include="SchemaComparisons\FromSRC18_06.scmp" />
<None Include="shared.publish.xml" />
<None Include="local.publish.xml" />
<None Include="SchemaComparisons\FromSrcToProject.scmp" />
<None Include="SchemaComparisons\FromProjectToLocalDb.scmp" />
<None Include="SchemaComparisons\FromCM18_06.scmp" />
</ItemGroup>
<ItemGroup>
<PreDeploy Include="Scripts\Script.PreDeployment.sql" />
<PostDeploy Include="Scripts\Script.PostDeployment.sql" />
<None Include="package.nuspec">
<CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
<Private>true</Private>
</None>
</ItemGroup>
<ItemGroup>
<Content Remove="Scripts\Script.PreDeployment.sql" />
<Content Remove="Scripts\Script.PostDeployment.sql" />
<Content Remove="Scripts\Post-Deployment\2429.0-PostDeployment.sql" />
<Content Remove="Scripts\Pre-Deployment\2429.0-PreDeployment.sql" />
<RefactorLog Include="WinchkDatabase.refactorlog" />
</ItemGroup>
<ItemGroup>
<SqlCmdVariable Include="AccountingDatabase">
<DefaultValue>AccountingDatabase</DefaultValue>
<Value>$(SqlCmdVar__8)</Value>
</SqlCmdVariable>
<SqlCmdVariable Include="AppLogDatabase">
<DefaultValue>AppLogDatabase</DefaultValue>
<Value>$(SqlCmdVar__15)</Value>
</SqlCmdVariable>
<SqlCmdVariable Include="BankCard">
<DefaultValue>BankCard</DefaultValue>
<Value>$(SqlCmdVar__13)</Value>
</SqlCmdVariable>
<SqlCmdVariable Include="CAPSHistoryDatabase">
<DefaultValue>CAPSHistory</DefaultValue>
<Value>$(SqlCmdVar__14)</Value>
</SqlCmdVariable>
<SqlCmdVariable Include="CustomerScoringDatabase">
<DefaultValue>CustomerScoring</DefaultValue>
<Value>$(SqlCmdVar__6)</Value>
</SqlCmdVariable>
<SqlCmdVariable Include="InternalAuditDatabase">
<DefaultValue>InternalAudit</DefaultValue>
<Value>$(SqlCmdVar__1)</Value>
</SqlCmdVariable>
<SqlCmdVariable Include="SqlReportServer">
<DefaultValue>SQLRPT</DefaultValue>
<Value>$(SqlCmdVar__9)</Value>
</SqlCmdVariable>
</ItemGroup>
<ItemGroup>
<ProjectReference Include="../CAPSHistoryDatabase/CAPSHistoryDatabase.csproj" DatabaseSqlCmdVariable="CAPSHistoryDatabase"/>
</ItemGroup>
<ItemGroup>
<PackageReference Include="Microsoft.SqlServer.Dacpacs.Master" Version="150.1.1" DacpacName="master" DatabaseVariableLiteralValue= "master" />
<PackageReference Include="Microsoft.SqlServer.Dacpacs.Msdb" Version="150.0.0" DacpacName="msdb" DatabaseVariableLiteralValue= "msdb"/>
<PackageReference Include="Database.AppLog" Version="$(InHousePackageVersionSpec)" DacpacName="AppLogDatabase" DatabaseSqlCmdVariable="AppLogDatabase"/>
<PackageReference Include="Database.CustomerScoring" Version="$(InHousePackageVersionSpec)" DacpacName="CustomerScoringDatabase" DatabaseSqlCmdVariable="CustomerScoringDatabase"/>
<PackageReference Include="Database.InternalAudit" Version="$(InHousePackageVersionSpec)" DacpacName="InternalAuditDatabase" DatabaseSqlCmdVariable="InternalAuditDatabase"/>
<PackageReference Include="Database.HotelCardifornia" Version="1.0.*" DacpacName="HotelCardifornia.Database" DatabaseSqlCmdVariable="BankCard"/>
</ItemGroup>
</Project>
Error log
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'master.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
EXEC : error SQL0: The reference to external elements from the source named 'CustomerScoringDatabase.dacpac' could not be resolved, because no such source is loaded. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
/Users/bheemvennapureddy/.nuget/packages/msbuild.sdk.sqlproj/2.7.2/Sdk/Sdk.targets(244,5): error MSB3073: The command "dotnet "/Users/bheemvennapureddy/.nuget/packages/msbuild.sdk.sqlproj/2.7.2/Sdk/../tools/net6.0/DacpacTool.dll" build -o "obj/Debug/WinchkDatabase.dacpac" -n "WinchkDatabase" -v "2430.0.32767" -sv Sql150 -i "obj/Debug/WinchkDatabase.InputFiles.txt" -r "/Users/bheemvennapureddy/.nuget/packages/microsoft.sqlserver.dacpacs.master/150.1.1/tools/master.dacpac;dbl=master|dbv=|srv=;" -r "/Users/bheemvennapureddy/.nuget/packages/microsoft.sqlserver.dacpacs.msdb/150.0.0/tools/msdb.dacpac;dbl=msdb|dbv=|srv=;" -r "/Users/bheemvennapureddy/.nuget/packages/database.applog/2430.0.1/tools/AppLogDatabase.dacpac;dbl=|dbv=AppLogDatabase|srv=;" -r "/Users/bheemvennapureddy/.nuget/packages/database.customerscoring/2430.0.1/tools/CustomerScoringDatabase.dacpac;dbl=|dbv=CustomerScoringDatabase|srv=;" -r "/Users/bheemvennapureddy/.nuget/packages/database.internalaudit/2430.0.1/tools/InternalAuditDatabase.dacpac;dbl=|dbv=InternalAuditDatabase|srv=;" -r "/Users/bheemvennapureddy/.nuget/packages/database.hotelcardifornia/1.0.3/tools/HotelCardifornia.Database.dacpac;dbl=|dbv=BankCard|srv=;" -r "/Users/bheemvennapureddy/github/Business/src/CAPSHistoryDatabase/bin/Debug/CAPSHistoryDatabase.dacpac;dbl=|dbv=CAPSHistoryDatabase|srv=;" -sc AccountingDatabase="AccountingDatabase" -sc AppLogDatabase="AppLogDatabase" -sc BankCard="BankCard" -sc CAPSHistoryDatabase="CAPSHistory" -sc CustomerScoringDatabase="CustomerScoring" -sc InternalAuditDatabase="InternalAudit" -sc SqlReportServer="SQLRPT" -dp IncludeCompositeObjects=True --predeploy Scripts/Script.PreDeployment.sql --postdeploy Scripts/Script.PostDeployment.sql --refactorlog WinchkDatabase.refactorlog -spw "71558,71502,71562" --generatecreatescript -an " exited with code 134. [/Users/bheemvennapureddy/github/Business/src/WinchkDatabase/WinchkDatabase.csproj]
7 Warning(s)
2836 Error(s)
Am I doing anything wrong here? Other projects without external references work fine.
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 19
Great news - as we only support the latest version. Assume it is a fix in DacFX then
@bheemvennapureddy Your repro builds fine for me!
I removed the following files and folder:
package.nuspec shared.publish.xml WinchkDatabase.refactorlog and the SchemaCompare folder.
Reduced the project file to this:
and it builds fine for me.
I think we have spent enough time asserting that it is not GenerateCreateScript and your question has been answered.
Make sure to make the repro simple and focused to increase the chances of anyone spending free time looking at it!
Can’t remember, but not the error you are seeing. Fixed in the test project by adding “databaseliteralname” property as you can see in the PR
I think you can just update that one to also GenerateScript
“we” - not sure, feel free to add one if not.
Please provide a simple, focused repro, and I will have a look.