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

  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

57 Tips Every Admin Should Know

Active Directory 1. To quickly list all the groups in your domain, with members, run this command: dsquery group -limit 0 | dsget group -members –expand 2. To find all users whose accounts are set to have a non-expiring password, run this command: dsquery * domainroot -filter “(&(objectcategory=person)(objectclass=user)(lockoutTime=*))” -limit 0 3. To list all the FSMO role holders in your forest, run this command: netdom query fsmo 4. To refresh group policy settings, run this command: gpupdate 5. To check Active Directory replication on a domain controller, run this command: repadmin /replsummary 6. To force replication from a domain controller without having to go through to Active Directory Sites and Services, run this command: repadmin /syncall 7. To see what server authenticated you (or if you logged on with cached credentials) you can run either of these commands: set l echo %logonserver% 8. To see what account you are logged on as, run this command: ...
Post a Comment
Read more
  The Guardrails of Automation VMware Cloud Foundation (VCF) 9.0 has redefined private cloud automation. With full-stack automation powered by Ansible and orchestrated through vRealize Orchestrator (vRO), and version-controlled deployments driven by GitOps and CI/CD pipelines, teams can build infrastructure faster than ever. But automation without guardrails is a recipe for risk Enter RBAC and policy enforcement. This third and final installment in our automation series focuses on how to secure and govern multi-tenant environments in VCF 9.0 with role-based access control (RBAC) and layered identity management. VCF’s IAM Foundation VCF 9.x integrates tightly with enterprise identity providers, enabling organizations to define and assign roles using existing Active Directory (AD) groups. With its persona-based access model, administrators can enforce strict boundaries across compute, storage, and networking resources: Personas : Global Admin, Tenant Admin, Contributor, Viewer Projec...
Post a Comment
Read more