|
Home > Archive > BizTalk Server General > February 2005 > Event Log
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]
|
|
|
| While trying to do an insert into a table, I am seeing in the event log the
following error message:
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>".
I thought that I heard there was a patch out there that might return a more
specific error message, instead of this generic error message, so I can get
data inserted into the table.
Thanks,
Eric
| |
| Martin Hellspong 2004-11-24, 5:52 pm |
| Isn't this the standard SQL Server error you get when you try to insert more
data than fits into the specific column? For example, if you try to insert
the value 'TooLong' into a varchar(2) column.
something like:
Create Table #TestErr (TestStr varchar(2))
go
Insert Into #TestErr Values('TooLong')
go
"Eric" wrote:
> While trying to do an insert into a table, I am seeing in the event log the
> following error message:
>
> 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>".
>
> I thought that I heard there was a patch out there that might return a more
> specific error message, instead of this generic error message, so I can get
> data inserted into the table.
>
> Thanks,
> Eric
>
>
>
| |
| Doug Girard [MSFT] 2005-02-22, 5:50 pm |
| Also FYI, the SQL Adapter now returns more verbose error descriptions with
BTS 2004 Service Pack 1. This should aid in your future debugging.
See the Readme for more information:
http://go.microsoft.com/?linkid=2165147
Regards,
Doug Girard [MSFT]
Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>Thread-Topic: Event Log
>thread-index: AcTSc5s7TuUPcTb2QTq1/K5Bq6OrzA==
>X-WBNR-Posting-Host: 213.66.35.20
>From: "=?Utf-8?B?TWFydGluIEhlbGxzcG9uZw==?="
<MartinHellspong@discussions.microsoft.com>
>References: <eb4NPXL0EHA.824@TK2MSFTNGP11.phx.gbl>
>Subject: RE: Event Log
>Date: Wed, 24 Nov 2004 14:19:04 -0800
>Lines: 30
>Message-ID: <F29EDCF5-DE94-47B0-9D3D-FB65F44F15DC@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:21966
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Isn't this the standard SQL Server error you get when you try to insert
more
>data than fits into the specific column? For example, if you try to insert
>the value 'TooLong' into a varchar(2) column.
>
>something like:
>Create Table #TestErr (TestStr varchar(2))
>go
>Insert Into #TestErr Values('TooLong')
>go
>
>"Eric" wrote:
>
the[vbcol=seagreen]
more[vbcol=seagreen]
get[vbcol=seagreen]
>
|
|
|
|
|