We have been having our VC server randomly crash recently and I am curious if anyone has seen smiliar problems. We are running VC 2.5 Update 3 and I see the following errors in the log file:
An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Check database connectivity before restarting. Error: Error[VdbODBCError] (-1) "ODBC error: (HY000) - [ODBC][Ora]ORA-01483: invalid length for DATE or NUMBER bind variable
" is returned when executing SQL statement "UPDATE VPX_VM SET TOOLS_STATUS = ? , TOOLS_VERSION = ? , GUEST_OS = ? , GUEST_FAMILY = ? , GUEST_STATE = ? , DNS_NAME = ? , IP_ADDRESS = ? WHERE ID = ?"
As far as I can tell the database servers are not having any issues and connectivity should not be an issue.
Our installation is not nearly as large as what you have. I finally got
all of our VMs up to date with the latest VMware Tools and I have not
seen our VC instance crash since. We are still running Update 3 over
here. Prior to the tools updates we were seeing the VC service crash
every 2 - 3 days. It's been running happily for a few weeks now.
Currently all of them are set to 1. As a band aid fix I actually disabled the past day rollup job in the sql agent and I havent seen the problem since. I have a feeling that by leaving all of the stat levels on and disabling the SQL agent past day stat roll up it may be causing other problems. I ideally would like to have a fix that works all around and I can make sense of.