Sovlabs Deployment Items Missing Actions

Problem 

This KB assumes the following:

1. Entitlements are configured according to our documentation found here
2. Your able to update / delete existing Sovlabs deployments.

This KB will assist customers in removing deployment items that appear to be "stuck" in the request phase from vRA 7.5.

A couple ways to identify the issue:

1. The deployment item has Add [Module] - SovLabs Module in the deployment section of vRA
   e.g. Add License - SovLabs Modules.
2. Click Actions for the deployment only shows View Details.
3. When you click View Details there is no gear icon

Cause

If your able to deploy the same module again without issue this may be related to the Deployment Details, gear icon of component does not display in full. 

Affected Versions

• vRA 7.5, vRA 7.5 HF1, vRA 7.5 HF2, vRA 7.5 HF3

Solution

Overview

This issue appears to have been resolved with vRA 7.5 hotfix 4 patch per VMware's KB found here.

How-to Clean up "stuck" Sovlabs deployment from vRA

This section will walk you through the steps for removing the "stuck" Sovlab deployment item.

Step 1 Remove "stuck" Sovlabs deployment from vRO

1. Click Workflows
2. Expand Sovlabs folder
3. Expand the affected module e.g. License
4. Expand vRA ASD
5. Select the Delete workflow
6. Start workflow...
7. Browse to the affected module
8. Select the "stuck" deployment
9. Click Select
10. Click Submit

WARNING!

• Ensure valid backups exist for your vRA appliance(s) before proceeding.
• The steps below will modify the vRA postgres database so proceed with caution and at your own risk.
• If you are uncomfortable with performing the steps below please contact VMware support for further assistance.

Step 2 Backup Postgres Database

1. SSH into Master vRA Node
2. Export embedded Postgres database to tmp directory and move to external location:
   1. su - postgres -m -c "/opt/vmware/vpostgres/current/bin/pg_dump -Fc vcac > /tmp/vcac.sql" postgres
3. Connect to Postgres:
   1. /opt/vmware/vpostgres/current/bin/psql vcac postgres
      \connect vcac;
      
4. Select "stuck" Sovlabs deployment and specific tenant:
   SELECT name,status,subtenant_id,tenant_id,datecreated,lastupdated,request_id FROM cat_resource WHERE name='[Name as it appears in the Deployment section of vRA]' and tenant_id='[tenant name]';
   Example:
   SELECT name,status,subtenant_id,tenant_id,datecreated FROM cat_resource WHERE name='Add License - SovLabs Modules' and tenant_id='dd-001';
5. Set status to Deleted:
   Update cat_resource set status='DELETED' where name='[Name as it appears in the Deployment section of vRA]' and tenant_id='[tenant name]';
   Example:
   1. Update cat_resource set status='DELETED' where name='Add License - SovLabs Modules' and tenant_id='dd-001';
   2. Rerun the previous select statement and notice the status is now set to DELETED. The item will no longer be displayed in the vRA Deployment section of the GUI.
      
   3. Note: Do not include the [] in the Name and tenant_id 
6. To exit the vcac DB, type in \q and then you can exit your ssh session

Additional information

How to export embedded Postgres DB from vRealize Automation appliance KB here.
Cumulative Update for vRealize Automation 7.5 (60310) KB here.