search

Azure / azure-powershell

Microsoft Azure PowerShell
Other
4.26k stars 3.86k forks source link

Get-AzSynapsePipeline does not work without name parameter which is not mandatory #20558

Open ssisjoost opened 1 year ago

ssisjoost commented 1 year ago

Description

Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp" always gives an error

Get-AzSynapsePipeline : The requested operation requires an element of type 'String', but the target element has type 'Object'. At line:7 char:1

unless you also provide the NOT mandatory name parameter: Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp" -Name "PL_Master"

Which is useless if you need ALL pipelines.

Tried also older versions of the module and both Powershell 5 and Powershell core

Issue script & Debug output

Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp"
DEBUG: 18:04:27 - GetAzureSynapsePipeline begin processing with ParameterSet 'GetByName'.
DEBUG: 18:04:27 - using account id 'mysecret@email.com'...
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(bd542563-dd1d-4594-89fa-2bf209b69a09)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - bd542563-dd1d-4594-89fa-2bf209b69a09

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(0dc1847f-af2d-47fd-831f-6436a6d4a583)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 0dc1847f-af2d-47fd-831f-6436a6d4a583

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(b945e3ee-ec9b-422d-ae43-f2877b96e365)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - b945e3ee-ec9b-422d-ae43-f2877b96e365

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(3f2e2983-cd3d-450f-8d93-46939d9ca289)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 3f2e2983-cd3d-450f-8d93-46939d9ca289

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(3e5e2328-0584-4575-893d-5d7c28471509)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 3e5e2328-0584-4575-893d-5d7c28471509

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a65b6927-8bdd-428f-b532-554330f15a26)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a65b6927-8bdd-428f-b532-554330f15a26

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a07c879f-9c98-49b3-875e-454584c5e11d)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a07c879f-9c98-49b3-875e-454584c5e11d

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a37abf97-d412-488e-9650-90c7a47e5367)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a37abf97-d412-488e-9650-90c7a47e5367

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(15e7b7cb-f3bc-4aad-bdbc-a34359db4722)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 15e7b7cb-f3bc-4aad-bdbc-a34359db4722

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a34643ee-101b-4e9c-91b5-ad1684adae45)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a34643ee-101b-4e9c-91b5-ad1684adae45

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(a262e493-a079-4446-9562-a9b729143d71)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - a262e493-a079-4446-9562-a9b729143d71

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(9ea662d0-f5ab-4d00-8f66-d160f09a6460)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 9ea662d0-f5ab-4d00-8f66-d160f09a6460

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(c38cee2d-d8b6-47c3-9a5e-f3255fbbc345)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - c38cee2d-d8b6-47c3-9a5e-f3255fbbc345

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(aa4a1867-f21c-408f-a0fb-26da1886106e)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - aa4a1867-f21c-408f-a0fb-26da1886106e

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: 18:04:27 - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'aaaaaaaa-bbbb-cccc-dddddddddddd', Scopes:'https://dev.azuresynapse.net/.default', AuthorityHost:'https://login.microsoftonline.com/', UserId
:'mysecret@email.com'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId: 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Found 3 cache accounts and 0 broker accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27] Returning 3 accounts
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] MSAL MSAL.Desktop with assembly version '4.30.1.0'. CorrelationId(0bb8b729-9acb-4a41-b822-cb226518c960)
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === AcquireTokenSilent Parameters ===
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] LoginHint provided: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Account provided: True
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] ForceRefresh: False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] 
=== Request Data ===
Authority Provided? - True
Scopes - https://dev.azuresynapse.net/.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 0bb8b729-9acb-4a41-b822-cb226518c960

DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition (SilentRequest) started:

    Authority Host: login.microsoftonline.com
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Azure region was not configured or could not be discovered. Not using a regional authority.
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Access token is not expired. Returning the found cache entry. [Current time (01/03/2023 17:04:27) - Expiration Time (01/03/2023 18:21:46 +00:00) - Extended Expirati
on Time (01/03/2023 18:21:46 +00:00)]
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Returning access token found in cache. RefreshOn exists ? False
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] Fetched access token from host login.microsoftonline.com. 
DEBUG: (False) MSAL 4.30.1.0 MSAL.Desktop Windows 10 Pro [01/03/2023 17:04:27 - ] === Token Acquisition finished successfully. An access token was returned with Expiration Time: 01/03/2023 18:21:46 +00:00 and Scopes https://dev.azuresynapse.net/u
ser_impersonation https://dev.azuresynapse.net/.default
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://dev.azuresynapse.net/.default ] ParentRequestId:  ExpiresOn: 2023-01-03T18:21:46.0000000+00:00
DEBUG: Request [3faf3af5-5a25-4da5-8164-a48bb2c800bf] GET https://xyz-we-a-saw-dp.dev.azuresynapse.net/pipelines?api-version=REDACTED
Accept:REDACTED
x-ms-client-request-id:REDACTED
x-ms-return-client-request-id:REDACTED
User-Agent:REDACTED
Authorization:REDACTED
client assembly: Azure.Analytics.Synapse.Artifacts
DEBUG: Response [3faf3af5-5a25-4da5-8164-a48bb2c800bf] 200 OK (00.2s)
Strict-Transport-Security:REDACTED
x-ms-request-id:REDACTED
x-ms-client-request-id:REDACTED
Date:REDACTED
Server:REDACTED
Content-Length:REDACTED
Content-Type:REDACTED

Get-AzSynapsePipeline : The requested operation requires an element of type 'String', but the target element has type 'Object'.
At line:1 char:1
+ Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp"
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : CloseError: (:) [Get-AzSynapsePipeline], InvalidOperationException
    + FullyQualifiedErrorId : Microsoft.Azure.Commands.Synapse.GetAzureSynapsePipeline

DEBUG: AzureQoSEvent: Module: Az.Synapse:1.1.0; CommandName: Get-AzSynapsePipeline; PSVersion: 5.1.19041.2364; IsSuccess: False; Duration: 00:00:00.5692572; Exception: The requested operation requires an element of type 'String', but the target e
lement has type 'Object'.;
DEBUG: Finish sending metric.
DEBUG: 18:04:27 - GetAzureSynapsePipeline end processing.

Environment data

Name                           Value                                                                                                                                                                                                                             
----                           -----                                                                                                                                                                                                                             
PSVersion                      5.1.17763.3770                                                                                                                                                                                                                    
PSEdition                      Desktop                                                                                                                                                                                                                           
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}                                                                                                                                                                                                           
BuildVersion                   10.0.17763.3770                                                                                                                                                                                                                   
CLRVersion                     4.0.30319.42000                                                                                                                                                                                                                   
WSManStackVersion              3.0                                                                                                                                                                                                                               
PSRemotingProtocolVersion      2.3                                                                                                                                                                                                                               
SerializationVersion           1.1.0.1

Module versions

Get-Module Az*

ModuleType Version    Name                                ExportedCommands                                                                                                                                                                                       
---------- -------    ----                                ----------------                                                                                                                                                                                       
Script     2.10.4     Az.Accounts                         {Add-AzEnvironment, Clear-AzConfig, Clear-AzContext, Clear-AzDefault...}                                                                                                                               
Script     2.2.0      Az.Synapse                          {Add-AzSynapseDataFlowDebugSessionPackage, Add-AzSynapseTriggerSubscription, Clear-AzSynapseSqlPoolVulnerabilityAssessmentRuleBaseline, Convert-AzSynapseSqlPoolVulnerabilityAssessmentScan...}

Error output

Get-AzSynapsePipeline : The requested operation requires an element of type 'String', but the target element has type 'Object'.
At line:17 char:1
+ Get-AzSynapsePipeline -WorkspaceName "xyz-we-a-saw-dp"
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : CloseError: (:) [Get-AzSynapsePipeline], InvalidOperationException
    + FullyQualifiedErrorId : Microsoft.Azure.Commands.Synapse.GetAzureSynapsePipeline
ghost commented 1 year ago

Thank you for your feedback. This has been routed to the support team for assistance.

PramodValavala-MSFT commented 1 year ago

@ssisjoost Thanks for the feedback! Looks like the issue is with the underlying .NET SDK used by the PowerShell cmdlet. We will share updates as we get this fixed.

ssisjoost commented 1 year ago

Solved. A hardcoded value from an activity property was accidentally put in the expression override. So the expresion contained a hardcoded text. Synapse did always ran succesfully and the hardcode text was just honered. Even the build was successful.

I just checked each single pipeline with the Get-AzSynapsePipeline -Name "xxxxxx" until I found one pipeline failing... removed it and then the Get-AzSynapsePipeline without the name filter ran succesful. After that just check every activity/property until I found the mistake.

MironAtHome commented 1 year ago

Can we hope for a fix. Like ever?

microsoft-github-policy-service[bot] commented 2 months ago

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @wonner, @v-yanjungao.