[JSWSERVER-11169] Fixing NLS_SORT for Jira Agile queries

Type: Bug
Resolution: Tracked Elsewhere
Priority: Medium (View bug fix roadmap)
Fix Version/s: None
Affects Version/s: 6.4.5, 6.5.0, 6.6.0
Component/s: None
Labels:
- affects-server
- fixme
- lexorank
- oracle
- warranty

Introduced in Version:
6.04
Bug Fix Policy:
View Atlassian Server bug fix policy

JAG needs a better way of fixing the NSL_SORT in Oracle DB.
Right now we are doing a forced NSL_SORT over the RANK column dropping the performance.

Possibilities:

Document this
Do a migration script that force the database to NLS_SORT=Binary
Try to fix the index or the column to use the proper NLS_SORT.

The difference between this ticket and ~~GHS-11162~~ is that we should take off the NLS_SORT while the other is about removing the function from the code.

blocks

JSWSERVER-11162 Indexing after installing JAG for the first time takes ages.

Closed

SW-746 Failed to load

is superseded by

JRASERVER-39970 Jira needs to check the collation of the DB before it starts

Closed

is caused by: SW-432 Failed to load

mentioned in: Page Failed to load

No work has yet been logged on this issue.

Assignee:: Unassigned

Reporter:: Carlos Khatchikian

Affected customers:: 0 This affects my team

Watchers:: 1 Start watching this issue

Created:: 10/Sep/2014 7:07 AM

Updated:: 27/Mar/2019 11:26 PM

Resolved:: 17/Sep/2014 6:00 AM

Jira Software Data Center

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates