Failure to import installation database error when upgrading Ops Manager

Products

• Operations Manager

Issue/Introduction

Symptoms:
Upgrades can fail when Postgres database is newer than Ops Manager version. 

The following error may appear:

{"errors":{"installation_asset_collection":["failed to import installation database"]}}

Environment

Cause

When you upgrade Ops Manager to a version with an older version of Postgres, the installation database import may fail. 

This error can occur when you upgrade from a recent patch of a lower version to a higher version with an earlier release date than the patched version you are upgrading from. For example, if you upgrade from PCF (Pivotal Cloud Foundry) 1.11.5 to PCF 1.12.0, you may encounter this error. 

Recent versions of Postgres are incompatible with data dumps from previous versions of Postgres. Ops Manager includes an updated version of Postgres, so if you are upgrading from a version of Ops Manager with a more recent version of Postgres to a version of Ops Manager with an older version of Postgres, data import can fail.

Resolution

There is no remediation for this error, but it is rare. As a best practice, upgrade to the most recent patch and version of PCF whenever possible.