Our customer migrated to MR 2.1.9001.11 back in 2014. They have used maybe 2 of their scores of MR reports and still use FRx. Now we are upgrading them and they want FRx migrated to MR again. I exported the MR reports they use so we can import after migration. Also backed up the MR db.
However, when we get to the Migrate FRx Data screen after connecting to the MR database, we get the message that the wizard has stopped working and have a choice to close or check for solution and close. Either way it closes and nothing happens. This wizard worked 4 years ago for their migration in the same setting. My network/SQL user is an admin.
There are two errors in Event Viewer. The first is .NET Runtime:
Application: MigrationWizard.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.ComponentModel.Win32Exception
Exception Info: System.Data.SqlClient.SqlException
at System.Data.SqlClient.SqlInternalConnection.OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1<System.Action>)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(System.Data.SqlClient.TdsParserStateObject, Boolean, Boolean)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(System.Data.SqlClient.TdsParserStateObject, UInt32)
at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte ByRef)
at System.Data.SqlClient.TdsParser.TryRun(System.Data.SqlClient.RunBehavior, System.Data.SqlClient.SqlCommand, System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.BulkCopySimpleResultSet, System.Data.SqlClient.TdsParserStateObject, Boolean ByRef)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(System.String, Boolean, Int32, Boolean)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(System.Threading.Tasks.TaskCompletionSource`1<System.Object>, System.String, Boolean, Int32, Boolean ByRef, Boolean, Boolean)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.DataSetCommon.ClearTable(System.Data.SqlClient.SqlConnection, System.String)
at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.DataSetCommon.MigrationCleanup()
at Microsoft.Dynamics.Performance.Reporting.Migration.FRx67Importer.Import(Boolean, Boolean)
at Microsoft.Dynamics.Performance.Reporting.Migration.Wizard.MigrationPage+<>c__DisplayClass8.<StartMigration>b__1()
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()
The second is Application Error:
Faulting application name: MigrationWizard.exe, version: 2.1.9001.11, time stamp: 0x536dae25
Faulting module name: KERNELBASE.dll, version: 6.1.7601.24000, time stamp: 0x5a499b18
Exception code: 0xe0434352
Fault offset: 0x000000000001a06d
Faulting process id: 0x1470
Faulting application start time: 0x01d454fdcf087a10
Faulting application path: C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Migration Wizard\MigrationWizard.exe
Faulting module path: C:\Windows\system32\KERNELBASE.dll
Report Id: 357e3024-c0f1-11e8-900d-000c293e3745
The wizard does delete all reports in MR so it does get that far. They have 5 companies and 5 spec sets and they are all cleaned up and assigned to a catalog. The G32 files were renamed and FRx launched for each company and compacted all local and system dbs. We followed the prep document as we have done many times.
Any help on this issue is greatly appreciated. Not sure where to check next...
Thanks!
Althea
*This post is locked for comments