Azure Synapse fails to load Lake Databases (500 error)

Timothy Dufrane 45 Reputation points
2024-06-11T20:11:33.8566667+00:00

When loading a Synapse workspace, it sits at "loading resources" for awhile and eventually errors with a 500 for lake databases.

User's image

User's image

User's image

The error is not particularly helpful. Any ideas on how I could potentially determine if it's a single data lake connection at fault or if that's even a possible root cause?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,916 questions
{count} votes

Accepted answer
  1. Harishga 5,990 Reputation points Microsoft Vendor
    2024-06-13T16:09:19.7766667+00:00

    Hi @Timothy Dufrane
    I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

    ASK
    When loading a Synapse workspace, it sits at "loading resources" for awhile and eventually errors with a 500 for lake databases.
    User's image

    User's image

    User's image

    The error is not particularly helpful. Any ideas on how I could potentially determine if it's a single data lake connection at fault or if that's even a possible root cause?

    Solution:
    This resolved itself without any action on our part, so I'll assume it was a Microsoft issue.

    If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

    I hope this helps!

    If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.