User configuration issue in copy data

Question

User configuration issue in copy data

Vijay Pimple 5

viewpoint_copy_test

Error code2010

Failure typeUser configuration issue

DetailsValue cannot be null. Parameter name: source

Activity ID75839ac7-f6f2-43ca-a77d-c10a79d00c5f

0 comments

1 answer

Your answer

Answer 1

Amira Bedhiafi 42,941 MVP Volunteer Moderator

From the error code it seems that you have an issue in the configuration of the Copy Data activity.

You need to verify if the source dataset is properly configured, including its linked service, parameters, and any dynamic values passed at runtime.

Validate that the dataset points to an accessible table, file, or query, and test the linked service connection for authentication or permission issues.

If parameters or variables are used, confirm they have valid runtime values. Use the Debug mode to inspect activity inputs and outputs, and verify that all required fields (like file paths, table names) are populated.

You can use the Activity ID in the Monitor section of the Azure portal to review detailed logs and pinpoint the issue.

Vijay Pimple 5 Reputation points

2025-01-15T22:10:45.7933333+00:00

I used preview data option in source and it is working fine. I can preview data. Validate also did not detect any issues.
Vijay Pimple 5 Reputation points

2025-01-15T22:11:53.6366667+00:00
Vijay Pimple 5 Reputation points

2025-01-15T22:13:12.17+00:00

I did not use any parameters. It is plain copy from source to target.
Ganesh Gurram 7,235 Reputation points Moderator

2025-01-16T13:04:31.54+00:00
Hi @Vijay Pimple
Thanks for the question and using MS Q&A platform.

Apologize for the inconvenience caused. Since the Preview data option works fine and the Validate did not detect any issues, but you're still encountering the error during execution, here are a few things to check:

Source Dataset Configuration at Runtime - Even though the preview works, ensure that the dataset is correctly referenced at runtime. Sometimes, issues arise if the source path or reference is dynamically resolved during execution, which may differ from the preview.

Check for Null or Missing Source Information - Although no parameters were used, there could still be a misconfiguration in the pipeline that causes the source to be null at runtime. Double-check the source configuration (file path, table name, etc.) to ensure everything is correctly set during execution.

Pipeline Debug Mode - Run the pipeline in Debug mode to inspect the inputs and outputs of the Copy Data activity and check if any fields are unexpectedly null during execution.

Activity ID Logs - You can also use the Activity ID (75839ac7-f6f2-43ca-a77d-c10a79d00c5f) in the Monitor section of Azure Data Factory to get more detailed logs, which can help pinpoint the issue.

For more details refer to this: Troubleshoot Azure Data Factory and Azure Synapse Analytics connectors

Configure the Copy File Activity

Hope this helps. Do let us know if you have any further queries.
Vijay Pimple 5 Reputation points

2025-01-16T15:34:52.3533333+00:00
The similar steps were given by chatgpt however it did not work.

for example - I did not find Pipeline Debug Mode - Run the pipeline in Debug mode

Source Path is not file it is database, and I can preview data??

Source Dataset Configuration at Runtime - Even though the preview works, ensure that the dataset is correctly referenced at runtime. Sometimes, issues arise if the source path or reference is dynamically resolved during execution, which may differ from the preview.
Ganesh Gurram 7,235 Reputation points Moderator

2025-01-16T17:21:11.19+00:00

@Vijay Pimple - I agree that this issue looks strange and I wasn't able to reproduce this issue. If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us?
Ganesh Gurram 7,235 Reputation points Moderator

2025-01-17T08:39:40.3133333+00:00

@Vijay Pimple - Did you get a chance to open a support ticket? The Azure support team will review your request and provide assistance as soon as possible Azure support.
Vijay Pimple 5 Reputation points

2025-01-21T16:53:52.9266667+00:00

Ranit G from Microsoft Support is looking into this issue.
Vijay Pimple 5 Reputation points

2025-01-21T16:54:54.9066667+00:00

Ranit G from Support team is looking into this issue.

Share via

User configuration issue in copy data

1 answer

Your answer