How to kill "In Progress" request task running on vRA portal.

Hello Everyone,

This post is based on vRealize Automation 7.3 versions.

This is regarding to the issue occurs when a user request a VM from vRA portal and give incorrect details or any other issues due to which request stuck in vRA portal with status "In Progress".

Please follow below steps to kill that "In Progress" tasks within vRA.

To resolve this issue, we need to clean up the Postgres database for those "In Progress"tasks.

1.    Take a valid backup of Postgres database via below command.
       su -m -c "/opt/vmware/vpostgres/current/bin/pg_dump -Fc vcac > /tmp/vcac.sql" postgres

2.    Login in vRA appliance via ssh with root account.   

3. run command cd /opt/vmware/vpostgres/current/bin

4.  run command ./psql -U postgres -d vcac

5. run command SELECT id,requestnumber,state FROM cat_request where                        requestnumber = "request number"; 

6. From above command note the ID number of the request and run below command after that. 
7.run command UPDATE cat_request SET state='PROVIDER_FAILED' where STATE='IN_PROGRESS' AND id=' 290ee11e-ccae-4620-8f17-ad72e90acd19' AND requestnumber='request number';
8. run \q to exit from vcac prompt.

9.Check the request status on vRA portal and status should be "Failed" now.

Comments if any issues !!!!