The dependency vmware vcenter Inventory Services is the only one missing and i can't get it started, each time i have tried to start it I guet the following message: "windows could not start the vmware vcenter inventory service on local computer error code 1", I restarted the management agents, also restarted the vcenter vm
Thanks
can you post the vpxd log to check
you may get the log location here
Location of VMware vCenter Server 6.0 log files (2110014) | VMware KB
Unfortunately I don't have access to the the logs, i am assisting a client through TeamViewer, i might get hold on them later
SureshKumarMuthukrishnan i got them Copy of logs.zip - Google Drive
are you able to start the service or still the issue persists?
No, I have discovered that the issue is related to a failure with the DB of Postgress, a little wierd because the postgress service starts without any problem, but if y try to restart it it fails
I am seeing the following messages in the logs
2017-05-24T06:42:20.707-05:00 error vpxd[04752] [Originator@6876 sub=Default opID=StatsUpdateQueryOptimizer-23f57fe8] [Vdb::GetConnection] Failed to obtain connection: 08001:101 2017-05-24T06:42:20.775-05:00 error vpxd[14260] [Originator@6876 sub=Default opID=StatsTruncateExpiredPartitions-29eb7f58] [Vdb::GetConnection] Failed to obtain connection: 08001:101 2017-05-24T06:42:20.785-05:00 error vpxd[14504] [Originator@6876 sub=Default opID=CollectRemoteStats-224a901] [Vdb::GetConnection] Failed to obtain connection: 08001:101
looks like the connection with DB is not good.
Can you go for a clean shutdown of DB server if it is remote and restart the machine.
Once DB is up and running, reboot the vcenter server.
Also check if the following article helps, take snapshot of VC before you modify any setting so that you may revert if the step doesnt workout
vCenter Server service does not shutdown when database connectivity is lost (2007542) | VMware KB
I have 2 more questions, how can i find the DB (some file with the name or location) and what data will they loose after the clean DB
You can find from vpxd.cfg file about DB information. Also you dont need to clean the DB, issue is not with data.
We discovered the location, it's local to the vCenter
using the ODBC we tested the DB, it failed, the vPostgress service is running (when we try to restart it, it fatally fails).
could you please paste the screenshot of services.msc which contains all postgres related services ?