{"id":91,"date":"2016-10-24T23:32:27","date_gmt":"2016-10-24T15:32:27","guid":{"rendered":"https:\/\/www.theinsecurewire.com\/?p=91"},"modified":"2016-10-24T23:32:27","modified_gmt":"2016-10-24T15:32:27","slug":"error-29702-upgrading-vmware-vcenter-5-5-6-0","status":"publish","type":"post","link":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/","title":{"rendered":"Error 29702 upgrading VMware VCenter 5.5 to 6.0"},"content":{"rendered":"

Like most enterprise IT shops, we have a significant VMware investment. One of the requirements of upgrading to VSphere 6 is to upgrade your VCenter out of band. Our VCenter is on Windows Server 2012 with Micosoft SQL Server on box. A Windows VCenter upgrade is fairly straight forward – make sure your SQL DB, SSL certs and SSO config are backed up prior to running the upgrade. Another gotcha is to make sure you know your VCenter DB username and password prior to any upgrade.\u00a0If your VCenter is a VM – then here is where a snapshot is the perfect tonic.<\/p>\n

During the installer pre-upgrade\u00a0check i had the following error:<\/p>\n

\"SQL

SQL Permissions Error<\/p><\/div>\n

This was resolved by running an SQL query on the VCenter DB:
\nuse master
\ngo
\ngrant VIEW SERVER STATE to [vCenter_database_user<\/i>]\ngo
\nGRANT VIEW ANY DEFINITION TO [vCenter_database_user<\/i>]\ngo
\n<\/code><\/p>\n

The KB below details this:
\nhttps:\/\/kb.vmware.com\/selfservice\/microsites\/search.do?language=en_US&cmd=displayKC&externalId=2114754<\/a><\/p>\n

Once I ran the installer it started to remove the existing 5.5 version but then it failed with an error, dumping the logs to the system temp directory. Upon investigation the MSI error was\u00a029702 – unable to configure log browser. Further inspection of the logs pointed to the VSphere Web Client. So the plan of action here was to remove all 5.5 components and then reinstall them cleanly, pointing to the existing database. All of the components would uninstall accept for the Web Client – it kept giving the above error.<\/p>\n

Enter the Microsoft Fix It utility:
\nhttps:\/\/support.microsoft.com\/en-us\/help\/17588\/fix-problems-that-block-programs-from-being-installed-or-removed<\/a><\/p>\n

This utility allowed me to force remove the Web Client (from the Windows registry) and then proceed to installing 5.5 fresh again. Pointing the 5.5 install to the existing DB – i now had a clean VCenter 5.5. This actually took several hours to find the fix and remove and reinstall 5.5. From this point running the 6.0 wizard was a breeze and took around 30 mins, this depends on the size of your VCenter DB.<\/p>\n","protected":false},"excerpt":{"rendered":"

Like most enterprise IT shops, we have a significant VMware investment. One of the requirements of upgrading to VSphere 6 is to upgrade your VCenter…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-vmware"],"acf":[],"yoast_head":"\nError 29702 upgrading VMware VCenter 5.5 to 6.0 - Insecure Wire<\/title>\n<meta name=\"description\" content=\"When upgrading VCenter from 5.5 to 6.0 if your install is not clean you can run into Error 29702. Here's how to fix this issue.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error 29702 upgrading VMware VCenter 5.5 to 6.0 - Insecure Wire\" \/>\n<meta property=\"og:description\" content=\"When upgrading VCenter from 5.5 to 6.0 if your install is not clean you can run into Error 29702. Here's how to fix this issue.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/\" \/>\n<meta property=\"og:site_name\" content=\"Insecure Wire\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-24T15:32:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG\" \/>\n<meta name=\"author\" content=\"nikonau\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/insecurewire\" \/>\n<meta name=\"twitter:site\" content=\"@insecurewire\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"nikonau\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/\"},\"author\":{\"name\":\"nikonau\",\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/person\/8ba08b41fc754b971a948ead6ccb777d\"},\"headline\":\"Error 29702 upgrading VMware VCenter 5.5 to 6.0\",\"datePublished\":\"2016-10-24T15:32:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/\"},\"wordCount\":330,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.insecurewi.re\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG\",\"articleSection\":[\"VMware\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/\",\"url\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/\",\"name\":\"Error 29702 upgrading VMware VCenter 5.5 to 6.0 - Insecure Wire\",\"isPartOf\":{\"@id\":\"https:\/\/www.insecurewi.re\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG\",\"datePublished\":\"2016-10-24T15:32:27+00:00\",\"description\":\"When upgrading VCenter from 5.5 to 6.0 if your install is not clean you can run into Error 29702. Here's how to fix this issue.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#primaryimage\",\"url\":\"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG\",\"contentUrl\":\"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.insecurewi.re\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error 29702 upgrading VMware VCenter 5.5 to 6.0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.insecurewi.re\/#website\",\"url\":\"https:\/\/www.insecurewi.re\/\",\"name\":\"Insecure Wire\",\"description\":\"A Network Engineer\u2019s Perspective.\",\"publisher\":{\"@id\":\"https:\/\/www.insecurewi.re\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.insecurewi.re\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.insecurewi.re\/#organization\",\"name\":\"Insecure Wire\",\"url\":\"https:\/\/www.insecurewi.re\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.insecurewi.re\/wp-content\/uploads\/2023\/10\/cloud.png\",\"contentUrl\":\"https:\/\/www.insecurewi.re\/wp-content\/uploads\/2023\/10\/cloud.png\",\"width\":32,\"height\":32,\"caption\":\"Insecure Wire\"},\"image\":{\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/insecurewire\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/person\/8ba08b41fc754b971a948ead6ccb777d\",\"name\":\"nikonau\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.insecurewi.re\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2d1b9d9dc90da4f6d3da31b870f418c6b3553ba9be48d53e8ee3a35b0adb1d35?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2d1b9d9dc90da4f6d3da31b870f418c6b3553ba9be48d53e8ee3a35b0adb1d35?s=96&d=mm&r=g\",\"caption\":\"nikonau\"},\"sameAs\":[\"https:\/\/x.com\/https:\/\/twitter.com\/insecurewire\"],\"url\":\"https:\/\/www.insecurewi.re\/index.php\/author\/nikon\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Error 29702 upgrading VMware VCenter 5.5 to 6.0 - Insecure Wire","description":"When upgrading VCenter from 5.5 to 6.0 if your install is not clean you can run into Error 29702. Here's how to fix this issue.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/","og_locale":"en_US","og_type":"article","og_title":"Error 29702 upgrading VMware VCenter 5.5 to 6.0 - Insecure Wire","og_description":"When upgrading VCenter from 5.5 to 6.0 if your install is not clean you can run into Error 29702. Here's how to fix this issue.","og_url":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/","og_site_name":"Insecure Wire","article_published_time":"2016-10-24T15:32:27+00:00","og_image":[{"url":"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG","type":"","width":"","height":""}],"author":"nikonau","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/insecurewire","twitter_site":"@insecurewire","twitter_misc":{"Written by":"nikonau","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#article","isPartOf":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/"},"author":{"name":"nikonau","@id":"https:\/\/www.insecurewi.re\/#\/schema\/person\/8ba08b41fc754b971a948ead6ccb777d"},"headline":"Error 29702 upgrading VMware VCenter 5.5 to 6.0","datePublished":"2016-10-24T15:32:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/"},"wordCount":330,"commentCount":0,"publisher":{"@id":"https:\/\/www.insecurewi.re\/#organization"},"image":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#primaryimage"},"thumbnailUrl":"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG","articleSection":["VMware"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/","url":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/","name":"Error 29702 upgrading VMware VCenter 5.5 to 6.0 - Insecure Wire","isPartOf":{"@id":"https:\/\/www.insecurewi.re\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#primaryimage"},"image":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#primaryimage"},"thumbnailUrl":"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG","datePublished":"2016-10-24T15:32:27+00:00","description":"When upgrading VCenter from 5.5 to 6.0 if your install is not clean you can run into Error 29702. Here's how to fix this issue.","breadcrumb":{"@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#primaryimage","url":"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG","contentUrl":"https:\/\/communities.vmware.com\/servlet\/JiveServlet\/showImage\/2-2502520-50208\/Capture.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/www.insecurewi.re\/index.php\/2016\/10\/24\/error-29702-upgrading-vmware-vcenter-5-5-6-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.insecurewi.re\/"},{"@type":"ListItem","position":2,"name":"Error 29702 upgrading VMware VCenter 5.5 to 6.0"}]},{"@type":"WebSite","@id":"https:\/\/www.insecurewi.re\/#website","url":"https:\/\/www.insecurewi.re\/","name":"Insecure Wire","description":"A Network Engineer\u2019s Perspective.","publisher":{"@id":"https:\/\/www.insecurewi.re\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.insecurewi.re\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.insecurewi.re\/#organization","name":"Insecure Wire","url":"https:\/\/www.insecurewi.re\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.insecurewi.re\/#\/schema\/logo\/image\/","url":"https:\/\/www.insecurewi.re\/wp-content\/uploads\/2023\/10\/cloud.png","contentUrl":"https:\/\/www.insecurewi.re\/wp-content\/uploads\/2023\/10\/cloud.png","width":32,"height":32,"caption":"Insecure Wire"},"image":{"@id":"https:\/\/www.insecurewi.re\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/insecurewire"]},{"@type":"Person","@id":"https:\/\/www.insecurewi.re\/#\/schema\/person\/8ba08b41fc754b971a948ead6ccb777d","name":"nikonau","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.insecurewi.re\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2d1b9d9dc90da4f6d3da31b870f418c6b3553ba9be48d53e8ee3a35b0adb1d35?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2d1b9d9dc90da4f6d3da31b870f418c6b3553ba9be48d53e8ee3a35b0adb1d35?s=96&d=mm&r=g","caption":"nikonau"},"sameAs":["https:\/\/x.com\/https:\/\/twitter.com\/insecurewire"],"url":"https:\/\/www.insecurewi.re\/index.php\/author\/nikon\/"}]}},"_links":{"self":[{"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":0,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/posts\/91\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/media?parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/categories?post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.insecurewi.re\/index.php\/wp-json\/wp\/v2\/tags?post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}