question

TerrenceRideauAmericas-6167 avatar image
0 Votes"
TerrenceRideauAmericas-6167 asked ·

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

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
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered ·

Hello @TerrenceRideauAmericas-6167,

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.


image.png (69.3 KiB)
· 3
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for the response and the troubleshooting link.

I did try a refresh and I also recreated the SQL Pool but I had the same issue. After an hour it seemed to have resolved itself. So it was probably an intermittent issue.

1 Vote 1 ·

Hello @TerrenceRideauAmericas-6167,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @TerrenceRideauAmericas-6167,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

0 Votes 0 ·