Password management task fails with an error “Password management operation failed in pre-validation Stage”

Products

• VMware SDDC Manager

Issue/Introduction

When a user is performing password management tasks such as Rotate/Update/Remediate, the operation fails with an error message similar to “Password management operation failed in pre-validation Stage”.

This article provides steps to review the old entries and clear them in VCF database.

Environment

VMware Cloud Foundation

Resolution

Note: Before you proceed further, please take a snapshot of the SDDC manager.

• Login to SDDC manager SSH session as VCF user
• Switch to root user using 'su' command.
  • Connect to database: psql -h localhost -U postgres
  • Navigate to operations manager database: \c operationsmanager
  • List out the prevalidation failed tasks for password management: select * from passwordmanager.password_operations where transaction_status='PREVALIDATION_FAILED';
  • Delete old prevalidation failed task from the database: update passwordmanager.password_operations set transaction_status='USER_CANCELLED' where transaction_status='PREVALIDATION_FAILED';
• Retry password management task from SDDC manager web UI.