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

CLONE 2019R2 - Vendor Item Import with R1 updates fails to create a new item

    Details

    • Type: Testing Defect
    • Status: Done (View Workflow)
    • Priority: Critical
    • Resolution: Fixed by another Defect
    • Affects Version/s: CFA 2019R1
    • Fix Version/s: None
    • 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

        Attachments

          Issue Links

          Clones

          Testing Defect - CFAMX-2590 Vendor Item Import with R1 updates fails to create a new item

          • Critical - Crashes, loss of data, severe memory leak.
          • Done
          relates to

          Feature Request - CFAMX-1083 Change Vendor Item File to Accommodate Vendor Entity Item Fields - INF-11079

          • Major - Major loss of function.
          • Closed

            Activity

              People

              • Assignee:
                david.nayyar David Nayyar (Inactive)
                Reporter:
                stacy.privalova Stacy Privalova
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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