title: Database Deployment - An error occurred during deployment plan generation. Deployment cannot continue
body: <p>I wondered if someone could perhaps help save my sanity by telling me what I'm missing here. The background first.</p>
  
  <p>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.</p>
  
  <p>The 5th however build ok but then raises the following error during deployment to the its SQL Server;</p>
  
  <hr>
  
  <p>"*** An error occurred during deployment plan generation. Deployment cannot continue."</p>
  
  <p>The Element or Annotation class PersistedResolvableAnnotation does not contain the Property class Length.</p>
  
  <p>[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.</p>
  
  <hr>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>Thanks for taking the time to read this.</p>
  
  <p>Nic</p>