5,653 questions with Azure Synapse Analytics tags
linked service connectivity issues in Azure Synapse Studio
Hi Team, We are not able to test connection when Key vault link service checking that time gating error as mentions below.
We are observing an issue with our Synapse Spark pool where both streaming and batch jobs are getting stuck and not making progress.
Streaming jobs: Jobs continue running beyond configured --running-duration-seconds (9600) No observable progress during this period Jobs do not self-recover, restarting Spark node pool fixes the issue Batch jobs: Python batch jobs are timing…
one of the pipeline is failing while saving the data back with spark context was closed
I am getting an error saying spark context was closed , it's taking an hour to run the pipeline and then it's failing because the spark context was closed . I am attaching the screenshot of the error and also the link to the logs : …
Changelog folder created by Synapse Link
Hi, Synapse Link is writing timestamped folders to Blob Storage from D365 as expected. The documentation states that consumers should not process the folder currently referenced in the changelog file. I would like to clarify the behavior of files within…
EntitySyncFailure: Could not find stored procedure SP_CDSVirtualEntityGetPageRangesV2 for Synapse Link for Dataverse D365FO
Our team was able to create Synapse Link for Dataverse D365FO select tables to sync. However now I have noticed all the tables are empty in synaspe workspace and the EntitySyncFailure folder is populated with logs of each entity having a message similar…
Synapse Pipeline and Spark Job Delays across West US2 and East US2, from 5/28 11PM to 5/29 1AM
Hi Synapse supporting: We found large amount of pipeline runs and spark jobs created from 5/28 11PM to 5/29 1AM were stuck for 6 to 24 hours. These jobs resumed randomly after long delays. This issue happened across all of our Synapse workspaces in…
Synapse Link: Changing Incremental Update Folder Structure time interval Azure Synapse Link
Hello, I have a synapse link to put data from D365 F n O to blob storage. The time interval for the folder structure was previously 60 minutes and I changed it to 720 minutes in the existing synapse link (no other changes, same container, tables not…
Azure Synapse Missing Theme In Settings
Hi, I am new to Azure and had the opportunity to adjust Microsoft products themes to Dark Mode. I was unable to change such theme in Azure Synapse as the option is missing. Looking on the internet there is a Theme option that should be present up top the…
System-managed MPE 'synapse-ws-sqlOnDemand--<workspace>' stuck in Rejected state
Environment Azure Synapse Analytics workspace (serverless SQL pool only — no dedicated SQL pool) Managed Virtual Network: Enabled Data Exfiltration Protection (DEP): Enabled Public network access: Disabled Region: Central US Problem The…
Does Microsoft give option to create new Ticket ?
How to generate new ticket in Azure portal? It was available earlier but now Microsoft is redirecting to documents or other Q&A pages and not letting me create new ticket.
Synapse workspace stuck in Failed provisioning state ; preserve existing artifacts (no delete)
Issue summary Synapse workspace entered Failed provisioning state after a workspace write operation failed. Subsequent update attempts fail with: ValidationFailed WorkspaceInNonTerminalState Workspace is in non-terminal state Failed and cannot…
synapse: tumbling trigger stopped firing
starting today, between 6am~ongoing, tumbling trigger stopped firing. even after recreating the trigger, it does not fire.currently manually triggered to unblock icm, but this won't last long. this blocked production job.
How can I update Synapse Workspace's Azure SQL Auditing connection to Storage Account to use Managed Identity
Hello, I am attempting to update the Azure SQL Auditing connection to use Managed Identity instead of Storage Access Key. Following the documentation online, when I'm in the Azure SQL Auditing settings I should see both an option for Managed Identity and…
Transition Azure Synapse Analytics workspaces to private links before 1 August 2026
We have a few questions regarding the Synapse transition to private links: Identifying impacted workspaces What is the recommended approach to identify which Synapse workspaces or environments are actually impacted? Customers are receiving the…
mssparkutils.credentials.getToken() does not support CognitiveServices or AIServices audience aliases — no way to acquire SAMI token for Azure OpenAI or Azure AI Foundry from Spark notebook.
We are migrating Synapse Spark pipeline authentication from certificate-based Service Principal to workspace System-Assigned Managed Identity (SAMI) to comply with SFI. The SAMI has been granted the required RBAC roles (Cognitive Services OpenAI…
Join: Microsoft Azure Q&A Champions Program
The Microsoft Azure Q&A Champions Program recognizes and empowers a global community of internal and external Azure experts who help customers succeed by providing high-quality, trusted answers on Microsoft Q&A. The program scales expert led…
AI answer
Synapse dedicated SQL pool external table failure with COPY schema discovery error after restart
Hello, We encountered an issue where external Parquet-based tables in a dedicated SQL pool started failing with the following error: COPY statement input file schema discovery failed: Cannot process the file https://
Unable to list or secret certificate in Azure Synapse Linked service
Hi Team, We have a linked service to Azure Key Vault and used 'User-assigned managed identity' as Authentication Method. Also, we have another linked service to Azure SQL Database and used this Key Vault linked service. When we test the connection, we…
Request assistance to validate Service Health Activity Log Alert for BCDR automation
We have implemented an automated BCDR mechanism for our Azure Synapse Analytics workloads. The solution uses an Activity Log Alert (type: microsoft.insights/activityLogAlerts) configured to fire when a Service Health incident is reported for Azure…
Error details Error details ResourceInUnupdatableState Target Spark pool specified in Spark job definition is not in succeeded state. Current state: Provisioning
Was doing deployment of spark spool thorugh CICD for synapse. Failure happened and keep saying the spool is in Provisioning state