Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

How to Clear out Move Archive List

Created: 29 Jan 2013 • Updated: 29 Jan 2013 | 2 comments
HolgerMu's picture
This issue has been solved. See solution.

Hi Folks,

I have a Customer who is moving some Users to a new EV Site with Move Archive.

For almost all users this procedure is working fine but we had 1 User whose Mailbox was recreated during the Move Process.

The Customer decided to Export the Users Archive to PST, import it to the newly created Archive for the new Mailbox and then delete the User-Entry in the Move Archive Status list.

Too bad the Move was stuck in Step 2 of 5 (waiting to update Shortcut) and therefore the Entry can not be stopped or deleted. I was searching through the EV-Database to find out where that information is stored but did not find anything.

The customer could live with that 1 Entry that will be stuck forever but is there a way to get that cleanded out?

Thanks for any suggestions.

Holger

Comments 2 CommentsJump to latest comment

JesusWept3's picture

you would have to delete the users entry from SubTask, ArchiveHistory and ArchiveMoveHistory tables

Then on the site the user is going to, go to the users ExhcangeMailboxEntry record, look at the MoveArchiveShortcutsSubtask column, it will have an ID there, note down the ID

then do a DELETE FROM SubTask WHERE SubTaskEntryId = 'value from EME'

SOLUTION
HolgerMu's picture

Thanks a lot! Looks a lot nicer now!

If you delete it manually you can delete the Subtask, then the ArchiveMoveHistory then ArchiveHistory (the last 2 have foreign references to it so you need to keep the order right)

------

Holger Mundt | I.Tresor GmbH & Co. KG | Germany | http://www.i-tresor.de