Pivotal Knowledge Base

Follow

Timezone Setting shows no Data on Charts

Environment

 Product  Version
 Pivotal Greenplum Command Center  (GPCC)  3.x

Symptom

Dashboard and Cluster Metrics views show no data in the histogram charts.

Cause

This issue is caused when the default timezone has changed for the gpmon user and the gpperfmon database. Pivotal Greenplum Command Center (GPCC) requires that the gpmon user and the gpperfmon database use the same default timezone as that of the system they are operating on. 

Resolution

Run the following query to fix this issue:

psql gpperfmon
alter user gpmon reset timezone;
alter database gpperfmon reset timezone; restart gpcc 

Comments

Powered by Zendesk