Task Panel fails to load post-upgrade from 4.1 to 4.2 when there are Credential operations with pre-validation Failure

Products

• VMware Cloud Foundation

Issue/Introduction

Symptoms:

• Task Panel in UI doesn't load post-upgrade from 4.1 to 4.2

Environment

VMware Cloud Foundation 4.2

Cause

This is caused when there is credential operation task failure with the status PREVALIDATION_FAILED during K1.

Resolution

This is a known affecting VCF 4.2, currently, there is no resolution.

Workaround:
Please follow below steps to workaround the issue :

• Run the below command by doing SSH into the system. Supply timestamp in format (yyyy-mm-dd hh:mm:ss.ms)
• Prefer a time before the upgrade

psql --host=localhost -U postgres -d operationsmanager -c “UPDATE passwordmanager.password_operations SET creation_time = ‘<>’ WHERE transaction_status = ‘PREVALIDATION_FAILED’ AND creation_time IS NULL;

• Run the below command 

systemctl restart commonsvcs

Task aggregator would work as expected. On password management UI - The cancel option would be available. Once canceled, the lock would get released.