Timeseries Metrics API gives a blank response after NAPP (ATP) is upgraded from 3.2.1 to 4.0.1

Products

• VMware NSX

Issue/Introduction

Providing a workaround allows metrics to be persisted and queried after NAPP (ATP) is upgraded from 3.2.1 to 4.0.1

Symptoms:
After NAPP (ATP) is upgraded from version 3.2.1 to 4.0.1 the time-series metrics API i.e. POST 'https://<NSX-IP>/napp/api/v1/metrics/data will not return data for the latest metrics

The UI screens and the metrics time-series API will start showing blank responses.

This will only happen on an upgraded NAPP setup from 3.2.1 to 4.0.1. A fresh 4.0.1 setup will work as expected

Environment

VMware NSX-T Data Center
VMware NSX 4.0.0.1
VMware NSX-T Data Center 3.x

Resolution

After NAPP is successfully upgraded from 3.2.1 to 4.0.1, the time-series PostgreSQL tables need to be altered to add a new column and index

Workaround:

PostgreSQL tables need to be altered to add a new column and index

If you believe you have encountered this issue, please open a support request and refer to this KB article to apply the workaround

Additional Information

Impact/Risks:
Fresh metrics will not be available when NAPP is upgraded from 3.2.1 to 4.0.1.

1. On the relevant UI screens showing the time-series metrics
2.  From the metrics time-series API