I have LAB with fresh Cassandra installation (which worked before):
My goal is described in this post vCD 9.1.0 adding to Cassandra DB additional metrics to collect performance data where i tried add additional metrics for billing and performance reasons.
Above issue existed in vCD 9.1
Few days ago i installed vCD 9.5 and Cassandra 3.11 and API requests (for metrics /current and /historical) and all worked fine on the beginning.
Next i uploaded 2 examples metrics and wanted check if Cassandra metrics will be visible in vCD.
mem.granted.average
mem.granted.maximum
In GUI all is working fine.
Honestly, i didn't check API requests after update metrics to DB.
Today im after vSphere upgrade from 6.5u2 to 6.7u1 and wanted double check if everything is still working.
Unfortunately API requests for metrics data are not working fine. Im using Visual Studio COde plugin for Rest:
In response I found an error:
"exceptions.InvalidQueryException: Undefined column name "mem.granted.average"
	at"
I'm not sure what should be the next step. I rebooted CELLS, Cassandra DB node1 and node 2 without results.
Some advice?
Sebastian
www.vSebastian.net
vExpert VSAN/NSX/CLOUD | VCAP5-DCA | VCP6-DCV/CMA/NV ==> akademiadatacenter.pl