Skip to main content

 

Aria Automation upgrade to 8.14 fails with error "LCMVRAVACONFIG90029" Deploying project services.


Symptoms

  • Aria Automation upgrade to 8.14 fails with error "LCMVRAVACONFIG90029" Deploying project services
  • The upgrade failed while deploying the services we can see the project service app in Error and crash loop

[INFO][2023-11-15 06:19:23][XXXXXXXXXXXX.vmware.cba] Synced upgrade data with node: xxxxxxxxxx.vmware.cba

[INFO][2023-11-15 06:19:24][xxxxxxxxxx.vmware.cba] Deployment of infrastructure and application services started.

[WARNING][2023-11-15 07:22:27][xxxxxxxxxx.vmware.cba][Exit Code: 123] Error while deploying infrastructure and application services.

[INFO][2023-11-15 07:22:27][xxxxxxxxxx.vmware.cba] Shutting down application services...


Cause

  • The problem causing the failure are duplicated database entries in project-db.

Impact / Risks

  • Upgrades to 8.14 onwards will fail.

Resolution

  • This is a known issue and likely to be made available as code fix in Aria Automation 8.16.1.
  • There is also a workaround.

Workaround

  • The workaround is to delete the duplicate entries from the project-db in Aria Automation DB.
  • Steps:
  1. Take a snapshot of Aria automation nodes.
  2. SSH to one of the the nodes as root
  3. Eter the vRA DB: vracli dev psql
  4. Change to project db: \c project-db
  5. Execute the below query to clear the duplicate entries:

DELETE FROM project_principals WHERE id IN (

  -- entries that are 1:1 copies (both have user_id/group_id or both do not have ids)

  SELECT fst.id FROM project_principals fst

  JOIN project_principals snd ON fst.id > snd.id

    AND fst.principal_id = snd.principal_id

    AND fst.project_id = snd.project_id

    AND fst.role = snd.role

  WHERE fst.user_id = snd.user_id OR fst.group_id = snd.group_id

    OR (fst.user_id IS NULL AND fst.group_id IS NULL AND snd.user_id IS NULL AND snd.group_id IS NULL)



  UNION



  -- entries that differ in having user_id/group_id - the one that does not have id is chosen to be deleted

  SELECT fst.id FROM project_principals fst

  JOIN project_principals snd ON fst.id != snd.id

    AND fst.principal_id = snd.principal_id

    AND fst.project_id = snd.project_id

    AND fst.role = snd.role

  WHERE fst.user_id IS NULL AND fst.group_id IS NULL AND (snd.user_id IS NOT NULL OR snd.group_id IS NOT NULL)

); 

  1. Take a new snapshot of the nodes
  2. Start the upgrade from LCM again.


Labels:

Comments

Post a Comment

Popular posts from this blog

Quick Guide to VCF Automation for VCD Administrators

  Quick Guide to VCF Automation for VCD Administrators VMware Cloud Foundation 9 (VCF 9) has been  released  and with it comes brand new Cloud Management Platform –  VCF Automation (VCFA)  which supercedes both Aria Automation and VMware Cloud Director (VCD). This blog post is intended for those people that know VCD quite well and want to understand how is VCFA similar or different to help them quickly orient in the new direction. It should be emphasized that VCFA is a new solution and not just rebranding of an old one. However it reuses a lot of components from its predecessors. The provider part of VCFA called Tenenat Manager is based on VCD code and the UI and APIs will be familiar to VCD admins, while the tenant part inherist a lot from Aria Automation and especially for VCD end-users will look brand new. Deployment and Architecture VCFA is generaly deployed from VCF Operations Fleet Management (former Aria Suite LCM embeded in VCF Ops. Fleet Management...
Post a Comment
Read more
  Issue with Aria Automation Custom form Multi Value Picker and Data Grid https://knowledge.broadcom.com/external/article?articleNumber=345960 Products VMware Aria Suite Issue/Introduction Symptoms: Getting  error " Expected Type String but was Object ", w hen trying to use Complex Types in MultiValue Picker on the Aria for Automation Custom Form. Environment VMware vRealize Automation 8.x Cause This issue has been identified where the problem appears when a single column Multi Value Picker or Data Grid is used. Resolution This is a known issue. There is a workaround.  Workaround: As a workaround, try adding one empty column in the Multivalue picker without filling the options. So we can add one more column without filling the value which will be hidden(there is a button in the designer page that will hide the column). This way the end user will receive the same view.  
Post a Comment
Read more
  "Cloud zone insights not available yet, please check after some time" message on Aria Automation https://knowledge.broadcom.com/external/article?articleNumber=314894 Products VMware Aria Suite Issue/Introduction Symptoms: The certificate for Aria operations has been replaced since it was initially added to Aria Automation as an integration. When accessing the Insights pane under  Cloud Assembly  ->  Infrastructure  ->  Cloud Zone  ->  Insights  the following message is displayed:   "Cloud zone insights not available yet, please check after some time." The  /var/log/services-logs/prelude/hcmp-service-app/file-logs/hcmp-service-app.log  file contains ssl errors similar to:   2022-08-25T20:06:43.989Z ERROR hcmp-service [host='hcmp-service-app-xxxxxxx-xxxx' thread='Thread-56' user='' org='<org_id>' trace='<trace_id>' parent='<parent_id>' span='<span_id>'] c.v.a.h.a.common.AlertEnu...
Post a Comment
Read more