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

Description

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

Configure from migrated databases failed

Observed in CAST AIP

Observed on RDBMS

Step by Step Scenario

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

Action Plan

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.

   ```sql
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;

Impact on Analysis Results and Dashboard

No results.

Notes/comments