Process for clearing deployments that are stuck "In Progress" for VRA 8.x

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

Deployment request in vRA 8.x will be stuck in progress and the Cancel option is not working.

Environment

VMware vRealize Automation 8.x

Resolution

Note: Before proceeding with any changes, please take no memory quiesced snapshots and backups of all Aria Automation appliances. 

Steps for handling stuck deployments:

1. Open an SSH session to the vRA appliance and login to tango-blueprint-db database:

vracli dev psql tango-blueprint-db

2. Run below query to display the stuck deployments:

select id,project_id,env->'DEPLOYMENT_ID' as deployment_id,env->'DEPLOYMENT_NAME' as deployment_name, task_name,last_execution_at from bp_tile_execution where ((last_execution_at is NULL and created_at < NOW() - INTERVAL '30 minutes') or (last_execution_at < NOW() - INTERVAL '30 minutes')) and status='IN_PROGRESS' and task_name<>'<<approval>>';
 

Note: Verify that the deployment id matches to the one that has the problem.

3. Please engage Broadcom Support to address the deployment state.