locked
Error Upgrading to 2011 from CRM 4.0 RRS feed

  • Question

  • Hi,

    I am trying to upgrade from CRM 4.0 to 2011. The installation fails and the below is an excerpt from the log. Any help is much appreciated:

    10:08:57|   Info| Setting organization state.  New state = Failed

    10:08:57|  Error| Install exception.System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. 

     

    ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> 

     

    System.Data.SqlClient.SqlException: Invalid column name 'DeletionStateCode'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

       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.DataUpgrade.AuditUpgradeDriver.CorrectCreatedByEmptyData(MetadataBusinessEntity entity)

       at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeData()

       at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeAuditData()

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

       --- End of inner exception stack trace ---

       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)

       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)

       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)

       at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)

       at Microsoft.Crm.Setup.Common.ComposedInstaller.InvokeInstall(Installer installer, IDictionary stateSaver)

       at Microsoft.Crm.Setup.Common.ComposedInstaller.InternalInstall(IDictionary stateSaver)

       at Microsoft.Crm.Setup.Common.ComposedInstaller.Install(IDictionary stateSaver)

       at Microsoft.Crm.Setup.Server.ServerSetup.Upgrade(IDictionary data)

       at Microsoft.Crm.Setup.Common.SetupBase.ExecuteOperation()

    10:08:57|Verbose| Method exit: Microsoft.Crm.Setup.Server.ServerSetup.ExecuteOperation

    10:08:57|   Info| ActivatePage(ServerSetupFinishPage)

     

     

    --Srihari.


    Srihari R
    Wednesday, March 16, 2011 2:38 AM

Answers

  • I figured it out. There were a lot of SP's and triggers that were referencing the 'DeletionStateCode' in the database. I currently dropped all the custom sp's and triggers and the installation completed just fine.
    Srihari R
    • Marked as answer by Srihari R Wednesday, March 16, 2011 7:07 AM
    Wednesday, March 16, 2011 7:07 AM

All replies

  • I figured it out. There were a lot of SP's and triggers that were referencing the 'DeletionStateCode' in the database. I currently dropped all the custom sp's and triggers and the installation completed just fine.
    Srihari R
    • Marked as answer by Srihari R Wednesday, March 16, 2011 7:07 AM
    Wednesday, March 16, 2011 7:07 AM
  • i have the same error.

    could you post the query that you used?

    Tuesday, July 10, 2012 4:15 PM