locked
Error when installing RU 1 for MS CRM 2013 RRS feed

  • Question

  • Hi!

    I have the version 6.0.0.809 installed and want to upgrade to RU 1.

    While upgrading I get the error :

    Action Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed.

    Invalid column name 'MajorVersion'.
    Invalid column name 'MinorVersion'.
    Invalid column name 'BuildNumber'.
    Invalid column name 'DBUpdateActionId'.
    Invalid column name 'CrmDatabase'.

    Can someone help me solving this issue?

    And in the logs I see following:

    07:39:09|   Info| The MSI Installer succeeded. You must restart the computer for the changes to take effect.
    07:39:09|   Info| CrmAction execution time; MspInstallAction; 00:01:48.3872777
    07:40:18|   Info| CrmAction execution time; RegisterPerformanceCountersAction; 00:01:08.8274415
    07:40:18|   Info| CrmAction execution time; PatchPortalAction; 00:00:00.0156245
    07:40:18|   Info| CrmAction execution time; PatchPlatformAction; 00:00:00
    07:40:18|   Info| CrmAction execution time; PatchDeploymentWebServiceAction; 00:00:00
    07:40:18|   Info| CrmAction execution time; PatchPrivacyFileAction; 00:00:00.1406211
    07:40:18|   Info| CrmAction execution time; CreatePerformanceCountersAction; 00:00:00.0156246
    07:40:25|   Info| CrmAction execution time; RegisterRouterPerformanceCountersAction; 00:00:06.9398840
    07:40:31|   Info| Found the older table DBUpdateInstallInfo_V5, updating new table and deleting
    07:40:31|   Info| Updating table with older rows: DBUpdateInstallInfo
    07:40:31|   Info| InstallerException: Invalid column name 'MajorVersion'.
    Invalid column name 'MinorVersion'.
    Invalid column name 'BuildNumber'.
    Invalid column name 'DBUpdateActionId'.
    Invalid column name 'CrmDatabase'.
    07:40:31|  Error| System.Exception: Action Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed. ---> System.Data.SqlClient.SqlException: Invalid column name 'MajorVersion'.
    Invalid column name 'MinorVersion'.
    Invalid column name 'BuildNumber'.
    Invalid column name 'DBUpdateActionId'.
    Invalid column name 'CrmDatabase'.
       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.Setup.Common.Update.DBUpdateInstallInfo.CreateTablesIfNotExists()
       at Microsoft.Crm.Setup.Common.Update.DBUpdateInstallInfo..ctor(CrmDatabase database)
       at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ConfigOnPremiseInstall()
       at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.Install()
       at Microsoft.Crm.Setup.Common.Update.DBUpdateAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---, Error, RetryCancel, Option1
    07:40:36|   Info| InputResult: Retry
    07:40:36|   Info| CrmAction execution time; DBUpdateAction; 00:00:10.8450897
    07:40:37|   Info| Found the older table DBUpdateInstallInfo_V5, updating new table and deleting
    07:40:37|   Info| Updating table with older rows: DBUpdateInstallInfo
    07:40:37|   Info| InstallerException: Invalid column name 'MajorVersion'.
    Invalid column name 'MinorVersion'.
    Invalid column name 'BuildNumber'.
    Invalid column name 'DBUpdateActionId'.
    Invalid column name 'CrmDatabase'.
    07:40:37|  Error| System.Exception: Action Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed. ---> System.Data.SqlClient.SqlException: Invalid column name 'MajorVersion'.
    Invalid column name 'MinorVersion'.
    Invalid column name 'BuildNumber'.
    Invalid column name 'DBUpdateActionId'.
    Invalid column name 'CrmDatabase'.
       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.Setup.Common.Update.DBUpdateInstallInfo.CreateTablesIfNotExists()
       at Microsoft.Crm.Setup.Common.Update.DBUpdateInstallInfo..ctor(CrmDatabase database)
       at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ConfigOnPremiseInstall()
       at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.Install()
       at Microsoft.Crm.Setup.Common.Update.DBUpdateAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---, Error, RetryCancel, Option1
    07:40:38|   Info| InputResult: Retry
    07:40:38|   Info| CrmAction execution time; DBUpdateAction; 00:00:01.3742505
    07:40:38|   Info| Found the older table DBUpdateInstallInfo_V5, updating new table and deleting
    07:40:38|   Info| Updating table with older rows: DBUpdateInstallInfo
    07:40:38|   Info| InstallerException: Invalid column name 'MajorVersion'.
    Invalid column name 'MinorVersion'.
    Invalid column name 'BuildNumber'.
    Invalid column name 'DBUpdateActionId'.
    Invalid column name 'CrmDatabase'.
    07:40:38|  Error| System.Exception: Action Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed. ---> System.Data.SqlClient.SqlException: Invalid column name 'MajorVersion'.
    Invalid column name 'MinorVersion'.
    Invalid column name 'BuildNumber'.
    Invalid column name 'DBUpdateActionId'.
    Invalid column name 'CrmDatabase'.
       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.Setup.Common.Update.DBUpdateInstallInfo.CreateTablesIfNotExists()
       at Microsoft.Crm.Setup.Common.Update.DBUpdateInstallInfo..ctor(CrmDatabase database)
       at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ConfigOnPremiseInstall()
       at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.Install()
       at Microsoft.Crm.Setup.Common.Update.DBUpdateAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---, Error, RetryCancel, Option1
    07:40:39|   Info| InputResult: Retry
    07:40:39|   Info| CrmAction execution time; DBUpdateAction; 00:00:01.3431065
    07:40:40|   Info| Found the older table DBUpdateInstallInfo_V5, updating new table and deleting
    07:40:40|   Info| Updating table with older rows: DBUpdateInstallInfo
    07:40:40|   Info| InstallerException: Invalid column name 'MajorVersion'.
    Invalid column name 'MinorVersion'.
    Invalid column name 'BuildNumber'.
    Invalid column name 'DBUpdateActionId'.
    Invalid column name 'CrmDatabase'.
    07:40:40|  Error| System.Exception: Action Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed. ---> System.Data.SqlClient.SqlException: Invalid column name 'MajorVersion'.
    Invalid column name 'MinorVersion'.
    Invalid column name 'BuildNumber'.
    Invalid column name 'DBUpdateActionId'.


    Christian Ternek, www.mscrm-addons.com
    follow us twitter.com/mscrmaddons

    Thursday, December 19, 2013 6:52 AM

