Search the VMware Knowledge Base (KB)
View by Article ID

Unable to create XaaS resource actions as 'Shared' or change the icon in vRA 7.2 (2149050)

  • 0 Ratings

Symptoms

  • An inability to update the icon for XaaS resource actions in vRealize Automation 7.2.  
  • When listing in Catalog Administration section, the user created actions based on Azure Virtual Machine custom resource and on the built-in Resource Mappings (Deployment, vSphere VMs and vCloud Director VMs) are shown as Built-In.
  • Resource actions that match the above criteria are visible to all tenants.

    For example:

    A resource action for snapshot called Create a snapshot is created in tenant A.
    A user from tenant B logs and looks at the actions created in tenant A. Similarly, resource actions created in tenant B are visible to user from tenant A.

    There is no way to differentiate between the two and you should not see the resource action from tenant A in tenant B and vice versa.
                  

Cause

This is caused by a regression in vRealize Automation 7.2 where the incorrect tenant value is set to user created Azure, IaaS vSphere VM, IaaS vCloud VM, and Deployment XaaS Resource Actions.
 
Note: This does not affect actions that are created in vRealize Automation 7.1 and then migrated to vRealize Automation 7.2. However, it will affect actions created after the upgrade and that comply on the above criteria.

Resolution

This is a known issue affecting VMware vRealize Automation 7.2.
 
Currently, there is no resolution.
 
To work around the issue, run the SQL query as per the procedure.
 
Note: The SQL query provided in the procedure modifies the tenant for any Resource Actions that are user created. If new XaaS Resource Actions are created, the query should be run again to correct the new ones.
 
Procedure:
 
  1. Take a snapshot of the vRealize Automation appliances within your environment.
  2. Log in to the vRealize Automation vPostgres database.

    1. Open an SSH session to the primary vRealize Automation appliance and log in using root credentials.
    2. Navigate to the correct folder by running this command:

      cd /opt/vmware/vpostgres/current/bin

    3. Log in to postgres by running this command:

      su postgres

    4. Log in to the vCAC database by running this command:

      ./psql vcac

  3. Run this query:

    update cat_resourceoperation set tenant_id = T.tenant
     from (select cat_resourceoperation.name, tenant_id, tenant, providertype_id from asd_resourceoperation join cat_resourceoperation on (asd_resourceoperation.name = cat_resourceoperation.name)
              where providertype_id = 'com.vmware.csp.core.designer.service' and tenant != '_internal') as T where cat_resourceoperation.name = T.name and (cat_resourceoperation.tenant_id = '') is not false;

  4. The XaaS Resource Actions should show as Shared.
Note: To rollback the changes, revert to the snapshot taken in Step# 1.

Additional Information

To be alerted when this article is updated, click Subscribe to Document in the Actions box.

Tags

vRealize Automation, XaaS, Resource Actions, Day 2 Operations, Catalog Actions, vRA

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 0 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 0 Ratings
Actions
KB: