Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-60890

DB session parameters depend on DB server OS language

    XMLWordPrintable

Details

    Description

      "Instance Health" detected a Collation problem with the following error message: The session collation of: 'GERMAN' is unsupported by JIRA

      Each time JIRA opens a DB session on an Oracle DB the session does not take the nls_* parameters set in the DB or the DB schema but from informations it gets from the OS.
      (i.e. set nls_sort=BINARY' on DB and and DB session will be changed within the session to nls_sort=GERMAN' just because the DB is installed on a German Windows2012)

      In my opinion the language of the OS must not influence the DB session parameters.

      Our selfmade solution is:
      Creating a session trigger on the DB which alters the parameter back to nls_sort=BINARY'

      Please fix this bug or document it in the installation description.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              fa711d2ef344 Thomas Ransberger
              Votes:
              9 Vote for this issue
              Watchers:
              18 Start watching this issue

              Dates

                Created:
                Updated: