SOS Health Check stops running on SDDC Manager

Products

• VMware Cloud Foundation

Issue/Introduction

The VMware Infrastructure Health (VIH) adapter on VCFOperations/Aria Operations runs a SOS Health Check once every 24 hours via API. If this check fails the error below will appear in the SDDC manager task list.

Environment

VMware Cloud Foundation 5.x

VMware Cloud Foundation 9.x

Resolution

Health-Checks may stop running due to the an issue with the SDDC SOS sqlite Database.

You can reset the SOS Database by following the steps in KB, The sosrest service on SDDC Manager reports the error "Convert from db to json failed" or "Upserting Json to DB failed"

Additional Information

More information about the VIH adapter.

• The VMware Infrastructure Health (VIH) will create a task for each domain in the SDDC UI.
• The VMware Infrastructure Health (VIH) adapter will retry three times. 
• You can change the retry values with KB, Task ‘Health-Check operations for SDDC’ Fails in VCF SDDC Manager due to concurrent workflows
• You can manually trigger the health check in the SDDC Manager UI from the API explorer.
SDDC Manager UI > Developer Center > API Explorer > SOS > POST /v1/system/health-summary
• Health Check results are saved in the SDDC manager directory /var/log/vmware/vcf/sddc-support.

The Health Check files are not captured in a SDDC log bundle
  
  Example:
     /var/log/vmware/vcf/sddc-support/healthcheck-####-##-##-##-##-##-####.tar.gz

• Documentation VMware Infrastructure Health integration

Reproducing the issue can be done by triggering the Health Check from the VCFOps/vROPS UI by stopping and starting the VMware Infrastructure Health Adapter by navigating to:
Operations > Configurations > Inventory Management > Adapter Instances > VMware Infrastructure Health Adapter Instance.