-
Bug
-
Resolution: Tracked Elsewhere
-
Medium (View bug fix roadmap)
-
None
-
6.4.5, 6.5.0, 6.6.0
-
None
-
6.04
-
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
-
-
- 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
[JSWSERVER-11169] Fixing NLS_SORT for Jira Agile queries
| Minimum Version | New: 6.04 |
| Workflow | Original: JAC Bug Workflow v2 [ 2854130 ] | New: JAC Bug Workflow v3 [ 2935528 ] |
| Status | Original: Resolved [ 5 ] | New: Closed [ 6 ] |
| Workflow | Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2542189 ] | New: JAC Bug Workflow v2 [ 2854130 ] |
| Workflow | Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1548581 ] | New: JIRA Bug Workflow w Kanban v7 - Restricted [ 2542189 ] |
| Labels | Original: fixme lexorank oracle warranty | New: affects-server fixme lexorank oracle warranty |
| Workflow | Original: JIRA Bug Workflow w Kanban v6 [ 908592 ] | New: JIRA Bug Workflow w Kanban v6 - Restricted [ 1548581 ] |
| Workflow | Original: GreenHopper Kanban Workflow 20141014 [ 746854 ] | New: JIRA Bug Workflow w Kanban v6 [ 908592 ] |
| Workflow | Original: GreenHopper Kanban Workflow v2 [ 727346 ] | New: GreenHopper Kanban Workflow 20141014 [ 746854 ] |
| Remote Link | New: This issue links to "Page (Extranet)" [ 80221 ] |
| Resolution | New: Tracked Elsewhere [ 15 ] | |
| Status | Original: Open [ 1 ] | New: Resolved [ 5 ] |