Edit

Troubleshoot the XML format connector in Data Factory in Microsoft Fabric

This article provides suggestions to troubleshoot common problems with the XML format connector in Data Factory in Microsoft Fabric.

Error code: XmldestinationNotSupported

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

  • Cause: XML data was used as destination data in your copy activity.

  • Recommendation: Use data in a different format from that of the destination data.

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.

For more troubleshooting help, try these resources: