How to migrate the Postgres database after a failure during MSME 8.5 upgrade

Technical Articles ID: KB82793
Last Modified: 9/18/2014

Environment

McAfee Security for Microsoft Exchange 8.5
Microsoft Windows 2012, 2008 x64-bit, 2003 x64-bit
Microsoft Exchange 2013, 2010 SP2, 2007 SP3

For product supported environments, see KB82890.

Problem

During an upgrade to McAfee Security for Microsoft Exchange (MSME) 8.5 from a previous version (such as MSME 8.0), the upgrade fails with a generic installer error (for example, a 1920 or 1630 error).

When this occurs, the installer rolls back and leaves MSME in an uninstalled state.

Cause

The migration of key MSME databases to the new installation folder location fails. This data must be moved from the backup location using either an automated script (Solution 1), or a manual process (Solution 2).

Solution

Automated migration of databases from backup location

When an upgrade starts, the installer creates a backup of the quarantine data along with PostgreSQL. Run the Powershell script attached to this article to move the relevant databases from the backup location to the default database folder. This Powershell script performs all necessary prerequisite actions required when the upgrade installation fails.

NOTE: This script should be used only when an upgrade fails with MSME 8.5, and the installation rolls back to an uninstalled state. Prior to running the script, ensure that no 'orphan' RPC/Postgres processes are running. If you are unsure how to check this, see the Related Information section for details.

Open a Windows Powershell or Exchange Management shell session, type the following command, and then press ENTER:

DBMigration_prerequisite
Run the MSME 8.5 setup again (either stand-alone or via ePolicy Orchestrator) to ensure that all components are updated correctly. This time, the installation will complete successfully.

Solution

Manual migration of databases from backup location

When an upgrade starts, the installer creates a backup of the quarantine data along with PostgreSQL. Perform the following steps to migrate this backed-up database manually:

NOTE: These steps should only be used when an upgrade fails with MSME 8.5, and the installation rolls back to an uninstalled state. Prior to performing these steps, ensure that no 'orphan' RPC/Postgres processes are running. If you are unsure how to check this, see the Related Information section of this article for details.

Verify that both the Quarantine data and PostgreSQL are backed up in the Upgrade folder (<%ProgramData%>\McAfee\MSME\Upgrade). This should contain a Data folder, and a PostgreSQL folder.
When you have confirmed that a backup exists, delete the files/folders in the default Database folder (<%ProgramData%>\McAfee\MSME\Data).
IMPORTANT: Do not delete the Upgrade folder.
Click Start, Run, type regedit and then click OK.
Verify that the registry key shown below exists. If it does not exist, create it:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\McAfee\MSME\Repository
Under this location, create the following three entries:
- RunPGUpgradePending (type: DWORD, value: 1)
- RunUpgradeScripts (type DWORD, value: 1)
- UpgradeBackupRootPath (type: String, value: path of your backup folder. For example C:\ProgramData\McAfee\MSME\Upgrade)
Run the MSME 8.5 installation again (either stand-alone or via ePolicy Orchestrator) to ensure that all components are updated correctly. This time, the installation will complete successfully.

When the installation completes, the database will be upgraded successfully and your quarantined items will be visible in Detected Items in the same way as with your previous MSME installation.

Related Information

You may need to manually terminate Windows processes. Follow these steps to terminate the Security for Exchange RPC/Postgres processes:

Click Start, Run, type taskmgr, and click OK.
Click the Processes tab.
Click Image Name to sort the list by Process Name.
If any of the following processes are listed, select them and click End Process:

Safeservice.exe
RPCserv.exe (two instances)
Postgres.exe (multiple instances)

Attachment

DBMigration_prerequisite.zip
2K • < 1 minute @ broadband

Affected Products

Known Issue/Product Defect
Security for Microsoft Exchange 8.5
Upgrade/Migrate

Glossary of Technical Terms

Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.

How to migrate the Postgres database after a failure during MSME 8.5 upgrade

Environment

Problem

Cause

Solution

Solution

Related Information

Attachment

Affected Products

Glossary of Technical Terms

Title

Title

Featured Solutions:Draft for New Nav

Explore Our Portfolio

Security Outcomes

Industries

Products

Featured Solutions

Explore Our Portfolio

MVISION Products

Services & Training

Threat Research

Our Researchers

Threat Landscape Dashboard

Tools

Contact Us

Resources

Downloads

Product Help

Connect with Us

Explore

Our Company

Our Efforts

Other Resources

Careers

Partnerships

How to migrate the Postgres database after a failure during MSME 8.5 upgrade

Environment

Problem

Cause

Solution

Solution

Related Information

Attachment

Affected Products

Glossary of Technical Terms

Choose your region

Title

Title