SQL update for this is the best approach. It's important that from a case perspective that everything matches identically. IE the system properties (mxe.doclink.doctypes.defpath, mxe.doclink.doctypes.topLevelPaths, etc.), DOCTYPES (Manage Folders), and DOCINFO (the individual attachments) need to reference everything the exact same way. IE \\maximo0xp\DOCLINKS will be handled differently than \\maximo0xp\doclinks and will lead to issues even if you are on platforms that are not case sensitive.
I used to have a SQL update statement that went through DOCINFO to update all the attachments dynamically but a really simple version that would likely do what you need would be this:
update docinfo set urlname=replace(urlname,'\\maxmo00p\DOCLINKS\','\\maxmo0Xp\DOCLINKS\') where urltype='FILE' and urlname like '\\maxmo00p\DOCLINKS\%';
------------------------------
Steven Shull
IBM
------------------------------
Original Message:
Sent: 01-25-2024 17:54
From: Diane Nohner
Subject: Maximo Server upgrade - Attachments update old attachments for the new servers
Maximo Server upgrade - Attachments how do you update old attachments for the new servers - error when trying to view the old attachments
Configuring the doclinks, via instructions on new servers. New attachments are viewable
Copied the folder DOCLINKS to the new server from the old server
updated the the manage folders for the new server
The manage library has the old server name \\maxmo00p\DOCLINKS\ATTACHMENTS\20230426_075455.jpg
tried updating a attachment via the library to the new server name \\maxmo0Xp\DOCLINKS\ATTACHMENTS\20230426_075455.jpg
How do you bulk update the attachments?
Not Found
The requested URL /ATTACHMENTS\20230426_075455.jpg was not found on this server.
IBM_HTTP_Server at maxmo03p Port 80
#Administration
#EverythingMaximo
#WorkManagement
------------------------------
Diane Nohner
City of Minneapolis
------------------------------