MSCEWI4067

Invalid parameters in OPENXML table-valued function.

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.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI4066

MSCEWI4068

Last modified 6mo ago