Project Shortcuts, Add Links do not appear for specific Projects
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
When accessing a Project, the Project Sidebar is missing one or both of the following items:
Project Shortcuts
the 'Add Links' option
Diagnosis
Run the following SQL query for the <project_id> in question:
1
SELECT * FROM "AO_550953_SHORTCUT" WHERE "PROJECT_ID" = '<project_id>';If you see entries that have no name or shortcut URL in the results, you have the situation described in this KB article. For example, in the query results below entries 3 and 4 are responsible for causing this issue.
ID | NAME | PROJECT_ID | SHORTCUT_URL | URL | ICON
----+--------------------------+------------+---------------------------------------------------------------------+-----+------
1 | Project management ideas | 11100 |
https://docs.atlassian.com/jira/jcore-docs-097/Project+management
| |
2 | Working in a project | 11100 |
https://docs.atlassian.com/jira/jcore-docs-097/Working+in+a+project
| |
3 | | 11100 | | |
4 | | 11100 | | |
Cause
Shortcuts with no name or URL are preventing display of the Project Shortcuts links. Removing these null shortcuts will restore the missing shortcuts.
Solution
To resolve this issue the null shortcuts will need to be removed from the database directly. To this:
Shut down Jira and take a database backup.
⚠️ It is strongly recommended to make a backup before making any direct database modifications to ensure there is a restore point if one becomes necessary.
Run this query for each Project experiencing the issue:
1SELECT * FROM "AO_550953_SHORTCUT" WHERE "PROJECT_ID" = '<project_id>';Run this query for each id missing a name and shortcut URL found in step 2:
1DELETE FROM "AO_550953_SHORTCUT" WHERE "PROJECT_ID" = '<project_id>' AND "ID" = '<shortcut_id>';Restart Jira and validate that your shortcuts and the "add link" option are appearing again.
Was this helpful?