Forum Discussion
Data Warehouse is inaccessible overnight
Hi All,
Documenting my issue here in hopes of anyone offering a possible solution or me sharing a solution if Microsoft can assist. I've already submitted a ticket (TrackingID#2405160010002716) with them.
The problem I'm having is in a "Premium Capacity" workspace. There are dataflow gen2, semantic model, lakehouse, and warehouse objects in the workspace. Starting yesterday morning, My warehouse has unable to "start" and I am unable to query or view tables in the warehouse web/local application. The issue seems to be isolated to this specific workspace as I am able to view data warehouses in other workspaces. Also, the lakehouse tables are viewable (at the moment).
The various errors I have received are an infinite "Loading" screen (30 min+), error pop-up "We couldn't get your warehouse's updated schema", error pop-up "Internal error, we failed while handling this action: [Datamart Model] Load datamart schema failed.
When using the developer tools to track the network activity, it was failing on the "authentication" step.
As mentioned, I've escalated the issue with Microsoft support, but if anyone has had the issue before or can offer suggestions I'm open to anything at this point.
Thanks,
The workspace "self-healed" itself after about 48 hours from the initial issue. No explanation of what caused the problem or how it was resolved.
7 Replies
Hi coverturfLSH ,
Thanks for using Fabric Community and sharing the Support ticket Number.
Please allow some time, so team can check and provide a resolution.
In case if you got a resolution please do share with the community as it can be helpful to others .
The workspace "self-healed" itself after about 48 hours from the initial issue. No explanation of what caused the problem or how it was resolved.
coverturfLSH , I have the same issue.
It all started after the may 2024 update. For me, after 48 hours, it is still an issue. Can you explain how you submitted the ticket? Maybe that ticket has gave someone a headsup to fix something. Which I need now 😛Hi Anonymous,
In PowerBI, there's a help & support icon in the upper right. Then select "Get Help". That will take you to this webpage https://support.fabric.microsoft.com/en-US/support.
On the support page, I selected "Synapse Data Warehouse > Get Support"
Type in a description of your problem. Then select the "Support" tab at the top.
Best of luck, as of right now still no explanation of what caused the issue and what fixed it. I am curious though, have you been running "Notebooks" in the workspace that has the warehouse failure?
Thanks coverturfLSH , I was able to submit a ticket on Monday. So far issue is not resolved by Microsoft Unified Support.
And answer to your question regarding to using notebook in the workspace. Yes, I do.
