systemctl status sosrest.service -l gives below output.* sosrest.service - VMware Cloud Foundation Supportability and Serviceability(SoS) Service
Loaded: loaded (/etc/systemd/system/sosrest.service; enabled; vendor preset: enabled)
Active: activating (auto-restart) (Result: exit-code) since YYYY-MM-DDTHH:MM:SS UTC; 15s ago
Process: 78514 ExecStart=/opt/vmware/sddc-support/sosrest (code=exited, status=1/FAILURE)
Main PID: #### (code=exited, status=1/FAILURE)
VCF 5.2.x
The cause of this issue could be the file /opt/vmware/vcf/sddc-support/status.json is corrupted, deleted, or modified.
/var/log/vmware/vcf/sddc-support/vcf-sos.log
YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [database.py::create_database::131::MainThread] Creating tables ['tasks', 'subtasks', 'br_tasks', 'br_subtasks'] for SOS operationsYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [database.py::create_database::134::MainThread] DB init operation completed successfullyYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [workflowhandler.py::handle_crash_recovery::255::MainThread] Check and Handle SOS REST application crashYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [workflowhandler.py::get_locks::157::MainThread] Get available lockYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [restutil.py::get::158::MainThread] trying#60 to get http://localhost/locks after 5 secondsYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [restutil.py::get::159::MainThread] URL GET: http://localhost/locksYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [restutil.py::get::167::MainThread] Reason:YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [restutil.py::get::171::MainThread] Status code: 200YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [workflowhandler.py::get_locks::163::MainThread] Locks : []YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [workflowhandler.py::release_lock::204::MainThread] Release DEPLOYMENT lockYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [workflowhandler.py::get_locks::157::MainThread] Get available lockYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [restutil.py::get::158::MainThread] trying#60 to get http://localhost/locks after 5 secondsYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [restutil.py::get::159::MainThread] URL GET: http://localhost/locksYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [restutil.py::get::167::MainThread] Reason:YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [restutil.py::get::171::MainThread] Status code: 200YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [workflowhandler.py::get_locks::163::MainThread] Locks : []YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [workflowhandler.py::release_lock::221::MainThread] System not locked by backup/restore. No lock has to be releasedYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [db_api.py::fetch_all_records::237::MainThread] Fetching records for table <class 'framework.dbinterface.database.BRTask'> with status in ['In Progress']YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [db_api.py::return_a_session::65::MainThread] Committing sessionYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [db_api.py::return_a_session::75::MainThread] Closing sessionYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [db_api.py::fetch_a_record::264::MainThread] Fetching records for table <class 'framework.dbinterface.database.BRTask'> with id in ['########-bcda-4067-8437-20b81330c0c5']YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [db_api.py::return_a_session::75::MainThread] Closing sessionYYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [db_api.py::fetch_a_record::273::MainThread] No record found for queryYYYY-MM-DDTHH:MM:SS ERROR [vcf_sos] [workflowhandler.py::handle_crash_recovery::282::MainThread] 'status'YYYY-MM-DDTHH:MM:SS ERROR [vcf_sos] [workflowhandler.py::handle_crash_recovery::283::MainThread] Traceback (most recent call last):File "framework/workflowhandler.py", line 264, in handle_crash_recoveryKeyError: 'status'YYYY-MM-DDTHH:MM:SS ERROR [vcf_sos] [sosrest.py::startup::98::MainThread] 'status'YYYY-MM-DDTHH:MM:SS INFO [vcf_sos] [sosrest.py::startup::99::MainThread] SOS REST service failed while checking for system locks
Follow the resolution steps provided in The sosrest service on SDDC Manager reports the error "Convert from db to json failed"