{"action":"created","issue":{"url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5817","repository_url":"https://api.github.com/repos/Microsoft/vsts-tasks","labels_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5817/labels{/name}","comments_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5817/comments","events_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5817/events","html_url":"https://github.com/Microsoft/vsts-tasks/issues/5817","id":272609618,"number":5817,"title":"Inline SQL Script doesn't work on 2017 Hosted Agent","user":{"login":"jrr","id":164652,"avatar_url":"https://avatars0.githubusercontent.com/u/164652?v=4","gravatar_id":"","url":"https://api.github.com/users/jrr","html_url":"https://github.com/jrr","followers_url":"https://api.github.com/users/jrr/followers","following_url":"https://api.github.com/users/jrr/following{/other_user}","gists_url":"https://api.github.com/users/jrr/gists{/gist_id}","starred_url":"https://api.github.com/users/jrr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jrr/subscriptions","organizations_url":"https://api.github.com/users/jrr/orgs","repos_url":"https://api.github.com/users/jrr/repos","events_url":"https://api.github.com/users/jrr/events{/privacy}","received_events_url":"https://api.github.com/users/jrr/received_events","type":"User","site_admin":false},"labels":[{"id":391088230,"url":"https://api.github.com/repos/Microsoft/vsts-tasks/labels/Area:%20Release","name":"Area: Release","color":"5319e7","default":false}],"state":"closed","locked":false,"assignee":{"login":"kmkumaran","id":11780076,"avatar_url":"https://avatars2.githubusercontent.com/u/11780076?v=4","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://avatars2.githubusercontent.com/u/11780076?v=4","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":"KrishnaAdityaB","id":14232392,"avatar_url":"https://avatars1.githubusercontent.com/u/14232392?v=4","gravatar_id":"","url":"https://api.github.com/users/KrishnaAdityaB","html_url":"https://github.com/KrishnaAdityaB","followers_url":"https://api.github.com/users/KrishnaAdityaB/followers","following_url":"https://api.github.com/users/KrishnaAdityaB/following{/other_user}","gists_url":"https://api.github.com/users/KrishnaAdityaB/gists{/gist_id}","starred_url":"https://api.github.com/users/KrishnaAdityaB/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KrishnaAdityaB/subscriptions","organizations_url":"https://api.github.com/users/KrishnaAdityaB/orgs","repos_url":"https://api.github.com/users/KrishnaAdityaB/repos","events_url":"https://api.github.com/users/KrishnaAdityaB/events{/privacy}","received_events_url":"https://api.github.com/users/KrishnaAdityaB/received_events","type":"User","site_admin":false},{"login":"rajatagrawal-dev","id":21691254,"avatar_url":"https://avatars3.githubusercontent.com/u/21691254?v=4","gravatar_id":"","url":"https://api.github.com/users/rajatagrawal-dev","html_url":"https://github.com/rajatagrawal-dev","followers_url":"https://api.github.com/users/rajatagrawal-dev/followers","following_url":"https://api.github.com/users/rajatagrawal-dev/following{/other_user}","gists_url":"https://api.github.com/users/rajatagrawal-dev/gists{/gist_id}","starred_url":"https://api.github.com/users/rajatagrawal-dev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rajatagrawal-dev/subscriptions","organizations_url":"https://api.github.com/users/rajatagrawal-dev/orgs","repos_url":"https://api.github.com/users/rajatagrawal-dev/repos","events_url":"https://api.github.com/users/rajatagrawal-dev/events{/privacy}","received_events_url":"https://api.github.com/users/rajatagrawal-dev/received_events","type":"User","site_admin":false}],"milestone":null,"comments":18,"created_at":"2017-11-09T15:41:33Z","updated_at":"2018-04-23T16:15:01Z","closed_at":"2018-04-23T16:15:01Z","author_association":"NONE","body":"We're using the _Azure SQL Database Deployment_ task's \"Inline SQL Script\" in a few build definitions.\r\n\r\nhttps://github.com/Microsoft/vsts-tasks/blob/master/Tasks/SqlAzureDacpacDeployment/README.md\r\n\r\nThis worked on the \"Hosted\" queue, but fails on the \"Hosted 2017\" queue:\r\n\r\n```\r\n==============================================================================\r\nTask         : Azure SQL Database Deployment\r\nDescription  : Deploy Azure SQL DB using DACPAC or run scripts using SQLCMD\r\nVersion      : 1.1.23\r\nAuthor       : Microsoft Corporation\r\nHelp         : [More Information](https://aka.ms/sqlazuredeployreadme)\r\n==============================================================================\r\ntempFile= d:\\a\\_temp\\tmp6EE1.tmp\r\nInvoke-Sqlcmd -ServerInstance (snip) -Inputfile \"d:\\a\\_temp\\tmp6EE1.tmp\" -QueryTimeout 600 -ConnectionTimeout 120\r\nSQL Powershell Module is not installed on your agent machine. Please follow steps given below to execute this task\r\n1. Install PowershellTools & SharedManagementObjects(dependency), from https://www.microsoft.com/en-us/download/details.aspx?id=52676 (2016)\r\n2. Restart agent machine after installing tools to register Module path updates\r\n3. Run Import-Module SQLPS on your agent Powershell prompt. (This step is not required on Powershell 3.0 enabled machines)\r\nThe term 'Invoke-Sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.\r\n******************************************************************************\r\n```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/comments/383633380","html_url":"https://github.com/Microsoft/vsts-tasks/issues/5817#issuecomment-383633380","issue_url":"https://api.github.com/repos/Microsoft/vsts-tasks/issues/5817","id":383633380,"user":{"login":"KrishnaAdityaB","id":14232392,"avatar_url":"https://avatars1.githubusercontent.com/u/14232392?v=4","gravatar_id":"","url":"https://api.github.com/users/KrishnaAdityaB","html_url":"https://github.com/KrishnaAdityaB","followers_url":"https://api.github.com/users/KrishnaAdityaB/followers","following_url":"https://api.github.com/users/KrishnaAdityaB/following{/other_user}","gists_url":"https://api.github.com/users/KrishnaAdityaB/gists{/gist_id}","starred_url":"https://api.github.com/users/KrishnaAdityaB/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/KrishnaAdityaB/subscriptions","organizations_url":"https://api.github.com/users/KrishnaAdityaB/orgs","repos_url":"https://api.github.com/users/KrishnaAdityaB/repos","events_url":"https://api.github.com/users/KrishnaAdityaB/events{/privacy}","received_events_url":"https://api.github.com/users/KrishnaAdityaB/received_events","type":"User","site_admin":false},"created_at":"2018-04-23T16:15:01Z","updated_at":"2018-04-23T16:15:01Z","author_association":"CONTRIBUTOR","body":"@Izzmo You seems to use private agent. On private agents, you need not run this each time.\r\n"}}
{"actor":{"display_login":"KrishnaAdityaB"}}