Issue
Error on CMT Server - Concurrency Violation
SOURCE: CMT Migration Server
Event ID: 0
CMT Migration Server : Exception in fh_UpdateFarmHandContactTime: Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.
Solution
This was essentially caused by the CMTe Net2.0 32bit Application Pool had stopped on the Controller. Reset IIS from the CMD window using iisreset
If this does not resolve the issue then check the following:
Check the user CMT person document.
Go to the "all NAB fields" tab and the 'work/home" tab. Make sure in the department field does not have a listing with an "&" as this can cause the user to be stuck in Pending.
If this is the issue, then you can either manually clear the Department field, or create a Notes agent to run on selected users, with the following formula
FIELD Department:="";
SELECT @All
--------------------------------------------
For 3.8 and newer versions:
Open SQL Management Studio
Open the CMTe database.
Open the MigrationQueuetable table and remove any and all entries not currently migrating.
Close SQL management studio
For 3.7 and older versions:
Open the Access database and go the migrationqueuetable.
Remove any users listed in the table.
Close the Access database
Restart IIS from the command console (iisreset)
Open the CMT.exe on the controller
Remove any user listed in a pending state.
-----------------------------------------------------------
Restart the Internet Information Services(IIS) from CMD, command iisreset
Return to Lotus Notes
Start the migration
