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

Multiple execution of workflows - EndpointMetrics, BlueprintMetrics, ReservationMetrics seen after upgrade from vRealize Automation 7.1 or 7.2 to 7.3 (2150239)

  • 0 Ratings

Symptoms

After upgrading from vRealize Automation 7.1 or 7.2 to 7.3, you notice multiple execution of the EndpointMetrics, BlueprintMetrics, ReservationMetrics workflows from the Infrastructure > Monitoring > Workflow History page.

Cause

This issue is caused by duplicate entries found in workflow schedule tables causing multiple workflows to begin execution.

Resolution

To resolve this issue, run these SQL commands to remove the duplicate workflow entries from the database:

Important: Take a back up of the database before making any changes.
 
DELETE FROM [DynamicOps.RepositoryModel].WorkflowSchedules WHERE Id IN (
SELECT wfs.Id FROM [DynamicOps.RepositoryModel].WorkflowSchedules wfs LEFT OUTER JOIN
(
 SELECT MIN(Id) as Id, Name, Description, WorkflowDefinitionId, WorkflowInstanceId, NextRunDatetime, LastRunDatetime, LastSuccessfulRunDatetime, StartDatetime, TimeOfDay, DayOfWeek, OccurrenceOfMonth, IntervalMinutes, TriggeringUser, IsActive, IsSystemGenerated
 FROM [DynamicOps.RepositoryModel].WorkflowSchedules
 GROUP BY Name, Description, WorkflowDefinitionId, WorkflowInstanceId, NextRunDatetime, LastRunDatetime, LastSuccessfulRunDatetime, StartDatetime, TimeOfDay, DayOfWeek, OccurrenceOfMonth, IntervalMinutes, TriggeringUser, IsActive, IsSystemGenerated
)
AS keeprows
ON wfs.Id = keeprows.Id
WHERE
keeprows.Id IS NULL);

Additional Information

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

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.

Feedback

  • 0 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.
  • 0 Ratings
Actions
KB: