Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-2590

Vendor Item Import with R1 updates fails to create a new item

    Details

    • 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

      Description

      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

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                stacy.privalova Stacy Privalova
                Reporter:
                stacy.privalova Stacy Privalova
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4h
                  4h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.