A community member has associated this post with a similar question:
How to resolve invalid property name error in ADF copy activity?

Only moderators can edit this content.

How to resolve invalid property name error in Azure Data Factory copy data activity?

Mansi Yadav 40 Reputation points
2024-05-19T09:21:06.6+00:00

ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'BadRequest'. Account: 'rmsdatalakestracc1mqa'. FileSystem: 'rmsadlscontainer'. Path: 'sharepoint/documents/RMS-MMY/ITBS-Apps/Unique User Experiences – Leading US Based Credit.pdf'. ErrorCode: 'InvalidPropertyName'. Message: 'The property name contains invalid characters.'. RequestId: '71491bd1-201f-0048-74c2-88e256000000'. TimeStamp: 'Sun, 07 Apr 2024 08:05:53 GMT'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.Azure.Storage.Data.Models.ErrorSchemaException,Message=Operation returned an invalid status code 'BadRequest',Source=Microsoft.DataTransfer.ClientLibrary,'

I'm getting above error while copying files from sharepoint using copy data activity in ADF. In sink I have defined some metadata also associated with that file like title, author, modified date, etc. But I'm facing above error and it's blocking other activities to run due to copy activity failure. I have also tried to replace -, spaces in file name but it didn't worked. Please help me to resolve this issue.

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