[Eng]: Sql test case fails randomly

[isra-fel]

Description

There's one case Microsoft.Azure.Commands.Sql.Test.ScenarioTests.DistributedAvailabilityGroupTests.TestManagedInstanceLink that fails randomly in CI.

Affected PR:

• Upgraded Microsoft.Rest.ClientRuntime to 2.3.24 #17792
• [KeyVault] Supported getting random number from managed HSM by Get-AzKeyVaultRandomNumber #17778

(in both cases, test failed only on Windows)

Log

https://dev.azure.com/azure-sdk/public/_build/results?buildId=1511684&view=logs&jobId=b17395f6-68a3-5682-0476-d3f6f1043109&j=b17395f6-68a3-5682-0476-d3f6f1043109&t=67f633ab-4360-5839-af42-f446e0c847f0

2022-04-18T09:19:45.3752921Z   [xUnit.net 00:02:52.69]     Microsoft.Azure.Commands.Sql.Test.ScenarioTests.DistributedAvailabilityGroupTests.TestManagedInstanceLink [FAIL]
2022-04-18T09:19:45.4516683Z     X Microsoft.Azure.Commands.Sql.Test.ScenarioTests.DistributedAvailabilityGroupTests.TestManagedInstanceLink [983ms]
2022-04-18T09:19:45.5047978Z EXEC : error Message:  [D:\a\1\s\build.proj]
2022-04-18T09:19:45.5076163Z      System.Management.Automation.ActionPreferenceStopException : The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: The requested resource of type 'Microsoft.Sql/managedInstances/distributedAvailabilityGroups' with name 'TestDAG' was not found.
2022-04-18T09:19:45.5090622Z     Stack Trace:
2022-04-18T09:19:45.5127430Z        at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input)
2022-04-18T09:19:45.5128886Z      at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke)
2022-04-18T09:19:45.5184778Z      at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync)
2022-04-18T09:19:45.5187053Z      at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
2022-04-18T09:19:45.5188672Z      at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
2022-04-18T09:19:45.5190312Z      at System.Management.Automation.PowerShell.Invoke(IEnumerable input, PSInvocationSettings settings)
2022-04-18T09:19:45.5191818Z      at Microsoft.WindowsAzure.Commands.ScenarioTest.EnvironmentSetupHelper.RunPowerShellTest(String[] scripts) in D:\a\1\s\tools\ScenarioTest.ResourceManager\EnvironmentSetupHelper.cs:line 573
2022-04-18T09:19:45.5193401Z      at Microsoft.Azure.Commands.ScenarioTest.SqlTests.SqlTestsBase.RunPowerShellTest(String[] scripts) in D:\a\1\s\src\Sql\Sql.Test\ScenarioTests\SqlTestsBase.cs:line 106
2022-04-18T09:19:45.5195092Z      at Microsoft.Azure.Commands.Sql.Test.ScenarioTests.DistributedAvailabilityGroupTests.TestManagedInstanceLink() in D:\a\1\s\src\Sql\Sql.Test\ScenarioTests\DistributedAvailabilityGroupTests.cs:line 45
2022-04-18T09:19:45.5196393Z     Standard Output Messages:
2022-04-18T09:19:45.5197311Z    Test-ManagedInstanceLink
2022-04-18T09:19:45.5198665Z    Caught Exception: System.Management.Automation.ActionPreferenceStopException: The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: The requested resource of type 'Microsoft.Sql/managedInstances/distributedAvailabilityGroups' with name 'TestDAG' was not found.
2022-04-18T09:19:45.5200238Z       at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input)
2022-04-18T09:19:45.5201380Z       at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke)
2022-04-18T09:19:45.5202584Z       at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync)
2022-04-18T09:19:45.5203788Z       at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
2022-04-18T09:19:45.5205166Z       at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
2022-04-18T09:19:45.5206420Z       at System.Management.Automation.PowerShell.Invoke(IEnumerable input, PSInvocationSettings settings)
2022-04-18T09:19:45.5207875Z       at Microsoft.WindowsAzure.Commands.ScenarioTest.EnvironmentSetupHelper.RunPowerShellTest(String[] scripts) in D:\a\1\s\tools\ScenarioTest.ResourceManager\EnvironmentSetupHelper.cs:line 573
2022-04-18T09:19:45.5209597Z    Message: The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: The requested resource of type 'Microsoft.Sql/managedInstances/distributedAvailabilityGroups' with name 'TestDAG' was not found.
2022-04-18T09:19:45.5211183Z EXEC : PowerShell error Record: The requested resource of type 'Microsoft.Sql/managedInstances/distributedAvailabilityGroups' with name 'TestDAG' was not found. [D:\a\1\s\build.proj]
2022-04-18T09:19:45.5212964Z   Exception:Microsoft.Rest.Azure.CloudException: The requested resource of type 'Microsoft.Sql/managedInstances/distributedAvailabilityGroups' with name 'TestDAG' was not found.
2022-04-18T09:19:45.5214562Z       at Microsoft.Azure.Management.Sql.DistributedAvailabilityGroupsOperations.GetWithHttpMessagesAsync(String resourceGroupName, String managedInstanceName, String distributedAvailabilityGroupName, Dictionary`2 customHeaders, CancellationToken cancellationToken)
2022-04-18T09:19:45.5216872Z       at Microsoft.Azure.Management.Sql.DistributedAvailabilityGroupsOperationsExtensions.GetAsync(IDistributedAvailabilityGroupsOperations operations, String resourceGroupName, String managedInstanceName, String distributedAvailabilityGroupName, CancellationToken cancellationToken)
2022-04-18T09:19:45.5218687Z       at Microsoft.Azure.Management.Sql.DistributedAvailabilityGroupsOperationsExtensions.Get(IDistributedAvailabilityGroupsOperations operations, String resourceGroupName, String managedInstanceName, String distributedAvailabilityGroupName)
2022-04-18T09:19:45.5221512Z       at Microsoft.Azure.Commands.Sql.ManagedInstanceHybridLink.Services.AzureSqlManagedInstanceLinkCommunicator.Get(String resourceGroupName, String instanceName, String distributedAvailabilityGroupName) in D:\a\1\s\src\Sql\Sql\DistributedAvailabilityGroup\Services\AzureSqlManagedInstanceLinkCommunicator.cs:line 65
2022-04-18T09:19:45.5224589Z       at Microsoft.Azure.Commands.Sql.ManagedInstanceHybridLink.Services.AzureSqlManagedInstanceLinkAdapter.GetManagedInstanceLink(String resourceGroupName, String instanceName, String distributedAvailabilityGroupName) in D:\a\1\s\src\Sql\Sql\DistributedAvailabilityGroup\Services\AzureSqlManagedInstanceLinkAdapter.cs:line 42
2022-04-18T09:19:45.5228150Z       at Microsoft.Azure.Commands.Sql.ManagedInstanceHybridLink.Cmdlet.GetAzureSqlManagedInstanceLink.GetEntity() in D:\a\1\s\src\Sql\Sql\DistributedAvailabilityGroup\Cmdlet\GetAzureSqlManagedInstanceLink.cs:line 116
2022-04-18T09:19:45.5229882Z       at Microsoft.Azure.Commands.Sql.Common.AzureSqlCmdletBase`2.ExecuteCmdlet() in D:\a\1\s\src\Sql\Sql\Common\AzureSqlCmdletBase.cs:line 122
2022-04-18T09:19:45.5231455Z       at Microsoft.Azure.Commands.Sql.ManagedInstanceHybridLink.Cmdlet.GetAzureSqlManagedInstanceLink.ExecuteCmdlet() in D:\a\1\s\src\Sql\Sql\DistributedAvailabilityGroup\Cmdlet\GetAzureSqlManagedInstanceLink.cs:line 104
2022-04-18T09:19:45.5232873Z       at Microsoft.WindowsAzure.Commands.Utilities.Common.AzurePSCmdlet.ProcessRecord()
2022-04-18T09:19:45.5233722Z   Details:
2022-04-18T09:19:45.5234855Z   Script Stack Trace: at Test-ManagedInstanceLink, D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\ScenarioTests\DistributedAvailabilityGroupTests.ps1: line 76
2022-04-18T09:19:45.5235968Z    at <ScriptBlock>, <No file>: line 1
2022-04-18T09:19:45.5236797Z   : Target: 
2022-04-18T09:19:45.5237542Z   
2022-04-18T09:19:45.5238365Z    ================== COMMANDS =======================
2022-04-18T09:19:45.5239124Z   
2022-04-18T09:19:45.5239967Z    Set-ExecutionPolicy Unrestricted -Scope Process -ErrorAction Ignore
2022-04-18T09:19:45.5240845Z   
2022-04-18T09:19:45.5241588Z    $error.clear()
2022-04-18T09:19:45.5242249Z   
2022-04-18T09:19:45.5243121Z    Write-Debug "current directory: D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\"
2022-04-18T09:19:45.5243991Z   
2022-04-18T09:19:45.5244815Z    Write-Debug "current executing assembly: D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1"
2022-04-18T09:19:45.5245698Z   
2022-04-18T09:19:45.5246500Z    cd "D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\"
2022-04-18T09:19:45.5247330Z   
2022-04-18T09:19:45.5248186Z    Import-Module "D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\Assert.ps1"
2022-04-18T09:19:45.5248980Z   
2022-04-18T09:19:45.5250930Z    Import-Module "D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\Common.ps1"
2022-04-18T09:19:45.5252102Z   
2022-04-18T09:19:45.5252904Z    Import-Module "D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\ScenarioTests\Common.ps1"
2022-04-18T09:19:45.5253727Z   
2022-04-18T09:19:45.5254554Z    Import-Module "D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\ScenarioTests\DistributedAvailabilityGroupTests.ps1"
2022-04-18T09:19:45.5255779Z   
2022-04-18T09:19:45.5256663Z    Import-Module "D:\a\1\s\artifacts\Debug\Az.Accounts\Az.Accounts.psd1"
2022-04-18T09:19:45.5257730Z   
2022-04-18T09:19:45.5258467Z    Enable-AzureRmAlias -Module Az.Accounts
2022-04-18T09:19:45.5259202Z   
2022-04-18T09:19:45.5260044Z    Import-Module "D:\a\1\s\artifacts\Debug\Az.Sql\Az.Sql.psd1"
2022-04-18T09:19:45.5260746Z   
2022-04-18T09:19:45.5261468Z    Enable-AzureRmAlias -Module Az.Sql
2022-04-18T09:19:45.5262119Z   
2022-04-18T09:19:45.5262973Z    Import-Module "D:\a\1\s\artifacts\Debug\Az.Network\Az.Network.psd1"
2022-04-18T09:19:45.5263759Z   
2022-04-18T09:19:45.5264412Z    Enable-AzureRmAlias -Module Az.Network
2022-04-18T09:19:45.5265133Z   
2022-04-18T09:19:45.5265885Z    Import-Module "D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\AzureRM.Storage.ps1"
2022-04-18T09:19:45.5266950Z   
2022-04-18T09:19:45.5267803Z    Import-Module "D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\AzureRM.Resources.ps1"
2022-04-18T09:19:45.5268562Z   
2022-04-18T09:19:45.5269410Z    Import-Module "D:\a\1\s\artifacts\Debug\Az.OperationalInsights\Az.OperationalInsights.psd1"
2022-04-18T09:19:45.5270246Z   
2022-04-18T09:19:45.5270930Z    Enable-AzureRmAlias -Module Az.OperationalInsights
2022-04-18T09:19:45.5271687Z   
2022-04-18T09:19:45.5272409Z    Import-Module "D:\a\1\s\artifacts\Debug\Az.EventHub\Az.EventHub.psd1"
2022-04-18T09:19:45.5273200Z   
2022-04-18T09:19:45.5274020Z    Enable-AzureRmAlias -Module Az.EventHub
2022-04-18T09:19:45.5274689Z   
2022-04-18T09:19:45.5275471Z    Import-Module "D:\a\1\s\artifacts\Debug\Az.Monitor\Az.Monitor.psd1"
2022-04-18T09:19:45.5276193Z   
2022-04-18T09:19:45.5277004Z    Enable-AzureRmAlias -Module Az.Monitor
2022-04-18T09:19:45.5277749Z   
2022-04-18T09:19:45.5278470Z    Import-Module "D:\a\1\s\artifacts\Debug\Az.KeyVault\Az.KeyVault.psd1"
2022-04-18T09:19:45.5279896Z   
2022-04-18T09:19:45.5280620Z    Enable-AzureRmAlias -Module Az.KeyVault
2022-04-18T09:19:45.5281642Z   
2022-04-18T09:19:45.5282401Z    Disable-AzureRmDataCollection -ErrorAction Ignore
2022-04-18T09:19:45.5283174Z   
2022-04-18T09:19:45.5283995Z    set-location "D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\"
2022-04-18T09:19:45.5284779Z   
2022-04-18T09:19:45.5285566Z    $TestOutputRoot='D:\a\1\s\src\Sql\Sql.Test\bin\Debug\netcoreapp3.1\'
2022-04-18T09:19:45.5286278Z   
2022-04-18T09:19:45.5287097Z    $VerbosePreference='Continue'
2022-04-18T09:19:45.5287743Z   
2022-04-18T09:19:45.5288451Z    $DebugPreference='Continue'
2022-04-18T09:19:45.5289151Z   
2022-04-18T09:19:45.5289872Z    $ErrorActionPreference='Stop'
2022-04-18T09:19:45.5290587Z   
2022-04-18T09:19:45.5291324Z    Write-Debug "AZURE_TEST_MODE = $($env:AZURE_TEST_MODE)"
2022-04-18T09:19:45.5292116Z   
2022-04-18T09:19:45.5292920Z    Write-Debug "TEST_HTTPMOCK_OUTPUT =  $($env:TEST_HTTPMOCK_OUTPUT)"
2022-04-18T09:19:45.5293679Z   
2022-04-18T09:19:45.5294367Z    Test-ManagedInstanceLink
2022-04-18T09:19:45.5294992Z   
2022-04-18T09:19:45.5295736Z    ===================================================
2022-04-18T09:19:45.5296481Z   
2022-04-18T09:19:45.5297271Z    ---------------------------------------------------------------
2022-04-18T09:19:45.5298047Z   
2022-04-18T09:19:45.5298658Z    DEBUG STREAM
2022-04-18T09:19:45.5299324Z   
2022-04-18T09:19:45.5300029Z    ---------------------------------------------------------------
2022-04-18T09:19:45.5300798Z   
2022-04-18T09:19:45.5301470Z    AZURE_TEST_MODE = 
2022-04-18T09:19:45.5302081Z   
2022-04-18T09:19:45.5302775Z    TEST_HTTPMOCK_OUTPUT =  
2022-04-18T09:19:45.5303400Z   
2022-04-18T09:19:45.5304287Z    9:19:45 AM - NewAzureSqlManagedInstance begin processing with ParameterSet 'NewBySkuNameParameterSetParameter'.
2022-04-18T09:19:45.5305243Z   
2022-04-18T09:19:45.5305896Z    9:19:45 AM - using account id ''...
2022-04-18T09:19:45.5306646Z   
2022-04-18T09:19:45.5307449Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:45.5308236Z    
2022-04-18T09:19:45.5308904Z    HTTP Method:
2022-04-18T09:19:45.5309699Z    GET
2022-04-18T09:19:45.5310351Z    
2022-04-18T09:19:45.5310964Z    Absolute Uri:
2022-04-18T09:19:45.5312018Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916?api-version=2021-05-01-preview
2022-04-18T09:19:45.5313486Z    
2022-04-18T09:19:45.5314185Z    Headers:
2022-04-18T09:19:45.5314999Z    x-ms-client-request-id        : 1e50fc92-95d9-45ae-8765-aa5952d906a6
2022-04-18T09:19:45.5315857Z    Accept-Language               : en-US
2022-04-18T09:19:45.5316501Z    
2022-04-18T09:19:45.5317267Z    Body:
2022-04-18T09:19:45.5317868Z    
2022-04-18T09:19:45.5318513Z    
2022-04-18T09:19:45.5319080Z    
2022-04-18T09:19:45.5319725Z   
2022-04-18T09:19:45.5320653Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:45.5321408Z    
2022-04-18T09:19:45.5322087Z    Status Code:
2022-04-18T09:19:45.5322712Z    NotFound
2022-04-18T09:19:45.5323369Z    
2022-04-18T09:19:45.5324062Z    Headers:
2022-04-18T09:19:45.5324728Z    Cache-Control                 : no-cache
2022-04-18T09:19:45.5325570Z    Pragma                        : no-cache
2022-04-18T09:19:45.5326259Z    x-ms-failure-cause            : gateway
2022-04-18T09:19:45.5327188Z    x-ms-request-id               : 45ea5919-7755-4dd9-b811-427249fc616a
2022-04-18T09:19:45.5328112Z    x-ms-correlation-request-id   : 45ea5919-7755-4dd9-b811-427249fc616a
2022-04-18T09:19:45.5329057Z    x-ms-routing-request-id       : UKSOUTH:20220315T171345Z:45ea5919-7755-4dd9-b811-427249fc616a
2022-04-18T09:19:45.5330080Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:45.5330968Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:45.5331741Z    Date                          : Tue, 15 Mar 2022 17:13:44 GMT
2022-04-18T09:19:45.5332595Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:45.5333312Z    
2022-04-18T09:19:45.5333909Z    Body:
2022-04-18T09:19:45.5334578Z    {
2022-04-18T09:19:45.5335183Z      "error": {
2022-04-18T09:19:45.5335928Z        "code": "ResourceNotFound",
2022-04-18T09:19:45.5337080Z        "message": "The Resource 'Microsoft.Sql/managedInstances/ps9916' under resource group 'ps9142' was not found. For more details please go to https://aka.ms/ARMResourceNotFoundFix"
2022-04-18T09:19:45.5338043Z      }
2022-04-18T09:19:45.5338703Z    }
2022-04-18T09:19:45.5339274Z    
2022-04-18T09:19:45.5339923Z    
2022-04-18T09:19:45.5341038Z   
2022-04-18T09:19:45.5341962Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:45.5342781Z    
2022-04-18T09:19:45.5343385Z    HTTP Method:
2022-04-18T09:19:45.5344075Z    PUT
2022-04-18T09:19:45.5344736Z    
2022-04-18T09:19:45.5345353Z    Absolute Uri:
2022-04-18T09:19:45.5346413Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916?api-version=2021-05-01-preview
2022-04-18T09:19:45.5347656Z    
2022-04-18T09:19:45.5348338Z    Headers:
2022-04-18T09:19:45.5349154Z    x-ms-client-request-id        : 1e50fc92-95d9-45ae-8765-aa5952d906a6
2022-04-18T09:19:45.5349933Z    Accept-Language               : en-US
2022-04-18T09:19:45.5351195Z    
2022-04-18T09:19:45.5351971Z    Body:
2022-04-18T09:19:45.5352662Z    {
2022-04-18T09:19:45.5353391Z      "sku": {
2022-04-18T09:19:45.5354030Z        "name": "GP_Gen5"
2022-04-18T09:19:45.5354739Z      },
2022-04-18T09:19:45.5355392Z      "properties": {
2022-04-18T09:19:45.5356165Z        "administratorLogin": "testusername",
2022-04-18T09:19:45.5357119Z        "administratorLoginPassword": "t357ingP@s5w0rd!",
2022-04-18T09:19:45.5358209Z        "subnetId": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/CustomerExperienceTeam_RG/providers/Microsoft.Network/virtualNetworks/vnet-mi-tooling/subnets/ManagedInstance",
2022-04-18T09:19:45.5359316Z        "vCores": 4,
2022-04-18T09:19:45.5360246Z        "publicDataEndpointEnabled": false
2022-04-18T09:19:45.5360976Z      },
2022-04-18T09:19:45.5361627Z      "location": "westcentralus"
2022-04-18T09:19:45.5362337Z    }
2022-04-18T09:19:45.5362962Z    
2022-04-18T09:19:45.5363650Z    
2022-04-18T09:19:45.5364225Z   
2022-04-18T09:19:45.5365005Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:45.5365799Z    
2022-04-18T09:19:45.5366402Z    Status Code:
2022-04-18T09:19:45.5367182Z    Created
2022-04-18T09:19:45.5367861Z    
2022-04-18T09:19:45.5368536Z    Headers:
2022-04-18T09:19:45.5369225Z    Cache-Control                 : no-cache
2022-04-18T09:19:45.5369996Z    Pragma                        : no-cache
2022-04-18T09:19:45.5370734Z    Retry-After                   : 60
2022-04-18T09:19:45.5371615Z    x-ms-request-id               : f5fc7630-c2e7-4668-9a99-61a1727297d5
2022-04-18T09:19:45.5372473Z    Server                        : Microsoft-HTTPAPI/2.0
2022-04-18T09:19:45.5373344Z    x-ms-ratelimit-remaining-subscription-writes: 1199
2022-04-18T09:19:45.5374184Z    x-ms-correlation-request-id   : 2597ff18-43c3-41a5-bbfe-b576a1d45169
2022-04-18T09:19:45.5375190Z    x-ms-routing-request-id       : UKSOUTH:20220315T171351Z:2597ff18-43c3-41a5-bbfe-b576a1d45169
2022-04-18T09:19:45.5376123Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:45.5377084Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:45.5377914Z    Date                          : Tue, 15 Mar 2022 17:13:51 GMT
2022-04-18T09:19:45.5378670Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:45.5379375Z    
2022-04-18T09:19:45.5380057Z    Body:
2022-04-18T09:19:45.5380652Z    {
2022-04-18T09:19:45.5381248Z      "identity": {
2022-04-18T09:19:45.5381942Z        "type": "None"
2022-04-18T09:19:45.5382609Z      },
2022-04-18T09:19:45.5383209Z      "sku": {
2022-04-18T09:19:45.5383917Z        "name": "GP_Gen5",
2022-04-18T09:19:45.5384662Z        "tier": "GeneralPurpose",
2022-04-18T09:19:45.5385398Z        "family": "Gen5",
2022-04-18T09:19:45.5386107Z        "capacity": 4
2022-04-18T09:19:45.5392411Z      },
2022-04-18T09:19:45.5394039Z      "properties": {
2022-04-18T09:19:45.5394961Z        "provisioningState": "Creating",
2022-04-18T09:19:45.5395757Z        "administratorLogin": "testusername",
2022-04-18T09:19:45.5396615Z        "licenseType": "LicenseIncluded",
2022-04-18T09:19:45.5398212Z        "vCores": 4,
2022-04-18T09:19:45.5398946Z        "storageSizeInGB": 256,
2022-04-18T09:19:45.5399667Z        "collation": "SQL_Latin1_General_CP1_CI_AS",
2022-04-18T09:19:45.5400482Z        "publicDataEndpointEnabled": false,
2022-04-18T09:19:45.5401229Z        "timezoneId": "UTC",
2022-04-18T09:19:45.5401946Z        "maintenanceConfigurationId": "SystemDefault",
2022-04-18T09:19:45.5402750Z        "privateEndpointConnections": [],
2022-04-18T09:19:45.5403477Z        "currentBackupStorageRedundancy": "Geo",
2022-04-18T09:19:45.5404279Z        "requestedBackupStorageRedundancy": "Geo"
2022-04-18T09:19:45.5405014Z      },
2022-04-18T09:19:45.5405654Z      "location": "westcentralus",
2022-04-18T09:19:45.5406623Z      "id": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916",
2022-04-18T09:19:45.5407624Z      "name": "ps9916",
2022-04-18T09:19:45.5408670Z      "type": "Microsoft.Sql/managedInstances"
2022-04-18T09:19:45.5409406Z    }
2022-04-18T09:19:45.5409988Z    
2022-04-18T09:19:45.5410652Z    
2022-04-18T09:19:45.5411555Z   
2022-04-18T09:19:45.5412785Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:45.5413628Z    
2022-04-18T09:19:45.5414318Z    HTTP Method:
2022-04-18T09:19:45.5415000Z    GET
2022-04-18T09:19:45.5415625Z    
2022-04-18T09:19:45.5416416Z    Absolute Uri:
2022-04-18T09:19:45.5417518Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916?api-version=2021-05-01-preview
2022-04-18T09:19:45.5418762Z    
2022-04-18T09:19:45.5419421Z    Headers:
2022-04-18T09:19:45.5420155Z    x-ms-client-request-id        : 1e50fc92-95d9-45ae-8765-aa5952d906a6
2022-04-18T09:19:45.5420929Z    
2022-04-18T09:19:45.5421522Z    Body:
2022-04-18T09:19:45.5422180Z    
2022-04-18T09:19:45.5422760Z    
2022-04-18T09:19:45.5423404Z    
2022-04-18T09:19:45.5424044Z   
2022-04-18T09:19:45.5424755Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:45.5425543Z    
2022-04-18T09:19:45.5426143Z    Status Code:
2022-04-18T09:19:45.5426999Z    OK
2022-04-18T09:19:45.5427657Z    
2022-04-18T09:19:45.5428445Z    Headers:
2022-04-18T09:19:45.5429201Z    Cache-Control                 : no-cache
2022-04-18T09:19:45.5430039Z    Pragma                        : no-cache
2022-04-18T09:19:45.5430875Z    x-ms-request-id               : c5ef318e-0256-4e5b-9181-3b0819e3f2e4
2022-04-18T09:19:45.5431727Z    Server                        : Microsoft-HTTPAPI/2.0
2022-04-18T09:19:45.5432491Z    x-ms-ratelimit-remaining-subscription-reads: 11998
2022-04-18T09:19:45.5433389Z    x-ms-correlation-request-id   : bff222c8-665b-45fa-bd10-d6ad60ee1edb
2022-04-18T09:19:45.5434331Z    x-ms-routing-request-id       : UKSOUTH:20220315T171452Z:bff222c8-665b-45fa-bd10-d6ad60ee1edb
2022-04-18T09:19:45.5435375Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:45.5436254Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:45.5437252Z    Date                          : Tue, 15 Mar 2022 17:14:52 GMT
2022-04-18T09:19:45.5438074Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:45.5438731Z    
2022-04-18T09:19:45.5439381Z    Body:
2022-04-18T09:19:45.5439981Z    {
2022-04-18T09:19:45.5440639Z      "sku": {
2022-04-18T09:19:45.5441330Z        "name": "GP_Gen5",
2022-04-18T09:19:45.5442000Z        "tier": "GeneralPurpose",
2022-04-18T09:19:45.5442732Z        "family": "Gen5",
2022-04-18T09:19:45.5443379Z        "capacity": 4
2022-04-18T09:19:45.5444063Z      },
2022-04-18T09:19:45.5444664Z      "properties": {
2022-04-18T09:19:45.5445404Z        "provisioningState": "Creating",
2022-04-18T09:19:45.5446264Z        "fullyQualifiedDomainName": "ps9916.1e6d90da5016.database.windows.net",
2022-04-18T09:19:45.5447192Z        "administratorLogin": "testusername",
2022-04-18T09:19:45.5448311Z        "subnetId": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/CustomerExperienceTeam_RG/providers/Microsoft.Network/virtualNetworks/vnet-mi-tooling/subnets/ManagedInstance",
2022-04-18T09:19:45.5449894Z        "state": "Creating",
2022-04-18T09:19:45.5450786Z        "licenseType": "LicenseIncluded",
2022-04-18T09:19:45.5451953Z        "vCores": 4,
2022-04-18T09:19:45.5452832Z        "storageSizeInGB": 256,
2022-04-18T09:19:45.5453573Z        "collation": "SQL_Latin1_General_CP1_CI_AS",
2022-04-18T09:19:45.5454377Z        "dnsZone": "1e6d90da5016",
2022-04-18T09:19:45.5455162Z        "publicDataEndpointEnabled": false,
2022-04-18T09:19:45.5455865Z        "timezoneId": "UTC",
2022-04-18T09:19:45.5456988Z        "maintenanceConfigurationId": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
2022-04-18T09:19:45.5458137Z        "privateEndpointConnections": [],
2022-04-18T09:19:45.5458925Z        "currentBackupStorageRedundancy": "Geo",
2022-04-18T09:19:45.5459734Z        "requestedBackupStorageRedundancy": "Geo",
2022-04-18T09:19:45.5460447Z        "zoneRedundant": false
2022-04-18T09:19:45.5461172Z      },
2022-04-18T09:19:45.5461890Z      "location": "westcentralus",
2022-04-18T09:19:45.5462797Z      "id": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916",
2022-04-18T09:19:45.5463839Z      "name": "ps9916",
2022-04-18T09:19:45.5464742Z      "type": "Microsoft.Sql/managedInstances"
2022-04-18T09:19:45.5465590Z    }
2022-04-18T09:19:45.5466231Z    
2022-04-18T09:19:45.5466901Z    
2022-04-18T09:19:45.5467549Z   
2022-04-18T09:19:45.5468325Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:45.5469050Z    
2022-04-18T09:19:45.5469721Z    HTTP Method:
2022-04-18T09:19:45.5470339Z    GET
2022-04-18T09:19:45.5470993Z    
2022-04-18T09:19:45.5471592Z    Absolute Uri:
2022-04-18T09:19:45.5472650Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916?api-version=2021-05-01-preview
2022-04-18T09:19:45.5473677Z    
2022-04-18T09:19:45.5474352Z    Headers:
2022-04-18T09:19:45.5475157Z    x-ms-client-request-id        : 1e50fc92-95d9-45ae-8765-aa5952d906a6
2022-04-18T09:19:45.5476104Z    
2022-04-18T09:19:45.5476780Z    Body:
2022-04-18T09:19:45.5477453Z    
2022-04-18T09:19:45.5478029Z    
2022-04-18T09:19:45.5478744Z    
2022-04-18T09:19:45.5479324Z   
2022-04-18T09:19:45.5480106Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:45.5480890Z    
2022-04-18T09:19:45.5481489Z    Status Code:
2022-04-18T09:19:45.5482159Z    OK
2022-04-18T09:19:45.5482739Z    
2022-04-18T09:19:45.5483394Z    Headers:
2022-04-18T09:19:45.5484221Z    Cache-Control                 : no-cache
2022-04-18T09:19:45.5484986Z    Pragma                        : no-cache
2022-04-18T09:19:45.5485747Z    x-ms-request-id               : 28731580-e219-4b12-a6a9-47953d888ff9
2022-04-18T09:19:45.5486587Z    Server                        : Microsoft-HTTPAPI/2.0
2022-04-18T09:19:45.5487434Z    x-ms-ratelimit-remaining-subscription-reads: 11997
2022-04-18T09:19:45.5488338Z    x-ms-correlation-request-id   : 2dce15f8-628b-4369-87fa-8d0ec039fb83
2022-04-18T09:19:45.5489354Z    x-ms-routing-request-id       : UKSOUTH:20220315T171553Z:2dce15f8-628b-4369-87fa-8d0ec039fb83
2022-04-18T09:19:45.5490285Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:45.5491150Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:45.5491977Z    Date                          : Tue, 15 Mar 2022 17:15:52 GMT
2022-04-18T09:19:45.5492740Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:45.5493455Z    
2022-04-18T09:19:45.5494054Z    Body:
2022-04-18T09:19:45.5494724Z    {
2022-04-18T09:19:45.5495395Z      "sku": {
2022-04-18T09:19:45.5496024Z        "name": "GP_Gen5",
2022-04-18T09:19:45.5496838Z        "tier": "GeneralPurpose",
2022-04-18T09:19:45.5497708Z        "family": "Gen5",
2022-04-18T09:19:45.5498500Z        "capacity": 4
2022-04-18T09:19:45.5499170Z      },
2022-04-18T09:19:45.5499790Z      "properties": {
2022-04-18T09:19:45.5500519Z        "provisioningState": "Creating",
2022-04-18T09:19:45.5501324Z        "fullyQualifiedDomainName": "ps9916.1e6d90da5016.database.windows.net",
2022-04-18T09:19:45.5502201Z        "administratorLogin": "testusername",
2022-04-18T09:19:45.5503324Z        "subnetId": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/CustomerExperienceTeam_RG/providers/Microsoft.Network/virtualNetworks/vnet-mi-tooling/subnets/ManagedInstance",
2022-04-18T09:19:45.5504413Z        "state": "Creating",
2022-04-18T09:19:45.5505181Z        "licenseType": "LicenseIncluded",
2022-04-18T09:19:45.5505921Z        "vCores": 4,
2022-04-18T09:19:45.5506574Z        "storageSizeInGB": 256,
2022-04-18T09:19:45.5507457Z        "collation": "SQL_Latin1_General_CP1_CI_AS",
2022-04-18T09:19:45.5508254Z        "dnsZone": "1e6d90da5016",
2022-04-18T09:19:45.5508998Z        "publicDataEndpointEnabled": false,
2022-04-18T09:19:45.5509690Z        "timezoneId": "UTC",
2022-04-18T09:19:45.5510758Z        "maintenanceConfigurationId": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
2022-04-18T09:19:45.5511753Z        "privateEndpointConnections": [],
2022-04-18T09:19:45.5512546Z        "currentBackupStorageRedundancy": "Geo",
2022-04-18T09:19:45.5513521Z        "requestedBackupStorageRedundancy": "Geo",
2022-04-18T09:19:45.5514232Z        "zoneRedundant": false
2022-04-18T09:19:45.5514932Z      },
2022-04-18T09:19:45.5515624Z      "location": "westcentralus",
2022-04-18T09:19:45.5516533Z      "id": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916",
2022-04-18T09:19:45.5517987Z      "name": "ps9916",
2022-04-18T09:19:45.5518964Z      "type": "Microsoft.Sql/managedInstances"
2022-04-18T09:19:45.5519701Z    }
2022-04-18T09:19:45.5520343Z    
2022-04-18T09:19:45.5520914Z    
2022-04-18T09:19:45.5521552Z   
2022-04-18T09:19:45.5522268Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:45.5523178Z    
2022-04-18T09:19:45.5523838Z    HTTP Method:
2022-04-18T09:19:45.5524457Z    GET
2022-04-18T09:19:45.5525112Z    
2022-04-18T09:19:45.5525715Z    Absolute Uri:
2022-04-18T09:19:45.5526846Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916?api-version=2021-05-01-preview
2022-04-18T09:19:45.5528188Z    
2022-04-18T09:19:45.5529008Z    Headers:
2022-04-18T09:19:45.5530235Z    x-ms-client-request-id        : 1e50fc92-95d9-45ae-8765-aa5952d906a6
2022-04-18T09:19:45.5531177Z    
2022-04-18T09:19:45.5531846Z    Body:
2022-04-18T09:19:45.5532454Z    
2022-04-18T09:19:45.5533104Z    
2022-04-18T09:19:45.5533689Z    
2022-04-18T09:19:45.5534346Z   
2022-04-18T09:19:45.5535056Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:45.5535840Z    
2022-04-18T09:19:45.5536494Z    Status Code:
2022-04-18T09:19:45.5537248Z    OK
2022-04-18T09:19:45.5537929Z    
2022-04-18T09:19:45.5538531Z    Headers:
2022-04-18T09:19:45.5539247Z    Cache-Control                 : no-cache
2022-04-18T09:19:45.5540494Z    Pragma                        : no-cache
2022-04-18T09:19:45.5541480Z    x-ms-request-id               : 6527325e-3f1b-47d7-88a6-56c876d1eaac
2022-04-18T09:19:45.5542318Z    Server                        : Microsoft-HTTPAPI/2.0
2022-04-18T09:19:45.5712245Z    x-ms-ratelimit-remaining-subscription-reads: 11996
2022-04-18T09:19:45.5714381Z    x-ms-correlation-request-id   : e2d2f6fd-ac7d-4804-8467-4b1d5b19499a
2022-04-18T09:19:45.5715778Z    x-ms-routing-request-id       : UKSOUTH:20220315T171653Z:e2d2f6fd-ac7d-4804-8467-4b1d5b19499a
2022-04-18T09:19:45.5716997Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:45.5717881Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:45.5718731Z    Date                          : Tue, 15 Mar 2022 17:16:52 GMT
2022-04-18T09:19:45.5719593Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:45.5720311Z    
2022-04-18T09:19:45.5721019Z    Body:
2022-04-18T09:19:45.5721669Z    {
2022-04-18T09:19:45.5722391Z      "sku": {
2022-04-18T09:19:45.5723134Z        "name": "GP_Gen5",
2022-04-18T09:19:45.5723858Z        "tier": "GeneralPurpose",
2022-04-18T09:19:45.5724601Z        "family": "Gen5",
2022-04-18T09:19:45.5725297Z        "capacity": 4
2022-04-18T09:19:45.5726028Z      },
2022-04-18T09:19:45.5726693Z      "properties": {
2022-04-18T09:19:45.5727530Z        "provisioningState": "Succeeded",
2022-04-18T09:19:45.5728436Z        "fullyQualifiedDomainName": "ps9916.1e6d90da5016.database.windows.net",
2022-04-18T09:19:45.5729317Z        "administratorLogin": "testusername",
2022-04-18T09:19:45.5730478Z        "subnetId": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/CustomerExperienceTeam_RG/providers/Microsoft.Network/virtualNetworks/vnet-mi-tooling/subnets/ManagedInstance",
2022-04-18T09:19:45.5731584Z        "state": "Ready",
2022-04-18T09:19:45.5732492Z        "licenseType": "LicenseIncluded",
2022-04-18T09:19:45.5733231Z        "vCores": 4,
2022-04-18T09:19:45.5736825Z        "storageSizeInGB": 256,
2022-04-18T09:19:45.5739045Z        "collation": "SQL_Latin1_General_CP1_CI_AS",
2022-04-18T09:19:45.5739936Z        "dnsZone": "1e6d90da5016",
2022-04-18T09:19:45.5747817Z        "publicDataEndpointEnabled": false,
2022-04-18T09:19:45.5748893Z        "timezoneId": "UTC",
2022-04-18T09:19:45.5749951Z        "maintenanceConfigurationId": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
2022-04-18T09:19:45.5751111Z        "privateEndpointConnections": [],
2022-04-18T09:19:45.5751933Z        "currentBackupStorageRedundancy": "Geo",
2022-04-18T09:19:45.5752682Z        "requestedBackupStorageRedundancy": "Geo",
2022-04-18T09:19:45.5753411Z        "zoneRedundant": false
2022-04-18T09:19:45.5754644Z      },
2022-04-18T09:19:45.5755526Z      "location": "westcentralus",
2022-04-18T09:19:45.5756454Z      "id": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916",
2022-04-18T09:19:45.5757481Z      "name": "ps9916",
2022-04-18T09:19:45.5758360Z      "type": "Microsoft.Sql/managedInstances"
2022-04-18T09:19:45.5759064Z    }
2022-04-18T09:19:45.5759637Z    
2022-04-18T09:19:45.5760220Z    
2022-04-18T09:19:45.5760798Z   
2022-04-18T09:19:45.5761989Z    9:19:45 AM - NewAzureSqlManagedInstance end processing.
2022-04-18T09:19:45.5762897Z   
2022-04-18T09:19:45.5763697Z    9:19:45 AM - GetAzureSqlManagedInstance begin processing with ParameterSet 'DefaultParameterSet'.
2022-04-18T09:19:45.5764516Z   
2022-04-18T09:19:45.5765256Z    9:19:45 AM - using account id ''...
2022-04-18T09:19:45.5765961Z   
2022-04-18T09:19:45.5766813Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:45.5767583Z    
2022-04-18T09:19:45.5768200Z    HTTP Method:
2022-04-18T09:19:45.5768806Z    GET
2022-04-18T09:19:45.5769447Z    
2022-04-18T09:19:45.5770055Z    Absolute Uri:
2022-04-18T09:19:45.5771030Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916?api-version=2021-05-01-preview
2022-04-18T09:19:45.5772053Z    
2022-04-18T09:19:45.5772641Z    Headers:
2022-04-18T09:19:45.5773415Z    x-ms-client-request-id        : 3c087845-e345-4efb-83fb-06fc7a966035
2022-04-18T09:19:45.5774241Z    Accept-Language               : en-US
2022-04-18T09:19:45.5774866Z    
2022-04-18T09:19:45.5775536Z    Body:
2022-04-18T09:19:45.5776135Z    
2022-04-18T09:19:45.5776803Z    
2022-04-18T09:19:45.5777388Z    
2022-04-18T09:19:45.5778004Z   
2022-04-18T09:19:45.5778707Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:45.5779469Z    
2022-04-18T09:19:45.5780111Z    Status Code:
2022-04-18T09:19:45.5780727Z    OK
2022-04-18T09:19:45.5781351Z    
2022-04-18T09:19:45.5781952Z    Headers:
2022-04-18T09:19:45.5782613Z    Cache-Control                 : no-cache
2022-04-18T09:19:45.5783295Z    Pragma                        : no-cache
2022-04-18T09:19:45.5784117Z    x-ms-request-id               : 76e6dc4e-c9a0-4dc4-8dfb-276e7ac30e5e
2022-04-18T09:19:45.5784983Z    Server                        : Microsoft-HTTPAPI/2.0
2022-04-18T09:19:45.5785742Z    x-ms-ratelimit-remaining-subscription-reads: 11995
2022-04-18T09:19:45.5786617Z    x-ms-correlation-request-id   : da7677d8-8ace-40e9-a84c-340a204324f3
2022-04-18T09:19:45.5787696Z    x-ms-routing-request-id       : UKSOUTH:20220315T171723Z:da7677d8-8ace-40e9-a84c-340a204324f3
2022-04-18T09:19:45.5788642Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:45.5789439Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:45.5790236Z    Date                          : Tue, 15 Mar 2022 17:17:23 GMT
2022-04-18T09:19:45.5791002Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:45.5791656Z    
2022-04-18T09:19:45.5792235Z    Body:
2022-04-18T09:19:45.5792878Z    {
2022-04-18T09:19:45.5793456Z      "sku": {
2022-04-18T09:19:45.5794339Z        "name": "GP_Gen5",
2022-04-18T09:19:45.5795027Z        "tier": "GeneralPurpose",
2022-04-18T09:19:45.5795678Z        "family": "Gen5",
2022-04-18T09:19:45.5796357Z        "capacity": 4
2022-04-18T09:19:45.5797050Z      },
2022-04-18T09:19:45.5797705Z      "properties": {
2022-04-18T09:19:45.5798390Z        "provisioningState": "Succeeded",
2022-04-18T09:19:45.5799327Z        "fullyQualifiedDomainName": "ps9916.1e6d90da5016.database.windows.net",
2022-04-18T09:19:45.5800192Z        "administratorLogin": "testusername",
2022-04-18T09:19:45.5801243Z        "subnetId": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/CustomerExperienceTeam_RG/providers/Microsoft.Network/virtualNetworks/vnet-mi-tooling/subnets/ManagedInstance",
2022-04-18T09:19:45.5802840Z        "state": "Ready",
2022-04-18T09:19:45.5803537Z        "licenseType": "LicenseIncluded",
2022-04-18T09:19:45.5804203Z        "vCores": 4,
2022-04-18T09:19:45.5804970Z        "storageSizeInGB": 256,
2022-04-18T09:19:45.5805698Z        "collation": "SQL_Latin1_General_CP1_CI_AS",
2022-04-18T09:19:45.5806519Z        "dnsZone": "1e6d90da5016",
2022-04-18T09:19:45.5807370Z        "publicDataEndpointEnabled": false,
2022-04-18T09:19:45.5808072Z        "timezoneId": "UTC",
2022-04-18T09:19:45.5809072Z        "maintenanceConfigurationId": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
2022-04-18T09:19:45.5810082Z        "privateEndpointConnections": [],
2022-04-18T09:19:45.5810800Z        "currentBackupStorageRedundancy": "Geo",
2022-04-18T09:19:45.5811591Z        "requestedBackupStorageRedundancy": "Geo",
2022-04-18T09:19:45.5812314Z        "zoneRedundant": false
2022-04-18T09:19:45.5812997Z      },
2022-04-18T09:19:45.5813676Z      "location": "westcentralus",
2022-04-18T09:19:45.5814604Z      "id": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916",
2022-04-18T09:19:45.5815549Z      "name": "ps9916",
2022-04-18T09:19:45.5816318Z      "type": "Microsoft.Sql/managedInstances"
2022-04-18T09:19:45.5817081Z    }
2022-04-18T09:19:45.5817712Z    
2022-04-18T09:19:45.5818295Z    
2022-04-18T09:19:45.5818922Z   
2022-04-18T09:19:45.5819649Z    9:19:45 AM - GetAzureSqlManagedInstance end processing.
2022-04-18T09:19:45.5820404Z   
2022-04-18T09:19:45.5821243Z    9:19:45 AM - GetAzureSqlManagedInstanceLink begin processing with ParameterSet 'GetByNameParameterSet'.
2022-04-18T09:19:45.5822044Z   
2022-04-18T09:19:45.5822734Z    9:19:45 AM - using account id ''...
2022-04-18T09:19:45.5823448Z   
2022-04-18T09:19:45.5824219Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:45.5824956Z    
2022-04-18T09:19:45.5825565Z    HTTP Method:
2022-04-18T09:19:45.5826226Z    GET
2022-04-18T09:19:45.5826944Z    
2022-04-18T09:19:45.5827563Z    Absolute Uri:
2022-04-18T09:19:45.5829819Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916/distributedAvailabilityGroups?api-version=2021-05-01-preview
2022-04-18T09:19:45.5831154Z    
2022-04-18T09:19:45.5831787Z    Headers:
2022-04-18T09:19:45.5832578Z    x-ms-client-request-id        : bc8b9af0-4407-4681-8294-c9a9087c2181
2022-04-18T09:19:45.5833408Z    Accept-Language               : en-US
2022-04-18T09:19:45.5834084Z    
2022-04-18T09:19:45.5834681Z    Body:
2022-04-18T09:19:45.5835271Z    
2022-04-18T09:19:45.5835906Z    
2022-04-18T09:19:45.5836478Z    
2022-04-18T09:19:45.5837177Z   
2022-04-18T09:19:45.5837980Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:45.5838705Z    
2022-04-18T09:19:45.5839368Z    Status Code:
2022-04-18T09:19:45.5839990Z    OK
2022-04-18T09:19:46.4029577Z    
2022-04-18T09:19:46.4034232Z    Headers:
2022-04-18T09:19:46.4035425Z    Cache-Control                 : no-cache
2022-04-18T09:19:46.4036477Z    Pragma                        : no-cache
2022-04-18T09:19:46.4037844Z    x-ms-request-id               : 0dcc6510-bed0-40dc-a66a-bdb636aa6256
2022-04-18T09:19:46.4039279Z    Server                        : Microsoft-HTTPAPI/2.0
2022-04-18T09:19:46.4040349Z    x-ms-ratelimit-remaining-subscription-reads: 11994
2022-04-18T09:19:46.4041436Z    x-ms-correlation-request-id   : bdb4e408-2e92-48d3-91d6-261507514397
2022-04-18T09:19:46.4042705Z    x-ms-routing-request-id       : UKSOUTH:20220315T171724Z:bdb4e408-2e92-48d3-91d6-261507514397
2022-04-18T09:19:46.4043805Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:46.4044731Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:46.4045668Z    Date                          : Tue, 15 Mar 2022 17:17:23 GMT
2022-04-18T09:19:46.4046753Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:46.4047571Z    
2022-04-18T09:19:46.4048286Z    Body:
2022-04-18T09:19:46.4049097Z    {
2022-04-18T09:19:46.4049880Z      "value": []
2022-04-18T09:19:46.4050616Z    }
2022-04-18T09:19:46.4051327Z    
2022-04-18T09:19:46.4052029Z    
2022-04-18T09:19:46.4052879Z   
2022-04-18T09:19:46.4054462Z    9:19:45 AM - GetAzureSqlManagedInstanceLink end processing.
2022-04-18T09:19:46.4055496Z   
2022-04-18T09:19:46.4056322Z    $listLinksZero is 
2022-04-18T09:19:46.4057079Z   
2022-04-18T09:19:46.4058072Z    9:19:45 AM - NewAzureSqlManagedInstanceLink begin processing with ParameterSet 'CreateByNameParameterSet'.
2022-04-18T09:19:46.4059020Z   
2022-04-18T09:19:46.4059825Z    9:19:45 AM - using account id ''...
2022-04-18T09:19:46.4060675Z   
2022-04-18T09:19:46.4061517Z    9:19:45 AM - NewAzureSqlManagedInstanceLink end processing.
2022-04-18T09:19:46.4062413Z   
2022-04-18T09:19:46.4063443Z    9:19:45 AM - GetAzureSqlManagedInstanceLink begin processing with ParameterSet 'GetByNameParameterSet'.
2022-04-18T09:19:46.4064533Z   
2022-04-18T09:19:46.4065389Z    9:19:45 AM - using account id ''...
2022-04-18T09:19:46.4066189Z   
2022-04-18T09:19:46.4067064Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:46.4067836Z    
2022-04-18T09:19:46.4068477Z    HTTP Method:
2022-04-18T09:19:46.4069184Z    GET
2022-04-18T09:19:46.4069785Z    
2022-04-18T09:19:46.4070395Z    Absolute Uri:
2022-04-18T09:19:46.4071560Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916/distributedAvailabilityGroups?api-version=2021-05-01-preview
2022-04-18T09:19:46.4072746Z    
2022-04-18T09:19:46.4073371Z    Headers:
2022-04-18T09:19:46.4074135Z    x-ms-client-request-id        : 49400df8-042a-46b3-bebf-b156c9dad500
2022-04-18T09:19:46.4074911Z    Accept-Language               : en-US
2022-04-18T09:19:46.4075606Z    
2022-04-18T09:19:46.4076218Z    Body:
2022-04-18T09:19:46.4076800Z    
2022-04-18T09:19:46.4077427Z    
2022-04-18T09:19:46.4078006Z    
2022-04-18T09:19:46.4078634Z   
2022-04-18T09:19:46.4079341Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:46.4080113Z    
2022-04-18T09:19:46.4080756Z    Status Code:
2022-04-18T09:19:46.4081372Z    OK
2022-04-18T09:19:46.4081974Z    
2022-04-18T09:19:46.4084471Z    Headers:
2022-04-18T09:19:46.4087279Z    Cache-Control                 : no-cache
2022-04-18T09:19:46.4089398Z    Pragma                        : no-cache
2022-04-18T09:19:46.4090382Z    x-ms-request-id               : aca18dcd-93ea-4540-ad03-6d998f83bb71
2022-04-18T09:19:46.4091231Z    Server                        : Microsoft-HTTPAPI/2.0
2022-04-18T09:19:46.4092008Z    x-ms-ratelimit-remaining-subscription-reads: 11985
2022-04-18T09:19:46.4093164Z    x-ms-correlation-request-id   : 22252855-8e93-4710-8148-d67735026918
2022-04-18T09:19:46.4094142Z    x-ms-routing-request-id       : UKSOUTH:20220315T171724Z:22252855-8e93-4710-8148-d67735026918
2022-04-18T09:19:46.4095080Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:46.4096195Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:46.4096974Z    Date                          : Tue, 15 Mar 2022 17:17:24 GMT
2022-04-18T09:19:46.4097740Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:46.4098485Z    
2022-04-18T09:19:46.4099076Z    Body:
2022-04-18T09:19:46.4099720Z    {
2022-04-18T09:19:46.4100310Z      "value": []
2022-04-18T09:19:46.4100928Z    }
2022-04-18T09:19:46.4101539Z    
2022-04-18T09:19:46.4102121Z    
2022-04-18T09:19:46.4102814Z   
2022-04-18T09:19:46.4103524Z    9:19:45 AM - GetAzureSqlManagedInstanceLink end processing.
2022-04-18T09:19:46.4104296Z   
2022-04-18T09:19:46.4105095Z    9:19:45 AM - GetAzureSqlManagedInstanceLink begin processing with ParameterSet 'GetByNameParameterSet'.
2022-04-18T09:19:46.4106076Z   
2022-04-18T09:19:46.4106785Z    9:19:45 AM - using account id ''...
2022-04-18T09:19:46.4107431Z   
2022-04-18T09:19:46.4108195Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:46.4108958Z    
2022-04-18T09:19:46.4109569Z    HTTP Method:
2022-04-18T09:19:46.4110269Z    GET
2022-04-18T09:19:46.4110847Z    
2022-04-18T09:19:46.4111458Z    Absolute Uri:
2022-04-18T09:19:46.4112654Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916/distributedAvailabilityGroups?api-version=2021-05-01-preview
2022-04-18T09:19:46.4113720Z    
2022-04-18T09:19:46.4114372Z    Headers:
2022-04-18T09:19:46.4115111Z    x-ms-client-request-id        : baaba935-50ab-489f-81cb-5c4054133559
2022-04-18T09:19:46.4115878Z    Accept-Language               : en-US
2022-04-18T09:19:46.4116549Z    
2022-04-18T09:19:46.4117133Z    Body:
2022-04-18T09:19:46.4117759Z    
2022-04-18T09:19:46.4118374Z    
2022-04-18T09:19:46.4118993Z    
2022-04-18T09:19:46.4119572Z   
2022-04-18T09:19:46.4120294Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:46.4121013Z    
2022-04-18T09:19:46.4121657Z    Status Code:
2022-04-18T09:19:46.4122256Z    OK
2022-04-18T09:19:46.4122960Z    
2022-04-18T09:19:46.4123601Z    Headers:
2022-04-18T09:19:46.4124259Z    Cache-Control                 : no-cache
2022-04-18T09:19:46.4124984Z    Pragma                        : no-cache
2022-04-18T09:19:46.4125725Z    x-ms-request-id               : 3ed276b0-4e02-4f87-bae2-677ab0692a25
2022-04-18T09:19:46.4126520Z    Server                        : Microsoft-HTTPAPI/2.0
2022-04-18T09:19:46.4127339Z    x-ms-ratelimit-remaining-subscription-reads: 11983
2022-04-18T09:19:46.4128162Z    x-ms-correlation-request-id   : c39791bb-3161-4f9d-b1e8-5978d083aa77
2022-04-18T09:19:46.4129106Z    x-ms-routing-request-id       : UKSOUTH:20220315T171755Z:c39791bb-3161-4f9d-b1e8-5978d083aa77
2022-04-18T09:19:46.4130151Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:46.4130932Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:46.4131735Z    Date                          : Tue, 15 Mar 2022 17:17:54 GMT
2022-04-18T09:19:46.4134674Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:46.4135480Z    
2022-04-18T09:19:46.4136125Z    Body:
2022-04-18T09:19:46.4136724Z    {
2022-04-18T09:19:46.4137331Z      "value": [
2022-04-18T09:19:46.4137937Z        {
2022-04-18T09:19:46.4138593Z          "properties": {
2022-04-18T09:19:46.4139307Z            "targetDatabase": "testdb",
2022-04-18T09:19:46.4147588Z            "sourceEndpoint": "TCP://SERVER:7022",
2022-04-18T09:19:46.4148651Z            "replicationMode": "Async",
2022-04-18T09:19:46.4149205Z            "distributedAvailabilityGroupId": "7a60eb24-937a-fb24-065c-eb4bcb0b60b8",
2022-04-18T09:19:46.4149800Z            "sourceReplicaId": "0cb00a6b-2461-8a4e-7bae-ba79fed799e0",
2022-04-18T09:19:46.4150403Z            "targetReplicaId": "f0e92fe9-ca08-6cd1-32ef-1febc1a34d46",
2022-04-18T09:19:46.4150878Z            "linkState": "Copying"
2022-04-18T09:19:46.4151454Z          },
2022-04-18T09:19:46.4152110Z          "id": "/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916/distributedAvailabilityGroups/TestDAG",
2022-04-18T09:19:46.4152910Z          "name": "TestDAG",
2022-04-18T09:19:46.4153431Z          "type": "Microsoft.Sql/managedInstances/distributedAvailabilityGroups"
2022-04-18T09:19:46.4153883Z        }
2022-04-18T09:19:46.4154205Z      ]
2022-04-18T09:19:46.4155629Z    }
2022-04-18T09:19:46.4156092Z    
2022-04-18T09:19:46.4156394Z    
2022-04-18T09:19:46.4156741Z   
2022-04-18T09:19:46.4157173Z    9:19:45 AM - GetAzureSqlManagedInstanceLink end processing.
2022-04-18T09:19:46.4157625Z   
2022-04-18T09:19:46.4158177Z    9:19:45 AM - GetAzureSqlManagedInstanceLink begin processing with ParameterSet 'GetByNameParameterSet'.
2022-04-18T09:19:46.4158835Z   
2022-04-18T09:19:46.4159224Z    9:19:45 AM - using account id ''...
2022-04-18T09:19:46.4159602Z   
2022-04-18T09:19:46.4160074Z    ============================ HTTP REQUEST ============================
2022-04-18T09:19:46.4160508Z    
2022-04-18T09:19:46.4160846Z    HTTP Method:
2022-04-18T09:19:46.4161176Z    GET
2022-04-18T09:19:46.4161524Z    
2022-04-18T09:19:46.4161847Z    Absolute Uri:
2022-04-18T09:19:46.4162754Z    https://management.azure.com/subscriptions/8313371e-0879-428e-b1da-6353575a9192/resourceGroups/ps9142/providers/Microsoft.Sql/managedInstances/ps9916/distributedAvailabilityGroups/TestDAG?api-version=2021-05-01-preview
2022-04-18T09:19:46.4163561Z    
2022-04-18T09:19:46.4163874Z    Headers:
2022-04-18T09:19:46.4164376Z    x-ms-client-request-id        : 7d359803-88f5-4993-886c-bcd183069a59
2022-04-18T09:19:46.4165664Z    Accept-Language               : en-US
2022-04-18T09:19:46.4166147Z    
2022-04-18T09:19:46.4166514Z    Body:
2022-04-18T09:19:46.4166829Z    
2022-04-18T09:19:46.4167142Z    
2022-04-18T09:19:46.4167440Z    
2022-04-18T09:19:46.4167776Z   
2022-04-18T09:19:46.4168222Z    ============================ HTTP RESPONSE ============================
2022-04-18T09:19:46.4168697Z    
2022-04-18T09:19:46.4169022Z    Status Code:
2022-04-18T09:19:46.4169379Z    NotFound
2022-04-18T09:19:46.4169700Z    
2022-04-18T09:19:46.4170073Z    Headers:
2022-04-18T09:19:46.4170445Z    Cache-Control                 : no-cache
2022-04-18T09:19:46.4170869Z    Pragma                        : no-cache
2022-04-18T09:19:46.4171339Z    x-ms-request-id               : ec284e68-47fb-4df5-a479-1e6acdc05826
2022-04-18T09:19:46.4171881Z    Server                        : Microsoft-HTTPAPI/2.0
2022-04-18T09:19:46.4172399Z    x-ms-ratelimit-remaining-subscription-reads: 11993
2022-04-18T09:19:46.4173031Z    x-ms-correlation-request-id   : 39824f73-8eb0-4345-a345-51284545d6de
2022-04-18T09:19:46.4173736Z    x-ms-routing-request-id       : UKSOUTH:20220315T171724Z:39824f73-8eb0-4345-a345-51284545d6de
2022-04-18T09:19:46.4174387Z    Strict-Transport-Security     : max-age=31536000; includeSubDomains
2022-04-18T09:19:46.4174935Z    X-Content-Type-Options        : nosniff
2022-04-18T09:19:46.4175425Z    Date                          : Tue, 15 Mar 2022 17:17:24 GMT
2022-04-18T09:19:46.4175892Z    azSdkTestPlayBackMode         : true
2022-04-18T09:19:46.4176290Z    
2022-04-18T09:19:46.4176602Z    Body:
2022-04-18T09:19:46.4176933Z    {
2022-04-18T09:19:46.4177251Z      "error": {
2022-04-18T09:19:46.4177664Z        "code": "ResourceNotFound",
2022-04-18T09:19:46.4178302Z        "message": "The requested resource of type 'Microsoft.Sql/managedInstances/distributedAvailabilityGroups' with name 'TestDAG' was not found."
2022-04-18T09:19:46.4178927Z      }
2022-04-18T09:19:46.4179245Z    }
2022-04-18T09:19:46.4179538Z    

[ostojicb]

Hi guys, I'm the author of this test (and respective cmdlets), I'd like to help

Unfortunately, I have a hard time reproducing this issue right now.
Last two logs (http req-resp pairs) are very weird, looks like some kind of race condition in arm, since from the first request (get all links) we see that the resource is present, but then the very next (get) request fails with ResourceNotFound.
Has anyone been able to reproduce this, or do we have any more recent instances of this failure so we can check arm/backend logs?

[isra-fel]

This issue was fixed by #18060
Thanks for your effort! @ostojicb

[BethanyZhou]

Same issue for TestManagedInstanceLink appears again on Linux : ( See details at https://dev.azure.com/azclitools/public/_build/results?buildId=36883&view=logs&j=ad07b744-5a1a-5d54-7693-fcb02e666633&t=b0841cae-a6b1-5a5c-4ebd-3cc6b3d3163d&l=229

@ostojicb could you help again?

[ostojicb]

Same issue for TestManagedInstanceLink appears again on Linux : ( See details at https://dev.azure.com/azclitools/public/_build/results?buildId=36883&view=logs&j=ad07b744-5a1a-5d54-7693-fcb02e666633&t=b0841cae-a6b1-5a5c-4ebd-3cc6b3d3163d&l=229

@ostojicb could you help again?

Hmm yeah looks like the same problem. This test seems to fail occasionally, and I suspect there is some kind of an issue with the way mock responses are matched. I'm not yet sure what's the solution.

Last request here has a smaller timestamp than the one before (Fri, 06 May 2022 12:45:40 GMT vs Fri, 06 May 2022 12:45:40 GMT) which doesn't make too much sense to me, I'd assume it matched some previous response (which was indeed empty)

I'll try to take a closer look into how we match req/resp

[vidai-msft]

The cause of this issue is the -AsJob in the test case script. Closing as fixed.