There are several possible root causes to this problem.
The first thing easy to check is the time configuration of the host. Check that the time zone and NTP sources are correctly configured.
Otherwise, it could be a problem with the SQL database. Search the knowledge base with the error message (have a look at this kb for example).
Hi Franck, thanks for the prompt response!
The time & NTP is configured same as it is on the other hosts. about the SQL database: isn't it relevant only for the history? I can't get even real time info!
Also, I am looking into the KB link you added but if there is a problem with the database, shouldn't it effect all hosts - not only one host?
I found a few articles about using the command "vmkperf resetall" to solve this issue. But it was only with ESXi, don't know if it works for ESX.
We have ESXi (not ESX). I tried to run "vmkperf resetall" but nothing changed.
I also restarted the VC machine after that, but it didn't help.
Check to see if the 3 rollup jobs under SQL Server Agent on your SQL server are owned by the same user as your VMware database or at least is owned by a user that has db_owner rights to the Vmware database.
The jobs you want to look for are: Past Day stats rollupVMware, PastMonth stats rollupvmware and Past Week stats rollupvmware.
Thanks for the suggestion, but we have vSphere essential edition with SQL server express installed without SQL Server Agent installed.
I'm not sure how it works, but I know that I can't see even the real time information although I have no problems viewing real time & history of other ESXi servers connected to this VC.
I also tried to connect to the ESXi server with the vSphere client directly, (not using the vSphere server) but i still can't view real time statistics. so I assume that the problem is with the ESXi server, not with the vSphere server or database.