Hello!

I'm using the SQL adapter to insert a row in table. I'm using the
updategram. Unfortunatelly I get an error from the SQL server, saying
"Transmission failure".
In the log I can see following error messages:

Type: Error
source: BizTalk Server
event ID: 5752
Description: The Messaging Engine has suspended "1" message(s) from adapter
"SQL" due to failures in message processing. Please refer to Health and
Activity Tracking tool for more detailed information on this failure.

Type:Warning
source: BizTalk Server
event ID: 5740
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e57"
Description="String or binary data would be truncated."
<Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError
HResult="0x80040e57" Source="Microsoft OLE DB Provider for SQL Server"
Description="String or binary data would be truncated."?></Root>".

While setting up the SQL port I have tested the connection with status
"connection succeded".

Can You please help me?

Thanks,

//theo

[ Post a follow-up to this message ]

Theo wrote:
> Hello!
>
> I'm using the SQL adapter to insert a row in table. I'm using the
> updategram. Unfortunatelly I get an error from the SQL server, saying
> "Transmission failure".
> In the log I can see following error messages:
>
> Type: Error
> source: BizTalk Server
> event ID: 5752
> Description: The Messaging Engine has suspended "1" message(s) from adapte
r
> "SQL" due to failures in message processing. Please refer to Health and
> Activity Tracking tool for more detailed information on this failure.
>
> Type:Warning
> source: BizTalk Server
> event ID: 5740
> The adapter "SQL" raised an error message. Details "HRESULT="0x80040e57"
> Description="String or binary data would be truncated."
>  <Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError
> HResult="0x80040e57" Source="Microsoft OLE DB Provider for SQL Server"
> Description="String or binary data would be truncated."?></Root>".
>
> While setting up the SQL port I have tested the connection with status
> "connection succeded".
>
> Can You please help me?
>
> Thanks,
>
> //theo
>
>
>
Hi Theo

I'm not at all sure but it seems that your error message is data related
the call went to SQL and the operation failed. I would examine the data
carefully and see that all data conversion are valid.

Yossi Dahan

[ Post a follow-up to this message ]

Looks like the error you're getting is a SQL error, not a BizTalk error.  Th
e value being sent in one of your parameters is greater than the SQL datatyp
e.  It's going to be truncated.  Check string value lengths.

HTH.

[ Post a follow-up to this message ]

Hi,

Did this problem with SQL Adapter get resolved? If Yes, how? Please let me
know as  i am getting a similar error in my orchestration.

Thanks in advance
Regards
Lakshmi

"Yossi Dahan" wrote:

> Theo wrote: 
> Hi Theo
>
> I'm not at all sure but it seems that your error message is data related
> the call went to SQL and the operation failed. I would examine the data
> carefully and see that all data conversion are valid.
>
> Yossi Dahan
>

[ Post a follow-up to this message ]

The problem was resolved. It was database related and had to do with the
length of the object written to database.

"Lakshmi Murthy" wrote:
[vbcol=seagreen]
> Hi,
>
> Did this problem with SQL Adapter get resolved? If Yes, how? Please let me
> know as  i am getting a similar error in my orchestration.
>
> Thanks in advance
> Regards
> Lakshmi
>
> "Yossi Dahan" wrote:
> 

[ Post a follow-up to this message ]