1.6

Table Of Contents
n
VMware Cloud Director database port
n
VMware Cloud Director database password
3 Delete all the hierarchies imported in to vCenter Chargeback from the original VMware Cloud Director
setup.
4 Run the following database commands.
delete from cb_vcloud_unprocessed_event
delete from cb_vsm_server
delete from cb_vsm_network
delete from cb_vsm_ip
delete from cb_server_property where
server_property_name='cbEventListRawView.lastProcessTime'
delete from cb_server_property where server_property_name like '%vcLastProcessTime-%'
5 Restart the VMware Cloud Director Data Collector instances.
Unable to Connect to the vCenter Chargeback Database
vCenter Chargeback can function only if it can connect to the vCenter Chargeback database.
Problem
vCenter Chargeback is unable to connect to the corresponding vCenter Chargeback database. A database
connection failed error is displayed.
Cause
This issue can occur due to multiple reasons.
n
The database service is not started and running.
n
The database is not reachable over the network.
n
The port number for the SQL Server named database instance has changed.
n
The number of server processes for the Oracle Database has exceeded the set maximum limit.
Solution
1 Check whether the database service is started and running.
2 Check whether the database machine is reachable over the network.
3 If you are using SQL Server for the vCenter Chargeback database and using the port number of the named
database instance to connect to it, ensure that the port is a dedicated or static port for the database instance.
a Modify the database configuration to use dedicated ports for the named database instances.
In SQL Server, the default configuration is to use dynamic ports for named database instances.
b Configure the database named instance with the formerly configured port number.
c Restart the database service and the vCenter Chargeback services, including the data collector
services.
Chapter 10 Troubleshooting vCenter Chargeback
VMware, Inc. 147