Error migrating from TFS05 to TFS08

Dec 16, 2008 at 9:34 PM
I get an error:

WorkItemMigrationFailer - Migration of the work item 'TFS!servername (project name): 10225' failed/

In the event log I get:

Message: An error occurred trying to store an event to the database.
 Call Stack: Column 'SessionInstanceID' does not allow nulls.    at System.Data.DataColumn.CheckNullable(DataRow row)
   at System.Data.DataColumn.CheckColumnConstraint(DataRow row, DataRowAction action)
   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
   at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
   at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
   at System.Data.DataRowCollection.Add(DataRow row)
   at Microsoft.Vsts.Ranger.Migration.TfsToTfs.Service.Data.EventData.StoreEventRow(EventsRow row)
   at Microsoft.Vsts.Ranger.Migration.TfsToTfs.Service.Business.SessionEventManager.LogEvent(MigrationEvents migrationEventType, MigrationEventArgs e)
Dec 16, 2008 at 9:55 PM
As a side note, it seems that NONE of the work items are migrated, is thisall wrapped up in a transaction??? Going thru the code now... 
Dec 16, 2008 at 10:05 PM
Karl,

Could you please give me the repro steps and the trace log for this session failure? I am going to take a look of this bug today.

Thanks,
Terry
Dec 16, 2008 at 10:18 PM
Hey Terry,

The contents of the trace log is below. I can repro it consistantly on my 2 TFS servers (05 -> 08). The project name does have round bracket ( and ) in its name? Trying to migrate to a test project called Test Project to see if that is an issue.

TfsMigrationWindowsServiceHost.exe Information: 0 : Connecting to 'https://tfs05.company.com/'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:34.2905746Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Connected to 'https://tfs05.company.com/'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:35.9097365Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Connecting to 'https://tfs08.company.com/'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:36.0177473Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Connected to 'https://tfs08.company.com/'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:36.8288284Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Connecting to 'https://tfs05.company.com/'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:36.8448300Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Connected to 'https://tfs05.company.com/'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:36.8458301Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Getting modified items from 'TFS!tfs05.company.com (SOURCE PROJECT)'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:36.8788334Z
TfsMigrationWindowsServiceHost.exe Information: 0 : TFS Query: SELECT [System.Id], [System.Rev] FROM WorkItems WHERE ([System.TeamProject]=@Project) ORDER BY [System.Id]
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:36.8838339Z
TfsMigrationWindowsServiceHost.exe Information: 0 : TFS Query: returned 42 item(s)
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:37.2788734Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Received modified items from 'TFS!tfs05.company.com (SOURCE PROJECT)'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:37.2798735Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Connecting to 'https://tfs08.company.com/'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:37.4508906Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Connected to 'https://tfs08.company.com/'
    LogicalOperationStack=
    ThreadId=7
    DateTime=2008-12-16T22:24:37.4508906Z
Update package was fully optimized - no changes to the existing data!
Update package was fully optimized - no changes to the existing data!
Update package was fully optimized - no changes to the existing data!
Update package was fully optimized - no changes to the existing data!
Update package was fully optimized - no changes to the existing data!
Update package was fully optimized - no changes to the existing data!
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):14626')
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:38.8490304Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10226')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:38.8980353Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10226
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:38.9690424Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 6 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):14626
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:38.9800435Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10227')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.1100565Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10227
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.1500605Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10228')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.1520607Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10228
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.2000655Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10229')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.2020657Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10229
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.2500705Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10230')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.2520707Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10230
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.2920747Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10231')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.2950750Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10231
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.3290784Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10232')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.3310786Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10232
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.3650820Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10233')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.3670822Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10233
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.3980853Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10234')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.4060861Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10234
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.4410896Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10235')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.4430898Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10235
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.4780933Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10236')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.4800935Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10236
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.5120967Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10237')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.5140969Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10237
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.5461001Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10238')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.5481003Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10238
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.5891044Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10239')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.5911046Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10239
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.6231078Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):10240')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.6251080Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 2 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):10240
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.6761131Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):14545')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.6781133Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 8 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):14545
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.7281183Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):14709')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.7321187Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 10 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):14709
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.7921247Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15093')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.7971252Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 4 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15093
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.8441299Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15096')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.8491304Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 5 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15096
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.8941349Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15159')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.8971352Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 10 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15159
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.9571412Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15181')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:39.9611416Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 11 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15181
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.0241479Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15371')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.0281483Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 6 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15371
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.0821537Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15628')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.0861541Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 18 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15628
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.1671622Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15876')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.1721627Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 3 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15876
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.2121667Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15877')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.2141669Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 8 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15877
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.2721727Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15878')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.2761731Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 3 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15878
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.3231778Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16028')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.3261781Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 5 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16028
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.3761831Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16029')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.3791834Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 4 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16029
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.4181873Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16036')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.4201875Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 5 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16036
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.4711926Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16175')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.4741929Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 10 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16175
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.5492004Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16176')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.5542009Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 5 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16176
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.6122067Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16190')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.6162071Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):14708')
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:40.7402195Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 20 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16190
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.8192274Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16196')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.8312286Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 6 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16196
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.9222377Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16197')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.9282383Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 3 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16197
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.9822437Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 20 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):14708
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:40.9822437Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16202')
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:40.9842439Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 4 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16202
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:41.0252480Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):15161')
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:41.1592614Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 10 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):15161
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:41.2802735Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16009')
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:41.7923247Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 10 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16009
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:41.8733328Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16013')
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:42.0063461Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 5 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16013
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:42.0763531Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16031')
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:42.2443699Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 16 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16031
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:42.3523807Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Migrating item 'TFS!tfs05.company.com (SOURCE PROJECT):16174')
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:42.5283983Z
TfsMigrationWindowsServiceHost.exe Information: 0 : 5 revision(s) obtained for item 'TFS!tfs05.company.com (SOURCE PROJECT):16174
    LogicalOperationStack=
    ThreadId=3
    DateTime=2008-12-16T22:24:42.5844039Z
TfsMigrationWindowsServiceHost.exe Information: 0 : Submitting 42 updates into 'TFS!https://tfs08.company.com (DESTINATION PROJECT)'
    LogicalOperationStack=
    ThreadId=10
    DateTime=2008-12-16T22:24:43.8915346Z

Dec 16, 2008 at 10:23 PM
OK - I tested with the destination project not having round brackets and it got further (some WI still failed - will check the trace log). So it seems round brackets like ( and ) do cause issues (some sort of crash as I metioned at the top).

Cheers,
Karl
Dec 16, 2008 at 10:37 PM
The trace log has no details about the work items the failed (about half did). Can I bump up the verbosity of the log? If so, how...
Dec 16, 2008 at 10:53 PM
Sorry, it doesn't seem like the trace log can be generated with different berbosity level.
Dec 16, 2008 at 11:51 PM
OK, tried same source project with a different destination project (test project 1) and got the same error but on differrent workitems than before. This time there was less errors that my first attempt

Message: An error occurred trying to store an event to the database.
 Call Stack: Column 'SessionInstanceID' does not allow nulls.    at System.Data.DataColumn.CheckNullable(DataRow row)
   at System.Data.DataColumn.CheckColumnConstraint(DataRow row, DataRowAction action)
   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
   at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
   at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
   at System.Data.DataRowCollection.Add(DataRow row)
   at Microsoft.Vsts.Ranger.Migration.TfsToTfs.Service.Data.EventData.StoreEventRow(EventsRow row)
   at Microsoft.Vsts.Ranger.Migration.TfsToTfs.Service.Business.SessionEventManager.LogEvent(MigrationEvents migrationEventType, MigrationEventArgs e)