-
Type:
Testing Defect
-
Status: Done (View Workflow)
-
Priority:
Critical
-
Resolution: Completed
-
Affects Version/s: CFA 2019R1
-
Fix Version/s: CFA 2019R1
-
Component/s: Imports
-
Labels:None
-
SCRUM Team:Brotherhood of Mutants
-
Source Code ID(s):
-
Sprint:CFAMX 2019R2 Sprint 4, CFAMX 2019R2 Sprint 5
Vendor Item Import with R1 updates - import fails for some expense items. The log shows the following error:
-
- Error : 2/23/2019 4:19:55 AM : Vendor Item Data Import on 2/23/2019 4:19:55 AM : <E: Record Import Failed with error :E> The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_tbVendorEntityItem_tbUnitOfMeasure". The conflict occurred in database "CFAStaging", table "dbo.tbUnitOfMeasure", column 'UnitOfMeasureID'.
The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_tbEntityItem_tbUnitOfMeasure2". The conflict occurred in database "CFAStaging", table "dbo.tbUnitOfMeasure", column 'UnitOfMeasureID'.
The statement has been terminated.
The statement has been terminated.
- Error : 2/23/2019 4:19:55 AM : Vendor Item Data Import on 2/23/2019 4:19:55 AM : <E: Record Import Failed with error :E> The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_tbVendorEntityItem_tbUnitOfMeasure". The conflict occurred in database "CFAStaging", table "dbo.tbUnitOfMeasure", column 'UnitOfMeasureID'.
Example:
VendorCode|ItemCode|VendorItemCode|VendorDescription|{UpdateVendorEntityItem}{DefaultToReportingUnit}{UpdateFromItem}{AddUOMMapping}{UpdateEntityItem}PurchaseUnit|VendorPrice|IntroductionDate|DiscontinueDate|AutoUpdateEntityPrice|AutoUpdateEntityUnit|{UpdateVendorEntityItem}PerformStockCount|{UpdateVendorEntityItem}{UpdateEntityItem}StockTakeInner|{UpdateVendorEntityItem}SetCostToLastPurchasePrice|{UpdateVendorEntityItem}ReplacedVendorItemCode
184774|016749|016749|TOWEL, ROLL||0|2009/08/13 00:00:00|4712/12/31 00:00:00|N|N|N||Y|
- relates to
-
CFAMX-1083 Change Vendor Item File to Accommodate Vendor Entity Item Fields - INF-11079
-
- Closed
-
