Skip to content

[Known Issue] Increased deployment time due to MSAL throttling #92

@udeeshagautam

Description

@udeeshagautam
  • SqlPackage or DacFx Version: All 160
  • .NET Framework (Windows-only) or .NET Core: Both
  • Environment (local platform and source/target platforms): AAD login

When: Intermittent. Using AAD username password with SqlPackage
Symptoms: Increased deployment time. Following exception and retry log if in log file using /df parameter

Microsoft.Data.Tools.Diagnostics.Tracer Warning: 0 : 2022-04-12T17:11:58 : Retry occurred: session: 00000000-0000-0000-0000-000000000000; attempt - 8; delay - 00:01:00; exception - "System.AggregateException: One or more errors occurred. ---> Microsoft.Identity.Client.MsalUiRequiredException: AADSTS50196: The server terminated an operation because it encountered a client request loop. Please contact your app vendor.
Trace ID: 4db7000d-e3cb-4d49-9b6d-8476ce410e00
Correlation ID: 1ea0fd86-6c90-4285-a9c8-a31a0f6b7939
Timestamp: 2022-04-13 00:11:59Z
at Microsoft.Identity.Client.OAuth2.OAuth2Client.ThrowServerException(HttpResponse response, RequestContext requestContext)
at Microsoft.Identity.Client.OAuth2.OAuth2Client.CreateResponse[T](HttpResponse response, RequestContext requestContext)
at Microsoft.Identity.Client.OAuth2.OAuth2Client.d__11`1.MoveNext()

Reason
DacFx uses Microsoft.Data.SqlClient which further uses MSAL for AAD connections. The throttling logic for MSAL has changed in newer versions causing this issue.
Ref: AzureAD/microsoft-authentication-library-for-dotnet#2808

Did this occur in prior versions? If not - which version(s) did it work in?
This is only for 160 versions
(DacFx/SqlPackage/SSMS/Azure Data Studio)

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions