Answered by:
Problem while Importing Through "Import Organization Wizard"

Question
-
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.- Moved by Andrii ButenkoMVP, Moderator Wednesday, August 10, 2011 6:50 AM (From:CRM)
Wednesday, August 10, 2011 5:00 AM
Answers
-
Thank You guys for Helping..
For this Issue I have reported to Microsoft.. We had Remote session with Server and root cause was the Customized Triggers applied on Leadbase table. While Deploying the Instance We have disabled the trigger and its worked out.
- Marked as answer by Sathish B R Thursday, September 8, 2011 6:03 AM
Thursday, September 8, 2011 6:03 AM
All replies
-
http://support.microsoft.com/kb/2306930
Eric UNG [Senior Analyst Programmer :: Sydney, Australia]Wednesday, August 10, 2011 5:06 AM -
Hi Eric, The Problem is while importing the instance itself..
Wednesday, August 10, 2011 6:10 AM -
Hi Sathish,
can you please elaborate more on the Version of the CRM, CRM4 or CRM 2011?? also can you tell on the exception stage in the import organization wizard.
Also i would suggest that, before running the import you update or match both source and destination CRM with the latest patch or any Update Rollup.
Also do keep in mind that any unsupported change in the Database will not be taken care in the import wizard, so if you have any unsupported change in CRM database you have to take of that too.
BharatKumar Bambhaniya Software Developer.- Proposed as answer by Bharat BambhaniyaMicrosoft employee Wednesday, August 10, 2011 6:41 AM
- Unproposed as answer by Sathish B R Friday, August 12, 2011 4:51 AM
Wednesday, August 10, 2011 6:39 AM -
Hi Bamboo,
CRM Version : CRM 4
I have CRM Rollup Updates of 6, 11 & 12.
But in our Test Server we dont have any Rollup updates. Let me install the same in Test Environment and try to import organization.
Wednesday, August 10, 2011 9:50 AM -
Hi Sathish, see the blog post below it mentions that Update Rollup 13 address the issue you have mentioned.
Give it a try since you are already installing updates. on both source and target servers then do the export and import organization with latest databases.
BharatKumar Bambhaniya Software Developer.- Proposed as answer by Bharat BambhaniyaMicrosoft employee Wednesday, August 10, 2011 10:00 AM
- Unproposed as answer by Sathish B R Friday, August 12, 2011 4:51 AM
Wednesday, August 10, 2011 10:00 AM -
Hi Bamboo..
Even Rollup 13 doesn't work for this issue.. Still unable to create instance with production database..
Friday, August 12, 2011 4:51 AM -
Hi sorry for not replying you immediately,
did you tried cleaning the unsupported sql stored procedures and other objects in organization database?
BharatKumar Bambhaniya Software Developer.Thursday, August 18, 2011 10:10 AM -
Looking at the error, I'd guess you may have duplicate organisation names or organisationids in the destination deployment. If possible, I'd delete any duplicate organisations (which you might have got by previous imports from Production) before importing.
If this doesn't help, the SQL Profiler tool could be used to capture the SQL query that's failing, which should give a better idea of the issue.
Microsoft CRM MVP - http://mscrmuk.blogspot.com http://www.excitation.co.ukFriday, August 19, 2011 8:13 AMModerator -
I Agree somewhat with the David, as i said, please check with the all un supported objects may created in the database and remove them as of now for the import wizard.
More on the suggestion to the Davids post.
you can check for the organization names in the Organization database and from SQL management studio or SQL query you can check and change the One of the Org's uniquename for while.
if your issues is solved please post here with the solution which sloved, or if you found this helpful please vote or mark accordingly.
sharing the self explored solution also could be of help to someone facing same issues.
Thanks.
Thanks, Bharatkumar. Save Nature For Future.Friday, August 19, 2011 12:38 PM -
Thank You guys for Helping..
For this Issue I have reported to Microsoft.. We had Remote session with Server and root cause was the Customized Triggers applied on Leadbase table. While Deploying the Instance We have disabled the trigger and its worked out.
- Marked as answer by Sathish B R Thursday, September 8, 2011 6:03 AM
Thursday, September 8, 2011 6:03 AM