Error when trying to configure the CRM 2015 Outlook client


Error: CrmSqlCeConnection::ExecuteInNewConnection() Unexpected Exception: System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: Therre must be one and only one Organization record (Fault Detail is equal to Microsoft.Xrm.Sdk.OrganizationServiceFault).

Cause: This can be caused because of a duplicate Organization entry in the OrganizationBase table in the OrgDB
If you have imported an organization from within the same deployment this could happen.

Resolution:
Run the query to find out if there are more than 1 record on the OrgnizationBase table.
/* Replace Orgname with your Organization name */
Use Orgname_MSCRM
Select * from OrganizationBase

Ideally there should be only 1 row. We need to delete the incorrect one. Query the ConfigDB to find the right Organization ID for your CRM org.
SELECT [DatabaseName],[FriendlyName] ,[Id]  FROM [MSCRM_CONFIG].[dbo].[Organization]

Delete the unwanted record from the OrgnizationBase table in the CRM Organization database
/* Replace Orgname with your Organization name */
Use Orgname_MSCRM
Delete from Organizationbase where OrganizationId != 'Paste the correct OrganizationId here'

Disclaimer: Take a backup of your CRM databases before making any changes.

Comments (4)

  1. Mayank Agrawal says:

    This helped me today. Thanks!

  2. Michiel says:

    Thanks! This also helped me.

  3. Poncho says:

    Huge thanks for this post – well done mate. Really solved an issue and got everything back on track.

    Cheers

  4. Brandon P says:

    I believe that this is caused by a serious bug in the Dynamics CRM import organization functionality.  I stumbled upon the problem of multiple entries in the OrganizationBase table from another direction.

    I created Org1, backed it up in SQL server, restored and imported it to Org2.  Then repeated with Org2 by backing it up, restoring and importing to Org3.  At this point I cannot log in to Org3 with any account.  If I do the procedure described in this post to remove the extraneous record in OrganizationBase in Org2, then I can backup and import to Org3 and it will work.

    Microsoft needs to address this.

Skip to main content