An entry in vmo_lock from previous workflow runs prevent further runs of Actions or Workflows
search cancel

An entry in vmo_lock from previous workflow runs prevent further runs of Actions or Workflows

book

Article ID: 326135

calendar_today

Updated On:

Products

VMware Aria Suite

Issue/Introduction

Symptoms:
  • You are using one of the following:
    • VMware Aria Automation Orchestrator (formerly vRealize Orchestrator) 8.x
    • VMware Aria Automation /w embedded Automation Orchestrator (formerly vRealize Automation) 8.x
    • VMware Aria Automation SaaS Cloud Extensibility appliance
  • You request an Aria Automation catalog item with a form that uses external resources to populate the form values.
  • The requested catalog item form generates a timed out error message when the form is attempting to load:
    The request took too long and it resulted in a timeout.  Timed out request: NameOfPackage/NameofAction
  • Error message similar to the below can be found in vco-app-server 
    ERROR duplicate key value violates unique constraint vmo_lock_pkey
image.png
  • ​​​Some catalog items and Orchestrator actions appear to be functioning that do not leverage the vmo_lock mechanism.


Environment

VMware vRealize Orchestrator 8.x
VMware vRealize Automation 8.x

Cause

This issue has been witnessed during heavy usage of workflow locking during workflow execution and when said workflow is stopped before it's unlocked.

Resolution

See the Workaround section for further details.

Workaround:
Prerequisites
  • Please take simultaneous non-memory snapshots of each virtual appliance(s) in the cluster.
  • You have access to root user and password
  • You have SSH or console access to each virtual appliance.
Procedure
  1. SSH / PuTTy into one vRO virtual appliance in the cluster
  2. Access the psql cli
    vracli dev psql
    
  3. Enter yes and press Enter.
  4. Connect to the vco-db
    \c vco-db
  5. Identify entries in the table
    select * from vmo_lock;
  6. Remove the entries
    delete from vmo_lock;