{"action":"created","issue":{"url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/2737","repository_url":"https://api.github.com/repos/Microsoft/vsts-tasks","labels_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/2737/labels{/name}","comments_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/2737/comments","events_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/2737/events","html_url":"https://github.com/Microsoft/vsts-tasks/issues/2737","id":180510378,"number":2737,"title":"Task Azure SQL Database Deployment shows \"The remote server returned an error: (500) Internal Server Error\" while from within VS it works fine","user":{"login":"abatishchev","id":351644,"avatar_url":"https://avatars.githubusercontent.com/u/351644?v=3","gravatar_id":"","url":"https://api.github.com/users/abatishchev","html_url":"https://github.com/abatishchev","followers_url":"https://api.github.com/users/abatishchev/followers","following_url":"https://api.github.com/users/abatishchev/following{/other_user}","gists_url":"https://api.github.com/users/abatishchev/gists{/gist_id}","starred_url":"https://api.github.com/users/abatishchev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abatishchev/subscriptions","organizations_url":"https://api.github.com/users/abatishchev/orgs","repos_url":"https://api.github.com/users/abatishchev/repos","events_url":"https://api.github.com/users/abatishchev/events{/privacy}","received_events_url":"https://api.github.com/users/abatishchev/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Microsoft/vsts-tasks/labels/Area:%20RM","name":"Area: RM","color":"5319e7"}],"state":"open","locked":false,"assignee":{"login":"kmkumaran","id":11780076,"avatar_url":"https://avatars.githubusercontent.com/u/11780076?v=3","gravatar_id":"","url":"https://api.github.com/users/kmkumaran","html_url":"https://github.com/kmkumaran","followers_url":"https://api.github.com/users/kmkumaran/followers","following_url":"https://api.github.com/users/kmkumaran/following{/other_user}","gists_url":"https://api.github.com/users/kmkumaran/gists{/gist_id}","starred_url":"https://api.github.com/users/kmkumaran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kmkumaran/subscriptions","organizations_url":"https://api.github.com/users/kmkumaran/orgs","repos_url":"https://api.github.com/users/kmkumaran/repos","events_url":"https://api.github.com/users/kmkumaran/events{/privacy}","received_events_url":"https://api.github.com/users/kmkumaran/received_events","type":"User","site_admin":false},"assignees":[{"login":"kmkumaran","id":11780076,"avatar_url":"https://avatars.githubusercontent.com/u/11780076?v=3","gravatar_id":"","url":"https://api.github.com/users/kmkumaran","html_url":"https://github.com/kmkumaran","followers_url":"https://api.github.com/users/kmkumaran/followers","following_url":"https://api.github.com/users/kmkumaran/following{/other_user}","gists_url":"https://api.github.com/users/kmkumaran/gists{/gist_id}","starred_url":"https://api.github.com/users/kmkumaran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kmkumaran/subscriptions","organizations_url":"https://api.github.com/users/kmkumaran/orgs","repos_url":"https://api.github.com/users/kmkumaran/repos","events_url":"https://api.github.com/users/kmkumaran/events{/privacy}","received_events_url":"https://api.github.com/users/kmkumaran/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2016-10-02T12:39:41Z","updated_at":"2016-10-02T18:27:06Z","closed_at":null,"body":"We have Azure SQL Database Deployment task in the middle of our RMO definition and it fails with error:\r\n```\r\nFilePath= Find-VstsFiles LegacyPattern D:\\_work_caas\\95a7cdab5\\PyRq - Daily\\drop\\Data.Schema\\bin\\Release\\Data.Schema.dacpac\r\npackageFile= D:\\_work_caas\\95a7cdab5\\PyRq - Daily\\drop\\Data.Schema\\bin\\Release\\Data.Schema.dacpac\r\nPublishProfilePath = Find-VstsFiles LegacyPattern D:\\_work_caas\\95a7cdab5\\PyRq - Daily\\drop\\Data.Schema\\Properties\\PublishProfiles\\Int.publish.xml\r\nPublish profile path = D:\\_work_caas\\95a7cdab5\\PyRq - Daily\\drop\\Data.Schema\\Properties\\PublishProfiles\\Int.publish.xml\r\n##[error]Status         : ProtocolError\r\n##[error]Response       : System.Net.HttpWebResponse\r\n##[error]Message        : The remote server returned an error: (500) Internal Server Error.\r\n##[error]Data           : {}\r\n##[error]InnerException : \r\n##[error]TargetSite     : System.Net.WebResponse GetResponse(System.Net.WebRequest)\r\n##[error]StackTrace     :    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request)\r\n##[error]                    at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord()\r\n##[error]HelpLink       : \r\n##[error]Source         : Microsoft.PowerShell.Commands.Utility\r\n##[error]HResult        : -2146233079\r\n```\r\nHowever, publishing from withing VS2015.3 shows way more meaningful error:\r\n```\r\n(58,1): SQL72014: .Net SqlClient Data Provider: Msg 50000, Level 16, State 127, Line 12 Rows were detected. The schema update is terminating because data loss might occur.\r\n(47,0): SQL72045: Script execution error.  The executed script:\r\nAn error occurred while the batch was being executed.\r\n```\r\n\r\nFull log: https://mpsit.visualstudio.com/DefaultCollection/PIExp/_apps/hub/ms.vss-releaseManagement-web.hub-explorer?definitionId=4&releaseId=808&_a=release-logs"},"comment":{"url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/comments/250986611","html_url":"https://github.com/Microsoft/vsts-tasks/issues/2737#issuecomment-250986611","issue_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/2737","id":250986611,"user":{"login":"abatishchev","id":351644,"avatar_url":"https://avatars.githubusercontent.com/u/351644?v=3","gravatar_id":"","url":"https://api.github.com/users/abatishchev","html_url":"https://github.com/abatishchev","followers_url":"https://api.github.com/users/abatishchev/followers","following_url":"https://api.github.com/users/abatishchev/following{/other_user}","gists_url":"https://api.github.com/users/abatishchev/gists{/gist_id}","starred_url":"https://api.github.com/users/abatishchev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abatishchev/subscriptions","organizations_url":"https://api.github.com/users/abatishchev/orgs","repos_url":"https://api.github.com/users/abatishchev/repos","events_url":"https://api.github.com/users/abatishchev/events{/privacy}","received_events_url":"https://api.github.com/users/abatishchev/received_events","type":"User","site_admin":false},"created_at":"2016-10-02T18:27:06Z","updated_at":"2016-10-02T18:27:06Z","body":"Release to out Daily env works fine from within both RMO and VS. However any deployment attempts to Int from RM fail with HTTP 500, and works fine from VS."}}
{"actor":{"display_login":"abatishchev"}}