This page outlines the issue where the below error is encountered while synchronizing an Analysis Service or the dashboard service.

Services/CASTDB on Oracle/CAST_TEST_LOCAL: Analysis Service "CAST_TEST_LOCAL" has same service ID as the Analysis Service "CAST_TEST_LOCAL".

Any Service ID must be unique among all services displayed in the Infrastructure view. The configuration problem typically occurs if you backup a CAST database and restore it under another name.
Figure 1

• if you backup a CAST database and restore it under another name on the same or different server where it already exists.

Even if you restore the CAST database under another name, the Service ID still remains the same for both and hence raises this error while doing any operation that will synchronize the Analysis or Dashboard Services.

This error will be encountered while synchronizing the Knowledge and Central base, Running an analysis or Snapshot.

Step by Step scenario

• Backup a CAST database.
• Restore it under another name on the same or different server where it already exists.
• Open Cast-MS, synchronize any schema from the services tab (Right Click on schema > Synchronize).

Action Plan

To troubleshoot this issue, you need the following Relevant input

Perform the below actions:

1. Are you getting error while synchronizing services?
   If you are getting the error while performing any operation that involves synchronize services (running snapshot or Analysis etc), you may encounter the following error:
   Services/CASTDB on Oracle/CAST_TEST_LOCAL: Analysis Service "CAST_TEST_LOCAL" has same service ID as the Analysis Service "CAST_TEST_LOCAL".
   Please refer to Solutions section to follow the steps to resolve the issue.

If you want the the user to contact Technical Support, use the following link: CAST Technical Support.

Relevant input

To help us investigate please provide us the following inputs:

• CAST Support Tool (CST) - alias Sherlock
• Screenshot from Cast-MS showing the error to identify the duplicated services.
  

Explain how to get this input by referencing other pages of the TKB. Create as many pages as you need. The instructions should not be in the user guide since they could be reused in a different context.

Solutions

1. Solution 1 : If the Duplicated databases are belonging to the same Database Server :
   
   
   • In CAST Management Studio, go to the Services panel :
     Figure 2
   • Select the duplicated Analysis Service (local database) or Dashboard service (central database), right click this duplicate database and select Edit
     Figure 3
   • Click Change Service ID to change the Service of the duplicated Database

   Note that if you change the Service ID of the Local Database that is currently used by CAST Management Studio to store the Analysis Result, you will face Added/Deleted Objects in the Dashboard, as the Snapshot is based on the Local Site ID (or Service ID) among others parameters.

2. Solution 2 : If the duplicated schema are not belonging to the same database and the Central schema and Local schema are in the same Database Server,
   
   
   • Either you change the detail connection of the Database server that contains the duplicated schema
   • Or you remove the Database server that contains the duplicated schema as below screenshot
     
     Figure 4
     
     
3. Solution 3 : If the duplicated schema are not belonging to the same database and the Central schema and Local schema are not in the same Database Server, then you must remove the duplicated schema from its Database Server