Details
-
Bug
-
Resolution: Unresolved
-
Medium
-
None
-
7.1.4, 8.22.2
-
Oracle DB 11g installed on Windows2012 Server (German OS)
JIRA 7.1.4 (Server)
-
7.01
-
13
-
Severity 2 - Major
-
0
-
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.