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

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

Steps for handling stuck deployments:

ssh into the vra appliance

vracli dev psql

\connect tango-blueprint-db

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>>’; (verify deployment id matches to the one that has the problem)
update bp_tile_execution set status=’SCHEDULED’, next_execution_at= NOW() 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>>’;