BizTalk Server Framework - BizTalk 2002 SQL Adapter

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Framework > February 2005 > BizTalk 2002 SQL Adapter





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 BizTalk 2002 SQL Adapter
Jonlar

2004-10-15, 9:09 pm

Hi there
I have Doc specs and map to insert into a sql-table. During tests in Editor
and Mapper there is no error, but when I run this I get:

[0x80004005] Failed to parse the XML Document, please refer to the trace log
for more information
[0x0159] The server encountered a transport error while processing the
messaging port "messPutToSQL", which uses a transport component with a ProgID
of "AICSQL.SQLPipeline.1".

[0x012b] A transmission attempt failed.


Any clues anyone? The tutorial works just fine...

Simular problem as Judy Harper (in this community). Judy, have you solved
your problems?

Best Regs

/J
Vikram

2005-01-03, 5:49 pm

Please Tell me if you have solved this issue ... I have a similar issue ...
thank you for the help
Vikram

"Jonlar" wrote:

> Hi there
> I have Doc specs and map to insert into a sql-table. During tests in Editor
> and Mapper there is no error, but when I run this I get:
>
> [0x80004005] Failed to parse the XML Document, please refer to the trace log
> for more information
> [0x0159] The server encountered a transport error while processing the
> messaging port "messPutToSQL", which uses a transport component with a ProgID
> of "AICSQL.SQLPipeline.1".
>
> [0x012b] A transmission attempt failed.
>
>
> Any clues anyone? The tutorial works just fine...
>
> Simular problem as Judy Harper (in this community). Judy, have you solved
> your problems?
>
> Best Regs
>
> /J

Jan Eliasen

2005-02-15, 5:50 pm

Hi

During the installation of the SQL Adapter, you can also install a
trace utility. The error mentioned below only means that the AIC
couldn't deliver the data to SQL Server. The reasons can be many - use
the trace utility to get a better idea of what went wrong.

Jan Eliasen

On Mon, 3 Jan 2005 14:39:03 -0800, Vikram
<Vikram@discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Please Tell me if you have solved this issue ... I have a similar issue ...
>thank you for the help
>Vikram
>
>"Jonlar" wrote:
>

--
Jan Eliasen, representing himself and not the company he works for.
Arjun Luthra [MSFT]

2005-02-15, 8:51 pm

Ensure that the Encoding is correct on the document being passed in. I
believe the 2002 SQL adapter expects UTF-16 little endian (unicode)
documents without the byte-order-mark.

--
Arjun

"Jan Eliasen" <eliasen@nospam.nospam> wrote in message
news:vk0411lno78pilv65rlse6tcnsk2plfiv5@
4ax.com...
> Hi
>
> During the installation of the SQL Adapter, you can also install a
> trace utility. The error mentioned below only means that the AIC
> couldn't deliver the data to SQL Server. The reasons can be many - use
> the trace utility to get a better idea of what went wrong.
>
> Jan Eliasen
>
> On Mon, 3 Jan 2005 14:39:03 -0800, Vikram
> <Vikram@discussions.microsoft.com> wrote:
>
>
> --
> Jan Eliasen, representing himself and not the company he works for.



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com