Event : 3/25/2021 1:16:52 PM : Shipping Confirmation Data Import on 3/25/2021 1:16:52 PM : Starting Data Import
   Event : 3/25/2021 1:16:52 PM : Data Import on 3/25/2021 1:16:52 PM : Source File \\mx-usp-cfa-vw01\Shared-Data\Sysco_Prod\Receive\ASN_055_01023_355513448_210324135125.xml successfully validated
   Event : 3/25/2021 1:16:52 PM : Data Import on 3/25/2021 1:16:52 PM : Record #1 parsed
-- Warning : 3/25/2021 1:16:54 PM : Shipping Confirmation Data Import on 3/25/2021 1:16:52 PM : Import Record #1: Purchase Order Number provided did not exist and was automatically created '3543767'
** Error : 3/25/2021 1:16:54 PM : Shipping Confirmation Data Import on 3/25/2021 1:16:52 PM : MMS.Utilities.MxUniqueIndexException: Violation of PRIMARY KEY constraint 'PK_tbEntityItemCostAdjust'. Cannot insert duplicate key in object 'dbo.tbEntityItemCostAdjust'. The duplicate key value is (588, 16, Mar 25 2021  9:16AM).
The statement has been terminated. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tbEntityItemCostAdjust'. Cannot insert duplicate key in object 'dbo.tbEntityItemCostAdjust'. The duplicate key value is (588, 16, Mar 25 2021  9:16AM).
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Mx.Data.EntityItemData.qryMMSEntityItemCostAdjust_Insert(Int64 entityID, Int64 itemID, DateTime transactionDate, Double sOHQuantity, Double adjustQuantity, Decimal oldInventoryUnitCost, Decimal adjustUnitCost, Decimal newInventoryUnitCost, SqlTransaction transaction, Int32 timeoutValue, Boolean fillPrimaryKey)
   --- End of inner exception stack trace ---
   at Mx.Data.DataUtility.HandleException(Exception exception)
   at Mx.Data.EntityItemData.qryMMSEntityItemCostAdjust_Insert(Int64 entityID, Int64 itemID, DateTime transactionDate, Double sOHQuantity, Double adjustQuantity, Decimal oldInventoryUnitCost, Decimal adjustUnitCost, Decimal newInventoryUnitCost, SqlTransaction transaction, Int32 timeoutValue, Boolean fillPrimaryKey)
   at Mx.Services.EntityItemService.EntityItemCostAdjust_Insert(Int64 entityId, Int64 itemId, DateTime transactionDate, Double sohQuantity, Double adjustQuantity, Decimal oldCost, Decimal adjustCost, Decimal newCost, SqlTransaction transaction)
   at Mx.Services.RegularInventoryItem.GetPurchaseToCostLayer(Double currentInventoryUnitQty, Double newInventoryUnitQty, Decimal newInventoryUnitCost)
   at Mx.Services.RegularInventoryItem.ProcessPurchaseAdjust(Double purchaseQty, String authorisedBy, Int64 vendorID, Decimal purchaseIVUnitPrice, Decimal purchaseUnitPrice, Int64 costingType, String vendorCode, SqlTransaction transaction)
   at Mx.Services.RegularInventoryItem.PurchaseAdjust(Double purchaseQty, Double receivedQty, Double returnedQty, String authorisedBy, Int64 vendorID, Decimal purchaseIVUnitPrice, Decimal purchaseUnitPrice, Int64 costingType, String vendorCode, Double backOrderQty, SqlTransaction transaction, Boolean calculateOnOrderQty)
   at Mx.Services.TransactionSupplyOrderService.AutoReceive(Int64 templateID, Int64 entityID, ApplyDateHolder applyDate, String authorisedBy, DateTime receiveDate, List`1& itemList, SupplyOrderAutoStatus autoReceiveStatus, SqlTransaction transaction)
   at Mx.Services.TransactionSupplyOrderServiceWrapper.AutoReceive(Int64 templateId, Int64 entityId, ApplyDateHolder applyDate, String authorizedBy, DateTime receiveDate, SupplyOrderAutoStatus supplyOrderAutoStatus)
   at Mx.Services.ShippingConfirmationImportProvider.AutoCreateOrder(IImportable importRecord, ShippingConfirmationImport shippingConfirmationImport)
   at Mx.Services.ShippingConfirmationImportProvider.Import(IImportable importRecord)
   Event : 3/25/2021 1:16:55 PM : Shipping Confirmation Data Import on 3/25/2021 1:16:52 PM : Data Import Complete