03-07-2011 06:04 PM
I'm in the process of moving archives from one Vault store to another on the same server. I was having trouble with the Move Archive feature, so I decided to use the "export to PST / import from PST" method. Everything seemed to work except the folder icons in Archive Explorer for Calendar and Sent Items are normal folder icons, not the special ones like in Outlook. The big issue is that the user cannot see who she sent an email to in Sent Items unless she opens each email up. Any suggestions to correct this?
EV 9.0.1 in Windows 2008 R2
Article used:
http://www.symantec.com/business/support/index?page=content&id=TECH35696&key=50996&actp=LIST
Solved! Go to Solution.
03-08-2011 09:18 AM
I did a search for FOLDERICON and found this tech article. I'm hardly work with SQL, but this looks similar to what you guys mentioned, correct? The goal is to change the FOLDERICON field to their correct settings (9 for Sent Items, 1 for Inbox, 2 for Calendar, and 4 for Deleted Items).
http://www.symantec.com/business/support/index?page=content&id=TECH35709&key=50996&actp=LIST
03-07-2011 06:26 PM
are the items actually in the \sent items folder or are they in a different folder like \PST Import\Sent Items?
03-07-2011 06:35 PM
They are in the regular root of Sent Items. I just noticed that the Inbox icon is also normal. I believe I'm running something similar to this. I ran the SQL statement in SQL 2008, but I can't edit the field from 0. How do I do this in SQL 2008?
http://www.symantec.com/business/support/index?page=content&id=TECH52763
03-08-2011 01:04 AM
The TN you have reference is focused towards an issue with the 'top of the infomation store' and the overall structure of your Archive.
The icons for calender or sent items are directly managed by, surprisingly, the value of the 'foldericon' field. so you need to confirm the correct 'rootidentity' then find the correct folderid, then run an 'update' script to change the specific value for the exact folder in the exact archive that needs changing.
There are probably quicker ways through SQL, for example if you return all rows with a foldername = 'calender' which have a foldericon value of < 2. that will show you how many archive calenders are affected.
I say this but I would seriously think about opening a support call if you are questioning how to change a value in SQL.
The icon issue has been seen in very few cases where, mail migrations or where other mass mail movement has occured, the migration process seems to affect the trigger that we look at to assign the correct folder icon to the folder when running the archive.
End story, if you are good with SQL you want to find the correcct folderid which is having the issue, using the archiveid and rootidentity.
Or if you want to blanket job it, something akin too
use enterprisevaultdirectory
Update dbo.ArchiveFolder
Set FolderIcon =2
Where FolderName = 'Calendar'
AND FolderIcon = 0
As always, before making manual edits to your EV SQL configuration, stop any archiving procedures, backup your db and system , committ the changes, test it works, then start archiving again.
03-08-2011 07:05 AM
gIn SQL Server 2008 you have to run SQL Querys if its past the 200 rows, because to edit a SQL database directly like you would have in 2005 or 2000, you would right click the table and press Edit Top 200 Rows, but the chances of your entries being in the top 200 are slim to none
Updating the foldericon won't make a bit of difference at all.
The query you would use would be the following though
UPDATE ArchiveFolderView SET FolderIcon = 9 WHERE FolderName = 'Sent Items' AND FolderIcon = 0 AND ArchiveVEID = (SELECT AFV.ArchiveVEID FROM ArchiveFolderView AFV, Archive A, Root R WHERE AFV.ArchiveVEID = R.VaultEntryID AND R.RootIdentity = A.RootIdentity AND A.ArchiveName = 'your Archive Name' GROUP BY AFV.ArchiveVEID)
However, can you run the following query and post a screenshot for us?
SELECT A.ArchiveName, AFV.FolderName, AFV.FolderPath, AFV.ParentFolderRootPathIdentity, AFV.FolderIcon FROM Archive A, Root R, ArchiveFolderView AFV WHERE AFV.ArchiveVEID = R.VaultEntryId AND R.RootIdentity = A.RootIdentity AND A.ArchiveName = 'your Archive Name' AND AFV.FolderName IN ('Top Of Information Store', 'Sent Items')
03-08-2011 09:18 AM
I did a search for FOLDERICON and found this tech article. I'm hardly work with SQL, but this looks similar to what you guys mentioned, correct? The goal is to change the FOLDERICON field to their correct settings (9 for Sent Items, 1 for Inbox, 2 for Calendar, and 4 for Deleted Items).
http://www.symantec.com/business/support/index?page=content&id=TECH35709&key=50996&actp=LIST
03-08-2011 09:26 AM
huh fair play, if thats how it does it then fine! run the query i gave you above
The query they give you in that article is wreckless to say the least
03-08-2011 09:28 AM
I just tested it in my lab and you are correct, if you change the folder icon to 9, it will represent the Sent Items and display the To field instead of the From field, good job
03-09-2011 04:31 AM
If you not really up to speed on SQL, I woulud open a support case. As mentioned in my initial post