Hello All,
We have faced a strange scenario where recently we observed that there have been couple of cases where the attached documents are missing from assets and we confirmed the same as one of our development environments was not refreshed since a long time and we could see the documents attached in the assets which the user reported.
Also,the user confirmed that there is no way that they could have deleted the attachments as there are lot of assets and they have not done it even by mistake also.
We checked the attachments on the server and we can see that the documents does exist in the attachments directory but they are no longer linked to the assets.What can be the way to solve this issue as a temporary work around,do we have to run an insert query on doclinks object and proceed?Also,how many objects would have got affected as we would have to prepare the necessary scripts.
Also,our challenge is how to find out the missing assets and other objects(work orders,locations,etc) where the attachments could have possibly got removed.
Kind assistance required.
#EverythingMaximo------------------------------
Mahadevan Ramakrishnan
------------------------------