Teamcity - DACPAC missing but there
Hi,
I'm wondering if someone could help me with an issue I'm having deploying a SQL database project.
The step that does the deployment is failing with an error relating to a missing DAC the project uses. Where things really get confused is the error message, I get this
An unexpected failure occurred: Failed to load D:\Team City Build Agents\DEV Agent\work\bad93ea02b6fab9b\DB-ExampleDataArchive\ExampleDataArchive\bin\Release\DACPACNAME.DACPAC..
However if I browse to the folder mentioned above then the DAC DACPACNAME.DACPAC is there.
I note that the error has the DACPACNAME.DACPAC plus .. on the end, I'm not sure if this is just an error log thing or its looking for a file name with .. which it wouldnt find,
but I've no idea where it would be adding that on, the configuration is identical to another one that works.
Anyone any ideas on what this may be?
Thanks,
Nic
Please sign in to leave a comment.
Hello Nic,
Apologies for the delayed response here. Is the issue still topical for you?
Could you please confirm how the project deployment is set up (e.g. do you run a custom command line script, do you use SQLPackage)? If you could provide me with an example of script (without sensitive data if any), I would try to check if anything is awry from TeamCity point of view.
Hi,
Thanks for getting back to me, it is using sqlPackage and that was the root cause of the issue, we were using the 120 version of msbuild and have been for a long time, it seems that an update to TeamCity at some point changed this, resulting in the error, we updated to use the 150 version and it then started to work, so we've now updated all our builds to use the latest version of msbuild and all is working well.
Thanks,
Nic
Nic,
I see - thank you for the notice and for the explanation!