DrJohnT / AzureDevOpsExtensionsForSqlServer

Microsoft SQL Server deployment extensions for Azure DevOps Pipelines
MIT License
20 stars 14 forks source link

Run Sql Command Scripts in Folder - Powershell loading issue #31

Closed Charlie939j closed 3 years ago

Charlie939j commented 3 years ago

I tried to use this extension and got an odd error when it went to run. It looks like it tried to load Powershell to run with and failed. Ever seen this before?

2021-01-27T17:04:14.8918526Z Calling Invoke-SqlCmd with the following parameters: 2021-01-27T17:04:14.8925868Z Server: xxxx 2021-01-27T17:04:14.8933072Z Database: xxxxx 2021-01-27T17:04:14.8941333Z SqlCmdSciptFolderPath: C:\azagent\A2_work\r1\a\xxxxxxx 2021-01-27T17:04:14.8948958Z Recursive: true 2021-01-27T17:04:14.8958216Z SqlCmdVariableType: none 2021-01-27T17:04:14.9501878Z Installing PowerShell module SqlServer for current user 2021-01-27T17:04:25.1524571Z ##[warning]MSG:UnableToDownload «https://go.microsoft.com/fwlink/?LinkID=627338&clcid=0x409» «» 2021-01-27T17:04:25.1542932Z ##[warning]Unable to download the list of available providers. Check your internet connection. 2021-01-27T17:04:25.2357417Z ##[warning]Unable to download from URI 'https://go.microsoft.com/fwlink/?LinkID=627338&clcid=0x409' to ''. 2021-01-27T17:04:25.5172481Z ##[error]No match was found for the specified search criteria for the provider 'NuGet'. The package provider requires 'PackageManagement' and 'Provider' tags. Please check if the specified package has the tags.

Charlie939j commented 3 years ago

ok, my mistake, I should have used an empty agent to host this extension, the one I was using was interfering with the loading.