Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

Upgrading vCloud Director 1.5 with an Oracle database to vCloud Director 1.5.1 fails with the error: CALL create_missing_index() (2017044)

Symptoms

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:
CALL create_missing_index()

Cause

This issue occurs when vCD tries to make a column in the object_condition table into a unique index and the table has duplicate entries. This issue occurs only when an Oracle database procedure has already been performed on MS SQL databases in previous releases.

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;

Resolution

To workaround this issue, delete the duplicate entries in the object_condition table. 
 
To delete the duplicate entries in the object_condition table:
  1. 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).
  2. Remove any existing connections to the Oracle database.
  3. Restore the Oracle DB from your pre-upgrade backup.
  4. 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);
  5. Re-run $VCLOUD_HOME/bin/upgrade

See Also

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.

Feedback

  • 1 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 1 Ratings
Actions
KB: