Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-1631

[JIRAALIGN-1631] Team Room: Date format issue

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Highest
    • 10.74, 10.75
    • 10.72
    • team - team room
    • None
    • 1
    • Severity 1 - Critical
    • X-Men - SCORP6

    Description

      Issue Summary

      On-prem JA users are getting logged out when accessing team room. This occurs for on-prem JA installation with a date format of dd/mm/yyyy and on the first 5 days of the month.

      Steps to Reproduce

      1. Set the region of your JA instances (webserver) to UK (Control Panel > Clock and Region > Region)
      2. In Region menu, set Format to English (United Kingdom).
      3. Click Administrative tab > Change system locale... and change it to English (United Kingdom)
      4. Your Windows will restart now with the new settings.
      5. Navigate to team room (modify server date to first 5 days of the month)

      Expected Results

      User should be able to view server room successfully with the correct data.

      Actual Results

      The user gets logged out and an exception is captured in the logs

      The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
      

      Workaround

      Set the Locale ID in IIS to 1033 (en_us)

      Attachments

        1. Copy Region Settings.png
          74 kB
          Chris Jeggo
        2. image-2020-06-16-16-00-45-164.png
          29 kB
          Bohdan Kuts
        3. Screen Shot 2020-06-16 at 5.57.24 pm.png
          65 kB
          Leo Soronio
        4. Screen Shot 2020-06-17 at 9.26.44 am.png
          31 kB
          Leo Soronio
        5. Screen Shot 2020-06-17 at 9.29.52 am.png
          27 kB
          Leo Soronio

        Activity

          People

            kbyrd@atlassian.com Kyle Byrd (Inactive)
            lsoronio@atlassian.com Leo Soronio
            Votes:
            1 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Backbone Issue Sync