An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbError] (-1) "ODBC error: (42S22)

[Tirelibirefe]

Hello Gentlemen;

I'm trying add an esxi 5.1 to vcenter 5.1 which is on win2008r2 & sql2008r2) but the following error message is displayed and the host can not be added.

Do you have and idea how to get rid of this error? Any suggestions are appreciated...

Regards

Tirelibirefe

------------------------------------

An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbError] (-1) "ODBC error: (42S22) - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'mo_id'." is returned when executing SQL statement "update vpx_text_array  with (rowlock)  set value = ? where mo_id = ? and mo_type = ? and type_id = ? and array_id in (select array_id from VPX_HOST_CONFIG_INFO where ID = ?)"

the message resource is present but the message is not found in the string/message table

[AndreTheGiant]

Seems some corruptions in the DB side.

IMHO, consider to reinstall your vCenter from scratch.

Or simple reset the vCenter DB:

http://communities.vmware.com/message/2038343

[Tirelibirefe]

Thanks for your response. you may right but I am not be able to confirm.

I 've installed another server which was VC5.0 and upgraded it to 5.1. It is runing without any problem.

VC5.1 Installation from scratch is a very big deal, adventure...

[semvcia]

change your OS regitional settings.

alternative

problem is about sql collation you need to set the db as collation Latin1_General_CI_AS