locked
Upgrade CRM 4.0 to CRM 2011 Import Organization Failed RRS feed

  • Question

  • Hi everyone:<o:p></o:p>

    I’m trying to upgrade CRM 4.0 to CRM 2011 and here is what I did. I began with a clean install of CRM 2011 and then copied the CRM 4.0 database and restored into a new SQL server. I'm having issues when I try to import CRM 4.0 organization into CRM 2011 server.  <o:p></o:p>

    Below is the error.

    Upgrade indexes

    Verbose| CleanupIndexes : Cleaning up  indexes
    Verbose| DatabaseAction execution time; Bin\Microsoft.Crm.DataUpgrade.dll:CleanupNonNullableColumns; 00:00:00.0781245
    Info| Upgrade indexes
    Info| CrmAction execution time; UpgradeDatabaseAction; 01:45:30.1950525
    Error| Installer Complete: OrganizationUpgrader - Error encountered
    Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationUpgrader: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed.
    InnerException:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.AggregateException: One or more errors occurred. ---> 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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.ReadByte()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.CreateIndexOrConstraintInSqlInternal(IndexData indexData, Boolean isForPrimaryTable, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.CreateOrRecreateIndexOrConstraintInternal(IndexData fullDataOfIndexToRegenerate, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RunParallelIndexCreateOrRecreateIndexOrConstraintCreation(IndexData indexToCreate, IIndexMetadataProvider metadata, ISqlExecutionContext context)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.<>c__DisplayClassa.<RestoreClusteredPrimaryKeyConstraints>b__9(IndexData indexToCreate)
       at System.Threading.Tasks.Parallel.<>c__DisplayClass32`2.<PartitionerForEachWorker>b__30()
       at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
       at System.Threading.Tasks.Task.<>c__DisplayClass7.<ExecuteSelfReplicating>b__6(Object )
       --- End of inner exception stack trace ---
       at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
       at System.Threading.Tasks.Task.Wait()
       at System.Threading.Tasks.Parallel.PartitionerForEachWorker[TSource,TLocal](Partitioner`1 source, ParallelOptions parallelOptions, Action`1 simpleBody, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
       at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
       at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RestoreClusteredPrimaryKeyConstraints(Dictionary`2 indexesToRecreate, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RecreateIndexesInternal(Dictionary`2 indexesToRecreate, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RecreateIndexes(IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext, Func`2 recreateIndex)
       at Microsoft.Crm.Setup.IndexAndConstraintUpgradeService.RestoreIndexesAndConstraints()
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
       at Microsoft.Crm.Setup.Database.DllMethodAction.Execute()
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
       at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
       at Microsoft.Crm.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
    InnerException:
    System.AggregateException: One or more errors occurred. ---> 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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.ReadByte()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.CreateIndexOrConstraintInSqlInternal(IndexData indexData, Boolean isForPrimaryTable, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.CreateOrRecreateIndexOrConstraintInternal(IndexData fullDataOfIndexToRegenerate, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RunParallelIndexCreateOrRecreateIndexOrConstraintCreation(IndexData indexToCreate, IIndexMetadataProvider metadata, ISqlExecutionContext context)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.<>c__DisplayClassa.<RestoreClusteredPrimaryKeyConstraints>b__9(IndexData indexToCreate)
       at System.Threading.Tasks.Parallel.<>c__DisplayClass32`2.<PartitionerForEachWorker>b__30()
       at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
       at System.Threading.Tasks.Task.<>c__DisplayClass7.<ExecuteSelfReplicating>b__6(Object )
       --- End of inner exception stack trace ---
       at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
       at System.Threading.Tasks.Task.Wait()
       at System.Threading.Tasks.Parallel.PartitionerForEachWorker[TSource,TLocal](Partitioner`1 source, ParallelOptions parallelOptions, Action`1 simpleBody, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
       at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
       at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RestoreClusteredPrimaryKeyConstraints(Dictionary`2 indexesToRecreate, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RecreateIndexesInternal(Dictionary`2 indexesToRecreate, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RecreateIndexes(IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext, Func`2 recreateIndex)
       at Microsoft.Crm.Setup.IndexAndConstraintUpgradeService.RestoreIndexesAndConstraints()
    ---> (Inner Exception #0) System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.ReadByte()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.CreateIndexOrConstraintInSqlInternal(IndexData indexData, Boolean isForPrimaryTable, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.CreateOrRecreateIndexOrConstraintInternal(IndexData fullDataOfIndexToRegenerate, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RunParallelIndexCreateOrRecreateIndexOrConstraintCreation(IndexData indexToCreate, IIndexMetadataProvider metadata, ISqlExecutionContext context)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.<>c__DisplayClassa.<RestoreClusteredPrimaryKeyConstraints>b__9(IndexData indexToCreate)
       at System.Threading.Tasks.Parallel.<>c__DisplayClass32`2.<PartitionerForEachWorker>b__30()
       at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
       at System.Threading.Tasks.Task.<>c__DisplayClass7.<ExecuteSelfReplicating>b__6(Object )<---

    InnerException:
    System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.ReadByte()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.CreateIndexOrConstraintInSqlInternal(IndexData indexData, Boolean isForPrimaryTable, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.CreateOrRecreateIndexOrConstraintInternal(IndexData fullDataOfIndexToRegenerate, IIndexMetadataProvider metadata, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.RunParallelIndexCreateOrRecreateIndexOrConstraintCreation(IndexData indexToCreate, IIndexMetadataProvider metadata, ISqlExecutionContext context)
       at Microsoft.Crm.Metadata.IndexAndConstraintManagementService.<>c__DisplayClassa.<RestoreClusteredPrimaryKeyConstraints>b__9(IndexData indexToCreate)
       at System.Threading.Tasks.Parallel.<>c__DisplayClass32`2.<PartitionerForEachWorker>b__30()
       at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
       at System.Threading.Tasks.Task.<>c__DisplayClass7.<ExecuteSelfReplicating>b__6(Object )

    Thursday, August 16, 2012 12:11 PM

All replies

  • Hi LiiBan,

     Installing Rollups for 2011 might solve this kind of issue. You can try this

    Download Update Rollup 1 : http://www.microsoft.com/downloads/details.aspx?FamilyID=8CD2384E-E06A-4CF1-800D-303AEC37F40B&amp;displaylang=th&displaylang=en

    Thanks

    T.Vinoth

    Thursday, August 16, 2012 12:39 PM
  • Hi Vinoth:

    We did install Rollup for 2011 (both rollup 6 and the 7). So I don't think it faills due the lack of update/rollup.

    Thursday, August 16, 2012 12:57 PM
  • Dear LiiBan,

    (sorry for my english)

    Did you solve this problem? I got the same issue when I was importing CRM 4 Organization to CRM 2011. The problem is in Roll Up 6.

    Please see http://support.microsoft.com/kb/2710577

    Here's the important update in Roll Up 10. "After you apply Microsoft Dynamics CRM 2011 Update Rollup 6, you cannot create new organizations. Additionally, you cannot import organizations."

    If you haven't fix this problem. You could install Roll Up 10 then import the organization, or you can import the organization before you install the roll up.

    Tuesday, October 2, 2012 7:05 AM