Repair broken SAP wiki links in all BOB posts.

about
1

I write this as a result of coming across a dead SAP wiki link in a post: https://bobj-board.org/t/176208/3

I found that:

  1. SAP wiki links prefixed with “https://wiki.sdn.sap.com/wiki/display/BOBJ/” no longer work.
    e.g. https://wiki.sdn.sap.com/wiki/display/BOBJ/Access+to+previous+row+values

  2. Editing the SAP wiki link slightly, so it is prefixed with “http://wiki.sdn.sap.com/wiki/display/BOBJ/” are redirected at the SAP end to new generic page location.
    e.g. http://wiki.sdn.sap.com/wiki/display/BOBJ/Access+to+previous+row+values

  3. Editing the SAP wiki link slightly more, SAP wiki links prefixed with “http://wiki.sdn.sap.com/wiki/display/EIM/” work.
    e.g. http://wiki.sdn.sap.com/wiki/display/EIM/Access+to+previous+row+values

This appears to be a widespread problem on BOB as googling:

"https://wiki.sdn.sap.com/wiki/display/BOBJ/" site:forumtopics.com

returns almost 10,000 hits. Should these dead SAP wiki links be updated to make usable again in BOB, or is this a SAP issue? Discuss…

Darth Services :uk: (BOB member since 2007-11-20)

2

If it’s an update that can be managed via a SQL update query, then I think it could be done. If it’s something that has to be done manually, then clearly it’s a no-go. :slight_smile:

One thing about the 10,000 hits though… one of the issues with the software used for BOB is there are multiple URLs for the same “page” in many cases. I can reference a post within a topic, a page within a topic, or the topic itself. There is also the regular version and the print version. So the actual number of posts that include SAP wiki links is probably far fewer. (Side note: This is actually a problem for Google that has been addressed in newer versions of the software to some extent.)

If I get a chance I will run a count and see if I can get the real number.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Here’s the total exposure, based on looking at the post text:

mysql> select count(post_id) from ...
    -> where post_text like '%wiki.sdn.sap.com/wiki/display/BOBJ%';
+----------------+
| count(post_id) |
+----------------+
|            720 |
+----------------+
1 row in set (3.97 sec)

mysql>

Dave Rathbun :us: (BOB member since 2002-06-06)