asked on

VMware VirtualCenter Server 6 service fails to start

Hello,

I am running vCentre Server 6 on Windows Server 2012 R2 Standard.
Every now and then, my VMware Virtual Center Server service is stopping and I cannot start the service.

Below some logs I found on the vmware folders :

016-12-24T20:44:30.304+01:00 info vpxd[05092] [Originator@6876 sub=vpxdVdb] Registry Item DB 5 value is ''
2016-12-24T20:44:30.304+01:00 info vpxd[05092] [Originator@6876 sub=vpxdVdb] Setting VDB delay statements queue size to 1000 transactions for 1 GB RAM dedicated to vpxd.
2016-12-24T20:44:30.304+01:00 info vpxd[05092] [Originator@6876 sub=vpxdVdb] [VpxdVdb::SetDBType] Logging in to DSN: with username
2016-12-24T20:44:30.305+01:00 error vpxd[05092] [Originator@6876 sub=Default] [Vdb::IsRecoverableErrorCode] Unable to recover from IM002:0
2016-12-24T20:44:30.305+01:00 error vpxd[05092] [Originator@6876 sub=vpxdVdb] [VpxdVdb::SetDBType]: Database error: ODBC error: (IM002) - [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2016-12-24T20:44:30.305+01:00 error vpxd[05092] [Originator@6876 sub=Default] Error getting configuration info from the database
2016-12-24T20:44:30.305+01:00 warning vpxd[05092] [Originator@6876 sub=Main] Database not initialized. Nothing to unlock
2016-12-24T20:44:30.305+01:00 info vpxd[05092] [Originator@6876 sub=Default] Forcing shutdown of VMware VirtualCenter now

Service: vpxd, Action: start
2016-12-24T19:21:15.968Z State for service vpxd: STOPPED
2016-12-24T19:22:16.151Z Error waiting for service vpxd start. Exit code: 1067
Current State: 1
ERROR:root:Unable to start service vpxd, Exception: {
"resolution": null,
"detail": [
{
"args": [
"vpxd"
],
"id": "install.ciscommon.service.failstart",
"localized": "An error occurred while starting service 'vpxd'",
"translatable": "An error occurred while starting service '%(0)s'"
}
],
"componentKey": null,
"problemId": null
}
Unable to start service vpxd, Exception: {
"resolution": null,
"detail": [
{
"args": [
"vpxd"
],
"id": "install.ciscommon.service.failstart",
"localized": "An error occurred while starting service 'vpxd'",
"translatable": "An error occurred while starting service '%(0)s'"
}
],
"componentKey": null,
"problemId": null
}

Thank you for your help

gheist

Obviously it is missing 32bit data source.
Why dont you approach vmware support?

Richardson Porto

Check which ODBC your vCenter is using like described in the following quote:

To check which Data Source is currently being used:
Log in to the vCenter Server as an administrator.
Navigate to C:\ProgramData\VMware\vCenterServer\cfg\vmware-vpx.
Open vpxd.cfg within a text editor.
Within the <vpxd> element, locate the <odbc> sub-element. The name of the Data Source that is currently being used is within the <dsn> sub-element. Make a note of this name for used in subsequent steps of this article.

...
<vpxd>
...
<odbc>
<dbtype>external</dbtype>
<dsn> datasource_name</dsn>
</odbc>
...
</vpxd>
...

The go to Start > Control Panel > Administrative Tools > Data Sources (ODBC) and check if the DSN found in previous step exist and is connecting successfully.

Note, the DSN should be a 64 bit DSN, not a 32 bit like described in previous comment, because since vCenter version 4.x, only 64 bit DSN is supported.

Charles Mulumba

ASKER

Hello Richardson Porto,

THe DNS it's running with 64 bit and it's working well. I tried to fix also with this KB without any good result. https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2076054

Mohammed Khawaja

Create 32-bit ODBC by going to c:\windows\syswow64 and run odbcad32.exe and create your ODBC connection.

ASKER CERTIFIED SOLUTION

Charles Mulumba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mohammed Khawaja

You are on the right path. Rebuilding vCenter should be your last resort.

Charles Mulumba

ASKER

Dear Mohammed,

Rebuilding is done, do you have any idea to import the hosts?

Thanks

specialist Mohamed

Hello Charles,

How many hosts are we talking about ?
Do we have Distributed Virtual Switches or Standard Switch ?

I am unaware of a way to add the hosts in one go.

Charles Mulumba

ASKER

i have 6 hosts and 4 distributed virtual switches.

In the next two hours, the support will connect for the reconfiguration.

Many thanks for your inputs.

Charles Mulumba

ASKER

Best solution was to rebuild Vmware Vcenter