Tirelibirefe
Contributor
Contributor

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

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
0 Kudos
3 Replies
AndreTheGiant
Immortal
Immortal

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

Andre | http://about.me/amauro | http://vinfrastructure.it/ | @Andrea_Mauro
0 Kudos
Tirelibirefe
Contributor
Contributor

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

0 Kudos
semvcia
Contributor
Contributor

change your OS regitional settings.

alternative

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

0 Kudos