How to uncluster Business Objects servers?

Here I'm illustrating a scenario where your Business Objects servers get clustered accidently. Many times we want to replicate the Business Objects environments. We want to make our TEST or DEV environment as same as production, so that we can perform the tests on either TEST or DEV and if the tests are successful, we apply the changes to Production system.

In order to achieve this, we need to use the copy datasource Wizard through CCM. Using the database copy gives us exact replica of the source environment.

Consider you have copied the database of your PROD system to a new box (let's consider this one as TEST). When you start the TEST system (SIA) and login to the Central Management Console (CMC), you will find the servers of PROD box in the "Servers" area. As we are copying the database, it will also bring the servers of PROD to your TEST box and it will make a cluster.

You'll need to perform following steps to uncluster these two environments.

We'll need to delete the entries of PROD servers from the CMS DB of TEST environment.

Stop the SIA of TEST environment, login to the DB server and execute following queries against CMS DB of TEST environment.

For XI R2:

delete from cms_infoobjects5 where typeid in (16,17);
delete from cms_infoobjects5 where objectid=4;

For XI 3.1:

delete from cms_infoobjects6 where typeid in (16,17);
delete from cms_infoobjects6 where objectid=4;

Once you execute the queries, commit the statements.

Here,

typeid 16 is for servers

typeid 17 is for servergroups

objectid 4 is for cluster

Now goto the CCM >> Properties of Server Intelligence Agent (SIA) >> Configuration tab.

Here, select the checkbox for "Change Cluster Name to" and provide a new cluster name.

For Unix, you can execute cmsdbsetup and reset the clustername.

Once you change the cluster name, you can start SIA. This time you'll not find the servers of PROD in your TEST environment. You may need to recreate SIA on the TEST box so that it can add default servers in the node.

How to avoid such accidental cluster?

Considering the above scenario, once you copy the DB of your PROD system to TEST system, change the cluster name for your TEST system (through CCM) before you start SIA. This will avoid clustering of PROD and TEST. You may still find the servers of your PROD system in the TEST system. For that, you can use the queries mentioned above to get rid of them.