[BUG]: SQL Server database deploy hiding error

[bdebaere]

New issue checklist

• I searched for existing GitHub issues
• I read pipeline troubleshooting guide
• I checked how to collect logs

Task name

SQL Server database deploy

Task version

0.198.0

Issue Description

Using the task below, we deployed a release to production today.

steps:
- task: SqlDacpacDeploymentOnMachineGroup@0
  displayName: 'Deploy using : sqlQuery'
  inputs:
    TaskType: sqlQuery
    SqlFile: '....sql'
    ServerName: '$(...)'
    DatabaseName: ...
    AuthScheme: sqlServerAuthentication
    SqlUsername: '$(...)'
    SqlPassword: '$(...)'

The first time it failed with

2025-09-16T13:00:55.6263841Z ##[section]Starting: Deploy using : sqlQuery
2025-09-16T13:00:55.6274538Z ==============================================================================
2025-09-16T13:00:55.6274675Z Task         : SQL Server database deploy
2025-09-16T13:00:55.6274766Z Description  : Deploy a SQL Server database using DACPAC or SQL scripts
2025-09-16T13:00:55.6274869Z Version      : 0.198.0
2025-09-16T13:00:55.6274930Z Author       : Microsoft Corporation
2025-09-16T13:00:55.6275025Z Help         : https://docs.microsoft.com/azure/devops/pipelines/tasks/deploy/sql-dacpac-deployment-on-machine-group
2025-09-16T13:00:55.6275165Z ==============================================================================
2025-09-16T13:00:58.1276076Z ##[error]Invalid format specification: '%2F&version=GBmaster&_a=contents'.
2025-09-16T13:00:58.1757746Z ##[section]Finishing: Deploy using : sqlQuery

Immediately retrying after, it succeeded with

2025-09-16T14:33:38.1106409Z ##[section]Starting: Deploy using : sqlQuery
2025-09-16T14:33:38.1117376Z ==============================================================================
2025-09-16T14:33:38.1117513Z Task         : SQL Server database deploy
2025-09-16T14:33:38.1117612Z Description  : Deploy a SQL Server database using DACPAC or SQL scripts
2025-09-16T14:33:38.1117714Z Version      : 0.198.0
2025-09-16T14:33:38.1117779Z Author       : Microsoft Corporation
2025-09-16T14:33:38.1117874Z Help         : https://docs.microsoft.com/azure/devops/pipelines/tasks/deploy/sql-dacpac-deployment-on-machine-group
2025-09-16T14:33:38.1118026Z ==============================================================================
2025-09-16T14:33:46.0845741Z ##[section]Finishing: Deploy using : sqlQuery

Now, transient errors happen. We get that, but what is bothering us is the fact that you can't even see the error. Surely that can't be right?

Environment type (Please select at least one enviroment where you face this issue)

• Self-Hosted
• Microsoft Hosted
• VMSS Pool
• Container

Azure DevOps Server type

dev.azure.com (formerly visualstudio.com)

Azure DevOps Server Version (if applicable)

No response

Operation system

Windows

Relevant log output

2025-09-16T13:00:55.6263841Z ##[section]Starting: Deploy using : sqlQuery
2025-09-16T13:00:55.6274538Z ==============================================================================
2025-09-16T13:00:55.6274675Z Task         : SQL Server database deploy
2025-09-16T13:00:55.6274766Z Description  : Deploy a SQL Server database using DACPAC or SQL scripts
2025-09-16T13:00:55.6274869Z Version      : 0.198.0
2025-09-16T13:00:55.6274930Z Author       : Microsoft Corporation
2025-09-16T13:00:55.6275025Z Help         : https://docs.microsoft.com/azure/devops/pipelines/tasks/deploy/sql-dacpac-deployment-on-machine-group
2025-09-16T13:00:55.6275165Z ==============================================================================
2025-09-16T13:00:58.1276076Z ##[error]Invalid format specification: '%2F&version=GBmaster&_a=contents'.
2025-09-16T13:00:58.1757746Z ##[section]Finishing: Deploy using : sqlQuery

Full task logs with system.debug enabled

 [REPLACE THIS WITH YOUR INFORMATION] 

Repro steps