V1.1.0 Seems to have broken teamcity nuget.

ktersius

This new version seems to break the publishing to the teamcity nuget server. It successfully publishes the database package to the server, but then gets an exception and fails the build. If you go to the deployment manager and search for the new package it was published. This was all working fine on the previous release and only broke after we upgraded.

Also I had to delete the newly added built in nuget repository or else my builds failed because the build step was looking for the generated package under this repository and was not finding it.
" Searching for database package MyPackage version 0.22.31.6706 failed with error InvalidOperationException "

Running Teamcity 7.1.3 upgraded to 7.1.4 and same issue.

[Publishing database package MyPackage version 0.22.30.6705 to http://192.168.2.61:8082/guestAuth/app/ ... ervice.svc] ##teamcity[buildStatus status='FAILURE' text='Publishing database package MyPackage version 0.22.30.6705 to [url=http://192.168.2.61:8082/guestAuth/app/nuget/v1/FeedService.svc]http://192.168.2.61:8082/guestAuth/app/ ... ervice.svc[/url] failed with error InvalidOperationException']

chirayu

You need to update our TeamCity sqlCI plugin to be able to build database packages via TeamCity.

The latest version can be found here.

Let me know if that fixes the issue. Thanks!

ktersius

Hi

I did upgrade it today. So it does not seem to be that.

My plugin version is 1.0.0.1003

Thanks

chirayu

Would you please pass a stack trace of the exception?

Also, what version is your Deployment Manager server?

Thanks!

ktersius

Figured out that it was the teamcity redgate plugin that broke it. Downgraded to an earlier version and this resolved the problem.

Please let the CI team know that their latest release is buggy.

swinghouse

I can confirm this bug in the latest version of the CI plugin.

/Mattias

Andy M

We are working on a solution to this right now.
Thanks for your patience.

Andy Morris
UX Specialist- Deployment Manager
Red Gate

Andy M

The fixes are now available on the Red Gate website at http://www.red-gate.com/products/sql-development/automation-license-for-continuous-integration/free-resources

The latest versions are available:

- TeamCity plugin v1.0.0.1029
- SqlCI v1.0.0.926

Thanks for your patience.
Best regards,

Andy Morris
UX Specialist- Deployment Manager
Red Gate

swinghouse

I just upgraded to v1.0.0.1029 of the TeamCity plugin, but unfortunately the result was the same as before.

This is the error message I get:

Searching for database package BagheraData version 0.20 failed with error InvalidOperationException

I've restarted TeamCity and Deployment Manager.

Deployment Manager version: 1.1.2.1

/Mattias

DavidRG

Hi Mattias,

For your most recent error where the package version 0.20 for the package named BagheraData can't be found:

Yeh, that's our bad. It was caused because as of the most recent release of Deployment Manager it now has an embedded NuGet package feed, and we haven't yet done the work to make sqlCI compatible with it.

I'm going to get one of the developers to look into this urgently.

Detailed explanation:
To generate static upgrade scripts, sqlCI uses the DM API to ask which versions of the package are currently deployed to any environment in any project, and it then generates static upgrade scripts for those versions. To do this, it contacts the NuGet package feed to download those versions of the package in order to calculate the script.

The problem is that sqlCI only downloads packages from the first NuGet feed in DM no matter how many you have, and the embedded NuGet feed is always set to be the first one. What this means is that it tries to download the old version of the package from the wrong feed causing the error. We'll fix this in 2 ways:
1. We'll contact all the feeds in parallel.
2. We'll turn the package not being there into a warning rather than a build failure, since in the general case it might be an ancient version that got deleted from the NuGet feed, e.g. because TeamCity cleans up old versions after a while (depending on how you've configured it).

David

(internal reference numbers:
[url=sareport://639e5b7e-aea9-4eec-a1cc-4c43c5b72fbe]sareport://639e5b7e-aea9-4eec-a1cc-4c43c5b72fbe[/url]
[url=sareport://af52eaa7-f49a-4bc1-9f4a-309076d1d53d]sareport://af52eaa7-f49a-4bc1-9f4a-309076d1d53d[/url]
[url=sareport://5b4bb6f8-0831-42cb-89cf-157e8dbd968a]sareport://5b4bb6f8-0831-42cb-89cf-157e8dbd968a[/url]
)

swinghouse

Hi David,

Thanks for the explanation - most appreciated!

I look forward to the bug fix.

/Mattias

Andy M

There is a temporary work around available for the later problem. As David suggested it is caused by the presence of the Deployment Manager package feed in version 1.1.0.27 if you already had an existing feed.

You can work around this problem by deleting this new feed. You can do this as follows:

1. In Settings > Package Feeds delete the Deployment Manager package feed. This is the embedded feed that was added in v1.1.

2. In the Server tools application (Start > Red Gate > Deployment Manager > Server Tools) uncheck "enable deployment manager package feed".

Regards,

Andy Morris
UX Specialist - Deployment Manager

csmith

Hi

Just wanted to update this thread to let you know that we believe the problems detailed in David Simner's last post should be fixed in the latest version of SQLCI (v1.0.0.945) and the TeamCity Plugin (v1.0.0.1039).

You can download them from here.

Best regards,
Chris