locked
Import Organization Failed RRS feed

  • Question

  •  

    We are trying to import an organization from our live CRM system into a second system which we can use to run some tests for some customizations we are planning to roll out.

     

    Unfortumately, when we run the import we are getting the following error message.  Can anyone help??

     

    Error| Import Organization (Name=CSWMDEV, Id=60f38ddb-abe8-dd11-ab03-005056b945dd) failed with Exception:
    System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
       at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
       at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
       at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
       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.CrmDbConnection.SetTransactionIsolationLevel(IsolationLevel il)
       at Microsoft.Crm.CrmTransaction.RollbackTransaction(Boolean raiseException)
       at Microsoft.Crm.SqlExecutionContext.OnErrorRequest()
       at Microsoft.Crm.BusinessEntities.ExecutionContext.OnErrorRequest()
       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)

    Thursday, January 22, 2009 5:58 PM

Answers

  • Hi,

    add a DWORD registry value to

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM\OleDbTimeout
    This specifies the value in seconds (the default is 30secs)

    You need to run IISReset after changing this value for it to take effect


    Viele Grüße Michael Sulz axcentro GmbH
    Saturday, April 25, 2009 10:58 AM
  • Have you tried to add the OLETimeout and extendedtimeout paramters to regitsry where SQL server is intalled because import is a lengthy process and SQL server closes the connection. It may work!

    Wednesday, January 28, 2009 3:54 AM
    Moderator
  • You might also consider importing individual entities (or groups of entities) if you have a lot of custom attributes and entities.  There is a lot of work being done when new entities/attributes are created during the import and running this in smaller batches can often work around this problem.  After the initial groups of entities are imported, a "Import All" will usually work w/o changing the timeout.


    Matt, MVP - Dynamics CRM
    Monday, May 4, 2009 8:25 PM

All replies

  • Have you tried to add the OLETimeout and extendedtimeout paramters to regitsry where SQL server is intalled because import is a lengthy process and SQL server closes the connection. It may work!

    Wednesday, January 28, 2009 3:54 AM
    Moderator
  • Hi!!
    I have the same problem. Can you resolved this??
    Thanks,
    Friday, February 6, 2009 10:42 PM
  • Did you find the solution of this problem, i am desperately looking for answer as well,

    Thanks,
    Saturday, April 25, 2009 12:48 AM
  • Hi Ayaz can you tell me exactly how do i change oletimeout in registry.
    Thanks
    Saturday, April 25, 2009 12:49 AM
  • Hi,

    add a DWORD registry value to

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM\OleDbTimeout
    This specifies the value in seconds (the default is 30secs)

    You need to run IISReset after changing this value for it to take effect


    Viele Grüße Michael Sulz axcentro GmbH
    Saturday, April 25, 2009 10:58 AM
  • You might also consider importing individual entities (or groups of entities) if you have a lot of custom attributes and entities.  There is a lot of work being done when new entities/attributes are created during the import and running this in smaller batches can often work around this problem.  After the initial groups of entities are imported, a "Import All" will usually work w/o changing the timeout.


    Matt, MVP - Dynamics CRM
    Monday, May 4, 2009 8:25 PM
  • Unfortunatly, it does not seem to work here:

    17:25:48|   Info| Import Organization (SelfNet)
    17:25:48|   Info| Organisatie bijwerken...
    17:25:58|   Info| Gebruikers bijwerken...
    17:26:00|  Error| Het importeren van de organisatie (naam=SelfNet, id=3b157351-1b3b-de11-b6d1-000c295b3233) is mislukt. Uitzonderingsfout:
    System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
       at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
       at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
       at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

    I edited bot values in the registry of the CRM IIS and did an iisreset; but still won't import. What can I do more?

    Regards,
    Philippe
    it's all very nice when it works
    Thursday, May 7, 2009 3:29 PM
  • Please check user permission in sql server
    Shubh
    Tuesday, February 15, 2011 5:56 AM