This was all working before we upgraded server to 3.3.22. Our build script downloads the Octopus command line tools from nuget and attempts to create the release. Here’s the log and stack dump:
[05:39:48][Step 1/1] Executing Download-OctopusTools
[05:39:49][Step 1/1] Feeds used:
[05:39:49][Step 1/1] https://api.nuget.org/v3/index.json
[05:39:49][Step 1/1]
[05:39:49][Step 1/1] GET https://api.nuget.org/v3/registration1-gz/octopustools/index.json
[05:39:49][Step 1/1] OK https://api.nuget.org/v3/registration1-gz/octopustools/index.json 152ms
[05:39:49][Step 1/1] Attempting to gather dependency information for package ‘OctopusTools.3.3.18’ with respect to project ‘C:\BuildAgent\work\9c07f1baa4859c13.Temp’, targeting ‘Any,Version=v0.0’
[05:39:49][Step 1/1] Attempting to resolve dependencies for package ‘OctopusTools.3.3.18’ with DependencyBehavior ‘Lowest’
[05:39:49][Step 1/1] Resolving actions to install package ‘OctopusTools.3.3.18’
[05:39:49][Step 1/1] Resolved actions to install package ‘OctopusTools.3.3.18’
[05:39:49][Step 1/1] Adding package ‘OctopusTools.3.3.18’ to folder ‘C:\BuildAgent\work\9c07f1baa4859c13.Temp’
[05:39:49][Step 1/1] Added package ‘OctopusTools.3.3.18’ to folder ‘C:\BuildAgent\work\9c07f1baa4859c13.Temp’
[05:39:49][Step 1/1] Successfully installed ‘OctopusTools 3.3.18’ to C:\BuildAgent\work\9c07f1baa4859c13.Temp
[05:39:49][Step 1/1] Executing Create-OctopusRelease
[05:39:49][Step 1/1] Octopus Deploy Command Line Tool, version 3.3.18+Branch.master.Sha.d32cf0e4440e5e245f014977288a915c3f267bfd
[05:39:49][Step 1/1]
[05:39:49][Step 1/1] Build environment is TeamCity
[05:39:49][Step 1/1] Handshaking with Octopus server: http://deploy.southsidesoft.com
[05:39:50][Step 1/1] Handshake successful. Octopus version: 3.3.22; API version: 3.0.0
[05:39:50][Step 1/1] Authenticated as: tcabanski <>
[05:39:50][Step 1/1] This Octopus Server supports channels
[05:39:50][Step 1/1] Finding project: M&I Customer Web
[05:39:50][Step 1/1] Automatically selecting the best channel for this release…
[05:39:50][Step 1/1] Building a release plan for Channel ‘Default’…
[05:39:50][Step 1/1] Finding deployment process…
[05:39:50][Step 1/1] Finding release template…
[05:39:50][Step 1/1] Selected the release plan for Channel ‘Default’ - it is a perfect match
[05:39:50][Step 1/1] Using version number provided on command-line: 8.9.18105.2217
[05:39:50][Step 1/1] Release plan for M&I Customer Web 8.9.18105.2217
[05:39:50][Step 1/1] Channel: ‘Default’ (this is the default channel)
[05:39:50][Step 1/1] # Name Version Source Version rules
[05:39:50][Step 1/1] — --------------- ---------------- ---------------- -------------------
[05:39:50][Step 1/1] 1 Deploy IR Web 8.9.18105.2217 User specified Allow any version
[05:39:50][Step 1/1]
[05:39:50][Step 1/1] Creating release…
[05:39:50][Step 1/1] Error from Octopus server (HTTP 500): Octopus Server returned an error: The correlation name ‘ALIAS_AAAAA’ is specified multiple times in a FROM clause.
[05:39:50][Step 1/1] Server exception:
[05:39:50][Step 1/1] System.Data.SqlClient.SqlException (0x80131904): The correlation name ‘ALIAS_AAAAA’ is specified multiple times in a FROM clause.
[05:39:50][Step 1/1] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) [05:39:50][Step 1/1] at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) [05:39:50][Step 1/1] at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) [05:39:50][Step 1/1] at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() [05:39:50][Step 1/1] at System.Data.SqlClient.SqlDataReader.get_MetaData() [05:39:50][Step 1/1] at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) [05:39:50][Step 1/1] at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) [05:39:50][Step 1/1] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
[05:39:50][Step 1/1] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
[05:39:50][Step 1/1] at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
[05:39:50][Step 1/1] at Octopus.Core.RelationalStorage.TransientFaultHandling.IDbCommandExtensions.<>c__DisplayClass5_0.b__0() in Y:\Work\refs\tags\3.3.22\source\Octopus.Core\RelationalStorage\TransientFaultHandling\IDbCommandExtensions.cs:line 65
[05:39:50][Step 1/1] at Octopus.Shared.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func1 func) in Y:\Work\refs\tags\3.3.22\source\Octopus.Shared\TransientFaultHandling\RetryPolicy.cs:line 213 [05:39:50][Step 1/1] at Octopus.Core.RelationalStorage.TransientFaultHandling.IDbCommandExtensions.ExecuteReaderWithRetry(IDbCommand command, String operationName) in Y:\Work\refs\tags\3.3.22\source\Octopus.Core\RelationalStorage\TransientFaultHandling\IDbCommandExtensions.cs:line 42 [05:39:50][Step 1/1] at Octopus.Core.RelationalStorage.RelationalTransaction.<Stream>d__281.MoveNext() in Y:\Work\refs\tags\3.3.22\source\Octopus.Core\RelationalStorage\RelationalTransaction.cs:line 279
[05:39:50][Step 1/1] at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable1 source, Func2 keySelector, Func2 elementSelector, IEqualityComparer1 comparer)
[05:39:50][Step 1/1] at System.Linq.Enumerable.ToDictionary[TSource,TKey](IEnumerable1 source, Func2 keySelector, IEqualityComparer1 comparer) [05:39:50][Step 1/1] at Octopus.Server.Communications.Lifecycles.DeploymentSummaryService.GetDeploymentSummaries(IRelationalTransaction transaction, Release release) in Y:\Work\refs\tags\3.3.22\source\Octopus.Server\Communications\Lifecycles\DeploymentSummaryService.cs:line 25 [05:39:50][Step 1/1] at Octopus.Server.Communications.Lifecycles.LifecycleEvaluator.Evaluate(String releaseId) in Y:\Work\refs\tags\3.3.22\source\Octopus.Server\Communications\Lifecycles\LifecycleEvaluator.cs:line 82 [05:39:50][Step 1/1] at Octopus.Server.Web.Infrastructure.Api.Responder1.ExecuteRules[TRule](Action2 ruleCallback) in Y:\Work\refs\tags\3.3.22\source\Octopus.Server\Web\Infrastructure\Api\Responder.cs:line 188 [05:39:50][Step 1/1] at Octopus.Server.Web.Infrastructure.Api.CreateResponseDescriptor2.Responder.Execute() in Y:\Work\refs\tags\3.3.22\source\Octopus.Server\Web\Infrastructure\Api\CreateResponseDescriptor.cs:line 92
[05:39:50][Step 1/1] at Octopus.Server.Web.Infrastructure.Api.Responder`1.Respond(TDescriptor options, NancyContext context) in Y:\Work\refs\tags\3.3.22\source\Octopus.Server\Web\Infrastructure\Api\Responder.cs:line 162
[05:39:50][Step 1/1] at System.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSite site, T0 arg0, T1 arg1, T2 arg2)
[05:39:50][Step 1/1] at Octopus.Server.Web.Api.OctopusRestApiModule.<>c__DisplayClass0_0.<.ctor>b__0(Object o) in Y:\Work\refs\tags\3.3.22\source\Octopus.Server\Web\Api\OctopusRestApiModule.cs:line 46
[05:39:50][Step 1/1] at Nancy.Routing.Route.<>c__DisplayClass4.b__3(Object parameters, CancellationToken context)
[05:39:50][Step 1/1] ClientConnectionId:ca86394d-c3fb-4681-b64b-55d7744d8687
[05:39:50][Step 1/1] Error Number:1011,State:1,Class:16
[05:39:50][Step 1/1] -----------------------
[05:39:50][Step 1/1]
[05:39:50][Step 1/1] Exit code: -7
