locked
Problem while Importing Through "Import Organization Wizard" RRS feed

  • 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.

    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

  • Have a look at this MS KB

    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.
    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.

     

    http://community.dynamics.com/product/crm/crmtechnical/b/crmcustomereffective/archive/2010/09/23/is-13-the-lucky-number-63.aspx

     

    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.
    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.uk
    Friday, August 19, 2011 8:13 AM
    Moderator
  • 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