Subject:XQuery external variable conversion failure since upgrade to SS 2008 Author:Thais Flory Date:30 May 2008 04:51 PM
I have an XQuery node in an XML Pipeline, which has this prolog:
declare variable $ck as xs:integer external;
[...]
A default value of 21 is assigned to the node's input port "ck" and I get this error:
Error: XQUERY processing by XQUERY node 'Web 2 DB to XML Map' failed: Error encountered while initializing variable ck with value xs:integer('21'):
[DataDirect][XQuery]The value "xs:integer('21')" cannot be converted to the XQuery data type xs:integer.
I test the same project with SS 2007 and it works fine. Please let me know what changed or if this is just a bug that needs fixed.
Subject:XQuery external variable conversion failure since upgrade to SS 2008 Author:Minollo I. Date:30 May 2008 05:17 PM
Nope, that won't help, sorry; I'm able to reproduce the problem. It happens when executing the pipeline inside Stylus Studio, but not when generating and running the code externally.
This is definitely a bug; we'll be in touch when a hotfix is available for you (early next week).