Protect Upgrade Fails With: "There is a problem with this Windows Installer package."

Version 5


    Symptoms

     

    The Protect patch installer fails with the error  "There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor."

    Or

    "Another version of this product is already installed. Installation of this version cannot continue"

    ErrorUpgrade.PNG

    In the ST.DatabaseConfiguration.log you can see the following errors

     

    2014-10-28T20:43:25.5457040Z 0004 E DatabaseState.cs:77|System.Data.SqlClient.SqlException (0x80131904): Database state cannot be changed while other users are using the database 'ShavlikScans'
    ALTER DATABASE statement failed.


    2014-10-28T20:43:25.5525745Z 0004 E UnattendedInstaller.cs:95|Database installation failed: Unable to lock the database because there are existing connections.
    2014-10-28T20:43:25.5535560Z 0004 E DatabaseInstallerController.cs:378|Database 'Update' error: Unable to lock the database because there are existing connections..
    2014-10-28T20:43:25.5535560Z 0004 S DatabaseInstallerController.cs:238|ExecuteInstall|Leaving.
    2014-10-28T20:43:25.5918345Z 0004 E UnattendedInstaller.cs:149|ST.Data.SchemaInstaller.DbLockFailedException: Unable to lock the database because there are existing connections. ---> System.Data.SqlClient.SqlException: Database state cannot be changed while other users are using the database 'ShavlikScans'
    ALTER DATABASE statement failed.

     

    Cause

     

    The database is locked and cannot be altered.

     

    Solution


    Using Studio Management express you can detach and reattach the Protect Database, or the SQL server can be rebooted.

    Run the patch again to attempt the upgrade.

     

    Related Article

     

    Database Connection Error Caused by Missing SQL Server

    Database Connection Error Caused by Missing SQL Server