{"action":"created","issue":{"url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1908","repository_url":"https://api.github.com/repos/OctopusDeploy/Issues","labels_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1908/labels{/name}","comments_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1908/comments","events_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1908/events","html_url":"https://github.com/OctopusDeploy/Issues/issues/1908","id":101304451,"node_id":"MDU6SXNzdWUxMDEzMDQ0NTE=","number":1908,"title":"Migration on SQL azure database fails due to unsupported query","user":{"login":"zentron","id":1830666,"node_id":"MDQ6VXNlcjE4MzA2NjY=","avatar_url":"https://avatars1.githubusercontent.com/u/1830666?v=4","gravatar_id":"","url":"https://api.github.com/users/zentron","html_url":"https://github.com/zentron","followers_url":"https://api.github.com/users/zentron/followers","following_url":"https://api.github.com/users/zentron/following{/other_user}","gists_url":"https://api.github.com/users/zentron/gists{/gist_id}","starred_url":"https://api.github.com/users/zentron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zentron/subscriptions","organizations_url":"https://api.github.com/users/zentron/orgs","repos_url":"https://api.github.com/users/zentron/repos","events_url":"https://api.github.com/users/zentron/events{/privacy}","received_events_url":"https://api.github.com/users/zentron/received_events","type":"User","site_admin":false},"labels":[{"id":62440880,"node_id":"MDU6TGFiZWw2MjQ0MDg4MA==","url":"https://api.github.com/repos/OctopusDeploy/Issues/labels/closed/wontfix","name":"closed/wontfix","color":"cccccc","default":false},{"id":62440875,"node_id":"MDU6TGFiZWw2MjQ0MDg3NQ==","url":"https://api.github.com/repos/OctopusDeploy/Issues/labels/kind/bug","name":"kind/bug","color":"eb6420","default":false},{"id":76706641,"node_id":"MDU6TGFiZWw3NjcwNjY0MQ==","url":"https://api.github.com/repos/OctopusDeploy/Issues/labels/priority","name":"priority","color":"e11d21","default":false}],"state":"closed","locked":false,"assignee":{"login":"michaelnoonan","id":1627582,"node_id":"MDQ6VXNlcjE2Mjc1ODI=","avatar_url":"https://avatars1.githubusercontent.com/u/1627582?v=4","gravatar_id":"","url":"https://api.github.com/users/michaelnoonan","html_url":"https://github.com/michaelnoonan","followers_url":"https://api.github.com/users/michaelnoonan/followers","following_url":"https://api.github.com/users/michaelnoonan/following{/other_user}","gists_url":"https://api.github.com/users/michaelnoonan/gists{/gist_id}","starred_url":"https://api.github.com/users/michaelnoonan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michaelnoonan/subscriptions","organizations_url":"https://api.github.com/users/michaelnoonan/orgs","repos_url":"https://api.github.com/users/michaelnoonan/repos","events_url":"https://api.github.com/users/michaelnoonan/events{/privacy}","received_events_url":"https://api.github.com/users/michaelnoonan/received_events","type":"User","site_admin":false},"assignees":[{"login":"michaelnoonan","id":1627582,"node_id":"MDQ6VXNlcjE2Mjc1ODI=","avatar_url":"https://avatars1.githubusercontent.com/u/1627582?v=4","gravatar_id":"","url":"https://api.github.com/users/michaelnoonan","html_url":"https://github.com/michaelnoonan","followers_url":"https://api.github.com/users/michaelnoonan/followers","following_url":"https://api.github.com/users/michaelnoonan/following{/other_user}","gists_url":"https://api.github.com/users/michaelnoonan/gists{/gist_id}","starred_url":"https://api.github.com/users/michaelnoonan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/michaelnoonan/subscriptions","organizations_url":"https://api.github.com/users/michaelnoonan/orgs","repos_url":"https://api.github.com/users/michaelnoonan/repos","events_url":"https://api.github.com/users/michaelnoonan/events{/privacy}","received_events_url":"https://api.github.com/users/michaelnoonan/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2015-08-16T22:15:48Z","updated_at":"2018-11-26T20:09:26Z","closed_at":"2015-08-23T23:20:31Z","author_association":"NONE","body":"It appears as though during migration, a query with multiple query hints is being invoked that can fail on SQL Azure installations.\n\nSource: http://help.octopusdeploy.com/discussions/problems/37624\n\n```\n2015-08-15 09:18:58.3136 6 FATAL Unhandled AppDomain exception occurred: Database upgrade failed: Deprecated feature 'Multiple table hints without comma' is not supported in this version of SQL Server. \nSystem.Exception: Database upgrade failed: Deprecated feature 'Multiple table hints without comma' is not supported in this version of SQL Server. ---> System.Data.SqlClient.SqlException: Deprecated feature 'Multiple table hints without comma' is not supported in this version of SQL Server. \n   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) \n   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) \n   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) \n   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() \n   at System.Data.SqlClient.SqlDataReader.get_MetaData() \n   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) \n   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) \n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) \n   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) \n   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) \n   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) \n   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() \n   at DbUp.Support.SqlServer.SqlScriptExecutor.<>c__DisplayClass7.<Execute>b__4(Func`1 dbCommandFactory) \n   at DbUp.Support.SqlServer.SqlScriptExecutor.Execute(SqlScript script, IDictionary`2 variables) \n   at DbUp.Engine.UpgradeEngine.PerformUpgrade() \n   --- End of inner exception stack trace --- \n   at Octopus.Core.Initialization.DatabaseUpgrader.Upgrade(IRelationalStore store) in Y:\\work\\refs\\heads\\master\\source\\Octopus.Core\\Initialization\\DatabaseUpgrader.cs:line 36 \n   at Octopus.Core.Initialization.StoreInitializer.Initialize() in Y:\\work\\refs\\heads\\master\\source\\Octopus.Core\\Initialization\\StoreInitializer.cs:line 22 \n   at Octopus.Server.OctopusServerEngine.Start() in Y:\\work\\refs\\heads\\master\\source\\Octopus.Server\\OctopusServerEngine.cs:line 49 \n   at Octopus.Server.Commands.RunCommand.Start() in Y:\\work\\refs\\heads\\master\\source\\Octopus.Server\\Commands\\RunCommand.cs:line 37 \n   at Octopus.Shared.Startup.AbstractCommand.Octopus.Shared.Startup.ICommand.Start(String[] commandLineArguments, ICommandRuntime commandRuntime, OptionSet commonOptions) in Y:\\work\\refs\\heads\\master\\source\\Octopus.Shared\\Startup\\AbstractCommand.cs:line 57 \n   at Octopus.Shared.Startup.WindowsServiceHost.<>c__DisplayClass1_0.<Run>b__0() in Y:\\work\\refs\\heads\\master\\source\\Octopus.Shared\\Startup\\WindowsServiceHost.cs:line 21 \n   at Octopus.Shared.Startup.WindowsServiceAdapter.RunService() in Y:\\work\\refs\\heads\\master\\source\\Octopus.Shared\\Startup\\WindowsServiceAdapter.cs:line 59 \n   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) \n   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) \n   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) \n   at System.Threading.ThreadHelper.ThreadStart()\n```\n"},"comment":{"url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/comments/441780294","html_url":"https://github.com/OctopusDeploy/Issues/issues/1908#issuecomment-441780294","issue_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/1908","id":441780294,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTc4MDI5NA==","user":{"login":"lock[bot]","id":33595554,"node_id":"MDM6Qm90MzM1OTU1NTQ=","avatar_url":"https://avatars1.githubusercontent.com/in/6672?v=4","gravatar_id":"","url":"https://api.github.com/users/lock%5Bbot%5D","html_url":"https://github.com/apps/lock","followers_url":"https://api.github.com/users/lock%5Bbot%5D/followers","following_url":"https://api.github.com/users/lock%5Bbot%5D/following{/other_user}","gists_url":"https://api.github.com/users/lock%5Bbot%5D/gists{/gist_id}","starred_url":"https://api.github.com/users/lock%5Bbot%5D/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lock%5Bbot%5D/subscriptions","organizations_url":"https://api.github.com/users/lock%5Bbot%5D/orgs","repos_url":"https://api.github.com/users/lock%5Bbot%5D/repos","events_url":"https://api.github.com/users/lock%5Bbot%5D/events{/privacy}","received_events_url":"https://api.github.com/users/lock%5Bbot%5D/received_events","type":"Bot","site_admin":false},"created_at":"2018-11-26T20:09:26Z","updated_at":"2018-11-26T20:09:26Z","author_association":"NONE","body":"This thread has been automatically locked since there has not been any recent activity after it was closed. If you think you've found a related issue, please contact our [support team](https://octopus.com/support) so we can triage your issue, and make sure it's handled appropriately.\n"}}
{"actor":{"display_login":"lock"}}