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

[ Post a follow-up to this message ]

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 erro
r
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

[ Post a follow-up to this message ]

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.

[ Post a follow-up to this message ]

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.
>
>

[ Post a follow-up to this message ]

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.

[ Post a follow-up to this message ]