Hi,
I get the following error in my Commerce Server site triggered by a call
to
the SaveAsOrder() method of a
Microsoft.CommerceServer.Runtime.Orders.Basket
object.
As I understand this error in SQL Server, it is due to data being written
that is longer than the target field but the data that is part of this
order
is made of very small data elements (short names and descriptions ...).
Also, this has just started happening on a site that's been working for a
while.
Here is the stack trace.
[COMException (0x80040e57): String or binary data would be
truncated.[22001]The statement has been terminated.[01000] String or
binary
data would be truncated.]
Microsoft.CommerceServer.Interop.Orders.DBStorageClass.InsertData(Object
vtReserved, Object pdispData) +0
Microsoft.CommerceServer.Interop.Orders.MTSHelperImpl.SaveDictToTable(Int16&
bExists, IDictionary& dict, String& table, String& key, Object& exception,
Object& exception2, DBStorage& dbs, Boolean& bReinitializeDBS, String&
SavePrefix, String& dsn, String& userid) +501
Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThreaded.Save(LoadedFromState
my_save_to, String SavePrefix) +1355
Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThreaded.SaveAsOrderHelper(Object
in_User, Object in_dsn, Object in_GenID, Object& in_out_OrderGroupData,
Object& loaded_from, Object& in_out_exists_in_databse, Object SavePrefix,
Object& out_vtOutTrackingNumber) +750 [CommerceException:
SaveAsOrderHelper
Failed.]
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg) +264
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type) +877
Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThreaded.SaveAsOrderHelper(Object
in_User, Object in_dsn, Object in_GenID, Object& in_out_OrderGroupData,
Object& loaded_from, Object& in_out_exists_in_databse, Object SavePrefix,
Object& out_vtOutTrackingNumber) +0
Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object&
vtOutTrackingNumber) +176 [CommerceException: SaveAsOrder Failed.]
Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String
message, Exception inner, String source) +51
Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object&
vtOutTrackingNumber) +284
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +241
[CommerceOrderSystemException: Failed to save basket as an order.]
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +528
MyOnlineSite.Controls.AcceptOrder.btnAccept_Click(Object sender, EventArgs
e) in c:\inetpub\wwwroot\MyOnlineSite\Controls\AcceptOrder.ascx.cs:115
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl,
String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1262Anybody has an idea about
this
?Thanks,Francois
|
