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

Cannot import new allocations for the same day after End Allocation

    Details

    • Type: Testing Defect
    • Status: Done (View Workflow)
    • Priority: Critical
    • Resolution: Completed
    • Affects Version/s: CFA 2020R1
    • Fix Version/s: None
    • Component/s: Allocations
    • Labels:
      None

      Description

      • Environment Testing
      • Store 00440
        The allocations below were created using the file AllocationsImport5.csv

        I used the End Allocation button to end all of these allocation on 1/16.

      I then tried to import file AllocationsImport6.csv , but in the log, it through the following message:

      Event : 1/16/2020 5:53:29 PM : Allocation Import Data Import on 1/16/2020 5:53:29 PM : Starting Data Import
      Event : 1/16/2020 5:53:29 PM : Data Import on 1/16/2020 5:53:29 PM : Source File W:\Macromatix\SiteData\CFATesting\DataImports\Allocation\AllocationsImport6.csv successfully validated
      Event : 1/16/2020 5:53:29 PM : Data Import on 1/16/2020 5:53:29 PM : Preparing Delimited Import Source
      Event : 1/16/2020 5:53:29 PM : Data Import on 1/16/2020 5:53:29 PM : Import source opened: W:\Macromatix\SiteData\CFATesting\DataImports\Allocation\AllocationsImport6.csv
      Event : 1/16/2020 5:53:29 PM : Data Import on 1/16/2020 5:53:29 PM : Header record succesfully parsed
      Event : 1/16/2020 5:53:29 PM : Data Import on 1/16/2020 5:53:29 PM : Record #0 parsed : 00440|101090|10|4|2020/01/16|2020/02/29
      Error : 1/16/2020 5:53:29 PM : Allocation Import Data Import on 1/16/2020 5:53:29 PM : Import Record #1: For StoreNumber: 269, VendorItemCode: 101090, AllocationStart: 1/16/2020 12:00:00 AM, AllocationEnd: 2/29/2020 12:00:00 AM, An allocation has already started for this item. Stop the existing allocation for this product first.
      Event : 1/16/2020 5:53:29 PM : Data Import on 1/16/2020 5:53:29 PM : Record #1 parsed : 00440|101016|20|4|2020/01/16|2020/02/29
      Error : 1/16/2020 5:53:29 PM : Allocation Import Data Import on 1/16/2020 5:53:29 PM : Import Record #2: For StoreNumber: 269, VendorItemCode: 101016, AllocationStart: 1/16/2020 12:00:00 AM, AllocationEnd: 2/29/2020 12:00:00 AM, An allocation has already started for this item. Stop the existing allocation for this product first.
      Event : 1/16/2020 5:53:29 PM : Data Import on 1/16/2020 5:53:29 PM : Record #2 parsed : 00440|101091|15|4|2020/01/16|2020/02/29
      Error : 1/16/2020 5:53:29 PM : Allocation Import Data Import on 1/16/2020 5:53:29 PM : Import Record #3: For StoreNumber: 269, VendorItemCode: 101091, AllocationStart: 1/16/2020 12:00:00 AM, AllocationEnd: 2/29/2020 12:00:00 AM, An allocation has already started for this item. Stop the existing allocation for this product first.
      Event : 1/16/2020 5:53:29 PM : Data Import on 1/16/2020 5:53:29 PM : Record #3 parsed : 00440|030004|5|4|2020/01/16|2020/02/29
      Error : 1/16/2020 5:53:29 PM : Allocation Import Data Import on 1/16/2020 5:53:29 PM : Import Record #4: For StoreNumber: 269, VendorItemCode: 030004, AllocationStart: 1/16/2020 12:00:00 AM, AllocationEnd: 2/29/2020 12:00:00 AM, An allocation has already started for this item. Stop the existing allocation for this product first.
      Event : 1/16/2020 5:53:29 PM : Allocation Import Data Import on 1/16/2020 5:53:29 PM : Data Import Complete

      *Defect* - we should be able to send in a new allocation in per AC 12 in the FRD: Confirm the End Allocation Early for All Stores option still exists for inventory items.

      Thoughts:
      Looking in tbAllocation, the end date of the allocations that I ended, using the End Allocation button is 2020-01-16 00:00:00

      Could it be that when we are importing the new allocations, the start date of 1/16, translates into 2020-01-16 00:00:00, which is the same as the end time, so we end up with an overlap?

      From the log: "An allocation has already started for this item. Stop the existing allocation for this product first."

        Attachments

        1. screenshot-1.png
          screenshot-1.png
          68 kB
        2. AllocationsImport5.csv
          0.3 kB
        3. AllocationsImport6.csv
          0.3 kB
        4. screenshot-2.png
          screenshot-2.png
          17 kB
        5. AllocationsImport_00442JATv2.csv
          0.3 kB
        6. AllocationsImport_00442v1.csv
          0.3 kB
        7. image-2020-02-05-16-30-13-875.png
          image-2020-02-05-16-30-13-875.png
          58 kB
        8. screenshot-3.png
          screenshot-3.png
          59 kB
        9. screenshot-4.png
          screenshot-4.png
          28 kB
        10. Validation-Test.sql
          2 kB

          Issue Links

            Activity

              People

              • Assignee:
                Gareth.Leibbrandt Gareth Leibbrandt (Inactive)
                Reporter:
                charles.wheeler Charles Wheeler
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2h Original Estimate - 2h
                  2h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 16.5h
                  16.5h

                    PagerDuty

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