vCAC 6 : Request remains in state “In Progress”

Ce message est également disponible en : French

In vCAC (or vRealize Automation now), many requests were blocked in status “In Progresssince few weeks or months!

The task was not more present in vCenter orchestrator or vCAC.

I will give you a fix to clean up all these tasks that remains “In Progress” :


In this example, the resquest number “92” is  « In progress » since 06/25/2014. More than 6 month !

inprogress

 

First step, you have to log in with ssh user “root” on your vCAC appliance.

Then , go to the bin directory of vpostgres.

#cd /opt/vmware/vpostgres/9.2/bin/·

Next, you should be able to connect to the vcac database with the  username”vcac”:

#./psql -U vcac -d vcac

Next,

SELECT id,requestnumber FROM cat_request where state=’IN_PROGRESS’ and requestnumber = “RequestNum”;

11

RequestNum should be replaced by the Request Number. So, in our  example  “92”.

Retrieve the ID send by the request.

In this example : b5ff16f8-433c-XXXX-XXXX-XXXX

Then execute this command :

delete from cat_requestevent_details where requestevent_id in(select id from cat_requestevent where request_id =”);

12 The  ID should be replaced by your ID.

The return can be 0.

Next  :

delete from cat_requestevent where request_id = ”;

13

And then :

delete from cat_request where id =’ID’;

14

It’s over 😉 so you can leave psql with this command :

\q and enter

That’s it ! Go to vCAC and refresh your web browser. The task is no more displayed.

Julien Varela
Follow me

Julien Varela

Virtualisation & Cloud manager at Excellium Services
Consultant Virtualisation/Cloud au sein de Excellium Services et blogger @vThink. Je suis passionné par les nouvelles technologies. Et tout particulièrement, celles concernant la virtualisation. j'ai su apporter par mon autonomie, ma curiosité, ma pugnacité et ma technicité mon expertise dans ce domaine.
Julien Varela
Follow me

3 thoughts on “vCAC 6 : Request remains in state “In Progress”

  1. It worked great. I did have to make one changes for 6.2. I had to trim down the SELECT statement for it to work properly.

    SELECT id,requestnumber FROM cat_request where state=’IN_PROGRESS’;

    Thanks again for the info!

Leave a Reply