This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(118.4, 7.000000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
I was trying to load data from Dynamics 365 Sales to MS-SQL using Using Azure Data Factory Copy data tool, Metadata-driven copy task. The type of load I am using is Delta Load/Incremental Load.
Facing this issue:
Failure happened on 'Source' side. ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: DynamicsOperationFailed, error message: The Fetch Xml query specified is invalid..,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,''Type=System.Xml.XmlException,Message=Data at the root level is invalid. Line 1, position 1.,Source=System.Xml,'
The error The Fetch Xml query specified is invalid indicates that the fetch query is invalid.
Hi,
Thank you for your prompt response and for sharing the link on constructing Fetch XML queries. I've reviewed the information, and while it's insightful, I wanted to clarify that my scenario involves using the Azure Data Factory Copy Data tool with the Metadata-driven copy task feature.
The Fetch XML query I'm working with is automatically generated by Azure Data Factory, and here is a snippet of the generated query:
<fetch>
<entity name="@{json(item().SourceObjectSettings).entityName}">
<all-attributes />
<filter type="and">
<condition attribute ="@{json(item().DataLoadingBehaviorSettings).watermarkColumnName}" operator="between">
<value>undefined</value>
<value>undefined</value>
</condition>
</filter>
</entity>
</fetch>
I'm encountering the "The Fetch Xml query specified is invalid" error, and it seems to be related to the automatically generated XML. Do you have any insights or suggestions on troubleshooting issues specifically with the Azure Data Factory Metadata-driven copy task?
Your assistance is highly appreciated!
Verify if the dynamic expressions used (@{json(item().SourceObjectSettings).entityName} and @{json(item().DataLoadingBehaviorSettings).watermarkColumnName}) are correctly formatted and that they reference existing parameters or variables in your ADF pipeline. The undefined values suggest that these expressions might be referencing non-existent or null values.
Hi Advait Bhujbal,
Just checking if above answer helps. if yes, please consider hitting Accept Answer button. Accepted answers help community as well. Thank you.
Hi Advait Bhujbal,
Thank you for posting query in Microsoft Q&A Platform.
The error message you are receiving indicates that the FetchXML query specified in the Dynamics 365 Sales source is invalid. This error can occur if the FetchXML query is not properly formatted or if it contains invalid characters.
To resolve this issue, you can try the following steps:
Check the FetchXML query. Make sure that the FetchXML query is properly formatted and that it does not contain any invalid characters. You can use the FetchXML Builder tool in Dynamics 365 Sales to create and test the FetchXML query.
Check the connection to Dynamics 365 Sales. Make sure that the connection to Dynamics 365 Sales is properly configured and that you have the necessary permissions to access the data.
Check the metadata-driven copy task. Make sure that the metadata-driven copy task is properly configured and that it is using the correct FetchXML query.
Check the data type mapping. Make sure that the data type mapping between Dynamics 365 Sales and MS-SQL is correct and that it can handle the data being transferred.
Check the incremental load settings. Make sure that the incremental load settings are properly configured and that they are using the correct FetchXML query.
If none of the above steps resolve the issue, you can try to recreate the metadata-driven copy task or contact Microsoft support for further assistance.
Hi Advait Bhujbal, Just checking if above answer helps. If yes, please consider hitting Accept Answer button. Accepted answers help community as well. Please let me know if any further queries. Thank you.
Hello @Advait Bhujbal
To resolve this issue, you need to fix the error in the Fetch XML query. You can refer to the Dynamics 365 Sales documentation to learn more about how to create a valid Fetch XML query.