Teamcity - Error in SQL deploy
Hi all,
I've hit a bit of weird issue that I'm hoping someone can help with as I'm a bit stuck, so the set up is this;
TeamCity server (TeamCity Enterprise 2020.1.4 (build 78906))
a 2 step job that pulls down a SQL database from BitBucket and deploys it to a SQL 2012 database.
So step 1 pulls the project folder, a build tools folder and a references (For the project) folder down to our TeamCity server from BitBucket.
This works fine.
Step 2 is the step that uses the .net to call ms_build which then uses sql_package to deploy the project. Up until recently this was
working fine but now all of a sudden it has stopped working and is giveing me the error;
Exec] *** An error occurred during deployment plan generation. Deployment cannot continue.
[18:38:22][Exec] The Element or Annotation class PersistedResolvableAnnotation does not contain the Property class Length.
If I manually bring the project manually it builds and deploys without any errors, directly through Visual Studio, so I can rule that out I think. Then I thought it
may be the sql_package or build tools but these shouldnt have changed in a long time so there is no reason to suspect that.
I've attached the full log.
Anyone any ideas on how I can resolve this or how to troubleshoot.
Thanks,
Nic
Please sign in to leave a comment.