TeamCity project for deployment fails with Exit Code 1

Question

I am adding a SQL script(StoredProc) for deployment using TeamCity Projects and the deployment fails and says(* Process exited with Code 1). It throws an Error in Deploying script to DB. But it was fine before. Seems to me some issue with permissions, but I havent changed any.

Could anyone enlighten?

Please describe how you're attempting to add this script. What are the commands and parameters? — John Hoerr, Apr 28 '15 at 13:52
@JohnHoerr, thanks it has already worked. I was missing an error in build since yesterday. — Shweta Saxena, Apr 28 '15 at 14:03
Good! If you have time, you might consider posting your resolution here. It may help users with similar problems in the future. — John Hoerr, Apr 28 '15 at 14:12

score 0 · Answer 1 · answered Apr 28 '15 at 14:39

Thanks this issue is resolved, I was missing a build error( was creating an SP in the script that I was deploying, but which already existed in DB with same name). The exit code error message isnt always very descriptive, but stumbled upon "already exists" keyword somewhere in between the build-log. Hence rectified . Good idea to examine log carefully.

TeamCity project for deployment fails with Exit Code 1

1 Answers1