Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
How to fix error Failed to import source schema. Sequence contains no matching element in Azure Data Factory
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 40%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kaz
0
Reputation points
Hi everyone,
I encountered an error when importing schemas in Copy Activity in Azure Data Factory. I am trying to get the converted value from Salesforce and load it into Azure SQL Database using Copy Activity. I have done this many times before, but after updating to the new connector for Copy Activity, which supports OAuth authentication on Bulk API 2.0 for both source and sink, I got the error Failed to import source schema. Sequence contains no matching element. I tried calling the query using Bulk API 2.0 via Postman, and the Postman returned the result I wanted. I believe there may be a bug in the update. Has anyone else encountered this issue and solved it? Any help would be appreciated!
Here are the steps I followed:
I put this query SELECT convertCurrency(Amount) Amount_Converted From Opportunity at the Source tab (see Image 1).
At the Sink tab (see Image 2), I created a table named Opportunity with a column Amount_Converted.
At the Mapping tab (see Image 3), I clicked the button Import Schemas and received the error Failed to import source schema. Sequence contains no matching element.
Image 1
Image 2
Image 3
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator2024-02-22T19:50:42.51+00:00 Hello Kaz,
In general, this error will occur when the column mapping in the Copy Activity does not match columns in the source or destination. Can you try to re-import the schema in the Copy Activity and see if it helps?
and can you click on Preview data on the salesforce source (1st screenshot) and see if you are getting any error?
-
Kaz 0 Reputation points
2024-02-23T06:09:39.0966667+00:00 Hello @Bhargava-MSFT ,
Thank you for your reply. I have clicked on preview data and got the same error.
-
Kaz 0 Reputation points
2024-02-23T07:43:30.1+00:00 Hi @Bhargava-MSFT ,
Thank you for your reply. I have clicked the preview data and got the same error. And I cannot still import schemas. I guess it is because the SOQL Query on the Source tab doesn't execute the query successfully, and then there is no data for previewing and mapping data. But, weirdly, why is the query not executed successfully?
-
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
2024-02-26T20:51:25.4633333+00:00 Kaz ,
from your error message at the source end, it seems like there is an issue with the SOQL query that you are using to retrieve the data from Salesforce.
Can you please try running the query in Salesforce to verify that it returns the expected results.
also check that the credentials you are using to connect to Salesforce are correct and have the necessary permissions to retrieve the data.
Sign in to comment
Sign in to answer