Last_status_change date/time is not updating to reflect the date/time the node was last rebooted

Products

• VMware Aria Suite

Issue/Introduction

• After a Graceful Shutdown and Power On of a VMware Identity Manager PostgreSQL cluster the last_status_change date/time was not updated to the date/time of the graceful shutdown.  A reboot of the node should be updated to the date/time of the last reboot this is outlined in the kb Analyzing root causes of Postgres Cluster issues on Workspace One (vIDM VMware identity Manager).  To check the last_status_change date/time run the command below:

  su root -c "echo -e 'password'|/opt/vmware/vpostgres/current/bin/psql -h localhost -p 9999 -U pgpool postgres -c \"show pool_nodes\""

• There is no replication delay found when running the above command to show pool nodes

Cause

The 'system-config.properties' located in '/usr/local/horizon/conf ' is missing required properties

Resolution

1. Take a snapshot of the affected node or cluster.
2. Stop the horizon workspace service on the affected node using the command: 

   service horizon-workspace stop

3. Update the file /usr/local/horizon/conf/system-config.properties of the affected node with the properties listed in from the system-config.properties.backup file or update it using the the /usr/local/horizon/conf/system-config.properties of a working node or you can use the referred exampled in Additional Information to update this file. 
4. Restart the horizon service on the affected node using the command 

   service horizon-workspace restart

Additional Information

system-config.properties file sample:

ClientID=Configurator_OAuthClient
suiteToken=XXXXX
tenant.id=XXXXXX
application.initialized=true