Duplicate Folders in Mimosa Archive

I recently ran across an unusual problem in which duplicate folders were appearing in a given user's Mimosa Archive as shown below.  

Note that the "Inbox" folder appears multiple times but the message "No records found" appears when attempting to view the contents of the duplicates.


This issue was most likely due to archiving a mailbox which has some degree of corruption. In this case, the folders were archived multiple times but the contents were not.  Fortunately, Mimosa Systems has provided the msisp_DeleteEmptyFolders stored procedure to remove the duplicate folders.  Here's how to use it:

1. Run the following SQL query to determine the MailboxID of the affected user:

Select * from MimosaContext..Mailbox (nolock) Where MailboxName like '%LastName%'

1. Change to the MimosaExchangeItem_1 database then run the following stored procedure, replacing MailboxID with the mailbox ID number determined by the previous query:

exec MimosaExchangeItem_1.dbo.msisp_DeleteEmptyFolders MailboxID, 1

e.g.,

exec MimosaExchangeItem_1.dbo.msisp_DeleteEmptyFolders 802, 1

The duplicate folders should be immediately removed.