question

DougR-8182 avatar image
0 Votes"
DougR-8182 asked CarrieKroutil-9243 answered

Error when trying to copy data

We regularly get an error even though I have checked the source data and it all aligns. I have also checked the column mapping and appears correct;

Error code
2200

Failure type
User configuration issue

Details
ErrorCode=UserErrorInvalidColumnMappingColumnNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'Activity ID' specified in column mapping cannot be found in source data.,Source=Microsoft.DataTransfer.ClientLibrary,

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered

Hello @DougR-8182 ,
Thanks for the ask .

Is it always this columns which complains ? Do you have another column which has space in between ?

Thanks
Himanshu

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello ,
We have not heard back from you on this and was just following up .
Incase if you have resolution , request you to share the same here , so that other community members can benefit from that .
Thanks
Himanshu

0 Votes 0 ·

Hello ,
We have not heard back from you on this and was just following up .
Incase if you have resolution , request you to share the same here , so that other community members can benefit from that .
Thanks
Himanshu

0 Votes 0 ·
CarrieKroutil-9243 avatar image
0 Votes"
CarrieKroutil-9243 answered

I am also experiencing this issue, always for the same column and if I preview the data before performing the steps to solve the issue, the column is missing from the preview.

When I clear the already mapped columns which look correct, import schema, and then the preview data again it will show up and the pipeline runs successfully again.

Note, I am using parameterized connections and the underlying database being pointed to can change, but the SQL table structure stays the same. The issue seems to crop up after switching environments and remapping again fixes.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.