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?
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.