Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

RapidStart Migration Error

Posted on 19 Dec 2014 03:17:59 by Microsoft Employee

Hi Again,

Having many problems here with trying to migrate data to GP 2013.

The process had worked and now no longer works to import via Excel Tables.

I am getting an error on trying to authenticate to the SQL server.  The error "The given key was nto present in the dictionary.  A graphic of the erro screen is below.  Any help woud lbe greatly appreciated..

 

Thank You,

Gus

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on 05 Jan 2015 at 01:28:29
    RE: RapidStart Migration Error

    Hi Kirk,

    Sorry foro the late reply.  I found the error shortly after your post, but have been very busy meeting some dealines.

    Anyway, for others that may be faced with the same problem..  The problem was in one of the SQL tables managed by the RapiStart utility.  Tracing with SQL Profiler gave some insights into the problem.  Apparently, the errors occurred due to one table (RmtProfile) that stores the previous session's information regarding the profile name and paths for the utility.  Apparently the table was either locked or corrupted.  Since the utility generates a new table we can safely delete the table.  Once deleted, all worked as expected.

     

    Hopefully, this will help some others loosing sleep :-)

    Thanks Again,

    Gus

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on 24 Dec 2014 at 00:01:12
    RE: RapidStart Migration Error

    Hi Gus,

    Another wild guess for you...Does DYNSA own the databases?

    Regards,

    Kirk

  • Community Member Profile Picture
    Community Member Microsoft Employee on 23 Dec 2014 at 12:15:22
    RE: RapidStart Migration Error

    Hi Kirk,

    Sorry for the delay.  I was trying a number of other unsuccessful attempts, i.e., Deleting the target DB and:

    1.   Recreating it with one of the GP Utilities Standard Templates (Success)

    3.  Deleting the company in GP/SQL and running ClearCompany.sql (Success)

    2.   Running RapidStart Configuration with our customized information (Success)

    3.   Running RapidStart Migration using our data (Failed)

     

    And, as per your suggestion, I did try another user account and the same error occurred.

     

    Any other suggestions appreciated,

    Gus

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on 22 Dec 2014 at 21:29:06
    RE: RapidStart Migration Error

    Gus,

    If you run the utility under another user account do you still receive the error?

    Kirk

  • Community Member Profile Picture
    Community Member Microsoft Employee on 22 Dec 2014 at 21:14:55
    RE: RapidStart Migration Error

    Hi Kirk,

    Thanks very much for the reply.

    1.  The x32 ODBC driver is indeed configured on the client.  As an FYI, eConnect is working perfectly with the driver.  

    2.  The firewall is off.

    Any other guesses would be appreciated.

    Thanks,

    Gus

  • KirkLivermont Profile Picture
    KirkLivermont 5,985 on 22 Dec 2014 at 20:59:43
    RE: RapidStart Migration Error

    Hi Gus,

    Have you made sure there is a 32 bit ODBC configured on the computer running the utility? Is the Windows Firewall on the SQL server disabled or configured to allow the connection? Just a few guesses.

    Good Luck,

    Kirk

  • Community Member Profile Picture
    Community Member Microsoft Employee on 22 Dec 2014 at 17:12:01
    RE: RapidStart Migration Error

    Update:

    I've opened a case with MS and still no resolution.  So, I thought I would reach out here where perhaps, with additional informaiton someone here could shed some light on thes issues:

    1.   I have uninstalled office 2007 on 2 win7 (VM) machines and Re-installed Office 2010 on one (VM3) and Office 2013 on the other (VM4). 

    After complete re-install, the same error appears on both machines.  I have captured the error in full and have included it below.

    2.  The Migration worked for me without error Thursday.  On Friday it began giving me the error.

    As an aside, the other RapidStart programs work without issues, i.e., RapidStart Configuration and Requester setup.

    3.  I have repaired the RapidStart modules on both computers once again without success.

    My guess is that there’s something going wrong on the SQL server connection.  The error occurs as soon as I log into SQL Server on the first window of the RapidStart  Migration wizard.  If I “continue” after the error, even if I enter all the required data the “Next” button is greyed out so I cannot go forward.

    4.  Does anyone know if any of these issues could be caused by the December updates to Office.  We've been having a number of issues with Active-X implementations after the updates?

     

    ************** Exception Text **************

    System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

       at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

       at System.Collections.ObjectModel.KeyedCollection`2.get_Item(TKey key)

       at Microsoft.Dynamics.GP.Deployment.Migrator.Core.Business.MigratorProfile.RetrieveMigratorProfileCollection(String profileName, MigratorModule module, DynamicsGpCompany destination)

       at Microsoft.Dynamics.GP.Deployment.Migrator.Modules.EX.Wizard.ExProfileCompanyMigratorDialog.OnSystemDatabaseSelectedIndexChanged(Object sender, EventArgs e)

       at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)

       at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)

       at System.Windows.Forms.ComboBox.RefreshItems()

       at System.Windows.Forms.ComboBox.OnDisplayMemberChanged(EventArgs e)

       at System.Windows.Forms.ListControl.SetDataConnection(Object newDataSource, BindingMemberInfo newDisplayMember, Boolean force)

       at System.Windows.Forms.ListControl.set_ValueMember(String value)

       at Microsoft.Dynamics.GP.Deployment.Migrator.Core.Wizard.BaseProfileCompanyMigratorDialog.InitializeControls()

       at Microsoft.Dynamics.GP.Deployment.Migrator.Modules.EX.Wizard.ExProfileCompanyMigratorDialog.InitializeControls()

       at Microsoft.Dynamics.GP.Deployment.Migrator.Core.Wizard.MigratorDialog.VisibleChangedEventHandler(Object sender, EventArgs e)

       at Microsoft.Dynamics.GP.Deployment.Migrator.Core.Wizard.SideMenuMigratorDialog.VisibleChangedEventHandler(Object sender, EventArgs e)

       at Microsoft.Dynamics.GP.Deployment.Migrator.Core.Wizard.BaseProfileCompanyMigratorDialog.VisibleChangedEventHandler(Object sender, EventArgs e)

       at Microsoft.Dynamics.GP.Deployment.Migrator.Modules.EX.Wizard.ExProfileCompanyMigratorDialog.VisibleChangedEventHandler(Object sender, EventArgs e)

       at System.Windows.Forms.Control.OnVisibleChanged(EventArgs e)

       at System.Windows.Forms.ScrollableControl.OnVisibleChanged(EventArgs e)

       at System.Windows.Forms.Form.OnVisibleChanged(EventArgs e)

       at System.Windows.Forms.Control.WmShowWindow(Message& m)

       at System.Windows.Forms.Control.WndProc(Message& m)

       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

       at System.Windows.Forms.ContainerControl.WndProc(Message& m)

       at System.Windows.Forms.Form.WmShowWindow(Message& m)

       at System.Windows.Forms.Form.WndProc(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

     

     

    ************** Loaded Assemblies **************

    mscorlib

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.18444 built by: FX451RTMGDR

        CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

    ----------------------------------------

    Microsoft.Dynamics.GP.Deployment.Migrator.Wizard

        Assembly Version: 12.0.0.0

        Win32 Version: 12.00.0639.089

        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Dynamics/RapidStart/Microsoft.Dynamics.GP.Deployment.Migrator.Wizard.exe

    ----------------------------------------

    System.Windows.Forms

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

    ----------------------------------------

    System.Drawing

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

    ----------------------------------------

    System

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.34238 built by: FX452RTMGDR

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll

    ----------------------------------------

    Microsoft.Dynamics.GP.Deployment.Migrator.Core

        Assembly Version: 12.0.0.0

        Win32 Version: 12.00.0639.089

        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Dynamics/RapidStart/Microsoft.Dynamics.GP.Deployment.Migrator.Core.DLL

    ----------------------------------------

    System.Configuration

        Assembly Version: 4.0.0.0

       Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

    ----------------------------------------

    Microsoft.Dynamics.Deployment.Forms

        Assembly Version: 2.0.0.0

        Win32 Version: 2.0.0231.0

        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Dynamics/RapidStart/Microsoft.Dynamics.Deployment.Forms.DLL

    ----------------------------------------

    System.Xml

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

    ----------------------------------------

    Microsoft.Dynamics.Deployment

        Assembly Version: 2.0.0.0

        Win32 Version: 2.0.0231.0

        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Dynamics/RapidStart/Microsoft.Dynamics.Deployment.DLL

    ----------------------------------------

    Microsoft.Dynamics.GP.Deployment.Migrator.Modules

        Assembly Version: 12.0.0.0

        Win32 Version: 12.00.0639.089

        CodeBase: file:///C:/Program%20Files%20(x86)/Microsoft%20Dynamics/RapidStart/Microsoft.Dynamics.GP.Deployment.Migrator.Modules.DLL

    ----------------------------------------

    System.Data

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

    ----------------------------------------

    System.Core

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

    ----------------------------------------

    System.Transactions

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll

    ----------------------------------------

    System.EnterpriseServices

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

    ----------------------------------------

    System.Numerics

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.18408 built by: FX451RTMGREL

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll

    ----------------------------------------

    Microsoft.Dynamics.GP.eConnect

        Assembly Version: 12.0.0.0

        Win32 Version: 12.00.1488.000

        CodeBase: file:///C:/Windows/assembly/GAC_32/Microsoft.Dynamics.GP.eConnect/12.0.0.0__31bf3856ad364e35/Microsoft.Dynamics.GP.eConnect.dll

    ----------------------------------------

    System.ServiceModel

        Assembly Version: 4.0.0.0

        Win32 Version: 4.0.30319.34234 built by: FX452RTMGDR

        CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.ServiceModel/v4.0_4.0.0.0__b77a5c561934e089/System.ServiceModel.dll

    ----------------------------------------

     

    ************** JIT Debugging **************

    To enable just-in-time (JIT) debugging, the .config file for this

    application or computer (machine.config) must have the

    jitDebugging value set in the system.windows.forms section.

    The application must also be compiled with debugging

    enabled.

     

    For example:

     

    <configuration>

        <system.windows.forms jitDebugging="true" />

    </configuration>

     

    When JIT debugging is enabled, any unhandled exception

    will be sent to the JIT debugger registered on the computer

    rather than be handled by this dialog box.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans