vRealize Automation 7.0.x SSO configuration fails in VAMI page

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• vRealize Automation 7.0.x SSO configuration fails in VAMI page after entering and confirming the SSO administrator password.
• You see the error:
  
  nested exception is org.postgresql.util.PSQLException: ERROR: insert or update on table "installation_wizard_params" violates foreign key constraint "installation_wizard_params_pk" Detail: Key (node)=(cafe.node.797715098.13641) is not present in table "cluster_nodes".

Cause

This issue occurs due to a network interruption in the vRealize Automation appliance after deployment. In this case, the VAMI postgres database tables are not created.

Resolution

This issue is resolved in VMware vRealize Automation 7.1 , available at VMware Downloads</u>

 

 

To work around this issue if you do not want to upgrade:

 

1. Log in to the vRealize Automation appliance using root credentials.
2. Run the command:
   
   /usr/sbin/vcac-config -v -e cluster-config-enable --update-info