book
Article ID: 328347
calendar_today
Updated On:
Cause
This issue occurs due to the missing primary key constraint PK_VPX_DBM_COUNTER_METADATA on table VPX_DBM_COUNTER_METADATA.
Resolution
To resolve this issue, run the the 2147952_fix_dbm_missing_constraints.sql script:
- Download the 2147952_fix_dbm_missing_constraints.sql file attached to this article.
- Obtain the VCDB useranme and password from vcdb.properties. For more information, see Connecting to the embedded vPostgres Database in a Windows installed vCenter Server 6.0 (2108848).
- Open a command prompt and navigate to C:\program files\vmware\vcenterserver\vpostgres\bin.
- Run this command:
psql.exe -U vc -d VCDB -f PATH_TO_SCRIPT
For example:
psql.exe -U vc -d VCDB -f C:\temp\2147952_fix_dbm_missing_constraints.sql
Note: You'll be prompted for the VCDB username and password from step #2.