-
Type: Testing Defect
-
Status: Done (View Workflow)
-
Priority: Critical
-
Resolution: Completed
-
Affects Version/s: CFA 2019R1
-
Fix Version/s: CFA 2019R2
-
Component/s: Imports
-
Labels:None
-
Source Code ID(s):
Vendor Item Import with R1 updates fails to create a new item.
It fails with the following error in CFA Staging:
Event : 2/19/2019 7:44:46 PM : VendorItemImport : Import Record #1: Vendor Item Updated: (VendorItemID:5609)
-
- Error : 2/19/2019 7:44:46 PM : Vendor Item Data Import on 2/19/2019 7:44:46 PM : <E: Record Import Failed with error :E> Cannot insert duplicate key row in object 'dbo.tbVendorItem' with unique index 'VendorIDVendorCode'. The duplicate key value is (11, 567880).
Invalid object name '#NewVendorEntityItems'.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
The statement has been terminated. - Error : 2/19/2019 7:44:46 PM : Vendor Item Data Import on 2/19/2019 7:44:46 PM : <E: Record Import Failed with error :E> Invalid object name '#NewVendorEntityItems'.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Event : 2/19/2019 7:44:46 PM : VendorItemImport : Import Record #4: Vendor Item Updated: (VendorItemID:9989)
Event : 2/19/2019 7:44:46 PM : VendorItemImport : Import Record #5: Vendor Item Updated: (VendorItemID:7637) - Error : 2/19/2019 7:44:46 PM : Vendor Item Data Import on 2/19/2019 7:44:46 PM : <E: Record Import Failed with error :E> Invalid object name '#NewVendorEntityItems'.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. - Error : 2/19/2019 7:44:46 PM : Vendor Item Data Import on 2/19/2019 7:44:46 PM : <E: Record Import Failed with error :E> Invalid object name '#NewVendorEntityItems'.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.
Event : 2/19/2019 7:44:46 PM : VendorItemImport : Import Record #8: Vendor Item Updated: (VendorItemID:10187)
Event : 2/19/2019 7:44:46 PM : Vendor Item Data Import on 2/19/2019 7:44:46 PM : Data Import Complete
- Error : 2/19/2019 7:44:46 PM : Vendor Item Data Import on 2/19/2019 7:44:46 PM : <E: Record Import Failed with error :E> Cannot insert duplicate key row in object 'dbo.tbVendorItem' with unique index 'VendorIDVendorCode'. The duplicate key value is (11, 567880).
Developer note: The problem is inside qryMMSVendorItem_InsertVendorItemForImport,
If it is missing the directive to InsertVendorEntityItem AND has at least one of the following directives
{UpdateEntityItem}PurchaseUnit
{UpdateEntityItem}StockTakeInner
{ DefaultReportingUnit}PurchaseUnit
then it would fail.
- Is Clone Of
-
CFAMX-2591 CLONE 2019R2 - Vendor Item Import with R1 updates fails to create a new item
- Done
- relates to
-
CFAMX-1083 Change Vendor Item File to Accommodate Vendor Entity Item Fields - INF-11079
- Closed