cloud-panda-logo-img
Cloud Computing

Changing the request state from 'In Progress' to 'Completed' in vRA 6.x

data-center

Error Details:

VMware vCAC or vRA request stuck in "In Progress" state but VM got successfully created and available in Managed Machines. There could be many requests were stuck in status “In Progress” since few months. So we need to change the status of old requests that are showing “In Progress” to “Completed”.

Possible Reason:

  • It could be a cause that a VM request was submitted which started a vRO workflow. Part of the workflow pauses release of the VM until it verifies that the request is marked completed. While this was pending, the vRO and vRA appliances were rebooted to resolve another issue. When the vRO server came back, there was a duplicate workflow for the same VM request triggered by vRO. After some time, the request was marked complete and original workflow completed. However the duplicate workflow did not complete and the vRA request still shows as "In Progress".
  • It could be another cause that a VM request was submitted which started a vRO workflow. Part of the workflow pauses release of the VM until it verifies that the request is marked completed. While this was pending, the standby model manager server also came online. When there are 2 active Manager Server at a time, such confusing situation may arise and the state of the request did not change in data-base and the vRA request still shows as "In Progress".

However the VM is available in the Managed Machines listing to use for daily activities, without having any issues.

Example: Assume the request number 37 is “In Progress” since 01/21/2016 i.e. more than 6 months.


Procedure:

  • Login with SSH user “root” on your vRA appliance.
  • Go to the “bin” directory of vPostgres i.e. #cd /opt/vmware/vpostgres/9.2/bin/
  • Connect to the “vcac” database with the username” vcac” i.e. #./psql -U vcac -d vcac
  • Run the query to confirm the current status for a specific request number #37.

SELECT id,requestnumber FROM cat_request where state='IN_PROGRESS' and requestnumber = '37';

  • Run the query to change the state from “In Progress” to “Completed” for a specific request number #37.

UPDATE cat_request SET datecompleted = now(), lastupdated = now(), requestcompletionstate = 'SUCCESSFUL', completiondetails = 'Request marked Successful using DB script as it was stuck in IN_PROGRESS state for long time.', state = 'SUCCESSFUL' WHERE state = 'IN_PROGRESS' AND requestnumber IN (37);

  • Login to vRA self-service portal and check the status for above mentioned request number #37
  • After changing the state of the request, vRA will NOT send the email notification to the requester or admin.

Tags:

Write Review

  1. Your email address and mobile number will not be published. Required fields are marked *



Reviews

  1. Marcy
    24/09/2016 07:23 PM

    Heya i am for the first time here. I found this board and I find It truly useful & it helped me out a lot. I hope to give something back and help others like you aided me.
      0

  2. cock stuffing
    02/12/2016 02:10 AM

    Major thanks for the blog article.Really thank you! Fantastic.
      0

  3. YokoVSandigo
    30/12/2016 03:01 AM

    Hello mates, its impressive post regarding tutoring and fully defined, keep it up all the time.
      0

  4. VCAP6
    09/01/2017 04:09 PM

    VMware Certified Advanced Professional 6 (Desktop and Mobility Deployment) – The industry-recognized VCAP6-DTM Deploy certification validates that you know how to deploy and optimize VMware Horizon 6 (with View) environments. It demonstrates that you have the understanding and expertise essential to leverage best practices to provide a scalable and reliable Business Mobility platform for your organization. Some of the topics involve: Configuring and managing Horizon View components, configuring cloud pod archituecture, configuring Group Policy settings related to Horizon View, Configuring and optimizing desktop images for Horizon View & Mirage, Configuring and managing App Volumes AppStacks, Configuring desktop pools, Configuring and deploying ThinApp packaged applications, Configuring VMWare Identity Manager, etc.Szumigalski.com was designed by Sebastian to circulate his interest for PowerShell & VMWare. Sebastian is an IT expert working in Singapore over 15 years who is all of the time on the lookout for fresh solutions to refine his technical abilities & knowledge. Ever since, Sebastian has joined PowerShell User Group & VMWare VMug group, and has also been engaged in most of the get-togethers held in Singapore. This weblog will reveal precisely how Sebastian are able to systemize some of his day-to-day assignments with PowerShell. There’s study guides available for the VCAP6-DTM exam, which are personally published by Sebastian. Sebastian is certified with VCAP6-DTM, and is well-informed with virtualization & server maintenance from 4 years experience of automation. The need for VMWare prepared admins and engineers are ever-increasing with the current economic tech industry. Learn about much more about PowerShell & VMWare with Szumigalski.com!
      0