Need help with application links on the Application Navigator.

[Amos Nung]

Background: I recently configured https on Jira and Confluence. SSL is enabled for both applications. Jira is running on v8.8.0. Confluence and Jira is running on the same server. 

Problem: After configuring https on Jira, there are multiple links in the application drop down list.

Steps Taken: I have looked into deleting the links but only have the option to do so for one of them. I have attached photos for clarification.

I would like to have only two links shown in the drop down.

Please let me know if I need to clarify anything.  

[Petter Gonçalves]

Hello @Amos Nung

Thank you for reaching out.

The behavior you are facing where duplicate links are displayed in your application navigator and cannot be deleted is caused by some scenarios, as described in the documentation below:

Remove Application Navigator entry from Jira server database 

To properly remove the app links as you need, you can delete them directly in the database as explained in the documentation.

P.S: Always back up your data before performing any modification to the database.

Let us know if you have any questions about the steps provided there.

[Amos Nung]

Per the instructions from the link. I have tried to input various queries, based off the template query so we can see the list, but neither query worked.

"SELECT * FROM propertytext WHERE propertyvalue LIKE '%baseUrl%';"

1. SELECT TOP (1000) [ID]
,[propertyvalue]
FROM [JIRA].[JIRA].[propertytext]

2.SELECT * FROM jira.jira.propertytext
WHERE jira.jira.propertyvalue
LIKE '%https://confluence.cobnet.org%';

I would guess the second query would be closest but not sure what I am missing.

Should the baseurl include the https? or port number?

[Daniel Ebers]

This can be sometimes a tricky one and as long as it comes "only" to a select the best guess is to look at the database and fiddle around with the exact SELECT statement (SQL).

In case you do not wan't to dive into database regularly you can hide the somewhat "doubled" entries from UI. This is not much nicer, no question - but saves a lot of time going into database debugging tasks.

Cheers,
Daniel