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

Aman Pahariya 0 Reputation points
2024-04-23T05:58:01.1533333+00:00

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=,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,711 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,126 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.

    1. 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.
    2. 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.
    3. 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.
    4. 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.