SqlAzureDacpacDeployment@1 - Analyzing deployment(failed)

Question

SqlAzureDacpacDeployment@1 - Analyzing deployment(failed)

IZMAR Mohamed (CSC/MST) 6

Hello,
I am working with the Azure SQL Database Deployment task SqlAzureDacpacDeployment@1 in Azure DevOps and getting the below error: ==> ##[error]*** Index was outside the bounds of the array.

Publishing to database 'cover-db' on server 'cover-sqlsrv.database.windows.net'.
Initializing deployment (Start)
Initializing deployment (Complete)
Analyzing deployment plan (Start)
Analyzing deployment plan (Failed)
Time elapsed 0:00:08.37

[error]*** Index was outside the bounds of the array.

[error]The Azure SQL DACPAC task failed. SqlPackage.exe exited with code 1.

Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting-
Finishing: Deploy Dacpac Encrypted to SQLDB

YML task that i am using :

task: SqlAzureDacpacDeployment@1
displayName: 'Deploy Dacpac Encrypted to SQLDB'
inputs:
azureSubscription: 'xxxxx'
AuthenticationType: 'connectionString'
ConnectionString: 'Server=$(SQLSERVER).database.windows.net;Database=$(SQLDATABASE);Column Encryption Setting=enabled;'
deployType: 'DacpacTask'
DeploymentAction: 'Publish'
AdditionalArguments: '/AccessToken:$(sqlToken) /AzureKeyVaultAuthMethod:ClientIdSecret /ClientId:$env:servicePrincipalId /Secret:$env:servicePrincipalKey /p:ExcludeObjectType="ColumnEncryptionKeys" /p:ExcludeObjectType="ColumnMasterKeys"'
DacpacFile: $(Build.SourcesDirectory)/data/$(DacFileEncrypted)
IpDetectionMethod: 'AutoDetect'

any help Would be appreciated
Thanks in advance

SSingh-MSFT 16,461 Reputation points Moderator

2022-12-20T10:18:25.503+00:00

Hi @IZMAR Mohamed (CSC/MST) ,

Welcome to Microsoft Q&A platform and thanks for using Azure services.

As I understand from the question, you are getting Error: Index was outside the bounds of the array during deployment through Azure DevOps.

Could you please let us know the configuration details of the target database "Publishing to database 'cover-db'"

Please try to perform deployment afresh and check.
IZMAR Mohamed (CSC/MST) 6 Reputation points

2022-12-20T11:38:00.6+00:00
@SSingh-MSFT
do you want me to send you info from these views? (sys.database_scoped_configurations, sys.databases, sys.configurations)
Pricing tier = General Purpose: Standard-series (Gen5), 2 vCores
Collation = SQL_Latin1_General_CP1_CI_AS
compatibility_level = 150

Let me explain my case:

Create a dacpac file that contains (1 table dbo.patients) with visual studio 2022
==> Successfully deployed

Deploy the table with task: SqlAzureDacpacDeployment@1

Insert Data

Create a new dacpac file that contains (1 table dbo.patients) but with encrypted columns

Deploy the table with task: SqlAzureDacpacDeployment@1
==> Error - Index was outside the bounds of the array

The error occurs when the table already exists. Otherwise I am able to publish with encrypted columns
SSingh-MSFT 16,461 Reputation points Moderator

2022-12-21T13:11:40.38+00:00

Hi @IZMAR Mohamed (CSC/MST) ,

Thanks for the reply.

When the table exists, there is probably mismatch occurring after encryption.
Could you please try the solution given here: index-was-outside-the-bounds-of-the-array-error-while-publishing-a-net-web-ap. See if this helps.

In the meantime, I am trying to reproduce to analyze the issue. Thanks for your patience.
IZMAR Mohamed (CSC/MST) 6 Reputation points

2022-12-22T08:37:21.377+00:00

Hello @SSingh-MSFT ,
solution not applicable for my case. I have added an attach with debug mode.
Maybe it would help to analyze the issue

Thanks for your help!

273149-sqlazuredacpacdeployment-failure-traces.txt
SSingh-MSFT 16,461 Reputation points Moderator

2022-12-22T08:51:31.42+00:00

Hi @IZMAR Mohamed (CSC/MST) ,

Thanks for the reply.

Possible cause of such error could be DAC tooling is not up to date and the target database is configured with an incompatible Compatibility Level. It tend to happen when Azure SQL receives an update and you are deploying on a new database. You can either update DAC tooling on self hosted agent or reduce the compatibility level of your DB

If this does not work, I would recommend you to raise support ticket for deeper investigation. Let me know if you are able to log the ticket and if any issue we can help in unblocking you.
SSingh-MSFT 16,461 Reputation points Moderator

2022-12-26T09:34:41.347+00:00

Hi @IZMAR Mohamed (CSC/MST) ,

We have not heard back from you. Could you please share if you are able to proceed with the deployment or still having issues. If you are having issue in opening support ticket, please let us know so that we may help unblocking you.

Thank you!
IZMAR Mohamed (CSC/MST) 6 Reputation points

2022-12-28T09:50:30.203+00:00

Hello @SSingh-MSFT ,
Sorry for my late reply but i was on holiday. Indeed support ticket raised

Thanks again for your support & Happy New Year!

Kr
M/