XML import fails with error "com.glide.db.impex.datasource.DataSourceException: Incorrect or missing XPath expression"


Description

Two files containing the same data, one in JSON and one in XML are uploaded to a Datasource.
The one in JSON successfully loads the data but the XML data source dails to load with exception "com.glide.db.impex.datasource.DataSourceException: Incorrect or missing XPath expression"


- Import of XML file via Data Source fails with the following error message:
"com.glide.db.impex.datasource.DataSourceException: Incorrect or missing XPath expression - please review http://docs.servicenow.com/?context=Data_Sources"

Data source:
XPath for each row: /node_name
Expand node children: true

Release or Environment

Any

Cause

The reason is this file size is 35252 and the maximum size system allows you to read a file with root element as the XPath is private static final int MAX_DEGENERATE_CASE_DOCUMENT_SIZE = 32 * 1024;

Resolution

Either reduce  file size or use 'Custom (Load by script)' to manually parse the XML and load it.