Skip to content

Files

Latest commit

jonburcheljonburchel
Add link to top level page to each connector page
Oct 1, 2021
ec1a49b · Oct 1, 2021

History

History
65 lines (40 loc) · 2.56 KB

connector-troubleshoot-xml.md

File metadata and controls

65 lines (40 loc) · 2.56 KB
title titleSuffix description author ms.service ms.subservice ms.topic ms.date ms.author ms.custom
Troubleshoot the XML format connector
Azure Data Factory & Azure Synapse
Learn how to troubleshoot issues with the XML format connector in Azure Data Factory and Azure Synapse Analytics.
jianleishen
data-factory
data-movement
troubleshooting
10/01/2021
jianleishen
has-adal-ref, synapse

Troubleshoot the XML format connector in Azure Data Factory and Azure Synapse

[!INCLUDEappliesto-adf-asa-md]

This article provides suggestions to troubleshoot common problems with the XML format connector in Azure Data Factory and Azure Synapse.

Error code: XmlSinkNotSupported

  • Message: Write data in XML format is not supported yet, choose a different format!

  • Cause: An XML dataset was used as a sink dataset in your copy activity.

  • Recommendation: Use a dataset in a different format from that of the sink dataset.

Error code: XmlAttributeColumnNameConflict

  • Message: Column names %attrNames;' for attributes of element '%element;' conflict with that for corresponding child elements, and the attribute prefix used is '%prefix;'.

  • Cause: An attribute prefix was used, which caused the conflict.

  • Recommendation: Set a different value for the "attributePrefix" property.

Error code: XmlValueColumnNameConflict

  • Message: Column name for the value of element '%element;' is '%columnName;' and it conflicts with the child element having the same name.

  • Cause: One of the child element names was used as the column name for the element value.

  • Recommendation: Set a different value for the "valueColumn" property.

Error code: XmlInvalid

  • Message: Input XML file '%file;' is invalid with parsing error '%error;'.

  • Cause: The input XML file is not well formed.

  • Recommendation: Correct the XML file to make it well formed.

Next steps

For more troubleshooting help, try these resources: