About 8 - 10 times per day we are receiving an error when calling the
Basket.Save() method.
Anyone know what could be causing this?
Thank you!
Glen Fergo
Exception Details: System.Data.SqlClient.SqlException: Cannot insert
duplicate key row in object 'dbo.OrderTemplatesAndBaskets' with unique
index 'OrderTemplatesAndBaskets_UniqueConstraints'.
StackTrace: Server stack trace: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior
runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.NextResult() at
System.Data.ProviderBase.DataReaderContainer.NextResult() at
System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer
dataReader) at System.Data.Common.DataAdapter.FillFromReader(DataSet
dataset, DataTable datatable, String srcTable, DataReaderContainer
dataReader, Int32 startRecord, Int32 maxRecords, DataColumn
parentChapterColumn, Object parentChapterValue) at
System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at
Microsoft.CommerceServer.Internal.Orders.MtsHelper.ExecuteSqlCommandDataSet(String
connStr, String commandText, CommandType commandType, ArrayList
sqlParameterHelpers, Int32 timeout) at
System.Runtime.Remoting.Messaging.Message.Dispatch(Object target,
Boolean fExecuteInContext) at
System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage
msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at
[0]: at
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg) at
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type) at
Microsoft.CommerceServer.Internal.Orders.MtsHelper.ExecuteSqlCommandDataSet(String
connStr, String commandText, CommandType commandType, ArrayList
sqlParameterHelpers, Int32 timeout) at
Microsoft.CommerceServer.Runtime.Orders.OrderGroup.Save(Int32
maxInstances, String baseClassName, String tableInsertSprocName,
PropertyColumnMapping[] stronglyTypedMappings, PropertyColumnMapping[]
weaklyTypedMappings, DetailedSqlColumnInformation indexerColumnInfo)
at Microsoft.CommerceServer.Runtime.Orders.Basket.Save() at
CsBaseOrder.GetOrderForm(String key)
|
