after reimport an Space within Confluence we hit this Bug.
Now i'm searching for a way to remove the dead links within Jira. Is it enought to delete the links within the Database Table "remotelinks", is there a script (JIRA CLI) which can be executed?
We're talking about 600+ Issues which contains missing links and manually deleting is not an option.
Found a solution with direct DB changes:
(Example from MySQL)
select rl.ID,rl.GLOBALID,rl.SUMMARY,rl.URL,rl.RELATIONSHIP,ji.ID,ji.summary,ji.PROJECT,ji.issuenum from remotelink rl JOIN jiraissue ji on rl.ISSUEID = ji.id where ji.PROJECT = ( SELECT ID FROM project WHERE pkey="$PROJECT") INTO OUTFILE '/tmp/wronglinks.txt';
Get the rl.ID and delete all wrong links directly within the Database (check that JIRA is not runnung and do a reindex after that).
If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot