Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Error while copying an organization - Systemuser with user id doesn't exist RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am not able to solve this issue for a while now. If somebody can help me it would be really appreciating.

    These are steps I am following

    1. Backup a org1 mscrm database.

    2. Restore a new database from this backup. name it as org2_mscrm.

    3. Import a new organization from org2_mscrm. (using automatic mapping using active directory domain names)

     

    When I got crm/org2/loader.aspx, I get the following exception.

    Error Description:
    systemuser With Id = c8b4fb19-f43d-df11-8bf6-005056aa5293 Does Not Exist
    Error Details:
    systemuser With Id = c8b4fb19-f43d-df11-8bf6-005056aa5293 Does Not Exist

    Full Stack:
    [CrmObjectNotFoundException: systemuser With Id = c8b4fb19-f43d-df11-8bf6-005056aa5293 Does Not Exist]
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32[] deletionCodes, Int32 languageCode)
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)
       at Microsoft.Crm.Caching.UserDataCacheLoader.LoadCacheData(Guid key, ExecutionContext context)
       at Microsoft.Crm.Caching.ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)
       at Microsoft.Crm.Caching.BasicCrmCache`2.CreateEntry(TKey key, IOrganizationContext context)
       at Microsoft.Crm.Caching.BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
       at Microsoft.Crm.BusinessEntities.SecurityLibrary.GetUserInfoInternal(WindowsIdentity identity, IOrganizationContext context, UserAuth& userInfo)
       at Microsoft.Crm.BusinessEntities.SecurityLibrary.GetCallerAndBusinessGuidsFromThread(WindowsIdentity identity, Guid organizationId)
       at Microsoft.Crm.Authentication.CrmWindowsIdentity..ctor(WindowsIdentity innerIdentity, Boolean publishCrmUser, Guid organizationId)
       at Microsoft.Crm.Authentication.WindowAuthenticationProviderBase.Authenticate(HttpApplication application)
       at Microsoft.Crm.Authentication.AuthenticationStep.Authenticate(HttpApplication application)
       at Microsoft.Crm.Authentication.AuthenticationPipeline.Authenticate(HttpApplication application)
       at Microsoft.Crm.Authentication.AuthenticationEngine.Execute(Object sender, EventArgs e)
       at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)



    Other Message:

    Error Number:
    0x80040217

    Source File:
    Not available

    Line Number:
    Not available
     


    Server: crm
     
     
    Request URL:
    http://crm/org2/loader.aspx
    If this answers your question, please use the answer button and say so. | Anoop
    Monday, April 5, 2010 6:13 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    I had a simillar issue and it helped when I restarted twice CRM async service which generate a key for it.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Tuesday, April 6, 2010 10:21 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Did restarting the async service work for you?  If not, query your filteredsystemuser table and see if you can find the systemuserid 'c8b4fb19-f43d-df11-8bf6-005056aa5293'

    If that user is not in the database, then try accessing the crm application with the user who ran the import.  Also, if you installed CRM using something other than the default web site, you'll need to add the port to your crm url.

    Best Regards | Twitter: edwardsdna
    Friday, April 9, 2010 12:56 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    I had a simillar issue and it helped when I restarted twice CRM async service which generate a key for it.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Tuesday, April 6, 2010 10:21 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Did restarting the async service work for you?  If not, query your filteredsystemuser table and see if you can find the systemuserid 'c8b4fb19-f43d-df11-8bf6-005056aa5293'

    If that user is not in the database, then try accessing the crm application with the user who ran the import.  Also, if you installed CRM using something other than the default web site, you'll need to add the port to your crm url.

    Best Regards | Twitter: edwardsdna
    Friday, April 9, 2010 12:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    CRM 4.0

    We had CRM up and running after the base installation.  We had a cloned version of test database that we needed to use and imported that into SQL Server 2005. Since that happened we can no longer run CRM.  We are getting the exact errors as above.

    When I checked the filteredsystemuser table it is empty. 

    How is this table populated?  Do I have to re-install CRM  or is there a stored proc we can run ?

    When I look at the old database there are 4 rows in it there is a systemuserid with the one CRM is indicating does not exist in the newly imported db.

    Here's the first line of the CRM error:

    Error Description:

    systemuser With Id = f5673a4f-0853-df11-b2c5-005056a07851 Does Not Exist

     

    Thanks in advance

     

    Friday, May 7, 2010 7:27 PM
  • Question
    Sign in to vote
    1
    Sign in to vote
    if you want to redeploy CRM to use as a test server, you need to follow this post.  Cloning is not a supported method.

    Regards, Donna

            Windows Live Blog

    Friday, May 7, 2010 8:04 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Donna.

     

    That post "Redeploy the Microsoft Dynamics CRM deployment that includes the Microsoft Dynamics CRM Server within the same domain or to another domain" moved us closer to the solution.  We had approached this initially by importing the CRM db into our target environments and ran into the problem of having unintentionally re-used the same OrganizationName.  To try to back out of that and still use the steps from the Post you provided, we renamed the new DB, restarted the SQL Server service, and re-tried the import. 

    The Deployment wizard was then able to walk us through the entire process of moving to the new database - we had to use a new organizationname to proceed but the steps did work, mostly.  There was an error at the conclusion of the Import Organization process "Microsoft.Crm.CrmException Id=...., Failed.  the changes made during import  could not be rolled back, Please manually delete the organization." 

    Our configuration includes a webportal (from MS) and one of our group tried the following, which worked.. But, if possible, we'd like to get some feedback on whether this was the right approach. (Understood if the customization goes beyond what you can respond to) 

    Any way, here are the steps that helped recover from the user-mapping error.  Can you comment on whether these make sense and are the best approach?  (These relate to some customizations done on the

    1.  Unpublish, then re-publish all workflows.
    2.  Run the following SQL queries:
         ModifyRequestQuickFindView
         ModifyRequestAssociatedView
    3.  Log into Microsoft CRM as an Administrator  and navigate to Settings | Customizations | Customize Entities
    4.  Highlight Request entity in the grid and click Publish.  (Actually, it would be best to re-publish all entities.)
    5.  Run SQL query EnablePluginEvents (fix db name first)
    6.  Delete the existing MercuryNumUser from the MercuryRequestNum database, then re-establish mapping to the database with dbo as default schema in the SQL logins.  Then grant 'execute' permissions to the MercuryNumUser for the stored procedure "GetNextRequestNumber".
    7.  Run the SQL query CreateNetworkService_User
    8.  Restart the Microsoft CRM Asynchronous Processing Service (all crm servers)
    9.  Run the PluginRegistration.exe
    10.  Unregister existing plugins and re-import the XML solution from [INSTALL PATH]\Server\bin\assembly\register.xml

     
    #6 is the one that is really important, but here's the bottom line on all of this:
     
    Whenever we decide to do a data refresh, chances are we will have to run through a full re-deployment of the latest CRM build.  That is certainly the safest approach, albeit the longest.
    Thanks again

    Monday, May 10, 2010 2:19 AM