This issue is resolved in vRealize Automation 6.2.3, available at
VMware Downloads.
To resolve this issue if you do not want to upgrade, either restore the database from a backup or run SQL queries to remove any scheduled workflows:
If you have a backup of the database:
Note: This procedure modifies the database. Ensure to take a backup of the database before proceeding.
- Restore this database and then run this query to remove any scheduled workflows:
-- Update WorkflowSchedules if they refer to Workflows in Workflowinstances table to be able to delete WorkflowInstances
UPDATE [DynamicOps.RepositoryModel].[WorkflowSchedules] SET WorkflowInstanceId = NULL WHERE WorkflowInstanceId is NOT NULL
- Update the Model Manager data.
If you do not have a backup of the database:
- Run these queries to remove any scheduled workflows:
-- Update WorkflowSchedules if they refer to Workflows in Workflowinstances table to be able to delete WorkflowInstances
UPDATE [DynamicOps.RepositoryModel].[WorkflowSchedules] SET WorkflowInstanceId = NULL WHERE WorkflowInstanceId is NOT NULL
-- DEM should be shutdown during upgrade and should be no Workflow Instances that are already claimed
DELETE FROM [DynamicOps.RepositoryModel].[WorkflowInstances] WHERE ClaimedDateTime is NOT NULL
- Run this command from an administrator command prompt to re-initialize the repository:
D:\VMware\vCAC\Server\Model Manager Data\Reporeg.exe" Install-MetaModel -s "IaaS_DB_Server_FQDN" -d "database_name" --store "https://model_manager_FQDN" --FileName "D:\VMware\vCAC\Server\Model Manager Data\Cafe\Vcac-Config.data"