Unable to delete duplicate Application links on the Application Navigator

[Amos Nung]

I have duplicate links between Confluence and Jira. The duplicate links are shown only on Jira and not Confluence. Both Confluence and Jira are on the same server and the database is also on the same server. 

I have looked at the instruction in this link but no success. Remove Application Navigator entry from Jira server database

I have tried the following query but no results were shown:

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

I am lead to suspect the propertytext is not the correct table. 

[Earl McCutcheon]

Hello @Amos Nung ,

The SQL query in the KB is looking for the value '%baseUrl%' rather than the actual base URL to your confluence site,  do you get a result when inputting the select as:

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

Regards,
Earl

[Amos Nung]

The output I get from the query: 

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

This is the output I get when I do this query:

SELECT *
FROM JIRA.propertytext
WHERE propertyvalue LIKE '%baseUrl%';

[Earl McCutcheon]

Hi @Amos Nung ,

Thanks for the update and you are going to want to copy the entire string from the 'propertyvalue' column for ID 20600 and drop it in a text editor of your choice and then edit out the line with the section for the duplicated link you are trying to remove.  

In the KB  Remove Application Navigator entry from Jira server database for the example the line with id=5 was removed, then reuploaded, but this will be different for your setup.

NOTE: While this is a relatively save DB modification and a live DB edit might not cause any issue, It is still always recommended to make sure to follow best practices safety precautions on production data, like shutting down the Jira Service before making the DB edit and take a DB backup in case something does go wrong in the update to allow for a rapid recovery.

Also as a quick side note, that when you update the line make sure that you have the full context for everything that you want to keep, as the update command in the KB is a full overwrite of the field:

UPDATE propertytext SET
propertyvalue='<EVERYTHING THAT YOU WANT TO KEEP>'
WHERE ID = 20600;

Regards,
Earl

[Amos Nung]

Hi @Earl McCutcheon 

After looking into the full text of the query I get two ID's both of which are valid urls. It is not showing what I would assume would be the repeated urls. The information below is the results:

id":"1","url":"http://confluence.cobnet.org:8080/secure/MyJiraHome.jspa","applicationName":"City Of Bryan - IT Jira","allowedGroups":[]},{"applicationType":"generic","hide":false,"displayName":"City of Bryan - IT Confluence","editable":true,"self":false,"id":"2","url":"https://confluence.cobnet.org:8443/confluence","allowedGroups":[]}]