Azure Data Factory - Copy data activity failed: Failure happened on 'Source' side

Aman Pahariya 0

Operation on target Copy data1 failed: Failure happened on 'Source' side. ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The file operation is failed, upload file failed at path: 'smartbook/IBM_weather_Forcast_Actual_Comparison.csv'.,Source=Microsoft.DataTransfer.Common,''Type=System.Data.SqlClient.SqlException,Message=A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.),Source=.Net SqlClient Data Provider,SqlErrorNumber=121,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=121,State=0,Message=A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.),},],''Type=System.ComponentModel.Win32Exception,Message=The semaphore timeout period has expired,Source=,'

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-04-23T18:02:27.03+00:00

Hi Aman Pahariya, Could you please share more details on implementation side and configurations of source and sink in copy activity to understand issue better?
Aman Pahariya 0 Reputation points

2024-04-24T05:55:45.9733333+00:00

In the copy activity, the source is SQL Server, and the sink is an Azure SQL Database managed instance.
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-04-24T10:59:23.96+00:00
Hi Aman Pahariya,

It looks like there was a failure during the file upload operation in your data transfer process. The error message indicates that the semaphore timeout period has expired, which could be caused by a network issue or a problem with the server.

It may intermittent error also, could you please retry and see if that helps?

Also, is this copy activity use to work before?

You can give try below options.

Check your network connection: Make sure that your network connection is stable and that there are no issues with your internet service provider. You can try running a network diagnostic tool to identify any network issues.

Increase the timeout period: You can try increasing the timeout period for the file upload operation. This can be done by modifying the timeout settings in your data transfer process.

Check the server logs: Check the server logs to see if there are any errors or warnings that could be related to the file upload operation. This can help you identify the root cause of the issue.

Retry the operation: You can try retrying the file upload operation to see if the issue was a temporary one. If the issue persists, you may need to investigate further or contact support for assistance.
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2024-04-30T16:59:41.2866667+00:00

Hi Aman Pahariya, Just checking if you get chance to share updates? Thank you.