When trying to open an attachment through the website in Archive Manager, you may get an error saying that the attachment cannot be found. After looking through the attachmentfile table in SQL and determining the location of the file, you discover that the message is still intact but still cannot be located.
In situations where attachments are not available through the Archive Manager website yet still available through the data store as discovered through navigating through to the exact location, the issue may be due to the storagelocation share specified in the StorageLocation table in SQL.
In order to access attachments, the attachment (data) folder that was specified to house the attachments has to have a share applied to it in order for the website to be able to know where to look for them. If this share is removed or is specified incorrectly in the Storage Location table in SQL, then the attachments will not be accessible
To check that Archive Manager can access the attachment store:
1. Open the Archive Manager Administration site and navigate to Storage location
2. Make a note of the path in the Connection String field, e.g. \\servername\ArchiveManagerAttachmentStore
3. Logon to the archive manager server as the archivemgr_service account and browse to the share noted above.
4. If the share can be accessed try to create a new txt file, edit and then delete it. If these actions cannot be performed the permissions need to be checked.
If the share does not exist and need In order to make the attachments available again, you will need to do the following:
1. Create a share on the Data folder where the attachments are currently housed.
2. Set the following Share Permissions:
Everyone - Full Access
3. On the Security tab set the following permissions:
Administrators - Full Access,
ArchiveManagerServiceUsers - Full Access
4. Open SQL Studio Manager and check the Storage Location Table. Verify if the share specified can be reached from the Archive Manager server. If no share exists in this table or an incorrect share exists then add the new share that was created in the following format: 'DATA=\\SERVERNAME\SHARENAME'. Verify that the share can be accessed successfully from the SQL server as well as the Archive Manager server. Once this is set in place then the attachments should open up again for messages in the Archive Manager website.
In order to determine the physical location you will need to cross reference multiple SQL tables. Here are the necessary steps:
1. Take the checksum of the message containing the attachment.
