How to find Confluence Page based on Link

[Jackson Farnsworth]

In this atlassian knowledge base article, Cannot Restore XML Backup due to Value too Large for Column, how I am supposed to find the source page of the links shown in the SQL Query so I can shorten the link?

[Bill Bailey · Accepted solution]

You checked the log files to find the page ID that is causing the issue?

[Jackson Farnsworth]

I don't have any instances of it showing up in the logs that I can see, only in the log analyzer under the troubleshooting tab in admin settings.

[Bill Bailey]

If the log analyzer is flagging it, then it is in the log. BUT the logs are a bit cryptic. Start looking at lines with ERROR.

[Jackson Farnsworth]

And that will work for the few that are in the logs, but I have 15 pop up with the database query provided by the article. What I want to know is if there's a way to find all of them without waiting for someone to find the page and then have it pop up in the log.

[Bill Bailey]

Doesn't the KB article describe a method or running a query against the database of the source space to find long links? Won't that work?

[Jackson Farnsworth]

There is the query, which was the one I was referring to above, but most of it's fields are the destination of the link itself, not the source. There might be another table with a matching key to one of the other fields, but I don't know what that table might be. Non-link destination fields are:

• LINKID
• CONTENTID
• CREATOR
• CREATIONDATE
• LASTMODDATE

My best bet is that LINKID or CONTENTID is used in another table, but I don't know a good way to search for it's use.

[Bill Bailey]

Yes, but inst the fix to edit the destination page link (destpagetitle), and that doing so will resolve the issue?


[Jackson Farnsworth]

Oh, misread that, thought it meant go to the page in Confluence and change it there. All sorts of confusion. Thanks for clearing that up.