Copy data activity was failed

Question

{
    "errorCode": "2200",
    "message": "ErrorCode=UserErrorFailedFileOperation,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The file operation is failed, upload file failed at path: 'logs/Recon KEPL/8db7dce1-5f78-4625-8a7c-d0415480191a/SynapseImportCommand/ITC reco April-21.xlsx.txt'.,Source=Microsoft.DataTransfer.Common,''Type=System.ArgumentException,Message=Not a legal OleAut date.,Source=mscorlib,'",
    "failureType": "UserError",
    "target": "Copy data1",
    "details": []

Answer 1

Hey @Kothapalli Srinivasarao ,

The error message indicates that the copy data activity failed due to a file operation error. The specific error is that the file upload failed at the path logs/Recon KEPL/8db7dce1-5f78-4625-8a7c-d0415480191a/SynapseImportCommand/ITC reco April-21.xlsx.txt.

There are a few possible reasons why the file upload might have failed. One possibility is that the file does not exist. Another possibility is that the file is too large to upload. Finally, it is also possible that there is a permissions issue that is preventing the file from being uploaded.

To troubleshoot the issue, you can try the following steps:

1. Check to make sure that the file exists.
2. Check the file size to make sure that it is not too large to upload.
3. Verify that you have the necessary permissions to upload the file.

Please provide your pipeline JSON for reference if possible.

Answer 2

Hi
Kothapalli Srinivasarao •,

Thanks for the screenshots.

Could you please let us know if Azure Synapse Analytics workspace is created with Managed Identity authentication?

If yes, please refer to this https://learn.microsoft.com/en-us/answers/questions/361154/synapse-analytics-copy-activity-sink-dedicated-sql.

Also, please let us know if Staging/Logging is enabled in Copy Activity? Make sure the path given is not the same as Source/Target dataset.

Please check the data inside the excel for the Date column if it is in correct format

Kindly check and let us know. Thanks