|
Home > Archive > BizTalk Server > February 2005 > SQL adapter raised error, Invalid unicode character
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL adapter raised error, Invalid unicode character
|
|
|
| The adapter "SQL" raised an error message. XML parsing
error: Invalid unicode character value for this platform.
[]<?xml version="1.0" encoding="utf-16"?>
Help, does anyone know why I am getting this error?
--
mj
| |
|
| I forgot to mention that I only get this error when I put a file batch
through Biztalk Server 2004 with has multiple records. I don't get the error
if the batch file only has one record. Help.
Thanks in advance.
"mj" wrote:
> The adapter "SQL" raised an error message. XML parsing
> error: Invalid unicode character value for this platform.
> []<?xml version="1.0" encoding="utf-16"?>
>
> Help, does anyone know why I am getting this error?
> --
> mj
| |
| WenJun Zhang[msft] 2005-02-08, 7:56 am |
| Hi mj,
Looks like the error is generated by SQLXML. You may manually test
the sql store procedure or query statement used by the sql receive
port in sql query analyzer. Save the result as XML document and
verify if there is any unacceptable character.
Please also paste the results here.
Thanks.
Best regards,
WenJun Zhang
Microsoft Online Partner Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
| |
|
| Hi,
I found that the customer is sending null chars randomly throughout there
batch file. This is why SQL is rejecting the xml doc. because of these null
chars. Thanks for your help in this matter.
""WenJun Zhang[msft]"" wrote:
> Hi mj,
>
> Looks like the error is generated by SQLXML. You may manually test
> the sql store procedure or query statement used by the sql receive
> port in sql query analyzer. Save the result as XML document and
> verify if there is any unacceptable character.
>
> Please also paste the results here.
>
> Thanks.
>
> Best regards,
>
> WenJun Zhang
> Microsoft Online Partner Support
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
| |
| WenJun Zhang[msft] 2005-02-10, 7:50 am |
| That's great. You are welcome Marci.
Best regards,
WenJun Zhang
Microsoft Online Partner Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
|
|