Had a few requests that stayed within the system even though the builds failed. This led to repeated attempts by vRA to expire items that didn’t exist. Got together with VMware Tech Support and learned this handy method of clearing these requests up.
1. SSH into the vRA appliance
2. su -c “/opt/vmware/vpostgres/9.5/bin/psql vcac” postgres (ignore the “could not change directory” error you’ll get)
3. update cat_resource set leasestate = null, status = ‘DELETED’, datedeleted = now()::timestamp where name = ‘Target Item Name‘;
4. update comp_deployment set status = ‘DELETED’ where name = ‘Target Item Name‘;
Hope that helps.