CMS Infrastructure Services - Synchronization - Error - Dashboard Service - Configure from migrated databases failed

After migration when you try to synchronize the local or central you would get the following error -

Configure from migrated databases failed

1. Upgrade Databases with CUT
2. Open Cast-MS with migrated MNGT
3. Click on the central base and synchronize.

The error is because the the table DSS_SITES on the central base is not correct. It contains a central schema name for a server type equivalent to a local site.

To fix this issue we need to run the following queries on KB

1. Check the correct site id of the local by running following query on local

   select * from <Local_Name>.SYS_SITE

2. Then update the site id on central.

   update <Central_Name>.DSS_SITES
   set site_id = '<correct Site_id of the local>'
       site_name = '<Name_of_the_Local>',
       server_type = 5,
       site_srvaddress = '<ip_of_the_server:port>'
   where site_id = <previous site id >;

   update <Central_Name>.DSS_SITES
   set local_dss_name = '<Central_Name>',
       server_type = 5,
       site_srvaddress = '<ip_of_the_server:port>'
   where site_id = 0;

No results.