Azure Synapse Error

Question

Azure Synapse Error

Alexandr Brailean 6

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": []
}

PRADEEPCHEEKATLA 91,866 Reputation points

2022-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 91,866 Reputation points

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.
Sarsambi, Sanjaya Shivasharanappa (Cognizant) 0 Reputation points

2024-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,'.