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

  • Article

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

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.

Related content

For more troubleshooting help, try these resources: