{"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:%20Release","name":"Area: Release","color":"5319e7"}],"state":"closed","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},{"login":"Ajay-MS","id":16772764,"avatar_url":"https://avatars.githubusercontent.com/u/16772764?v=3","gravatar_id":"","url":"https://api.github.com/users/Ajay-MS","html_url":"https://github.com/Ajay-MS","followers_url":"https://api.github.com/users/Ajay-MS/followers","following_url":"https://api.github.com/users/Ajay-MS/following{/other_user}","gists_url":"https://api.github.com/users/Ajay-MS/gists{/gist_id}","starred_url":"https://api.github.com/users/Ajay-MS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ajay-MS/subscriptions","organizations_url":"https://api.github.com/users/Ajay-MS/orgs","repos_url":"https://api.github.com/users/Ajay-MS/repos","events_url":"https://api.github.com/users/Ajay-MS/events{/privacy}","received_events_url":"https://api.github.com/users/Ajay-MS/received_events","type":"User","site_admin":false},{"login":"rohit-batra","id":21075522,"avatar_url":"https://avatars.githubusercontent.com/u/21075522?v=3","gravatar_id":"","url":"https://api.github.com/users/rohit-batra","html_url":"https://github.com/rohit-batra","followers_url":"https://api.github.com/users/rohit-batra/followers","following_url":"https://api.github.com/users/rohit-batra/following{/other_user}","gists_url":"https://api.github.com/users/rohit-batra/gists{/gist_id}","starred_url":"https://api.github.com/users/rohit-batra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rohit-batra/subscriptions","organizations_url":"https://api.github.com/users/rohit-batra/orgs","repos_url":"https://api.github.com/users/rohit-batra/repos","events_url":"https://api.github.com/users/rohit-batra/events{/privacy}","received_events_url":"https://api.github.com/users/rohit-batra/received_events","type":"User","site_admin":false}],"milestone":null,"comments":6,"created_at":"2016-10-02T12:39:41Z","updated_at":"2016-10-05T09:01:21Z","closed_at":"2016-10-05T09:01:21Z","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/251620612","html_url":"https://github.com/Microsoft/vsts-tasks/issues/2737#issuecomment-251620612","issue_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/2737","id":251620612,"user":{"login":"Ajay-MS","id":16772764,"avatar_url":"https://avatars.githubusercontent.com/u/16772764?v=3","gravatar_id":"","url":"https://api.github.com/users/Ajay-MS","html_url":"https://github.com/Ajay-MS","followers_url":"https://api.github.com/users/Ajay-MS/followers","following_url":"https://api.github.com/users/Ajay-MS/following{/other_user}","gists_url":"https://api.github.com/users/Ajay-MS/gists{/gist_id}","starred_url":"https://api.github.com/users/Ajay-MS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ajay-MS/subscriptions","organizations_url":"https://api.github.com/users/Ajay-MS/orgs","repos_url":"https://api.github.com/users/Ajay-MS/repos","events_url":"https://api.github.com/users/Ajay-MS/events{/privacy}","received_events_url":"https://api.github.com/users/Ajay-MS/received_events","type":"User","site_admin":false},"created_at":"2016-10-05T09:01:21Z","updated_at":"2016-10-05T09:01:21Z","body":"@abatishchev \r\n\r\nUsing RMO it was failing on creating firewall rules failed before executing your dacpac but creating firewall should also giving understandable message which is here you getting as object of System.Net.HttpWebResponse. We have created internal bug for this. Since your release is succeeding now I am closing this issue and tracing it as part of internal bug. If you again face this issue feel free to reopen this bug again.\r\n"}}
{"actor":{"display_login":"Ajay-MS"}}