Environment

Symptom

When attempting an upgrade from Elastic Runtime (ER) 1.7.x to 1.8.x, when you click on 'Apply Change' in Ops Manager GUI, the installation process just stops and there are error messages on the web page as below

Please review the errors below
Database verification error: Unknown database 'routing'
All errors will be verified before installation. 

Cause

In ER 1.8, if the customer is using an external database, it is required that one additional database named 'routing' is created.


In ER the .9, if the customer is using an external database, it is required that two additional databases named 'routing' and 'diego' are created. 


Resolution

For Pivotal Cloud Foundry (PCF) 1.8, you need to connect to the external database, and 

create database routing; 

For PCF 1.9, you need to connect to the external database, and 

create database routing;
create database diego; 

Additional Information

Please note that this is a temporary resolution. We will update the document in Section 'Create External System Databases' Step 4 shortly.