Errors in XPath Queries

Troubleshooting SQL Server

Troubleshooting

Errors in XPath Queries

These are the XPath errors detected during XPath processing

"XPath: an unexpected internal error occurred"

Not expected during typical processing.

"XPath: unable to instantiate MSXML class factories"

"XPath: the parsed XPath contains an unexpected value (%1). The version of MSXML2.DLL installed may be incompatible with SQLXMLX.DLL"

Not expected during typical processing.  If one of these errors occurs, the most likely cause is an installation problem.  Check that SQLXMLX.DLL and MSXML2.DLL are the versions that were installed with SQL Server.

"XPath: the %1 axis is not supported"

"XPath: the %1 nodetest is not supported"

"XPath: the %1 function is not supported"

"XPath: the %1 operator is not supported"

Refer to the topic in SQL Server Books Online that  explains the functionality supported in SQL Server 2000.

"XPath: direct object access must select a column"

"XPath: only direct object access may select an attribute"

Refer to the topic in SQL Server Books Online that explains direct object access.  Selecting an attribute is supported only in direct object access because the attribute's value is returned, and this is not valid XML.  Conversely, direct object access must select a single column from a single row.

"XPath: the root selection (/) is not supported"

Refer to the topic in SQL Server Books Online that explains XPath Limitations.

"XPath: the attribute %1 cannot be selected from root. It must be selected from a containing element"

There can be no top-level attributes.  Only elements can have attributes.

"XPath: ordinal (numeric) predicates are not supported"

Refer to the topic in SQL Server Books Online that explains XPath Limitations.

"XPath: the parameter %1 is undefined"

The parameter was used, but not defined anywhere.

"XPath: the type of the parameter %1 is not supported.  XPath parameters must be of type WSTR"

Only string-valued parameters are supported in XPath queries.

"XPath: unable to find %1 in the schema"

The named element or attribute does not exist in the schema.

"XPath: conversion to type %1 cannot be performed"

Refer to the topic in SQL Server Books Online that explains XPath Data Types.

"XPath: unable to evaluate the text content of element %1"

"XPath: the use of idrefs/nmtokens %1 in the predicate is not supported"

Refer to the topic in SQL Server Books Online that explains XPath Limitations.  The named element does not map to a single column in a single row of the database.

"XPath: uncorrelated query in predicate is not supported. Read the documentation for details"

Refer to the topic in SQL Server Books Online that explains XPath Limitations.  XPath cross-products are not supported in SQL Server 2000.