Share via

Synapse Built-in SQL Pool not available with "internal error" after Workspace creation. 1hour later it was online?

Terrence Rideau (Americas) 1 Reputation point
2021-06-13T16:34:09.557+00:00

I created a Synapse Workspace based on Quickstart steps. Built-in SQL pool was not available due to internal error. I researched the issue (Azure, Stack Overflow) but could not find a resolution. After an hour or so it was online. How do I find out what was wrong?

I looked at Azure Service Status and did not see any outages or service interruptions.

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.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA 91,496 Reputation points Moderator
    2021-06-14T09:33:17.627+00:00

    Hello @Terrence Rideau (Americas) ,

    Welcome to Microsoft Q&A platform.

    It could an intermittent issue.

    Mostly this error message will be resolved after refreshing the SQL pools from management tab.

    105308-image.png

    In case the refresh does not resolve the issue, you need to file a support ticket for deeper investigation and immediate assistance on this issue.

    For more details, refer Synapse Studio troubleshooting.

    Hope this helps. Do let us know if you any further queries.

    ------------

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

Your answer

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