When checking the WebDebugLog.txt log file for this service it can be seen
Viewing the location for the .hostguid file as above will see that the file is missing.
To resolve, the ".hostguid" file must be regenerated. This will create a new database password which will need to be uploaded to the database.
1. Create a new .hostguid file
"C:\Program Files\Veritas\VRTSsfmh\bin\xdbadm.exe" -g -u habdbsync -c C:\ProgramData\Symantec\VRTSsfmcs\conf
New hadbsync password:
dfonmlqjhqi
Contents of new .hostguid file:
{00120050-5697-0ffc-0000-000098d15f35}
2. Upload the new database password
"C:\Program Files\Veritas\VRTSsfmh\bin\xdbadm" -u habdbsync -p dfonmlqjhqi -o "C:\ProgramData\Symantec\VRTSsfmcs\VRTSsfmcs\odbc.ini" -c "C:\ProgramData\Symantec\VRTSsfmcs\conf"
NOTE: The password shown here and the .hostguid shown are for example purposes only. They will differ from system to system and need to be generated on the CMS experiencing the issue.