Dear Friends,
I have been trying to import Organization from Production Database, I have uploaded it to SQL Server Successfully but when Im trying to use "Import Organization Wizard" . It is throughing an Error given below"
16:45:00|Verbose| Calling BaseGroup.Validate
16:45:00| Info| Check ReportingUrlValidator: Success
16:45:00| Info| Check ExistingRSValidator: Success
16:45:00|Verbose| BaseGroup.Validate completed
16:45:00|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
16:45:00|Verbose| Validation ran.
16:45:00|Verbose| Validation completed.
16:45:00|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
16:45:00|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
16:45:00|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
16:45:00|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
16:45:22| Info| Import Organization (FallbackCrm)
16:45:22| Info| Update Organization...
16:45:32| Info| Update Users...
16:45:53|Verbose| Update Active Directory properties for entry {0}|
LDAP://mhp1wpdc01.corp.hexaware.com/<GUID=2d0eded3-2baa-46f8-bbb8-88ab4ead13c8>
16:45:53|Verbose| Populate with user
16:45:53|Verbose| Updating membership
16:45:53|Verbose| Old account {0}| CORP\16705
16:45:53|Verbose| Adding new account {0}| CORP\16705
16:45:53|Verbose| Found dn {0}| CN=Rajiv Pant,OU=Sales Users,OU=USA,DC=corp,DC=hexaware,DC=com
16:45:53|Verbose| Attempting to add user using distinguished name. DN = {0}| CN=Rajiv Pant,OU=Sales Users,OU=USA,DC=corp,DC=hexaware,DC=com
16:45:55|Verbose| Update completed
16:45:55|Verbose| Update Active Directory properties for entry {0}|
LDAP://mhp1wpdc01.corp.hexaware.com/<GUID=7b5fbbce-630e-4e09-b73b-e20622e27081>
16:45:55|Verbose| Populate with user
16:45:55|Verbose| Updating membership
16:45:55|Verbose| Old account {0}| CORP\16705
16:45:55|Verbose| Adding new account {0}| CORP\16705
16:45:55|Verbose| Found dn {0}| CN=Rajiv Pant,OU=Sales Users,OU=USA,DC=corp,DC=hexaware,DC=com
16:45:55|Verbose| Attempting to add user using distinguished name. DN = {0}| CN=Rajiv Pant,OU=Sales Users,OU=USA,DC=corp,DC=hexaware,DC=com
16:45:56|Verbose| Update completed
16:45:56|Verbose| User added successfully to the OU groups in Active Directory
16:46:09| Error| Import Organization (Name=FallbackCrm, Id=da55fdde-78c2-e011-9a09-005056800016) failed with Exception:
System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
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.Tools.Admin.DBImportHelper.UpdateSystemUserReferences(IDbCommand command, Guid oldSystemUserId, Guid newSystemUserId, Guid newAdObjectGuid, DomainAccount newAdDomainAccount)
at Microsoft.Crm.Tools.Admin.DBImportHelper.UpdateSystemUserAndReferences(IDbCommand command, User user, Guid organizationId)
at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, String privilegedUserGroupName,
String sqlAccessGroupName, String userGroupName, String reportingGroupName, String privilegedReportingGroupName, ICollection`1 users, MultipleTenancy multipleTenancy)
16:46:09|Warning| Attempting to cancel a long running process: ProgressWizard. This might leave the data in an invalid state and the application might not function correctly.
03:27:00|Warning| Attempting to cancel a long running process: FinishWizard. This might leave the data in an invalid state and the application might not function correctly.
