How can I force MCS to redistribute all the profiles which have previously failed?

Document ID : KB000115870
Last Modified Date : 26/09/2018
Show Technical Document Details
Question:
We have had some servers get their robots re-installed and it doesn't look like the mon_config_service is re-distributing the configuration of MCS. Making a change to the profile in USM seems to re-distribute the profile, but we have many servers and profiles to do this for so it takes far too long to do manually. Is there a way to force a redistribution of all the failed profiles en masse?
Answer:
  1. deactivate mon_config_service probe on the primary hub.
  2. run the following query against your backend SQL database:
    update ssrv2profile set status='new' , retries=1 where status = 'error'
  3. activate mon_config_service probe and it will redistribute all the failed profiles