We were upgrading JIRA Software from 7.4 to 7.13.
We used Oracle driver ojdbc8.jar that signed in with
Database Driver : Oracle JDBC driver - 126.96.36.199.0
Before upgrade procedure starts we got following error:
2019-01-30 15:16:00,320 JIRA-Bootstrap ERROR [c.a.jira.upgrade.UpgradeLauncher] No upgrade is being performed due to detected inconsistencies. Your database is using an unsupported collation
Calling the URL in Browser gave us some information about changing Collation in Postgres.
Oracle Database Collation seemed to be GERMAN
Found following article: https://confluence.atlassian.com/jirakb/health-check-database-collation-in-oracle-943951532.html -- This is probably the check that is done for upgrade, isn't it?
This had no effects.
Do I have other possibilities than user.language and user.country, e.g. in connection string?
How to decide if we have to change Oracle database?
How can following three statements show what to change on database?
SELECT * FROM nls_database_parameters WHERE parameter IN ('NLS_SORT');
SELECT * FROM nls_session_parameters WHERE parameter IN ('NLS_SORT');
SELECT COALESCE(value, (SELECT value FROM nls_database_parameters WHERE parameter = 'NLS_SORT')) FROM nls_session_parameters WHERE parameter = 'NLS_SORT'
We have the same issue.
Using the article at https://confluence.atlassian.com/jirakb/database-collation-health-check-fails-in-jira-server-with-oracle-database-828788420.html and running each of the SQL statements in order, I've found that:
nls_database_parameters = BINARY
nls_session_parameters = NORWEGIAN
...and the last statement also returns NORWEGIAN.
I'm wondering if there's a safe way to change the session parameter live or if we have to do a fresh import from the XML backup or similar to get this sorted.
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events