Hi,
We cannot preview tables in a direct Azure SQL Server connection using Active Directory Password authentication. The connection fails on the first attempt with a MSAL4J library loading error, though syncs succeed on retry.
Environment Details -
-
Data Source Type: Azure SQL Server (Direct Connection)
-
Authentication Method: Active Directory Password
Problem Description
Symptoms - Unable to preview any tables in the data connection - Sync operations fail on first attempt with the MSAL4J error - Syncs succeed on second attempt (retry), indicating intermittent/transient nature - Error occurs during the getTables operation
Error Details
• ServiceException: INVALID_ARGUMENT (MagritteExplorer:SqlError)
• Reason: Failed to load MSAL4J Java library for performing ActiveDirectoryPassword authentication
• The error originates in the JDBC exploration layer: JdbcExplorationRunner.getTables() MagritteExplorerErrors.sqlError()
Impact - Data preview functionality is blocked - Sync jobs require manual retry to succeed - Impacts data ingestion workflow reliability
Expected Behaviour
-
Table preview should work on first attempt
-
Sync jobs should succeed consistently without requiring retry
-
Active Directory Password authentication should load MSAL4J library without error
Additional Information
• Full error stack trace and diagnostic output are attached
• The issue affects both data preview and sync operations
• The retry-success pattern suggests a potential race condition or resource initialization issue
Questions for Support
-
Is this a known issue with MSAL4J library availability in the Foundry runtime?
-
Are there specific configurations or dependencies required for Azure SQL Server AD authentication?
-
Why do syncs succeed on retry if the library is genuinely unavailable? - Is there a resource initialization or connection pooling issue causing transient failures?