Xslt -- Value either too large or small for int32

krishk189 · April 15th, 2014, 05:18 PM

Hi All,

I am trying to do a dblookup from custom xslt(Biztalk Maps) and assigning to variable, value from ScriptNS0:DBValueExtract.

But it's giving an error ScriptNS0:DBValueExtract has failed. Value was either too large or too small for an int32.

I tried using 'as=xs:decimal' but unable to compile the map, Is there a way to explicitly convert the default variable type int32 to decimal or double.

I am using xslt 1.0.

Any suggestion,

Thanks

mhkay · April 15th, 2014, 05:26 PM

Your question probably needs someone who knows Biztalk to answer it, it's not a generic XSLT question.

You can't use attributes like as="xs:decimal" in XSLT 1.0, this is a 2.0 feature.

krishk189 · April 15th, 2014, 05:34 PM

Thanks Michael,

I would like to know in xslt 1.0 what is default type of variable and how change to double or decimal.

Is there a way to store '33.000' in the variable for xslt 1.0

Thanks

mhkay · April 15th, 2014, 05:52 PM

XSLT 1.0 has four data types: string, double, boolean, and node-set. Variables do not have a type, only values have a type. A value written as 33.000 is a double. I would think the message about int32 is something to do with passing values between XSLT and some other language.

samjudson · April 16th, 2014, 04:01 AM

The error "Value was either too large or too small for an Int32" is exactly the error you get when calling int.Parse in .Net code and try to parse something bigger than int.MAXVALUE (which I'm guessing your Biztalk extension method is written in). So this isn't an XSLT issue, but something in your code that is assuming one of the fields in your database is an INT but is probably a BIGINT.