XMLPort cuts off EE

DenSter
Member Posts: 8,307
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.
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.
0
Comments
-
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?0 -
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions