locked
CRM 2013 upgrade failed RRS feed

  • Question

  • Hello, I want to upgrade a CRM 2011 on premises instance to CRM 2013.

    Unfortunately it fails every time even if on the setup I select to just install CRM 2013 and upgrade later.

    Error message: Action Microsoft.Crm.Setup.Server.InstallConfigDatabase action failed.
    Cannot drop the table 'SiteLockProperties', because it does not exist or you do not have permissions.

    Indeed, SiteLockProperties does not exist in SQL :)

    verbose log:

    10:25:06|   Info| Installer Start: ConfigDBInstaller.Install: operation Upgrade
    10:25:06|   Info| Executing Install action: Microsoft.Crm.Setup.Server.SetConfigDBRegistrySettingsAction
    10:25:06|   Info| CrmAction execution time; SetConfigDBRegistrySettingsAction; 00:00:00.0156479
    10:25:06|   Info| Executing Install action: Microsoft.Crm.Setup.Server.InstallConfigDatabaseAction
    10:25:06|   Info| Initializing install strategy...
    10:25:06|   Info| Loading Releases...
    10:25:07|   Info| Executing IDiffBuilder.Pass1 ...
    10:25:11|   Info| Creating table MonitoringSettings
    10:25:12|   Info| Adding column FullName to table Server
    10:25:12|   Info| Creating relationships ...
    10:25:12|   Info| Executing IDiffBuilder.Pass2 ...
    10:25:12|   Info| Dropping table SiteLock
    10:25:12|   Info| CrmAction execution time; InstallConfigDatabaseAction; 00:00:06.2904558
    10:25:12|  Error| Installer Complete: ConfigDBInstaller - Error encountered
    10:25:12|Warning| Error reported while configuring _Deployment. Attempting rollback
    10:25:12|   Info| ConfigDBInstaller: Beginning uninstall operation
    10:25:12|   Info| ConfigDBInstaller:  Uninstall completed
    10:25:12|  Error| Install exception.System.Exception: Action Microsoft.Crm.Setup.Server.InstallConfigDatabaseAction failed. ---> System.Data.SqlClient.SqlException: Cannot drop the table 'SiteLockProperties', because it does not exist or you do not have permission.
       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.DatabaseInstaller.Common.SharedDatabaseUtility.ExecuteSql(IDbConnection connection, IDbTransaction transaction, String sql, Int32 timeout, Boolean enableTrace)
       at Microsoft.Crm.SystemDatabaseInstaller.Core.StandardConfigSqlStrategy.ExecuteSql(SqlObjectType type, IDbConnection connection, String sql)
       at Microsoft.Crm.SystemDatabaseInstaller.Core.StandardConfigSqlStrategy.AddSqlObject(SqlObjectType type, IDbConnection connection, String sql)
       at Microsoft.Crm.SystemDatabaseInstaller.Core.DiffBuilderBase.DropTables()
       at Microsoft.Crm.SystemDatabaseInstaller.Core.DiffBuilderBase.Pass2()
       at Microsoft.Crm.SystemDatabaseInstaller.Core.ReleaseBase.Install(IDbConnection connection)
       at Microsoft.Crm.SystemDatabaseInstaller.Core.DatabaseInstallerBase.Install()
       at Microsoft.Crm.Setup.Server.InstallConfigDatabaseAction.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.Setup.Server.ServerRoleInstaller.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:25:13|Verbose| Method exit: Microsoft.Crm.Setup.Server.ServerSetup.ExecuteOperation
    10:25:13|   Info| ActivatePage(ServerSetupFinishPage)

    Some advice?

    Thanks,
    Emanuel Ceciu

    Saturday, December 14, 2013 8:32 AM