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

RDS - Vault - SP_SuggestedOrderExport_Test yields 100k rows with a null line id

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Closed/Resolved by Caller
    • Affects Version/s: CFA 2022R5
    • Fix Version/s: None
    • Component/s: Reports
    • Labels:
      None
    • VTask #:
      VTASK0503342

      Description

      The team has a question about the Suggested Order SP:

      We expect the SP and query in the attached file to have no rows with a NULL Line ID, but the query returns over 100k instances of this field being NULL.

       Example of one record:

      (6215108, 7228761, null, 00316, 2022-11-04 07:34:55.383, MCLANE, 21586, 2022-11-04 07:34:55.383, null, null, null, 2022-11-03 07:10:51.533, 2022-11-09 05:30:00, FALSE, FALSE, Placed, Suggested Values Used, 4.93, null, raquel.garciarosas1, raquel.garciarosas1, null, null, 101417, BAG, SIDE SALAD/WRAP C, 0.00, 0.49000000000000005, 1, null, 0, 0, 0, null, null, null, t, null, null, null, 2022-11-04 08:35:00, null)

        Attachments

        1. Screen Shot 2022-11-04 at 3.17.03 PM.png
          45 kB
          Wesam El-Gendy
        2. SO Stored Proc
          10 kB
          Wesam El-Gendy

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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