search

microsoft / azuredevopslabs

Learn how you can plan smartly, collaborate better, and ship faster with a set of modern development services with Azure DevOps.
https://www.azuredevopslabs.com
MIT License
806 stars 905 forks source link

DB deployment task failed #688

Closed eoumenwa closed 7 months ago

eoumenwa commented 7 months ago

Getting the error below when deploying the DB 2023-11-12T14:06:27.5985514Z ##[section]Starting: Azure SQL DacpacTask 2023-11-12T14:06:27.5992798Z ============================================================================== 2023-11-12T14:06:27.5993129Z Task : Azure SQL Database deployment 2023-11-12T14:06:27.5993351Z Description : Deploy an Azure SQL Database using DACPAC or run scripts using SQLCMD 2023-11-12T14:06:27.5993793Z Version : 1.225.1 2023-11-12T14:06:27.5993905Z Author : Microsoft Corporation 2023-11-12T14:06:27.5994087Z Help : https://docs.microsoft.com/azure/devops/pipelines/tasks/deploy/sql-azure-dacpac-deployment 2023-11-12T14:06:27.5994641Z ============================================================================== 2023-11-12T14:06:27.6125650Z ##[error]The current operating system is not capable of running this task. That typically means the task was written for Windows only. For example, written for Windows Desktop PowerShell. 2023-11-12T14:06:27.6137534Z ##[debug]System.InvalidOperationException: The current operating system is not capable of running this task. That typically means the task was written for Windows only. For example, written for Windows Desktop PowerShell. at Microsoft.VisualStudio.Services.Agent.Worker.TaskRunner.RunAsync() in /home/vsts/work/1/s/src/Agent.Worker/TaskRunner.cs:line 117 at Microsoft.VisualStudio.Services.Agent.Worker.StepsRunner.RunStepAsync(IStep step, CancellationToken jobCancellationToken) in /home/vsts/work/1/s/src/Agent.Worker/StepsRunner.cs:line 238 2023-11-12T14:06:27.6142276Z ##[section]Finishing: Azure SQL DacpacTask

image

See full logs ReleaseLogs_3.zip

surajshenoy commented 7 months ago

Hi @eoumenwa,

Thanks again for trying out the lab.

This pipeline has been configured in template to use 'Windows-2019' agent so that DB deployment work without any issue. As per your logs it is using Ubuntu-22.04.

Will you please change the agent to Windows-2019 and give a try so that you will not get the above mentioned issue. You can use the below screenshot for reference.

image

jaysnanavati commented 7 months ago

Hello, May I please request to be removed from this list?

Thanks, Jay

From: surajshenoy @.> Sent: Monday, November 13, 2023 10:01:52 AM To: microsoft/azuredevopslabs @.> Cc: Subscribed @.***> Subject: Re: [microsoft/azuredevopslabs] DB deployment task failed (Issue #688)

Hi @eoumenwahttps://github.com/eoumenwa,

Thanks again for trying out the lab.

This pipeline has been configured in template to use 'Windows-2019' agent so that DB deployment work without any issue. As per your logs it is using Ubuntu-22.04.

Will you please change the agent to Windows-2019 and give a try so that you will not get the above mentioned issue. You can use the below screenshot for reference.

[image]https://user-images.githubusercontent.com/36665779/282426874-a22ba716-c50b-4afb-a2b5-157bd31e28bb.png

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredevopslabs/issues/688#issuecomment-1807831500, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAURCSMSBRZYJWFMB5LJHZDYEHVZBAVCNFSM6AAAAAA7ICMC4CVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMBXHAZTCNJQGA. You are receiving this because you are subscribed to this thread.Message ID: @.***>

eoumenwa commented 7 months ago

Hi @eoumenwa,

Thanks again for trying out the lab.

This pipeline has been configured in template to use 'Windows-2019' agent so that DB deployment work without any issue. As per your logs it is using Ubuntu-22.04.

Will you please change the agent to Windows-2019 and give a try so that you will not get the above mentioned issue. You can use the below screenshot for reference.

image

This worked. Thanks