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

CLONE 2020R2.1 - Staging - Forecast Import not working

    Details

    • Sprint:
      CFAMX 2020R4 Sprint 2

      Description

      While performing the Smoke Test on Staging today, upgraded to 2020R2.1, I noticed that when trying to pull in a forecast from the Request AWS page, that it wouldn't work.
      I have spent some more time on this, and it appears that the forecasts are not imported into the environment.
      We upgraded last night and this seems to have started this morning.

      I was investigating a similar, but maybe different, issue in JAT yesterday, CFAM-10826.

      When running this SQL against Staging, I am seeing errors.

      select * from tbAudit with(nolock)
      where EventEntityID in (123, 1041)
      and AuditDateTime > '2020-07-07'
      and AuditCategoryID = 23
      order by auditid
      

      These are the error messages that I am seeing:

      * Error getting or saving forecast data for 00198 from https://api.scforecast-test.cfadevelop.com/v1/forecast/status/00198?fromDate=07-15-2020&toDate=07-27-2020 to W:\Macromatix\SiteData\CFAStaging\DataImports\Forecast\Forecast_{storenumber}_{forecastdate}.xml: Can't Parse 0 as ForecastingSales
      * Error getting or saving forecast data for 01919 from https://api.scforecast-test.cfadevelop.com/v1/forecast/status/01919?fromDate=07-15-2020&toDate=07-27-2020 to W:\Macromatix\SiteData\CFAStaging\DataImports\Forecast\Forecast_{storenumber}_{forecastdate}.xml: Can't Parse 0 as ForecastingSales
      

      To try and determine if this was due to the non-production endpoint, or something on our side, I did swap over the endpoints to point at Prod, and it too failed, which makes me think that this is something in our code.

      select * from tbAudit with(nolock)
      where AuditID in (16380, 16381)
      

      Note: this appears to be working in 2020R3 (Testing), but not in JAT (Trunk) and Staging (2020R2.1)

        Attachments

        1. image-2020-07-07-16-07-34-222.png
          69 kB
          Will Englefield
        2. image-2020-07-07-16-08-01-105.png
          12 kB
          Will Englefield
        3. image-2020-07-07-16-13-33-445.png
          65 kB
          Will Englefield
        4. screenshot-1.png
          52 kB
          Will Englefield
        5. screenshot-2.png
          48 kB
          Will Englefield
        6. Test_After.png
          58 kB
          Will Englefield
        7. Test_Before.png
          59 kB
          Will Englefield

          Issue Links

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h
                  4h
                  Remaining:
                  0h
                  Logged:
                  Time Not Required
                  Not Specified

                    PagerDuty

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