Forum Discussion

coverturfLSH's avatar
coverturfLSH
Icon for Resolver II rankResolver II
2 years ago
Solved

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.