locked
Cannot add new users after migration upgrade from CRM 2011 to CRM 2013 RRS feed

  • Question

  • Hi

    I have a CRM 2011 environment that I want to migrate to a new CRM 2013 environment.

    New CRM Environment:

    • 1x App server (Win server 2012)
    • 1x DB Server (Win Server 2012 / SQL 2012)

    Old CRM Environment:

    • 1x App server (Win server 2k8)
    • 1x DB server (Win server 2k8/ SQL 2k8)

    Notes:

    • All servers are in the same domain.
    • Both dev 2011 & 2013 use the same service accounts (for each/given service) and point to the same OU in AD. The same is true for staging.

    I have installed and configured the CRM 2013 with no hustles and deployed a default vanilla Organization. I can add new users to the new organization with just one unresolved "famous" error showing in the trace log. (Unable to get DNS name of domain myDomain: No such domain is known).  But the user is added and fully functional.

    I then upgraded the CRM 2011 organization DB to the new 2013 environment with very minimal issues (Just unsupported JavaScript customizations that I removed). After the upgrade, when testing, I soon found out that I could not add new users to the organization, and error shown from the trace log is:

    Error Snippet (not full stack trace):

    >Error while retrieving GUID  from SID. Exception: System.Runtime.InteropServices.COMException (0x8007203A): The server is not operational.

    >Crm Exception: Message: Server was unable to process request., ErrorCode: -2147016646, InnerException: System.Runtime.InteropServices.COMException (0x8007203A): The server is not operational.

    >Web Service Plug-in failed in SdkMessageProcessingStepId: {5ACABB1B-EA3E-DB11-86A7-000A3A5473E8}; EntityName: systemuser; Stage: 30; MessageName: Create; AssemblyName: Microsoft.Crm.Extensibility.InternalOperationPlugin, Microsoft.Crm.ObjectModel, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35; ClassName: Microsoft.Crm.Extensibility.InternalOperationPlugin; Exception: Unhandled Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.

    Inner Exception: System.Runtime.InteropServices.COMException: The server is not operational.

    I should add that I did the migration upgrade several times first to dev 2013 and then I tried to staging 2013 and in all instances, I still get the same issue.

    Any pointers will be greatly appreciated.

    Wednesday, January 15, 2014 9:18 AM

Answers

  • Hi

    Finally got a resolution for this one. This is for anyone struggling or is yet to get a few grey hairs.

    Thanks to this post (http://41.73.54.55/issue-creating-new-users-in-upgraded-crm-4-crm-2011-org/), it turns out that the default values for regional settings needs to be refreshed/reset somehow in the System Settings - Formats tab.  

    Can anyone elaborate on the cause of these values requiring a refresh/reset?


    • Edited by Mondy Thoobe Wednesday, January 22, 2014 11:27 AM spelling
    • Marked as answer by Mondy Thoobe Wednesday, January 22, 2014 11:27 AM
    Wednesday, January 22, 2014 11:26 AM

All replies

  • This is most likely to be an Active Directory problem. One possible cause is if the new CRM server is connecting to a non-functioning Domain Controller. You can specify the domain controller to use via a registry value - see http://support.microsoft.com/kb/954811 (it relates to a different CRM version, but the registry value should be the same for Crm 2013(

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk


    Wednesday, January 15, 2014 7:38 PM
    Moderator
  • Thanks David for the pointer.

    I have set the PreferredDc in the registry to my domain controller, rebooted server and still no luck.  What I am not certain about is how the PreferredDc value should be .i.e. servername.mydomain.com or servername or \\servername. I have used the FQDN.

    The odd thing is that there are two organizations on the same CRM 2013 instance and the I am able to add new users on the first organization. It is only on the upgraded Organization from CRM 2011 that is giving me this error.

    Thursday, January 16, 2014 7:24 AM
  • In this case I would think the issue is a corruption in the org database, and it didn't upgrade properly.

    Try dropping the org from the deployment manager, deleting the org database, restore a fresh copy from the source environment and do the import again.  Then check the log files in the CRM directory to see if there are any issues during the import.  Check the deployment manager to make sure that the org shows the correct version number.  Then try adding your new users.


    Jason Peterson

    Thursday, January 16, 2014 9:27 AM
  • Thanks Jason,

    Disabled the organization, deleted it and dropped the DB on 2013. Then created a new 2011 backup from Live, removed unsupported customizations (one JavaScript file referencing 2007 service endpoint), then imported the org into 2013. Again the same issue occurred.

    I will do an in-place upgrade on our 2011 dev environment to see if this would be a better alternative.

    Thanks again.

    Friday, January 17, 2014 7:39 AM
  • Hi

    Finally got a resolution for this one. This is for anyone struggling or is yet to get a few grey hairs.

    Thanks to this post (http://41.73.54.55/issue-creating-new-users-in-upgraded-crm-4-crm-2011-org/), it turns out that the default values for regional settings needs to be refreshed/reset somehow in the System Settings - Formats tab.  

    Can anyone elaborate on the cause of these values requiring a refresh/reset?


    • Edited by Mondy Thoobe Wednesday, January 22, 2014 11:27 AM spelling
    • Marked as answer by Mondy Thoobe Wednesday, January 22, 2014 11:27 AM
    Wednesday, January 22, 2014 11:26 AM
  • Hi All,

    I have just upgrade from CRM 2011 to CRM 2013 , and I am not able to add new user.  I already tried the above suggestions, which did not work. Are there any other alternative?

    Thursday, February 20, 2014 8:14 PM
  • Hi Charles,

    1. Which upgrade method/path (in-place/migration) did you use?
    2. What errors do you get in the trace log when you try to add a new user?
    3. Which suggestion did you try?

    I am trying to understand which route you took to get where you are now, so I can better assist where possible.

    Friday, February 21, 2014 8:35 AM
  • Hi

    I am experiencing the same issue after the CRM 2013 upgrade. I can add users to default organisation but not the actual organisation. But it works fine in dev and staging environment.

    Dev, Staging and Production all are same version CRM 2013 (6.0.2.51)

    The error below shows up during Add New Users.

     

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: SQL timeout expired.Detail:

    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">

      <ErrorCode>-2147204783</ErrorCode>

      <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />

      <Message>SQL timeout expired.</Message>

      <Timestamp>2014-05-17T21:42:55.0927347Z</Timestamp>

      <InnerFault i:nil="true" />

      <TraceText i:nil="true" />

    </OrganizationServiceFault>

    Saturday, May 17, 2014 10:45 PM