How to remove wrong Confluence links within Jira issues?

[Patrick Schneider]

Hi,

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.

Regards

Patrick

[Patrick Schneider · Accepted solution]

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).