Failures during the upgrade of a Discovery Center installation may require that a clean installation be performed using an existing database backup.
This article assumes that you have backed up your pre-upgrade database before attempting the initial upgrade as per the Installation guide. Failure to do so may lead to an unrecoverable loss of index data.
Cause
Failed upgrades may result in a situation where the upgrade cannot progress, and so it must roll back to the most stable state. This may leave the software in a condition where the database is not upgraded, with program components removed.
Resolution
Discovery Center upgrades can fail for many reasons; typically related to environmental issues such as firewalls, pre-requisite software, and permissions to SQL and SSAS. Resolving the cause of the initial upgrade failure must be addressed first. Check the installation log for the cause, and correct the issue before continuing.
- Ensure that your original installation is completely removed using the Windows uninstaller or the manual uninstallation steps detailed in the Discovery Center installation guide Common Problems section.
- Verify if your database is still available by accessing the database object node in SSMS, and looking for your Discovery Center Database.
- If the Database is not there, restore the original from a backup:
- Using SSMS, connect to your database instance and right-click on the 'database' node in the Object Explorer
- Select 'Restore Database...'
- Follow the directions from SSMS to choose your backed up database and restore it ensuring that its name is unchanged.
- Run the Discovery Center installer as normal, and when prompted for the SQL server instance and database name, enter the details for the SQL server where the restored database is stored and the restored database name.
- You will be informed that an existing database has been found and asked if you wish to upgrade, which you will choose yes. The installer will then proceed to install the new version as expected.
- Failures after this procedure has been completed are most likely caused by differences between the original installation and the new installation. Contact ActiveNav support for assistance, providing as much information as possible about the reported error.
How to submit a ticket to ActiveNav Support