Move Archive Help 9.0.2

[EVUserAB]

I recently had issues with several move archive processes moving from one site to another.  Several tasks were basically in a hung state, and unable to further process.  Symantec support assisted in getting the SQL tables cleaned in the source site, and I found a forum posting that helped me clear the CLOSED table on the source SQL DB so I could start the process over.

Now Task 1 is completed, and the data has removed, but Task 2 is still waiting for a Shortcut Processing task to be run.  I have run this, and get this error in the log.

Im pretty sure I need to modify a SQL table in Destination SQL DB, but I am not sure which one.  The Task that it is referring too, is obviously the previous hung tasks that were cleared from the source DB table.

Thank you for any help

22/08/2011 22:06:14 Started Processing
22/08/2011 22:06:15 Entered a sleep state for 30 minutes. Reason: Shortcut processing from an earlier Move Archive is not yet complete in mailbox ###################. Move Archive will wait for it to complete before scheduling shortcut processing for the current move.
22/08/2011 22:06:15 Stopped Processing

[JesusWept3]

Can you run the following SQL Query on the destination site for us?

USE EnterpriseVaultDirectory
SELECT MbxDisplayName, MoveArchiveShortcutSubTask
FROM ExchangemailboxEntry
WHERE MbxDisplayName = 'your User'

It should so that there is a SubTask specified here, something like
16CBAEE2812B5BD48A56CC60C00A1691E1013700myEVSite

Then run this query to make sure it exists in the SubTask table

USE EnterpriseVaultDirectory
SELECT *
FROM SubTask
WHERE SubTaskEntryId = '16CBAEE2812B5BD48A56CC60C00A1691E1013700myEVSite'

If this returns no results, what you may have to do unfortunately is start over again, but this time clearing out the column for MoveArchiveShortcutSubTask so that it doesnt believe its already in progress

[EVUserAB]

Thank you.  I got results both times.

The 2nd result has all of the tasks identified as NULL.

Can I simply delete these rows from the subtask table?  Then once I re-run shortcut processing it should kick off?

Thank you

[EVUserAB]

Also, I think I might have noticed the subtask table having those entries last time, performed a backup, but when I went to execute a delete query based on the common entry in the table (this impacts about 12 users), it did not allow me to delete the task.  So I ignored it and simply tried to to start the process over.  So if I need to delete those entries now, if you could help with the correct SQL query, I would greatly appreciate it.  I did not try to simply delete the row.

Thank you

[JesusWept3 · Accepted solution]

it wouldn't delete the subtasks because there is a constraint in the exchangeMailboxEntry table to that subtask

So what i would do is the following

1. Get all the MoveArchiveShortcutSubTask ID's

USE EnterpriseVaultDirectory
SELECT MoveArchiveShortcutSubTask
FROM ExchangeMailboxEntry
WHERE MoveArchiveShortcutSubTask IS NOT NULL

2. Copy them from sql, and paste them in to notepad in to a comma delimited list with single quotes.
So the following list:

16CBAEE2812B5BD48A56CC60C00A1691E1013700myEVSite
11C7605FD568B7743B04A9C5FF9E2A90E1013700myEVSite
17DBDFF178D9DC54B99E00E756A79AF771013700myEVSite

Becomes:

'16CBAEE2812B5BD48A56CC60C00A1691E1013700myEVSite',
'11C7605FD568B7743B04A9C5FF9E2A90E1013700myEVSite',
'17DBDFF178D9DC54B99E00E756A79AF771013700myEVSite'

3. Run the following query to clear them from the ExchangeMailboxEntry table

USE EnterpriseVaultDirectory
UPDATE ExchangeMailboxEntry
SET MoveArchiveShortcutSubTask = NULL
WHERE MoveArchiveShortcutSubTask IS NOT NULL

4. Go to your notepad, copy the delimited list of ID's and run the following query

USE EnterpriseVaultDirectory
DELETE FROM SubTask
WHERE SubTaskEntry IN ('16CBAEE2812B5BD48A56CC60C00A1691E1013700myEVSite',
'11C7605FD568B7743B04A9C5FF9E2A90E1013700myEVSite',
'17DBDFF178D9DC54B99E00E756A79AF771013700myEVSite')

You will then need to start the move archives again and make sure this time it completes