Upgrade to PAS 2.3 smoke-test fails on the push-app-usage-service errand

Products

• VMware Tanzu Application Service for VMs

Issue/Introduction

Symptoms:
When upgrading to Pivotal Cloud Foundry (PCF) v2.3.0 / 2.3.1 / 2.3.2,  the deployment will fail on the smoke-tests. The following error will be found in the changelog for the failed deployment. You can see from this error that the MySQL Service Hostname is not included in the MySQL connection string. 

Gem Load Error is: the scheme mysql2 does not accept registry part: app_usage:O53m5zigVVIrrhkjYl7JBqlGvrAadc@:3306 (or bad hostname?)

Environment

Cause

The cause of this error is that the database link is not being properly populated during the push-app-usage-service errand.

Resolution

If you have already upgraded to PAS (2.3.0 /2.3.1/ 2.3.2) , please follow this process: 

Disable the push-app-usage-service errand before the upgrade. This can be disabled in the errands section of the PAS tile.  Once it is disabled you can proceed with the upgrade. 

After the upgrade it will be necessary to check the status of the application's with the following commands: 

• cf target -o system -s system
• cf apps

If the applications are stopped then you can start them again with the following commands: 

• cf start app-usage-scheduler
• cf start app-usage-server
• cf start app-usage-worker

To check that this has been successful you can run cf apps.

Please upgrade to PAS 2.3.3 (fix included in that version) and re-enabled the errand
https://docs.pivotal.io/pivotalcf/2-3/pcf-release-notes/runtime-rn.html#2.3.3