Error while importing an Organization: ExecuteNonQuery requires an open and available Connection

  • Article

During the import of an Organization we have seen that the following error may occur:

ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

The following error can be seen in the CRM Platform trace:

19:03:33| Error| Import Organization (Name=Test2, Id=fb88688b-46a2-de11-8a64-0013724e5a05) 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.CrmDbConnection.Dispose(Boolean disposing)
at Microsoft.Crm.SqlExecutionContext.Dispose(Boolean disposing)
at Microsoft.Crm.SqlExecutionContext.Dispose()
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)

 

The above error is likely caused by a known Microsoft.Net Framework 2.0 issue. If your System.data.ni.dll file is less than 2.0.50727.1813, then you will need to update the Microsoft.Net Framework version on (at least) your Microsoft CRM server and also your Microsoft SQL Server. 

 

Related links
Hotfix rollup:
https://support.microsoft.com/kb/948815/en-us

Problem description:
https://support.microsoft.com/kb/948868/en-us

How to enable CRM Platform tracing:
https://support.microsoft.com/kb/907490/en-us

How to adjust OLEDBTimout settings:
https://support.microsoft.com/kb/918609/en-us

Greeting,
Dieter