CRM 4.0 Import organization Trace error

• Friday, 27 July 2012 2:27 PM

   

   
  

  0

  Dear All,

  I am getting the following error when I import the organization and  it is failed. Please share me any exact solution for the below error.

  18:46:20|  Error| Import Organization (Name=bsilmktg, Id=5f1bb13c-e9d7-e111-80a5-0080ad8d0240) 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)
  18:46:20|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.
  18:46:51|  Error| Import Organization (Name=bsilmktg, Id=5f1bb13c-e9d7-e111-80a5-0080ad8d0240) failed.
  The changes made during Import Organization could not be rolled back. Please manually delete the Organization database from the 'MDT699' SQL Server if it was not successfully deleted.

  System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
     at System.Data.SqlClient.SqlInternalConnection.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.SqlDataReader.ConsumeMetaData()
     at System.Data.SqlClient.SqlDataReader.get_MetaData()
     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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
     at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
     at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
     at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command)
     at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate)
     at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command)
     at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context)
     at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieveMultiple(BusinessEntityCollection entities, EntityExpression entityExp, ExecutionContext context)
     at Microsoft.Crm.BusinessEntities.BusinessProcessObject.RetrieveMultiple(EntityExpression entityExpression, ExecutionContext context)
     at Microsoft.Crm.Setup.Server.Utility.NewOrgUtility.RemoveExistingUsersFromConfigDatabase(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)

  ---

  Thanks & Regards, CRM Sudhakar

  • Reply
  • Quote