The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Upgrading vCloud Director 1.5 with an Oracle database to vCloud Director 1.5.1 fails with the error: CALL create_missing_index() (2017044)
When vCloud Director (vCD) uses the Oracle database, you experience these symptoms:
Cannot upgrade from vCD 1.5 to 1.5.1
Upgrading to vCD 1.5.1 fails
- You see the error:
You can verify you are hitting this issue by running the following SQL query:
SELECT object_id, object_type, category, condition, count(*) AS dups FROM
object_condition GROUP BY object_id, object_type, category, condition HAVING
count(*) > 1;
To workaround this issue, delete the duplicate entries in the object_condition table.
To delete the duplicate entries in the object_condition table:
- Power off the vCD cell with the cell management tool. For more information, see Using the Cell Management Tool to shut down a vCloud Director Cell (1033575).
- Remove any existing connections to the Oracle database.
- Restore the Oracle DB from your pre-upgrade backup.
Log in to the Oracle database machine and run this delete statement:
DELETE FROM object_condition WHERE object_id IN (SELECT object_id FROM object_condition GROUP BY object_id, object_type, category, condition HAVING count(*) > 1);
- Re-run $VCLOUD_HOME/bin/upgrade
Request a Product Feature
To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.