All replies

  • Further informations are:

    This was an in-place upgrade from CRM 2011 to crm2013.

    I see now that the dbupdateinstallinfo table looks completely different on this server as on the other server on which I installed a new version of CRM 2013.

    thx

    Thursday, December 19, 2013 6:52 AM
  • I am having this issue too, and mine is an in place upgrade also.

    Please assist.

    Thanks,

    Monday, December 23, 2013 8:36 PM
  • We too are also having the same problem. Ours was an in place upgrade also from CRM 2011 to 2013.

    Microsoft Help!

    Friday, December 27, 2013 4:53 AM
  • Hi,

    I also have this problem.  This was an in-place upgrade from 2011 to 2013.  This is also a database that started with CRM 1.2 and has been upgraded over the years.

    Thanks for any assistance.


    E. Palmer
    • Edited by eugp Wednesday, March 26, 2014 3:44 AM
    Wednesday, March 26, 2014 3:44 AM
  • Hi !

    I used following workaround:

    1) uninstall CRM 2013

    2) delete the MSCRM_CONFIG Database

    3) Install CRM 2013 with a new blank organization

    4)updated the server with the latest RU

    5) imported my original organization---> worked without problems

    It looks like the in-place upgrade destroyed something in the MSCRM_CONFIG and with the new install created a new MSCRM_CONFIg and with this I had no problems anymore.


    Christian Ternek, www.mscrm-addons.com
    follow us twitter.com/mscrmaddons

    Wednesday, March 26, 2014 6:01 AM