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 metricsThe 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
Purpose
Providing a workaround allows metrics to be persisted and queried after NAPP (ATP) is upgraded from 3.2.1 to 4.0.1
Impact / Risks
Fresh metrics will not be available when NAPP is upgraded from 3.2.1 to 4.0.1.
On the relevant UI screens showing the time-series metrics From the metrics time-series API
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 indexIf you believe you have encountered this issue, please open a support request and refer to this KB article to apply the workaround
