XMLPort cuts off EE

DenSter

5.0 SP1 on SQL 2005. There is a report object that calls a webservice that returns an XML document that contains sales orders. The webservice is called using MSXML4 and the in/outstream in TempBLOB. When the value of one of the elements ends with 'EE', this gets cut off. So let's say the value is 'PICK MEE', what gets imported is 'PICK M', which is not a valid value. It's not a field length issue, we've seen it cut off the ending 'EE' in various lengths values.

I am thinking this is an encoding issue, but what exactly, or how to fix it.... that's a different story. The XMLPort is set to UTF-8, and that is what is in the xml declaration as well.

Has anyone seen this, and if you have, then how did you solve it? For now they renamed the value to something that doesn't end with 'EE', but I'd like to be able to provide a real solution.

ara3n

does it cut the value in the xml or does it cut the whole xml file?

Have you tried with new version of msxml and have you tried with new version of executable?

DenSter

The value of the one field is where it happens.