Search the VMware Knowledge Base (KB)
View by Article ID

After cancelling the selected alerts in vRealize Operations Manager 6.x, one or more of the selected alerts remain active (2123921)

  • 6 Ratings
Language Editions


  • After selecting multiple alerts in VMware vRealize Operations Manager 6.x and clicking Cancel Alert, one or more of the selected alerts remains active.
  • An error states that few alerts which were deleted may still be present.


This is a known issue affecting VMware vRealize Operations Manager 6.x.

To work around this issue, delete alerts directly from the database.

To delete alerts directly from the database:
  1. Log in to the Master node as the root user.
  2. Launch the psql utility and connect to the vPostgres database by running this command::

    su - postgres -c "/opt/vmware/vpostgres/9.3/bin/psql -U vcops -d vcopsdb"

    The prompt changes to vcopsdb=> when the command is completed.

  3. Delete all alerts by running these commands:

    truncate table alert cascade;
    truncate table alarm cascade;

  4. To delete alerts related to a specific resource, run these commands:

    delete from alert where resource_id = resource_id;
    delete from alarm where resource_id = resource_id

    The resource_id value can be obtained from the Administration > Environment Overview page.

  5. Type \q to exit the psql utility.
  6. Repeat steps 2 to 5 on all other nodes (except for Remote Collector nodes) in the cluster.
  7. From the vRealize Operations Manager Admin UI, click Bring Online to restart the cluster.

Additional Information

To be alerted when this article is updated, click Subscribe to Document in the Actions box.

See Also

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.


  • 6 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)

Please enter the Captcha code before clicking Submit.
  • 6 Ratings