Error : 2200 in Copy activity

Question

Error : 2200 in Copy activity

Divya Sahu 21

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

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-09T09:59:11.38+00:00

Hello @Divya Sahu ,

Thanks for the question and using MS Q&A platform.

As per the error message it looks like "Authentication failed because the remote party has closed the transport stream", could you please check the source connection and try to test the connection?

Please do share the authentication method used for connecting the source?
Divya Sahu 21 Reputation points

2022-03-09T10:40:43.027+00:00

@PRADEEPCHEEKATLA I tried testing the source connection and it looks good.

"Account key" authentication method was used in linked service.
PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-11T03:55:43.06+00:00

Hello @Divya Sahu ,

Thanks for the additional details. Could you please share the configuration firewall details in Azure Cosmos DB?
PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-14T10:18:46.117+00:00

Hello @Divya Sahu ,

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.

Accepted answer

0 additional answers

Your answer

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-09T09:59:11.38+00:00

Hello @Divya Sahu ,

Thanks for the question and using MS Q&A platform.

As per the error message it looks like "Authentication failed because the remote party has closed the transport stream", could you please check the source connection and try to test the connection?

Please do share the authentication method used for connecting the source?
Divya Sahu 21 Reputation points

2022-03-09T10:40:43.027+00:00

@PRADEEPCHEEKATLA I tried testing the source connection and it looks good.

"Account key" authentication method was used in linked service.
PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-11T03:55:43.06+00:00

Hello @Divya Sahu ,

Thanks for the additional details. Could you please share the configuration firewall details in Azure Cosmos DB?
PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-14T10:18:46.117+00:00

Hello @Divya Sahu ,

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.

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:

In storage account access management page, assign Storage blob data contributor role to Management Identity "Synapse service".
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

Share via

Error : 2200 in Copy activity

0 additional answers

Your answer