Insight import UI displays wrong weekdays when using Cron Expression

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Low
    • 4.20.2
    • Affects Version/s: 4.20.0, Mindville - Pre Bundled
    • None
    • 1
    • Severity 2 - Major

      Issue Summary

      Insight import UI displays wrong weekdays when using Cron Expression.

      Steps to Reproduce

      1. Create an Object Schema
      2. Create any Insight Import Configuration (CSV, Discovery or any other)
      3. Tick "Automatically synchronize" and set the following Cron Expression

        0 27 12 ? * 3


      4. Insight UI translates to 'At 12:27 PM, only on Wednesday'
      5. Cron is triggered on Tuesday instead of on Wednesday

      Expected Results

      Insight UI should display 'At 12:27 PM, only on Tuesday'.
      Wednesday field is 4 and Tuesday is 3

      Ref: http://www.quartz-scheduler.org/documentation/quartz-2.3.0/tutorials/crontrigger.html

      Actual Results

      Insight Displays the wrong day (Wednesday) when the import will be triggered.

      Workaround

      Instead of using Day-of-week field, to avoid confusion, use for example, “MON,WED,FRI” in the day-of-week field. For this scenario would be:

      0 27 12 ? * TUE

        1. image-2021-10-26-15-08-13-890.png
          140 kB
          Pablo Bartolome
        2. image-2021-10-26-15-10-19-089.png
          255 kB
          Pablo Bartolome
        3. image-2021-11-02-11-51-25-675.png
          5 kB
          François Dénommée

            Assignee:
            François Dénommée (Inactive)
            Reporter:
            Pablo Bartolome (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: