MSCEWI4067

Invalid parameters in OPENXML table-valued function.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Critical

Description

This EWI is added when there are invalid parameters in the OPENXML, specifically when the XML path cannot be accessed.

To avoid this EWI, please send the explicit node path through the parameters.

Input Code:

SELECT
      *
FROM
      OPENXML (@idoc, @path, 1) WITH (
            CustomerID VARCHAR(10),
            ContactName VARCHAR(20)
      );

Output Code:

SELECT
      *
FROM
-- ** MSC-ERROR - MSCEWI4067 - NODE PATH CANNOT BE ACCESSED **
--      PUBLIC.OPENXML(idoc, variable, 1) WITH (CustomerID VARCHAR(10), ContactName VARCHAR(20)
--      )
       ;

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [email protected]