Cannot establish synapse link connection to azure sql db table (that was previously linked)

Frank Bluemke 1

I had a link connection in my synapse workspace to an azure sql db table. I discovered that the data had not been syncing for the last month (not sure why). as a troubleshooting step i stopped the link, deleted it and then tried to re create it. When i try to start the new link I get this error:There is no available source table that has been enabled successfully for Synapse Link. Continuous run ID: b67f5a88-268c-473b-8a2a-3de7e9dc12ff

I had this happen before and it just eventually went away but i really need to get this table synced tonight if posisble. Does anyone know work around?

PRADEEPCHEEKATLA-MSFT 85,746 Reputation points Microsoft Employee

2023-07-11T09:19:14.4233333+00:00
@Frank Bluemke - Thanks for the question and using MS Q&A platform.

The error message "There is no available source table that has been enabled successfully for Synapse Link" indicates that the Synapse Link service is unable to find a valid source table to link to. This could be due to a number of reasons, such as:

The source table has been deleted or renamed.

The source table has been modified in a way that is not compatible with Synapse Link.

The Synapse Link service is experiencing issues or is not configured correctly.

To troubleshoot this issue, you can try the following steps:

Verify that the source table exists and is accessible. You can do this by connecting to the Azure SQL Database using SQL Server Management Studio or Azure Data Studio, and checking that the table is present and contains data.

Check the compatibility of the source table with Synapse Link. Synapse Link requires that the source table meets certain requirements, such as having a primary key and being in a supported format. You can check the requirements in the Synapse Link documentation.

Check the configuration of the Synapse Link service. Make sure that the service is configured correctly and that there are no issues with the connection to the Azure SQL Database. You can check the service status and configuration in the Synapse workspace.

Try recreating the link again. If the issue persists, you can try deleting the Synapse workspace and recreating it from scratch. This will reset the Synapse Link service and may resolve any configuration issues.

If none of these steps resolve the issue, you may need to open a support ticket for further assistance.
Frank Bluemke 1 Reputation point

2023-07-11T13:48:05.2666667+00:00

Hello,

I have previously synced this table and no changes were made to it. I have tried a few times to re create a new link and it does not work. This happened previously with another table and it just self resolved so i Feel this is a bug when you stop a link and delete it.

I cannot delete the entire synapse workspace as it is our production environment!

I tried to create this link on our non production synapse workspace and it worked! How can i get this working on our production workspace?
Frank Bluemke 1 Reputation point

2023-07-11T13:48:53.8133333+00:00

Update, i was able to use my non prod synapse environment and it was able to start the link with no issues. But i need to get this working on our prod workspace. How can i fix?

I think the "bug" or issue happens when an existing link connection is stopped and deleted. It is like something is getting "stuck" in the workspace.
PRADEEPCHEEKATLA-MSFT 85,746 Reputation points Microsoft Employee

2023-07-13T06:54:42.9766667+00:00

@Frank Bluemke - Did you tried recreating the link again?
Frank Bluemke 1 Reputation point

2023-07-13T10:52:51.2366667+00:00

I recreated using sql server admin credentials vs the previous which was using managed identity and it’s now working. Still not clear why.
PRADEEPCHEEKATLA-MSFT 85,746 Reputation points Microsoft Employee

2023-07-14T06:24:45.28+00:00

@Frank Bluemke - I agree that this issue looks strange and I wasn't able to reproduce this issue. If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us?
PRADEEPCHEEKATLA-MSFT 85,746 Reputation points Microsoft Employee

2023-07-17T07:57:59.19+00:00

@Frank Bluemke - Did you get a chance to open a support ticket?

Share via

Cannot establish synapse link connection to azure sql db table (that was previously linked)