Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-5943

Date calculation through timezones causes invite loading loop in CE BI & PRD 7.1

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Rejected
    • Affects Version/s: 7.1.0 GA
    • Fix Version/s: Backlog
    • Component/s: Report Generation
    • Labels:
      None
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Browser:
      Google Chrome 48.x, Mozilla Firefox 43.x
    • Operating System/s:
      CentOS 7.x
    • Steps to Reproduce:
      Hide

      1. Set a CE PRD 7.1 date parameter to have a timezone of `Australia/Sydney` and display type of `Date Picker`, ie call it `DateInput`
      2. Setup a dependant parameter, ie with a type of `String` and default value of `=([DateInput])`
      3. Save the report, load it into CE BI server 7.1 and open it
      4. Select a date that should be in AEST (my example was 2017-09-30)
      5. Now select a date that is in AEDT (my example was 2017-10-07)
      6. You'll get an infinite refreshing

      The bug seems to happen when traversing a timezone with a dependant parameter.

      Show
      1. Set a CE PRD 7.1 date parameter to have a timezone of `Australia/Sydney` and display type of `Date Picker`, ie call it `DateInput` 2. Setup a dependant parameter, ie with a type of `String` and default value of `=( [DateInput] )` 3. Save the report, load it into CE BI server 7.1 and open it 4. Select a date that should be in AEST (my example was 2017-09-30) 5. Now select a date that is in AEDT (my example was 2017-10-07) 6. You'll get an infinite refreshing The bug seems to happen when traversing a timezone with a dependant parameter.

      Description

      We have a suite of PRD reports that take a date (via a datepicker) parameter on a CE BI 7.1 instance created using PRD 7.1. The parameter is a `date` type and has a timezone of `Australia/Sydney`. The `Australia/Sydney` timezone changes to AEST or AEDT depending on the time of year [please see this link for details on when the timezone change occurs for Australia/Sydney: https://www.timeanddate.com/time/zone/australia/sydney]. The date parameter also has a dependant parameter that is a function of it's value.

      Ever since a local timezone change (daylight saving, AEST -> AEDT [Sydney time]) we've noticed some strange behaviour when the date picker has to traverse across a timezone.

      For example, if you initially select a date in AEST (example, 2017-09-30) then select a date that should be in AEDT (example, 2017-10-07) the BI server gets itself into an infinite refresh loop.

      • I've attached a GIF of this bug occurring and also the accompanying simple test PRD file that is enough to reproduce the error. *

      FYI: This bug doesn't seem to exist in 5.4.

      [^attachment-name.zip]
      [^attachment-name.zip]

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            benletchford Ben Letchford
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: