Error when trying to copy data

Christopher Aghassi 11

I am getting this error even though I have checked the source data and the column is there. {
"errorCode": "2200",
"message": "Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidColumnMappingColumnNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'first_name' specified in column mapping cannot be found in source data.,Source=Microsoft.DataTransfer.ClientLibrary,'",
"failureType": "UserError",
"target": "Patient Data",
"details": []
}

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2020-10-02T06:24:10.69+00:00

Hi @Christopher Aghassi ,

Welcome to Microsoft Q&A platform and thank you for your query.

Are you doing explicit mapping (Import Schemas in Mapping section of Copy) or auto mapping from source to sink? If you are doing auto mapping, could you please try explicit mapping by clicking import schemas in Mapping section of your copy activity. Please see below GIF.

Hope this helps. Let us know how it goes. In case if the issue still persists, could you please share failed pipeline and activity runID's for further investigation.

Looking forward to your confirmation.
Christopher Aghassi 11 Reputation points

2020-10-05T15:24:39.243+00:00

Still getting the same error.

Here are the details.

Pipeline ID: 0a3f1a92-e226-4db5-8b9c-7b7336e4c7c0
Run ID: 908c5e63-b88e-4603-a2d6-ed3e8d9c54b5
Christopher Aghassi 11 Reputation points

2020-10-05T15:25:04.787+00:00

@KranthiPakala-MSFT
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2020-10-07T00:58:25.793+00:00
Hi @Christopher Aghassi , Thanks for your response. In default/auto mapping, copy activity maps source data to sink by column names in case-sensitive manner. But it is strange as your are seeing this error even for explicit mapping. One additional verification we can do is:

Clear your data schema in your source dataset

Import schema in your source dataset

Clear your mapping in your copy settings

Import schemas on mapping of copy

Now copy paste the errored column name from source file, import schema of your dataset and column name from mapping of copy are exactly same.

Please let me know how this goes.
Looking forward to your response.

Thank you
Obadeji Adedamola 1 Reputation point

2021-01-20T15:46:11.167+00:00

Good day,

i have a similar problem too and have i gone through your reply to help solve my problem but i am working with sharepoint list as the source data and cant find schema for it thereby giving me issues during the debugging to copy to synapse studio

Thanks!

1 answer

Christopher Aghassi 11 Reputation points

2020-10-19T15:42:57.093+00:00

That worked!! Thank you! Last question for you. I have a serverless SQL server which takes time to turn on from the first time it is queried. What can I do in the pipeline to turn on the server?
Please sign in to rate this answer.

0 comments No comments
Sign in to comment