Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 4 to CRM 2011 - Upgrade - Import Organization RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Folks:

    Our Production environment is CRM 4.0 on Windows 2003 (32 bit) - SQL Server 2008 R2 (64 bit). Before we migrate to CRM 2011 Windows 2008 R2 (64 bit) we would like to do some testing in our Test environment which is on a SEPERATE DOMAIN. I followed the steps outlined by Microsoft Implementation Instructions and the CRM 2011 is working fine, but when I plan on moving the CRM 4.0 data to CRM 2011 the IMPORT ORGANIZATION Wizard throws a error when it reaches the 'Edit User Mappings' step. None of the Users get displayed. The screen is empty. The error reported on screen is:

     'You must map your Active Directory user account to atleaset one enabled Microsoft Dynamics CRM user who has   the System Administrator seciroty role before the organization can be imported'

    The error is the Log file is this:

    Error| Exception occurred while mapping usersMicrosoft.Crm.CrmArgumentException: Expected non-empty string. ---> System.ArgumentException: Expected non-empty string.Parameter name: domainAndAccount
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Exceptions.ThrowIfEmpty(String value, String parameterName)
       at Microsoft.Crm.UserManagement.DomainAccount..ctor(String domainAndAccount)
       at Microsoft.Crm.Tools.Admin.DBImportHelper.ReadUsers(IProgressEventSource progressHandler, UserAccountMapper mapUserAccountInfo, String sqlServerName, String databaseName)
       at Microsoft.Crm.Tools.Admin.ImportUserMapper.MapUsers()
       at Microsoft.Crm.Tools.Admin.UserMappingProgressPage.PerformUserMapping()


    Any idea what could be the problem or is there any setting I need to change before I do Import Organization because I'm doing it Import Organization on a DIFFERENT DOMAIN?

     

    Thanks !

    Friday, May 18, 2012 3:28 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Did you find a solution for this issue? 

    A couple of things to try, ensure at least one of the users in CRM 4 has the system administrator role with full access set.  In some cases, you can run into a mapping issue becasue a user account does not have a domainname.  You can check that by querying the systemuserbase and see if there are any users listed with a blank domainname.

    Regards, Donna

    Saturday, June 16, 2012 4:22 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    It sounds like you might not be mapping your users correctly.  Does it give you the option to manually map your users even?

    Jamie Miley
    Check out my about.me profile!
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!

    Friday, May 18, 2012 4:20 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    It gives me all the options but when I click Next (whether I click manually or auto) the 'Edit User Mappings' screen is displayed with no records/users. I also tried using 'Generate a new mapping file' but that also doesn't return anything and the log file returns the same error. Here is the log file:

    Info| Import Organization Wizard launched from Organization action pane
    Verbose| Retrieving database version Data Source=SQL83;Initial Catalog=SBA_TEST_MSCRM;Integrated Security=True;Connect Timeout=60 ...
    Info| Database version: 5.0.9690.1992.
    Verbose| Retrieving database version Data Source=SQL83;Initial Catalog=SBA_MSCRM;Integrated Security=True;Connect Timeout=60 ...
    Info| Database version: 4.0.7333.3822.
    Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=SQL83;Integrated Security=True;Initial Catalog=SBA_MSCRM;Connect Timeout=60 ...
    Info| Database version: 4.0.7333.3822.
    Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=SQL83;Integrated Security=True;Initial Catalog=SBA_MSCRM;Connect Timeout=60 ...
    Info| Database version: 4.0.7333.3822.
    Verbose| Retrieving database base language code Data Source=SQL83;Initial Catalog=SBA_MSCRM;Integrated Security=True;Connect Timeout=60 ...
    Info| Database base language code: 1033.
    Verbose| Retrieving database version Data Source=SQL83;Initial Catalog=SBA_MSCRM;Integrated Security=True;Connect Timeout=60 ...
    Info| Database version: 4.0.7333.3822.
    Info| Retrieved organization ID 843a94b2-8c69-4db5-9713-e9d1ffb6fddb.
    Error| Exception occurred while mapping usersMicrosoft.Crm.CrmArgumentException: Expected non-empty string. ---> System.ArgumentException: Expected non-empty string.
    Parameter name: domainAndAccount
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Exceptions.ThrowIfEmpty(String value, String parameterName)
       at Microsoft.Crm.UserManagement.DomainAccount..ctor(String domainAndAccount)
       at Microsoft.Crm.Tools.Admin.DBImportHelper.ReadUsers(IProgressEventSource progressHandler, UserAccountMapper mapUserAccountInfo, String sqlServerName, String databaseName)
       at Microsoft.Crm.Tools.Admin.ImportUserMapper.MapUsers()
       at Microsoft.Crm.Tools.Admin.UserMappingProgressPage.PerformUserMapping()





    • Edited by sqldba20 Friday, May 18, 2012 5:19 PM
    Friday, May 18, 2012 5:09 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Maybe try updating your CRM server prior to importing the org.  This seems kind of strange.

    Jamie Miley
    Check out my about.me profile!
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!

    Friday, May 18, 2012 6:11 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    What do you mean by updating the CRM server? For CRM 2011 (the new one) I installed update rollup 8.
    Friday, May 18, 2012 6:33 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    That's exactly what I meant.   That isn't the problem in this case that means.

    Jamie Miley
    Check out my about.me profile!
    http://mileyja.blogspot.com
    Linked-In Profile
    Follow Me on Twitter!

    Friday, May 18, 2012 6:54 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    DO you think seperate domain might be a problem and that's the reason it is not pulling the user list?
    Friday, May 18, 2012 7:38 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Did you find a solution for this issue? 

    A couple of things to try, ensure at least one of the users in CRM 4 has the system administrator role with full access set.  In some cases, you can run into a mapping issue becasue a user account does not have a domainname.  You can check that by querying the systemuserbase and see if there are any users listed with a blank domainname.

    Regards, Donna

    Saturday, June 16, 2012 4:22 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Were you able to resolve this issue?  I just ran into this as well and any help would be greatly appreciated!  Thanks!

    Steven Rasmussen

    Tuesday, July 17, 2012 12:20 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    It has not worked for me yet. Don't know what might be the problem. I have the CRM Admin account set to Admin with full access, my CRM Id set to Admin with full access and also anther couple of employees CRM ID set to Admin with full access.


    • Edited by sqldba20 Monday, August 20, 2012 6:39 PM
    Monday, August 20, 2012 6:36 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Nevermind It worked for me now. The problem was that there was a User in systemuserbase table which had the DomainName column blank. I updated the DomainName column and that worked. (PS: This User is other than the INTEGRATION and SYSTEM Users).
    Tuesday, August 21, 2012 1:55 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    This sounds like what we want to do. So we have a test environment on a different domain where we plan to install CRM 2011 and then import the organization from CRM 4. Is that what you did? Our test environment has its own ActiveDirectory. Do the users need to be created in there first before we import the organization? Or does the user mapping create them, even though they are separate ActiveDirectory's in different domains?
    Wednesday, January 16, 2013 12:24 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    @STHook - you might be better off starting your own question thread and referring to this one.

    As a short answer - you need to create users in your test domain to map to existing users in CRM.

    For the purposes of testing, you only need to worry about mapping at least one user who currently has System Administrator role in CRM 4 to an account in the target test domain, and any other users who will be involved in testing / UAT etc. You don't have to map all users - any which are not mapped will be deactivated in the test system.

    You can easily create user accounts in AD using command line tools such as DSADD in a batch file, or import with CSVDE.exe for example.

    Hope this helps.
    Adam Vero, Microsoft Certified Trainer | Microsoft Community Contributor 2011
    Blog: Getting IT Right

    Wednesday, January 16, 2013 2:08 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I had the same problem. I fixed it! The problem was that I had to map the user which originally setup the CRM for me it was CRMSVRSetup. It seems CRM just knows that one!
    Tuesday, November 26, 2013 12:41 PM