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

Vendor Item Import with R1 updates - import fails for some expense items

    Details

    • 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

      Description

      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.

       

      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|

        Attachments

        1. CFAMX-2634-Explanation.sql
          2 kB
          David Nayyar
        2. VENDORITEM_20190221_1525A.csv
          347 kB
          Stacy Privalova
        3. VENDORITEM_20190225_1623A.csv
          334 kB
          Stacy Privalova
        4. VENDORITEM-Trace_20190220_202729.log
          2 kB
          Stacy Privalova
        5. VENDORITEM-Trace_20190227_081501.log
          337 kB
          Stacy Privalova

          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.