The XML type extract function encounters a "parsing failed" error when executing a SQL query.
Last Published: October 25, 2017ArcSDE/Enterprise Geodatabase
Bug ID Number
BUG-000099298
Submitted
September 13, 2016
Last Modified
May 31, 2023
Applies to
ArcSDE/Enterprise Geodatabase
Version found
10.2.1
Status
Known Limit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
Additional Information
This seems to be a data issue.
The query runs into this error when the definition column of the sde.gdb_items_vw does not contain any XML data.
"LPX-00007: unexpected end-of-file encountered."
Workaround
Run the following query prior running the XML extract query:
select * from sde.gdb_items_vw