Restore VMware Cloud Director from backup fails with "Unable to restore the VMware Cloud Director server configuration."

Products

• VMware Cloud Director

Issue/Introduction

• Attempt to restore VMware Cloud Director(i.e. vcd) fails with following error in management UI "Unable to restore the VMWare Cloud Director server configuration."
  
  
• /opt/vmware/var/log/vcd/restore.log reports setupvcd script fails to run: 
  
  | DEBUG | Invoking as root: /opt/vmware/appliance/bin/configure-vcd.sh restore true true
| ERROR | Error running command: CompletedProcess(args='/opt/vmware/appliance/bin/configure-vcd.sh restore true true', returncode=23, stdout='Running in restore mode\nAppliance OS Phase has been Completed.\nStarting Appliance Cloud Director Configuration Phase.\nInvoking check-vcd-params script again.\nAll the required ovf parameters provided for the Cloud Director configuration phase\nInvoking nfs-setup script.\nMounting NFS file share ...\nInvoking setupvcd script.\nsetupvcd script failed to execute.\nFor more details, check /opt/vmware/var/log/vcd/configure-vcd.log.\n', stderr='')
| ERROR | An error was encountered while restoring.
Traceback (most recent call last):
  File "/opt/vmware/appliance/bin/api/restore.py", line 243, in restore
    reconfigure_vcd(str(http_cert).lower(), str(pgmanagement_cert).lower())
  File "/opt/vmware/appliance/bin/api/restore.py", line 168, in reconfigure_vcd
    err = 'Unable to restore the VMware Cloud Director server configuration.'
  File "/opt/vmware/appliance/bin/api/restore.py", line 50, in run
    raise RestoreException(err)
RestoreException: Unable to restore the VMware Cloud Director server configuration.
  
  
• /opt/vmware/var/log/vcd/configure-vcd.log has error messages similar to:
  
  Reconfiguring vCD to use a secure database connection.
Invalid database configuration provided. Aborting configuration of local cell.
[ERROR] Failed to run reconfigure-database. See /opt/vmware/vcloud-director/logs/cell-management-tool.log for details. Aborting.
[ERROR] setupvcd script failed to execute.
  
  
• /opt/vmware/vcloud-director/logs/cell-management-tool.log reports unable to find valid certificate:
  
  Invalid database configuration: SSL error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target |
org.postgresql.util.PSQLException: SSL error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target


• /opt/vmware/var/log/vcd/appliance-sync.log reports timeout when adding certificate:
  
  Timed out adding certificate for node node-<node id>, continuing to other nodes.

Environment

VMware Cloud Director 10.x

Cause

The failure to restore VMware Cloud Director from backup is due to timeout issue when trying to import certificate.

Resolution

To resolve the issue, increase the certificate import timeout value following "Resolution" part of below KB:
VCD cell configuration fails during database configuration with error " setupvcd script failed to execute"