-
Type:
Customer Defect
-
Status: Done (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: CFA 2022R5
-
Fix Version/s: None
-
Component/s: Inventory
-
Labels:None
-
VTask #:VTASK0505392
-
Root cause - Reason:Bad data
-
Source Code ID(s):
-
Root Cause:not implemented
When CFA log into InFORM (Legacy) then chose the Manage Tab then under Product Admin then select Wizard. they select Manage Inventory Items from the Drop Down and enter the item number.
Once they select the item they go to the 3^rd^ tab for “Set Suppliers” to add the other Distributors needed to be added.
Once they select the Distributor to add then go to input they get the following error message.
They get the same error message on both Edge and Google Chrome.
They need to get this issue resolved to finish some expense item setup.
I am able to replicate the issue:
[SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.tbVendorItem' with unique index 'VendorIDVendorCode'. The duplicate key value is (155, 063767). The statement has been terminated.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1968826 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4907355 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2412 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +200 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137 Mx.Data.VendorItemData.qryMMSVendorItem_InsertVendorItem(Int64 vendorID, Int64 itemID, Decimal vendorPrice, String vendorCode, String vendorBin, String vendorDescription, Int16 purchaseUnitID, Int16 innerUnitID, Double minOrderQty, Double maxOrderQty, Boolean restrictedOrder, DateTime introductionDate, DateTime discontinueDate, Int64 billingVendorID, String purchaseUnitTranslation, String newVendorItemComment, Int64& vendorItemID, SqlTransaction transaction, Int32 timeoutValue, Boolean fillPrimaryKey) +1579 [MxUniqueIndexException: Cannot insert duplicate key row in object 'dbo.tbVendorItem' with unique index 'VendorIDVendorCode'. The duplicate key value is (155, 063767). The statement has been terminated.] Mx.Data.DataUtility.HandleException(Exception exception) +301 Mx.Data.VendorItemData.qryMMSVendorItem_InsertVendorItem(Int64 vendorID, Int64 itemID, Decimal vendorPrice, String vendorCode, String vendorBin, String vendorDescription, Int16 purchaseUnitID, Int16 innerUnitID, Double minOrderQty, Double maxOrderQty, Boolean restrictedOrder, DateTime introductionDate, DateTime discontinueDate, Int64 billingVendorID, String purchaseUnitTranslation, String newVendorItemComment, Int64& vendorItemID, SqlTransaction transaction, Int32 timeoutValue, Boolean fillPrimaryKey) +1682 Mx.Services.VendorItemService.InsertVendorItem(VendorItem vendorItem) +1360 Mx.Services.VendorItemService.InsertVendorItemWithTrigger(VendorItem vendorItem) +41 MMS.ItemManageVendorItemDataSourceView.InsertObject(EntityBase bo) +22 MMS.Controls.MxDataSourceView.ExecuteInsert(IDictionary values) +256 System.Web.UI.DataSourceView.Insert(IDictionary values, DataSourceViewOperationCallback callback) +86 Telerik.Web.UI.GridTableView.PerformInsert(GridEditableItem editedItem, Boolean suppressRebind) +172 Telerik.Web.UI.GridTableView.PerformInsert() +33 Telerik.Web.UI.GridCommandEventArgs.ExecuteCommand(Object source) +3148 Telerik.Web.UI.RadGrid.OnBubbleEvent(Object source, EventArgs e) +134 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 Telerik.Web.UI.GridItem.OnBubbleEvent(Object source, EventArgs e) +38 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 Telerik.Web.UI.GridItem.OnBubbleEvent(Object source, EventArgs e) +115 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +118 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
- blocks
-
CFAMX-11540 Production Defects
-
- Open
-