数据库部署-部署计划生成期间发生错误.部署无法继续 [英] Database Deployment - An error occurred during deployment plan generation. Deployment cannot continue

问题描述

我想知道是否有人可以通过告诉我我在这里想念的东西来帮助拯救我的理智.首先是背景.

I wondered if someone could perhaps help save my sanity by telling me what I'm missing here. The background first.

我们在TC中有5个数据库项目，每个项目都有一个构建步骤，然后一个部署步骤.这5个项目中有4个可以完美地构建和部署.

We have 5 database projects in TC, each with a build step and then a deploy step. 4 out of these 5 projects build and deploy perfectly.

第5次编译正常，但随后在部署到其SQL Server的过程中引发了以下错误；

The 5th however build ok but then raises the following error during deployment to the its SQL Server;

"***部署计划生成期间发生错误.部署无法继续."

"*** An error occurred during deployment plan generation. Deployment cannot continue."

Element或Annotation类PersistedResolvableAnnotation不包含属性类Length.

The Element or Annotation class PersistedResolvableAnnotation does not contain the Property class Length.

[08:32:52] [Exec] C:\ TeamCity \ BuildAgent3 \ work \ c3c1bdeecddf68ca.Build \ dbdeploy_single.proj(9，5):错误MSB3073:命令" C:\ Program Files(x86) \ Microsoft SQL Server \ 120 \ DAC \ Bin \ sqlpackage.exe"/Action:Publish/sf:"../DB-ExampleData/ExampleData/bin/Release/ExampleData.dacpac"/pr:"../DB-ExampleData/ExampleData/UAT.publish.xml"/TargetServerName:IP.IP.IP.111"退出，代码为1.

[08:32:52][Exec] C:\TeamCity\BuildAgent3\work\c3c1bdeecddf68ca.Build\dbdeploy_single.proj(9, 5): error MSB3073: The command ""C:\Program Files (x86)\Microsoft SQL Server\120\DAC\Bin\sqlpackage.exe" /Action:Publish /sf:"../DB-ExampleData/ExampleData/bin/Release/ExampleData.dacpac" /pr:"../DB-ExampleData/ExampleData/UAT.publish.xml" /TargetServerName:IP.IP.IP.111" exited with code 1.

在调查期间，我将UAT.publish.xml与可以正常工作的UAT.publish.xml进行了比较，它们看起来是相同的.我已经尝试过Windows身份验证和SQL身份验证，两者也没有区别.在Visual Studio中也可以正常运行发布文件.

During my investigation I compared the UAT.publish.xml to one that works and they seem identical. I've tried Windows Authentication and SQL Authentication and that makes no difference either. The publish file works fine when run from within Visual Studio as well.

我已经检查了工作的项目与该项目之间的部署设置，我唯一看到的区别是预期的数据库名称.

I've checked the deploy settings between the projects that work and this one and the only difference I can see is in the database name which is expected.

有人对这可能是由什么引起的以及如何解决它有任何想法.如果需要，我有日志和屏幕截图.

Has anyone got any ideas on what this may be caused by and how I can resolve it. I have logs and screenshots if needed.

感谢您抽出宝贵的时间阅读这篇文章.

Thanks for taking the time to read this.

Nic

推荐答案

看起来您的构建服务器具有与Visual Studio使用的版本不同的sqlpackage(即DacFX)版本，并且您的五个项目中只有一个包含两个版本不同"处理的任何功能.

It looks as if your build server has a different version of sqlpackage (i.e. DacFX) than the one that Visual Studio is using, and only one of your five projects contains whatever feature is handled "differently" by the two versions.

此简而言之，我将在构建服务器上更新DacFX，并确保构建作业正在调用

In short, I'd be updating DacFX on the build server, and making sure the build job is calling the sqlpackage.exe that is in

C:\ Program Files(x86)\ Microsoft Visual Studio 14.0 \ Common7 \ IDE \ Extensions \ Microsoft \ SQLDB \ DAC \ 130

C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130

这篇关于数据库部署-部署计划生成期间发生错误.部署无法继续的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！