When extending the lease period of particular blueprint Item, it gives an error like below. I don't see any other active requests (inprogress/unsubmitted) corresponding to this blueprint.
Request initialization failed: Rejecting blueprint request [.....id....]. There are other active requests on the corresponding deployment.
vRA 7.2
vCenter 6
By creating vmware ticket the issue has been resolved. They have cleared the stuck requests for that particular blueprint deployment by running following commands in vRA
select br.id,
br.status,br.created_date
from comp_bprequest br,
comp_deployment d
where br.dep_id = d.id and
d.name = 'Deployment name'
order by br.created_date desc;
The above command show one progress operation. The following commands has been ran further to resolve
BEGIN;
select br.id,
br.status,
br.created_date
from comp_bprequest br,
comp_deployment d
where br.dep_id = d.id and
d.name = 'Deployment name'
order by br.created_date desc;
update comp_bprequest br
set status = 'SUCCEEDED'
from comp_deployment d
where br.status = 'IN_PROGRESS' and
br.dep_id = d.id and
d.name = 'Deployment name'
By creating vmware ticket the issue has been resolved. They have cleared the stuck requests for that particular blueprint deployment by running following commands in vRA
select br.id,
br.status,br.created_date
from comp_bprequest br,
comp_deployment d
where br.dep_id = d.id and
d.name = 'Deployment name'
order by br.created_date desc;
The above command show one progress operation. The following commands has been ran further to resolve
BEGIN;
select br.id,
br.status,
br.created_date
from comp_bprequest br,
comp_deployment d
where br.dep_id = d.id and
d.name = 'Deployment name'
order by br.created_date desc;
update comp_bprequest br
set status = 'SUCCEEDED'
from comp_deployment d
where br.status = 'IN_PROGRESS' and
br.dep_id = d.id and
d.name = 'Deployment name'
can you provide more details on where they ran the command? was it on the vra appliance? or one of the windows iaas servers?
These are postgres commands that would be applicable to the café appliance.
The commands has been executed on vRA postgres DB.
thank you for the select and update, this worked for me
in other news, you should really consider moving to 7.6 + latest hotfixes, or 8x
7.2 is like ...ancient.