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

Sales Processing Queues rising due to MXC_Forecast_GetOrderItemForecastByDateRangeWithProcessingTimes

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2023R2
    • Fix Version/s: CFA 2023R3
    • Component/s: Forecasting
    • Labels:
      None
    • VTask #:
      VTASK0515191
    • Root cause - Reason:
      Non-optimal code
    • Root Cause:
      Improvement made

      Description

      The same issue with the SP MXC_Forecast_GetOrderItemForecastByDateRangeWithProcessingTimes occurred again on 04/29/2023 after the fix was introduced in Production for Jira CFAMX-24694, can we get this issue investigated to find the root cause for having the Sales Processing Queues rising and the SP taking longer than expected time.

      Zendesk ticket created to address the issue : incident-3504426

      The fix was to recompile and killed off the old requests by the DB team.

       

        Attachments

          Issue Links

          Is Clone Of

          Customer Defect - CFAMX-25644 CLONE - Patch back R2 - Sales Processing Queues rising due to MXC_Forecast_GetOrderItemForecastByDateRangeWithProcessingTimes

          • Major - Major loss of function.
          • In QA
          is related to

          Feature Request - CFAMX-11540 Production Defects

          • Blocker - Blocks development and/or testing work, production could not run.
          • Open

          Customer Defect - CFAMX-24694 Sales Processing Queues rising due to MXC_Forecast_GetOrderItemForecastByDateRangeWithProcessingTimes

          • Major - Major loss of function.
          • Done

            Activity

              People

              • Assignee:
                charles.wheeler Charles Wheeler
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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