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

        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