While using a copy data activity, I get InvalidParameter error

Question

While using a copy data activity, I get InvalidParameter error

Anonymous

I get this error message in a copy data activity. The pipeline was working fine. Not sure what changed. I do not see any changes. Checked source and sink for the activity but I did not mention any parameters. Still, I see the below error message.

ErrorCode=InvalidParameter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The value of the property 'properties' is invalid: 'Value cannot be null. Parameter name: properties'.,Source=,''Type=System.ArgumentNullException,Message=Value cannot be null. Parameter name: properties,Source=Microsoft.DataTransfer.DataContracts,'

SSingh-MSFT 16,371 Reputation points Moderator

2023-02-20T06:40:17.2333333+00:00

Hi @Daxesh Radadiya ,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Jeff Stoker 5 Reputation points Microsoft Employee

2023-02-21T15:46:27.2366667+00:00

I also encountered this exact issue on a previously functioning copy data task.

I found I needed to go to the User Properties tab and click 'auto generate' for properties. Once I did that, the ETL could run successfully.

FYI @SSingh-MSFT
SSingh-MSFT 16,371 Reputation points Moderator

2023-02-23T12:57:55.5833333+00:00

Hi Jeff Stoker (Decisive Data),

Thanks for sharing the solution opted in your case.

Hi @Daxesh Radadiya ,

Could you please let us know if you are still facing the issue so that we can further look into this.

Thanks

1 answer

Your answer

SSingh-MSFT 16,371 Reputation points Moderator

2023-02-20T06:40:17.2333333+00:00

Hi @Daxesh Radadiya ,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Jeff Stoker 5 Reputation points Microsoft Employee

2023-02-21T15:46:27.2366667+00:00

I also encountered this exact issue on a previously functioning copy data task.

I found I needed to go to the User Properties tab and click 'auto generate' for properties. Once I did that, the ETL could run successfully.

FYI @SSingh-MSFT
SSingh-MSFT 16,371 Reputation points Moderator

2023-02-23T12:57:55.5833333+00:00

Hi Jeff Stoker (Decisive Data),

Thanks for sharing the solution opted in your case.

Hi @Daxesh Radadiya ,

Could you please let us know if you are still facing the issue so that we can further look into this.

Thanks

Answer 1

Hi @Anonymous ,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand from the question, you have started getting Error in Pipeline which involves Copy Activity when it has been working fine before.

In order to troubleshoot, could you please do the following:

1). Check if the Source=Microsoft.DataTransfer.DataContracts, is accessible?

Could you check if you can connect in ADF through the Linked Service and Dataset.

Even if this shows success, could you also please check the directory/folder is correctly pointed.

2). Secondly, try to clear data schema of source dataset.

3). Again, import schema, clear Mapping in Copy setting, import schema on Mapping of Copy.

Please try and let us know if this helps.

If not, please share more details about the pipeline configuration which will help us in reproducing the issue and investigate.

Thank you.

Share via

While using a copy data activity, I get InvalidParameter error

1 answer

Your answer