vCloud Director 1.5 Update 1 – Oracle DB issue and why to back it up
It seems I keep running into things throwing my in a loop and I am sure someone else out there in the VMTN worlds knows that I am talking about. I love vCloud, I enjoy the product, but man some things are still pretty vague although it continue to grow more and more each day I definitely want to do my part to help contribute. So I will make this a short and quick post.
Well take a peek at this VMware Knowledgebase and it will describe in detail the issue I ran into:
“Upgrading vCloud Director 1.5 with an Oracle database to vCloud Director 1.5.1 fails with the error: CALL create_missing_index()”
Although it is hard to say why this is a bug in the database or duplicated entries most oracle DBA’s can knock it out fairly easy. However let me explain to you how this happens and provide some further insight on how to resolve it without having to guess.
Now I want to point out that someone forgot to use the call-management tool (which you can find here) but one would think that this is mostly a database issue because it’s referencing a duplicate table entry. Also this seems to happen with updating vCloud from 1.5 to 1.5.1.
If you run into this issue you need to do the following:
- Restore the Database
- Run the KB Fix of the following:
“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);”
- Then perform you Database upgrade
I know this seems to be pretty simple but the KB doesn’t tell you specifically what you need to do. The Oracle piece was vague in that one would think you need to run the snippet above to fix it. You should just know that this is something that should be ran AFTER the database restore. This may save you some time if you run into it.
Posted on August 24, 2017, in Troubleshooting, Upgrading, vCloud and tagged 1, 1.5, 1.5.1, category, condition HAVING count(*) > 1);, DELETE FROM object_condition WHERE object_id IN (SELECT object_id FROM object_condition GROUP BY object_id, Duplicate Table, object_type, Oracle, patch, vcloud update, VMware. Bookmark the permalink. Leave a comment.