<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic vIDM upgrade stuck at &amp;quot;Waiting for SaaS to come up on the VMware Identity Manager Host&amp;quot; in VMware Aria Suite Lifecycle Discussions</title>
    <link>https://communities.vmware.com/t5/VMware-Aria-Suite-Lifecycle/vIDM-upgrade-stuck-at-quot-Waiting-for-SaaS-to-come-up-on-the/m-p/2850398#M198</link>
    <description>&lt;P&gt;We started the upgrade from our vIDM installation from 3.3.4 to 3.3.5 in vRLCM but it hangs at "Waiting for SaaS to come up on the VMware Identity Manager Host". Looking at the IDM system diagnostic page turns out that the "ACS Health - Application Deployment Status" service was in error state.&lt;/P&gt;&lt;P&gt;The log file for this service is found at&amp;nbsp;/opt/vmware/horizon/workspace/logs/accesscontrol-service.log and there was the error:&lt;/P&gt;&lt;P&gt;ERROR your.idm.appliance.com:accesscontrol (localhost-startStop-5) [;;;] org.springframework.boot.SpringApplication - Application run failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [com/vmware/vidm/accesscontrol/db/DbDataStoreAutoConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LockException: Could not acquire change log lock. Currently locked by 0.0.0.0 (0.0.0.0) since 11/11/11 11:11&lt;/P&gt;&lt;P&gt;This brings me to the KB&amp;nbsp;&lt;A href="https://kb.vmware.com/s/article/2076107" target="_self"&gt;Following an upgrade Workspace fails to start correctly with error: Could not acquire change log lock (2076107)&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The KB is not very detailed so here are all the steps i did:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- get the PostgreSQL DB password:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;cat /usr/local/horizon/conf/db.pwd&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Login to the DB with the above password:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;psql -U horizon saas&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- View the lock entry:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;SELECT * FROM saas.ACS_DATABASECHANGELOGLOCK;&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Remove the lock:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;UPDATE saas.ACS_DATABASECHANGELOGLOCK set LOCKED=false, LOCKGRANTED=null, LOCKEDBY=null where ID=1;&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Close the DB connection:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;\q&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Reboot the appliance and the vRLCM task finished successfully&lt;/P&gt;</description>
    <pubDate>Thu, 03 Jun 2021 09:20:22 GMT</pubDate>
    <dc:creator>rwk1982</dc:creator>
    <dc:date>2021-06-03T09:20:22Z</dc:date>
    <item>
      <title>vIDM upgrade stuck at "Waiting for SaaS to come up on the VMware Identity Manager Host"</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Suite-Lifecycle/vIDM-upgrade-stuck-at-quot-Waiting-for-SaaS-to-come-up-on-the/m-p/2850398#M198</link>
      <description>&lt;P&gt;We started the upgrade from our vIDM installation from 3.3.4 to 3.3.5 in vRLCM but it hangs at "Waiting for SaaS to come up on the VMware Identity Manager Host". Looking at the IDM system diagnostic page turns out that the "ACS Health - Application Deployment Status" service was in error state.&lt;/P&gt;&lt;P&gt;The log file for this service is found at&amp;nbsp;/opt/vmware/horizon/workspace/logs/accesscontrol-service.log and there was the error:&lt;/P&gt;&lt;P&gt;ERROR your.idm.appliance.com:accesscontrol (localhost-startStop-5) [;;;] org.springframework.boot.SpringApplication - Application run failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [com/vmware/vidm/accesscontrol/db/DbDataStoreAutoConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.LockException: Could not acquire change log lock. Currently locked by 0.0.0.0 (0.0.0.0) since 11/11/11 11:11&lt;/P&gt;&lt;P&gt;This brings me to the KB&amp;nbsp;&lt;A href="https://kb.vmware.com/s/article/2076107" target="_self"&gt;Following an upgrade Workspace fails to start correctly with error: Could not acquire change log lock (2076107)&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The KB is not very detailed so here are all the steps i did:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- get the PostgreSQL DB password:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;cat /usr/local/horizon/conf/db.pwd&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Login to the DB with the above password:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;psql -U horizon saas&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- View the lock entry:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;SELECT * FROM saas.ACS_DATABASECHANGELOGLOCK;&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Remove the lock:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;UPDATE saas.ACS_DATABASECHANGELOGLOCK set LOCKED=false, LOCKGRANTED=null, LOCKEDBY=null where ID=1;&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Close the DB connection:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;\q&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Reboot the appliance and the vRLCM task finished successfully&lt;/P&gt;</description>
      <pubDate>Thu, 03 Jun 2021 09:20:22 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Suite-Lifecycle/vIDM-upgrade-stuck-at-quot-Waiting-for-SaaS-to-come-up-on-the/m-p/2850398#M198</guid>
      <dc:creator>rwk1982</dc:creator>
      <dc:date>2021-06-03T09:20:22Z</dc:date>
    </item>
  </channel>
</rss>

