When opening a Message it fails to open with Server Error in '/' Application: AttachmentFile with CheckSum does not exist
E.g.
Server Error in '/' Application.
--------------------------------------------------------------------------------
AttachmentFile with CheckSum 5d7963b2-f769-8124-5329-584d741c89e6 does not exist
Open the Message in Internet Explorer
http://archivemanager/ViewMessage.aspx?CheckSum=ceb1cea0-5a1c-b45b-7792-e5389aacbee5
2. Run the following query in SQL against the ArchiveManager database replacing the checksum number with the one you are searching for:
It should return the MessageID.
3. Then run the below (replace xx with the MessageID you found from the Checksum)
4. The attachmentType should be 5 which means it's a message, if it is 1 that means it's a File. It may return 0.
5. Then try this if it's 0 (replace xx with the messageID you found above)
update Attachment
set AttachmentType = 5
6. Open the Message from the Archive Manager WebUI and see if the issue is resolved.