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

2020R1(S3): Store Calendar-Investigate why two records with the same Longkey are inserted into tbTaskQueueMessage

    Details

    • Type: Sprint Defect
    • Status: Done (View Workflow)
    • Priority: Critical
    • Resolution: No Longer Required
    • Affects Version/s: CFA 2020R1
    • Fix Version/s: None
    • Component/s: Ordering
    • Labels:
      None
    • Sprint:
      CFAMX 2020R1 - SA Sprint 4, CFAMX 2020R1 Sprint 6

      Description

      Environment: JAT
      Build: Build # CFA - 20.1.0.2674
      Store: 01640 - St. Johns Town Center FSU
      User: System Admin
      Day: Tue, Oct 22th, 2019
      Page/URL: https://m.inform.jatesting.cfahome.com/#/Inventory/Order/Place/2105061
      Vendor: MBM

      Investigate why two messages are placed in tbTaskMessageQueue when the order is created from a Store Calendar schedule and not through the import.

      To reproduce issue:

      • Create an order schedule through the store calendar
      • Run the Create Scheduled Orders Job
        Results: two records in tbTaskQueueMessage with the same LongKey - tbTransactionSalesOrder.iTransaction_Num (Draft Order)

        Expected: One record to get created when the job runs:

        Attachments

        1. CFAMX-6247.sql
          0.9 kB
        2. screenshot-1.png
          screenshot-1.png
          119 kB
        3. screenshot-2.png
          screenshot-2.png
          23 kB

          Issue Links

            Activity

              People

              • Assignee:
                kevin.reid Kevin Reid (Inactive)
                Reporter:
                soma.dixon Soma Dixon (Inactive)
              • 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 - 1h Time Not Required
                  1h

                    PagerDuty

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