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.

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