| Author |
SQL adapter - transmission failure
|
|
|
| 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
| |
| Yossi Dahan 2005-08-05, 7:48 am |
| 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 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
>
>
>
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
| |
| bradsaint 2005-08-05, 11:33 am |
| Looks like the error you're getting is a SQL error, not a BizTalk error. The value being sent in one of your parameters is greater than the SQL datatype. It's going to be truncated. Check string value lengths.
HTH. | |
| Lakshmi Murthy 2005-08-25, 7:48 am |
| 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
>
| |
|
| 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:
>
|
|
|
|