Error : 2200 in Copy activity

Question

I'm trying to copy data from Cosmos DB to Azure data explorer in Synapse analytics. While running the pipeline it's giving below error:

{
"errorCode": "2200",
"message": "'Type=System.Net.Http.HttpRequestException,Message=An error occurred while sending the request.,Source=mscorlib,''Type=System.Net.WebException,Message=The underlying connection was closed: An unexpected error occurred on a send.,Source=System,''Type=System.IO.IOException,Message=Authentication failed because the remote party has closed the transport stream.,Source=System,'",
"failureType": "UserError",
"target": "Copy Redlight Count",
"details": []
}

Can someone please help me to resolve this issue?

Thanks,
Divya Sahu

Answer 1

@Divya Sahu

I have got same error 2200. I tried to set up a pipeline to transfer data from sql server in vm to snowflake. and failed on first step; store the csv file into storage account by IntegrationRuntimeEngine...
And I had fixed the issue by 2 steps:

1. In storage account access management page, assign Storage blob data contributor role to Management Identity "Synapse service".
   
2. I found I forget to add "create" and "write" permission on storage account SAS ticket, and then I regenerated a new SAS, and updated the link service to the storage account in Synapse.
   

Finally, Succeed:
265838-image.png