Clustering and unclustering of BO Node

[former_member596160]

We had distributed environment with 4 servers:

1. BO Server
2. Tomcat Server
3. Lumira Server
4. Hana DB server

We have upgraded Lumira 1.31 to Lumira 2.1 and then had a lot of issues. To resolve this I have uninstalled the Lumira server, and then on the Lumira node first I have installed full build BO 4.2 SP3 Patch 3 and then installed Lumira 2.1 full build. This installation was not part of cluster as I have done the installation choosing the default DB and Tomcat which comes with the installation and not the existing one.

Installation was successful, and after proper testing I want to make Lumira server also part of the cluster.

Now below are my queries:

1. Currently I can see in CMC of BO server Lumira node (which was part of cluster and now a standalone server) with old lumira services. How can I remove it ?
2. I have found one SAP node which says first I have to add SIA to the cluster then I can delete the existing node from the cluster so if I add the SIA it will not read the standalone server info which is pointing to different DB ? As SIA name is same?
3. Once I will delete the old node entry from the cluster, how can I add new Lumira server to existing DB and existing BO server. (In short how to make it cluster)
4. Do I need to make any changes on Tomcat as well (existing one which is part of distributed environment)

We have Linux environment.

Thanks,
Garima

[pavan_k11]

To delete the old node, recreate(do not add a new ) SIA without any services in it.

While recreating provide exact name and port number.

Once SIA is recreated, go ahead and delete it.

[former_member263415]

Hi Garima,

As I understand, we do not want the node “tvaluapp01”.

I would recommend to take a backup of CMS DB and file store before performing the below steps :

-Login to the CMC > Servers, select " Lumira Servers" under Service Categories or select the node tvaluapp01.

You would only see the corresponding node services on the right hand side. Select the servers, right click > select option " delete "

-Now, the servers would be deleted, but we still have the node tvaluapp01. Select this node under CMC > Servers > Nodes.

Right click it and go to its properties.

You would find ID,CUID mentioned in the second row.

Copy and note the CUID of this node.

Now, stop the servers (./stopservers.sh), manually login to the CMS DB using HANA studio and run the below queries :

Select * from cms_infoobjects7 where SI_CUID=’<CUID copied>’

This should return only one row with ParentID=59 under the PARENTID folder.

Once we check this, use the delete query to delete this row from the DB.

Now, once you start the servers, (./startservers), the tvaluapp01 node should disappear from the CMC > Nodes.

In order to cluster the environment again, re-create SIA and use the database details of the current environment.

Regards,

Sharvari

[former_member596160]

Hi Sharvari,

Thanks a lot !

I will try these steps Today.

Regards,

Garima

[former_member263415]

Hi Garima,

To help you to uncluster and remove the stale Lumira services, attach the below screenshots :

-Screenshot of CMC > Servers > Expand "Nodes" on the left hand side

-Screenshot of ./serverconfig.sh from the CMS node of the , Option 8 "List all nodes"

Regards,

Sharvari

[former_member590052]

cmc-nodes.jpgoption8-serverconfig.jpg

Hi Sharvari,

PFA the screenshots.

Thanks,

Garima

[former_member269268]

Hi Garima,

Yes, follow scenario 2 from KBA https://launchpad.support.sap.com/#/notes/0001838017

For clustering I just have to run cmsdbsetup.sh from the standalone Lumira node and point it to existing DB? -Yes

Regards,

Rishi

[former_member590052]

Hi Rishi,

When I try to add new node (so later I can delete it) I get below error message:

This node is already part of the cluster , please enter to continue.

We are not able to add node to cluster.

Any suggestion swill be much appreciated.

Thanks,

Garima

[former_member269268]

Hello Garima,

Lumira:

-Uninstalling BI Lumira is not support as mentioned in SAP KBA 2568039 - SAP Lumira Server 2.x - Unsupported Uninstallation Scenarios

-However, as you have already uninstalled Lumira. After uninstalling, to go back to the Lumira 2.x state, you can either install same version which was there previously or install the latest 2.x Lumira server.

BI Server:

-After taking consideration of above points.

-We have BI server along with Lumira AddOn installed on it.

-You can simply point BI server back to the original Database.

(We have to make sure all the version in the Cluster are on same Patch level.)

-After you make Lumira server cluster. Update your tomcat as well.

Regards,

Rishi

[former_member590052]

Hi Rishi,

Thanks for the reply!

Currently I can also see old Lumira (which is now a standalone server) in CMC > Servers as second node with old services.

So before clustering the standalone server to existing BO server I have to remove the old Lumira server from the cluster ? Right?

I have found below note for unclustering, please check scenario 2, is this what I have to do?

https://launchpad.support.sap.com/#/notes/0001838017

For clustering I just have to run cmsdbsetup.sh from the standalone Lumira node and point it to existing DB?

Thanks,

Garima

[amitrathi239]

Have you upgrade the tomcat server as well when you have upgraded the lumira server to 2.1?

It seems you didn't upgraded tomcat server

[former_member596160]

Hi Amit,

When our Lumira was in cluster we had Lumira installed in tomcat server as well, when I unclustered the Lumira I had to uninstall Lumira from tomcat server. After I make Lumira server cluster again I will upgrade tomcat as well.