locked
Deployment manager Import Org process gets an error RRS feed

  • Question

  • Hi,

     

    I'm trying to import an organization, the database has been restored and given a different name. it has 10k users. and always get the same error on the log:

     

    11:38:18|   Info| Import Organization (OrgDevTesting)
    11:38:18|   Info| Update Organization...
    11:38:24|   Info| Update Users...

    11:38:30|  Error| Import Organization (Name=OrgDevTesting, Id=8e1df362-6ba4-df11-8730-005056af0e0d) failed with Exception:
    System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.SystemUserOrganizations' with unique index 'SystemUserOrganizations_CrmUserId'.


    The statement has been terminated.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
       at Microsoft.Crm.SharedDatabase.DatabaseService.Create(String tableName, PropertyBag columnSet)
       at Microsoft.Crm.Authentication.CrmPrincipal.AddPrincipalToConfigDB(Guid organizationId, Guid crmId, String authInfo)
       at Microsoft.Crm.ObjectModel.SystemUserServiceInternal`1.AddUserToConfigDB(IBusinessEntity systemUser, Guid crmId, SecurityIdentifier identifier, ExecutionContext context)
       at Microsoft.Crm.Tools.Admin.DBImportHelper.AddExistingUserToTheConfigDB(Guid organizationId, Guid crmUserId, SecurityIdentifier userSID)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String

     

    does anyone can tell what's happening ?

    Tuesday, August 10, 2010 11:10 AM
    Answerer

Answers