SDDC Manager fails to upgrade with error 'Failed to stop cap-workflow-engine.service'

Products

• VMware SDDC Manager / VCF Installer

Issue/Introduction

• SDDC Manager failed to upgrade at the task of 'Setup Common Appliance Platform' with the error messages:
  
  Failed to stop cap-workflow-engine.service: Transport endpoint is not connected See system logs and 'systemctl status cap-workflow-engine.service' for details.
  
  
• SDDC Manager UI is normal to access.
• Retry upgrade but not work with the same error. 
• Rebooting SDDC Manager does not help.

Environment

VMware Cloud Foundation 9.1.x

Cause

The workflow.db file serves as the local state database for the Common Appliance Platform (CAP) workflow engine, recording the execution context and status of active lifecycle tasks. The failure occurs because this database file becomes corrupted, locked by a stale process, or enters an inconsistent transactional state.

Resolution

To fix the issue:

1. SSH SDDC Manager with vcf account and then switch to root account with 'su' command.
2. Backup workflow database:
   
   mv /storage/lifecycle/capengine/workflow.db /root/workflow.db
   
   
3. Reboot SDDC Manager.
4. Check if a new workflow.db is created in /storage/lifecycle/capengine/
5. Upgrade SDDC Manager again.

Additional Information

SDDC Manager upgrade fails with ERROR: CAP services are not enabled in SDDC Manager