A general system error occured: Error[VdbODBCError] -1

[mnisadmin]

Hi,

I have Virtual Cener 4.01 on windows 2008 R2 64bit server.

I have ESXi hosts with 4.1_update01 patch and have the free SQL server db for the VC

I was logged in the VC and notived one of the servers was disconnected.

So I tried to connect it again and I got "A general system error occurred: failed to ..... Error: Error[VdbODBCError] (-1) "ODBC error: (40001) - [Microsoft][ODBC SQL ..... ERROR [42000"

I have followed http://kb.vmware.com/kb/1003980

And have shrunked the log file and restarted management agent but still no luck.

The VM's on the server are still online. Can anyone please help. Thanks

The log file has this

[2011-03-02 15:42:01.247 06116 info 'vmomi.soapStub[4]' opID=EE6B6942-0000003D] Resetting stub adapter for server TCP:mnisvmsrv4:443 : Closed
[2011-03-02 15:42:01.247 06116 error 'App' opID=EE6B6942-0000003D] An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) "ODBC error: (42000) - [Microsoft][SQL Native Client][SQL Server]Could not allocate space for object 'dbo.VPX_HOST_VM_CONFIG_OPTION'.'PK_VPX_HOST_VM_CONFIG_OPTION' in database 'VIM_VCDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup." is returned when executing SQL statement "INSERT INTO VPX_HOST_VM_CONFIG_OPTION WITH (ROWLOCK) (HOST_ID, CONFIG_OPTION_VER, DATA, ARRAY_INDEX, CONFIG_OPTION_DESC, CREATE_SUPPORTED_FLG, DEFAULT_CONFIG_OPTION_FLG) VALUES (?, ?, ?, ?, ?, ?, ?)"
[2011-03-02 15:42:01.809 07132 info 'App' opID=EE6B6942-00000046] [VpxLRO] -- BEGIN task-internal-56 --  -- vmodl.query.PropertyCollector.Filter.destroy -- FA2F537F-CA34-44A4-95F8-14AAF05BB5B2(909B8829-6F75-42A7-9023-4AFA478ACDE9)
[2011-03-02 15:42:01.809 07132 info 'App' opID=EE6B6942-00000046] [VpxLRO] -- FINISH task-internal-56 --  -- vmodl.query.PropertyCollector.Filter.destroy -- FA2F537F-CA34-44A4-95F8-14AAF05BB5B2(909B8829-6F75-42A7-9023-4AFA478ACDE9)
[2011-03-02 15:42:54.927 05640 info 'App' opID=EE6B6942-00000048] [VpxLRO] -- BEGIN task-internal-57 --  -- vim.view.InventoryView.closeFolder -- FA2F537F-CA34-44A4-95F8-14AAF05BB5B2(909B8829-6F75-42A7-9023-4AFA478ACDE9)
[2011-03-02 15:42:54.927 05640 info 'App' opID=EE6B6942-00000048] [VpxLRO] -- FINISH task-internal-57 --  -- vim.view.InventoryView.closeFolder -- FA2F537F-CA34-44A4-95F8-14AAF05BB5B2(909B8829-6F75-42A7-9023-4AFA478ACDE9)
[2011-03-02 15:42:58.375 06116 info 'App' opID=EE6B6942-0000003D] Forcing shutdown of VMware VirtualCenter now

[Rubeck · Accepted solution]

Hi..

Don't know the exact reason to why you're getting this error, but are you trying to manage an ESXi 4.1 Update 1 host with vCenter 4.0.x?

If so, this is not supported.. Page 3 here http://www.vmware.com/pdf/vsphere4/r40/vsp_compatibility_matrix.pdf

/Rubeck

[mnisadmin]

Hi Rubeck,

Thanks for the reply. I have upgraded to VC build 345043.

Strange things are happening. One of the host got disconnted and the vm's became orphaned.

Then I shh'ed into one of the host and when I cat /etc/hosts it shows the IP address and host name of other other host...and I can't login to that host as I get invalid password.