Azure Synapse Analytics

Unable to Start Apache Spark Pool. Fails with SessionCreationTimeoutException: Session creation timed out.

When I run a pipeline, it fails with ]Cluster was in terminal state=[Cancelled] before it reached 'Ready' state. When I run a new notebook, it fails with SessionCreationTimeoutException: Session creation timed out. I am on Spark version 3.5

Hi, I recently created an Azure Synapse workspace and was attempting to run a simple SQL query using the built-in serverless SQL pool. However, I encountered an issue where the built-in serverless SQL pool is displays internal error and is unavailable

How long does it take to get approved for a SQL database server

I submitted a support ticket a while ago to get access to have an SQL database server in US EAST. It feels impossible to reach out to someone who can tell me how far along the request is and if I will get approved. I'd like to know if anyone else has…

Workspace creation problem, stopped my progress.

I'm on a student subscription, and I'm doing a Microsoft course, "Machine Learning Operations Engineer Associate." For this I have to create a workspace, but I'm not able to create one in any region. This issue is preventing me from progressing…

Azure Synapse Studio shows 403 Forbidden for all workspace artifacts despite Subscription Owner access

I have an Azure Synapse Workspace named "sansynapsews". Issue: Synapse Studio launches successfully, but almost all workspace artifacts fail to load with: "Failed to load one or more resources due to forbidden issue, error code…

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…

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.

Azure Synapse Spark Pool: Executor added mid-execution fails to acquire token, causing job failure

Environment Details: Workspace: hasonorthcentralus75c63383c7cd32ae1209 Region: North Central US Spark Pool / Livy: SparkV35-987 (Spark 3.5) Application ID: application_1782261914206_0001 First Trace ID: 249853a3-7ea9-4e79-95f4-b7e4813aa950 Issue…

Action Required – Synapse Spark Pool error

We have enabled synpase link of dataverse which ahs stopped syncing since 16 and we are getting below error. We have identified an issue with the Synapse Spark diagnostic emitter configuration, which is impacting the logging for the…

Trying to connect to DataBricks to pull data into Azure Synapse

I'm trying to connect to a third party application's data (we use the app - it's our data). I'm able to connect and pull this into Power BI using the DataBricks connector. I access it using a provided URL to their Delta Sharing Server and I have a bearer…

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…

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…

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…