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,444 questions
Azure Synapse Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 50%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Alexandr Brailean
6
Reputation points
Hi everyone! I used Metada Driven toll from Azure Synapse Analytics in order to build my pipeline. It works perfectly fine, but onse in while I am getting this error msg.
{
"errorCode": "2200",
"message": "ErrorCode=SqlConnectionIsClosed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The connection is closed by SQL Database.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.InvalidOperationException,Message=ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.,Source=System.Data,'",
"failureType": "UserError",
"target": "FullLoadOneObject",
"details": []
}
{count} vote
-
PRADEEPCHEEKATLA-MSFT 78,986 Reputation points Microsoft Employee2022-06-23T06:22:09.41+00:00 Hello @Alexandr Brailean ,
Thanks for the question and using MS Q&A platform.
Could you please share the below details to understand the issue further:
- Source services which you are trying to connect?
- Have you tried again to run the pipeline and see if you are facing same issue?
Looking forward for your response.
-
PRADEEPCHEEKATLA-MSFT 78,986 Reputation points Microsoft Employee
2022-06-30T09:47:56.037+00:00 Hello @Alexandr Brailean ,
Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 77%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sarsambi, Sanjaya Shivasharanappa (Cognizant) 0 Reputation points2024-05-07T13:27:36.2+00:00 Azure synapse pipelines (multiple) fails occasionally with the below error. In the next run all pipelines would be successful.
"ErrorCode=SqlConnectionIsClosed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The connection is closed by SQL Database.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.InvalidOperationException,Message=ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.,Source=System.Data,'.
Sign in to comment