2022-12-21T15:10:17.9934383Z ##[debug]Dac Framework installed with Visual Studio found at C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\150\SqlPackage.exe on machine fv-az98-841 2022-12-21T15:10:18.0001043Z "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe" /Action:Publish /SourceFile:"D:\a\1\s\data\Database3.dacpac" /TargetConnectionString:"Server=cover-sqlsrv.database.windows.net;Database=cover-db;Column Encryption Setting=enabled;" /AccessToken:eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyIsImtpZCI6Ii1LSTNROW5OUjdiUm9meG1lWm9YcWJIWkdldyJ9.eyJhdWQiOiJodHRwczovL2RhdGFiYXNlLndpbmRvd3MubmV0IiwiaXNzIjoiaHR0cHM6Ly9zdHMud2luZG93cy5uZXQvZTdhYjgxYjItMWU4NC00YmY3LTlkY2ItYjZmZWMwMWVkMTM4LyIsImlhdCI6MTY3MTYzNTAxMCwibmJmIjoxNjcxNjM1MDEwLCJleHAiOjE2NzE2Mzg5MTAsImFpbyI6IkUyWmdZRmgwOG5uRnpCOXFuazIyWEN2RmxzMVBCUUE9IiwiYXBwaWQiOiI1MmZlYTgzNi0yOWY5LTRkNDQtYjE2Zi0xNTk4MmUyNDAyNzUiLCJhcHBpZGFjciI6IjEiLCJpZHAiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC9lN2FiODFiMi0xZTg0LTRiZjctOWRjYi1iNmZlYzAxZWQxMzgvIiwiaWR0eXAiOiJhcHAiLCJvaWQiOiIzZjcwNmYxNi0wYjY3LTRmMDQtYTdlMS0yZTY4NzNlZmVkN2UiLCJyaCI6IjAuQVJFQXNvR3I1NFFlOTB1ZHk3Yi13QjdST05NSEtRSWJEX2RJdXR3YnBxdXJiV1lSQUFBLiIsInN1YiI6IjNmNzA2ZjE2LTBiNjctNGYwNC1hN2UxLTJlNjg3M2VmZWQ3ZSIsInRpZCI6ImU3YWI4MWIyLTFlODQtNGJmNy05ZGNiLWI2ZmVjMDFlZDEzOCIsInV0aSI6Inp6SlJFMGxwdWsyYUF6V1VNWkp4QUEiLCJ2ZXIiOiIxLjAifQ.YddURYun9zNdVWj074MMxhW8jo4xWtfm84Uzk6DudBdwVtXcxh9NCXcRK1rXz24gLZWz_AlbT5f4EyPFYFBsSyxRwna3UtZztIJ4gOTY_-Zllu2j-EAa-5MuWpRKn_gEq5izPXKrExpN2A5UD404NwyzuZqZyvM1cjeKZZyNIE5pMoUYgtBel8M0HIGmkSofXe_LIgKfnXjBCVwNZKJqydXy7t03QYO67fryEtql8ovIiMF2BoQsFwa9tCWsw97zjRytCoUHNtF7H4c6X3Z3bEWugQBe3sHWrtjIe13zh_8O6bIqnpMZqJMkePu22d55nZyLyl_Dw22ttTo5Md8_Dg /AzureKeyVaultAuthMethod:ClientIdSecret /ClientId:*** /Secret:*** /p:ExcludeObjectType="ColumnEncryptionKeys" /p:ExcludeObjectType="ColumnMasterKeys" 2022-12-21T15:10:18.2683177Z Publishing to database 'cover-db' on server 'cover-sqlsrv.database.windows.net'. 2022-12-21T15:10:20.6671193Z Initializing deployment (Start) 2022-12-21T15:10:37.4220236Z Initializing deployment (Complete) 2022-12-21T15:10:37.4227750Z Analyzing deployment plan (Start) 2022-12-21T15:10:37.8095924Z Analyzing deployment plan (Failed) 2022-12-21T15:10:37.8254324Z Time elapsed 0:00:19.60 2022-12-21T15:10:37.8537171Z ##[debug]Error record: 2022-12-21T15:10:37.9028850Z ##[debug]Execute-Command : *** Index was outside the bounds of the array. 2022-12-21T15:10:37.9040987Z ##[debug]At D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.209.0\SqlAzureActions.ps1:477 char:5 2022-12-21T15:10:37.9052196Z ##[debug]+ Execute-Command -FileName $sqlPackagePath -Arguments $sqlpackageA ... 2022-12-21T15:10:37.9063588Z ##[debug]+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 2022-12-21T15:10:37.9074940Z ##[debug] + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException 2022-12-21T15:10:37.9086338Z ##[debug] + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Execute-Command 2022-12-21T15:10:37.9097404Z ##[debug] 2022-12-21T15:10:37.9114828Z ##[debug]Script stack trace: 2022-12-21T15:10:37.9146401Z ##[debug]at Execute-Command, D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.209.0\Utility.ps1: line 292 2022-12-21T15:10:37.9157917Z ##[debug]at Execute-SqlPackage, D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.209.0\SqlAzureActions.ps1: line 477 2022-12-21T15:10:37.9169149Z ##[debug]at Publish-Dacpac, D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.209.0\SqlAzureActions.ps1: line 200 2022-12-21T15:10:37.9180491Z ##[debug]at , D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.209.0\DeploySqlAzure.ps1: line 150 2022-12-21T15:10:37.9191521Z ##[debug]at , : line 1 2022-12-21T15:10:37.9202872Z ##[debug]at , : line 22 2022-12-21T15:10:37.9214110Z ##[debug]at , : line 18 2022-12-21T15:10:37.9225421Z ##[debug]at , : line 1 2022-12-21T15:10:37.9242294Z ##[debug]Exception: 2022-12-21T15:10:37.9279461Z ##[debug]Microsoft.PowerShell.Commands.WriteErrorException: *** Index was outside the bounds of the array. 2022-12-21T15:10:37.9483713Z ##[error]*** Index was outside the bounds of the array. 2022-12-21T15:10:37.9492765Z ##[debug]Processed: ##vso[task.logissue type=error]*** Index was outside the bounds of the array. 2022-12-21T15:10:37.9811441Z ##[debug]No Firewall Rule was added 2022-12-21T15:10:38.0046201Z ##[debug]Caught exception from task script. 2022-12-21T15:10:38.0067542Z ##[debug]Error record: 2022-12-21T15:10:38.0184706Z ##[debug]The Azure SQL DACPAC task failed. SqlPackage.exe exited with code 1.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting- 2022-12-21T15:10:38.0196087Z ##[debug]At D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.209.0\DeploySqlAzure.ps1:220 char:5 2022-12-21T15:10:38.0207465Z ##[debug]+ throw $errorMessage 2022-12-21T15:10:38.0218813Z ##[debug]+ ~~~~~~~~~~~~~~~~~~~ 2022-12-21T15:10:38.0230245Z ##[debug] + CategoryInfo : OperationStopped: (The Azure SQL D...roubleshooting-:String) [], RuntimeException 2022-12-21T15:10:38.0241825Z ##[debug] + FullyQualifiedErrorId : The Azure SQL DACPAC task failed. SqlPackage.exe exited with code 1.Check out how to tro ubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting- 2022-12-21T15:10:38.0252847Z ##[debug] 2022-12-21T15:10:38.0270659Z ##[debug]Script stack trace: 2022-12-21T15:10:38.0288861Z ##[debug]at , D:\a\_tasks\SqlAzureDacpacDeployment_ce85a08b-a538-4d2b-8589-1d37a9ab970f\1.209.0\DeploySqlAzure.ps1: line 220 2022-12-21T15:10:38.0299874Z ##[debug]at , : line 1 2022-12-21T15:10:38.0311567Z ##[debug]at , : line 22 2022-12-21T15:10:38.0322874Z ##[debug]at , : line 18 2022-12-21T15:10:38.0334272Z ##[debug]at , : line 1 2022-12-21T15:10:38.0351757Z ##[debug]Exception: 2022-12-21T15:10:38.0389178Z ##[debug]System.Management.Automation.RuntimeException: The Azure SQL DACPAC task failed. SqlPackage.exe exited with code 1.Check out how to troubleshoot failures at https://aka.ms/sqlazuredeployreadme#troubleshooting- 2022-12-21T15:10:38.0405472Z ##[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- 2022-12-21T15:10:38.0406600Z ##[debug]Processed: ##vso[task.logissue type=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- 2022-12-21T15:10:38.0414999Z ##[debug]Processed: ##vso[task.complete result=Failed] 2022-12-21T15:10:38.0794755Z ##[section]Finishing: Deploy Dacpac Encrypted to SQLDB