locked
Import CRM 2011 Organization Failed- please help RRS feed

  • Question

  • Hi All,

    I am importing CRM 2011 organization in one of the dev server. Source and target CRM versions are same (having CRM 2011 with Rollup 17).

    CRM Server RAM: 4 GB RAM & SQL Server installed on the same server
    Orgnization DB size is 39 GB.

    During the import, I am getting below error. Please help.

    Log:

    07:42:36|   Info| Organization marked as having reports published
    07:42:36|   Info| Updating language packs
    07:42:36|   Info| Applying database updates
    07:42:36|   Info| Applying slipstream dbUpdates to organization.  Id=6258b633-2f81-e411-b75b-0050569a000c, UniqueName=Dev1.
    07:46:18|  Error| Import Organization (Name=Dev1, Id=6258b633-2f81-e411-b75b-0050569a000c) failed with Exception:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesException: Sdk Messages import: FAILURE ---> Microsoft.Crm.CrmException: Crm Internal Exception: Singleton Retrieve Query should not return more than 1 record. Query Executed = System.Data.SqlClient.SqlCommand
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.GetValuesFromDatabase(String entityName, Guid entityId, Boolean allowNonUniqueRows, ArrayList attributes, ArrayList extraConditions, Boolean isRetrieveUnpublished, ExecutionContext context)
       at Microsoft.Crm.BusinessEntities.SecurityAttributes..ctor(SecurityTraits traits, Guid objectId, Boolean allowNonUniqueRows, ArrayList attributes, ExecutionContext context)
       at Microsoft.Crm.BusinessEntities.SecurityExtension.CreateSecurityAttributesForUpdateDelete(Object sender, SecurityTraits traits, ExtensionEventArgs e)
       at Microsoft.Crm.BusinessEntities.SecurityExtension.PreUpdateHandler(ExtensionEventArgs e, Object sender)
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.PreUpdateEventHandler.Invoke(Object sender, ExtensionEventArgs e)
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.UpdateWithPipelineAndExtensions(IBusinessEntity entity, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.SdkMessageProcessingStepServiceInternal`1.Update(IBusinessEntity entity, ExecutionContext context)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportEntityHandlerBase.EnsureEntityExisted(BusinessProcessObject service, EntityExpression expression, BusinessEntity entity, ExecutionContext context)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportEntityHandlerBase.EnsureEntityExisted(BusinessProcessObject service, BusinessEntity entity, ExecutionContext context)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportSdkMessagerProcessingSteps(SdkMessage message, SdkMessageFilter filter, XmlNodeList stepNodes)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportSdkMessageFilters(XmlNode messageNode, SdkMessage message)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportSdkMessages(XmlNodeList sdkMessageNodes)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportSdkMessages(XmlNodeList sdkMessageNodes)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportItem()
       at Microsoft.Crm.Tools.ImportExportPublish.ImportHandler.Import()
       at Microsoft.Crm.Tools.ImportExportPublish.RootImportHandler.RunImport()
       at Microsoft.Crm.SE.DllMethodActions.ImportSystemSolution.Execute(String targetRevision)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
       at Microsoft.Crm.Setup.Database.DllMethodAction.Execute(Guid organizationId)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.InstallUpdate(String configurationFilePath, Boolean upgradeDatabase)
       at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ApplyDBUpdatesForSpecificRelease(Guid orgId, String releaseFilePath)
       at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdatesInternal(Guid orgId, String orgUniqueName, String releaseFilePath, Boolean ignoreErrors)
       at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdates(Guid orgId, String orgUniqueName, OrganizationOperationType operationType)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, ICollection`1 users, MultipleTenancy multipleTenancy, Int32 fullTextSearchLocaleId)
    07:46:19|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 4150.
    07:46:38|  Error| Import Organization (Name=Dev1, Id=6258b633-2f81-e411-b75b-0050569a000c) failed with Exception:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesException: Sdk Messages import: FAILURE ---> Microsoft.Crm.CrmException: Crm Internal Exception: Singleton Retrieve Query should not return more than 1 record. Query Executed = System.Data.SqlClient.SqlCommand
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.GetValuesFromDatabase(String entityName, Guid entityId, Boolean allowNonUniqueRows, ArrayList attributes, ArrayList extraConditions, Boolean isRetrieveUnpublished, ExecutionContext context)
       at Microsoft.Crm.BusinessEntities.SecurityAttributes..ctor(SecurityTraits traits, Guid objectId, Boolean allowNonUniqueRows, ArrayList attributes, ExecutionContext context)
       at Microsoft.Crm.BusinessEntities.SecurityExtension.CreateSecurityAttributesForUpdateDelete(Object sender, SecurityTraits traits, ExtensionEventArgs e)
       at Microsoft.Crm.BusinessEntities.SecurityExtension.PreUpdateHandler(ExtensionEventArgs e, Object sender)
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.PreUpdateEventHandler.Invoke(Object sender, ExtensionEventArgs e)
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.UpdateWithPipelineAndExtensions(IBusinessEntity entity, ExecutionContext context)
       at Microsoft.Crm.ObjectModel.SdkMessageProcessingStepServiceInternal`1.Update(IBusinessEntity entity, ExecutionContext context)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportEntityHandlerBase.EnsureEntityExisted(BusinessProcessObject service, EntityExpression expression, BusinessEntity entity, ExecutionContext context)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportEntityHandlerBase.EnsureEntityExisted(BusinessProcessObject service, BusinessEntity entity, ExecutionContext context)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportSdkMessagerProcessingSteps(SdkMessage message, SdkMessageFilter filter, XmlNodeList stepNodes)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportSdkMessageFilters(XmlNode messageNode, SdkMessage message)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportSdkMessages(XmlNodeList sdkMessageNodes)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportSdkMessages(XmlNodeList sdkMessageNodes)
       at Microsoft.Crm.Tools.ImportExportPublish.ImportSdkMessagesHandler.ImportItem()
       at Microsoft.Crm.Tools.ImportExportPublish.ImportHandler.Import()
       at Microsoft.Crm.Tools.ImportExportPublish.RootImportHandler.RunImport()
       at Microsoft.Crm.SE.DllMethodActions.ImportSystemSolution.Execute(String targetRevision)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
       at Microsoft.Crm.Setup.Database.DllMethodAction.Execute(Guid organizationId)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.InstallUpdate(String configurationFilePath, Boolean upgradeDatabase)
       at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ApplyDBUpdatesForSpecificRelease(Guid orgId, String releaseFilePath)
       at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdatesInternal(Guid orgId, String orgUniqueName, String releaseFilePath, Boolean ignoreErrors)
       at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdates(Guid orgId, String orgUniqueName, OrganizationOperationType operationType)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, ICollection`1 users, MultipleTenancy multipleTenancy, Int32 fullTextSearchLocaleId)

    Thursday, December 11, 2014 1:48 PM

All replies

  • Have you already imported this organization onto the new server already?
    Monday, December 15, 2014 11:53 AM
  • HI,

    Did anyone ever find a solution to this error "Singleton Retrieve Query should not return more than 1 record"?

    I do get the same when importing a CRM 4.0 database into a new installed CRM 2011 environment.

    Any help is very much appriciated.

    Kind Regards,
    Peter

    Friday, February 5, 2016 10:30 AM