Error code 2200 Unable to connect to remote server

Question

Can anyone help with this error? It happens intermittently in Synapse Studio (more often than not) on a Copy activity using a REST API { "errorCode": "2200", "message": "Failure happened on 'Source' side. ErrorCode=RestResourceReadFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Fail to read from REST resource.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.Http.HttpRequestException,Message=An error occurred while sending the request.,Source=mscorlib,''Type=System.Net.WebException,Message=Unable to connect to the remote server,Source=System,''Type=System.Net.Sockets.SocketException,Message=A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 184.29.168.39:443,Source=System,'", "failureType": "UserError", "target": "CopyNote", "details": [] }

Answer 1

Hello Glenda and welcome to Microsoft Q&A.

Given you get this error intermittently, and the details of the error message, I think you should check the status of whatever service you are connecting to.

It sounds like the (non-Azure) server is under such a heavy load, it is either unable to respond, or is too slow to respond.

Another thing to try, is increasing the retry options on your Copy activity. Since the issue is intermittent, the next attempt might work.