Enabling the Update Manager plug-in fails with the error: database unavailable or has network problems
book
Article ID: 338377
calendar_today
Updated On:
Products
VMware vCenter ServerVMware vSphere ESXi
Issue/Introduction
This article provides various options to resolve the issue when enabling the Update Manager plug-in fails with the database unavailable or has network problems error.
Symptoms:
You cannot enable Update Manager
If you try to enable Update Manager, you see the error:
There was an error connecting to VMware vCenter Update Manager <server name>:8084. Database temporarily unavailable or has network problems.
The Update Manager plug-in can be installed but not enabled
In the vpxclient.log file, you see entries similar to:
Loaded plugin from : C:\Program Files (x86)\VMware\Infrastructure\Virtual Infrastructure Client\Plugins\Update Manager 4.0\vimIntegrityClient.dll Extension.Key - com.vmware.vcIntegrity [Update M:SoapTran] YYYY-MM-DD TIME.225 Invoke 1 Finish RetrieveVcIntegrityContent on VcIntegrity:Integrity.VcIntegrity [1xx.2xx.1xx.1xx:8084] - Serial:0.001, Server:000.021 [ERROR] Vmomi.Fault.DatabaseError: Database temporarily unavailable or has network problems.
In the C:\Documents and Settings\All Users\Application Data\VMware\Update Manager\vmware-vum-server-log4cpp.log file or C:\Users\All Users\VMware\VMware Update Manager\Logs\ vmware-vum-server-log4cpp.log file, you see entries similar to:
[<YYYY-MM-DD>T<time>:873 'Activation' 3296 ERROR] [activationValidator, 237] vim.fault.DatabaseError [<YYYY-MM-DD>T<time>:873 'Activation' 3296 ERROR] [activationValidator, 244] No started [<YYYY-MM-DD>T<time>:873 'Activation' 3296 INFO] [activationValidator, 249] Leave Validate. Failed [<YYYY-MM-DD>T<time>:862 'VcIntegrity' 3416 ERROR] [vcIntegrity, 807] ODBC error: (IM002) - [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
</time></time></time></time>Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.
Update Manager is installed with a remote SQL 2005, 2008 or 2012 database using Windows Authentication and the Update Manager Service is set to log in as a Local System Account.
The Update Manager configuration file contains an incorrect database entry or if DSN does not match the Update Manager configuration file.
Resolution
To resolve this issue, perform one of these options:
Confirm connectivity between Update Manager and the SQL database.
Update Manager is installed with a remote SQL 2005, 2008 or 2012 database using Windows Authentication and the Update Manager Service is set to log in as a Local System Account.
To resolve this issue, change the Update Manager Service to log in to the remote database as a Windows account with Administrator privileges:
Click Start > Run, type services.msc, and click OK.
Right-click VMware Update Manager and click Properties.
Click the Log on tab.
Select This account, specify the Windows account along with the appropriate password, then click OK.
Right-click VMware Update Manager and click Restart.
The Update Manager configuration file contains an incorrect database entry or if DSN does not match the Update Manager configuration file.
To resolve this issue, ensure that the entries in the Update Manager configuration file match:
Open the vci-integrity.xml file (located at C:\Program Files (x86)\VMware\Infrastructure\Update Manager\vci-integrity.xml) using a text editor.
Verify that ODBC DSN and driver match the <dsn> and <dbtype> entries:
If the system is 32-bit, go to Administrative Tools > Data Sources ODBC > System DSN.
If the system is 64-bit, launch %SystemRoot%\syswow64\odbcad32.exe from Start > Run
Note: Spaces in these entries matter, when comparing the vci-integrity.xml file to the ODBC DSN ensure they are identical down to the spaces.
If the DSN does not exist, recreate it with the same entries as the vci-integrity.xml file and ensure to apply appropriate permissions to the database. For more information, see the ESX/ESXi and vCenter Server Installation Guides.
If you cannot enable the Update Manager plug-in after changing the password for the Update Manager database, see:
After making any changes, restart the Update Manager Service and test the plug-in connectivity.
If you still get the error, it may be necessary to remove the Update Manager plug-in (by going to Add/Remove Programs), then reinstall it in the Plug-in Manager.