CMS Cluster Summary and the CMSClusterMembers Registry Key

55 thoughts on “CMS Cluster Summary and the CMSClusterMembers Registry Key”

1. Hi,

   Quite an interesting article. I am new to this site and already impressed. Would like to add some more points the article. One part is about Fail-over. Say we have 2 CMSs in a Cluster and suddenly one of them crashed while taking the requests. These requests will not be taken by other CMS for the following scenarios.
   1.The CMS crashes before the request is actually received by the CMS (Between Client and CMS)
   2.The CMS crashes before registering the request with the CMS Database

   We had one very interesting learning. If you configure Auditor in a clustered environment, we need to make sure that ODBC System DSN name for Auditor connection should be same in all the machines. In case we have different System DSN Names, all the CMS in the cluster will not get started.

   Regards

   Aravind

2. Hi Aravind,

   I am glad you are finding the article interesting; thanks for the feedback. Thanks for sharing your knowledge and experience. All of them are very important details.

   I was not aware of the trouble with setting the auditing database information differently. Did you have to figure it out on your own or was there some kind of helpful error message that led you to the problem?

   Thanks, Julian

3. Hi Julian,

   Nice to hear from you.

   In fact there was no obvious error message when we start the CMS. When we start CMS from one server, we noticed that the other CMS was getting stopped automatically. No error message was thrown. In order to identify the issue, we enabled -trace for CMS and captured the logs. With the help of SAP technical team, we identified that there was some ODBC connection error. As soon as we disabled the auditor from the cluster, both the CMS got started. Auditor System DSN name was made identical, then we were able to successfully start the CMS.

   Thanks and Regards,

   Aravind

4. Hi Julian,

   This is an awesome website for getting deeper in to BusinessObjects. It is really helpful for us.

   Cheers!!!
   Arun Sasi

5. Wow Arun! Thanks for the compliment. I’d like to have more here, but all of the other demands on my time are making that difficult. Thanks for the encouragement to keep building on the site.
   Thanks, Julian

6. Hi Julian,

   how can i improve the report and universe performance?

   Please explain me step by step procedure?

7. Hi ashok,

   Your question is quite important, but it is quite wide open. If you could provide more information about which aspect of the performance you want to improve it would be helpful. My initial response is that the biggest overall improvement in performance of reports and universes will come from improving the performance of the query (which is a database issue and a query design issue), this will impact the performance of report refresh.

   Please let me know what specifically you are concerned about improving and I will try to put together a new article (as it certainly deserves one) on the topic.

   Thanks, Julian

8. Your article is very helpful. It is hard to find people discussing this topic. now my problem with cluster is: by accident, I added a new CMS server to current cluster. So now I have two CMS servers in one cluster. If I change the cluster name, it will change the other server’s cluster name too. I tried to give different cluster name to each CMS in registery, however, after the machine is rebooted, both of the CMS are still in the same cluster. In Central Management Console, we see both two servers there. You will see two CMS, two pager servers, two cacheservers, two jobservers under two different machine name. This is not what we want. We want to have one CMS server as production, the other one as test server. We do not want these two CMS interrelated and connected. In other words, in each machine’s CMC, we only want to see its own servers(CMS,page, cache, job), not both machines’.

   I have read the administrator guide, but I don’t see any info regarding this issue. Can you shed some lights on? I appreciate it. Thank you very much and have a great holiday

9. Hi Sunny,

   My mind is on vacation right now, so you are not going to get my deepest, validated ideas. Sorry.

   My initial thought is, from the server you want to become your “test” environment, what if you delete the CMS using the SI Agent utility (BO XI 3.x) or CCM (BO XI R2)? Then you could remove them from the production CMC as well.

   Then I would wipe out the cluster registry key on “test”. Then I would create a new CMS and hopefully designate a new “test” cluster name, such as “testenvironment”.

   Please try this and report back if you can. Merry Christmas to you, by the way.

10. Hi Julian/Sunny:

    I have the exact same issue as Sunny, running BO XI R2. We are migrating Oracle 10 -> 11 and I was doing some testing.

    Specifically, in BO XI R2’s Central Configuration Manager (CCM) I am unable to find a way to “delete the CMS”. When I open the CCM, a menu at the top right above the services list labeled “Computer Name” lists both Crystal Management Servers (CMSs) in the cluster, but nowhere do I see a way to “delete/remove” one. When I stopped Crystal Management Server service on the good CMS and removed the registry extraneous key within HKEY_LOCAL_MACHINE\SOFTWARE\\Business Objects\Suite 11.5\Enterprise\CMSClusterMembers, upon restart of the CCM the servers were both still listed.

    Any chance either of you have found such an action to “remove/delete” the CMS in BO XI R2?

    Thanks,
    Cris

11. Here are the steps that worked for me to “remove” a undesired CMS from a cluster in BO XI R2:

    1) Search the registries of the relevant CMSs (confirmed clustered or not) for the names of all other suspected CMSs clustered. For example, search CMSa in the registry of CMSb, and via versa. You may find entries in the CMSClusterMembers, CurrentComputerList, and in some “instances” and such*. Remove them (backing up the parent tree like “HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects” first would be wise).

    2) On the “dead/moving” CMS machines, like “CMSb” in my example, use the CCM to stop the CMS service, then use the properties -> configuration to Specify a CMS Data Source of “test / test” (invalid names). I suspect you could connect to another valid CMS Database, and that might help cleanup a bit. Reboot the dying CMS.

    3) Back on the good CMS, like “CMSa” in my example, connect to the Central Management Console (CMC), like http://CMSa/businessobjects/enterprise115/admin, and login as Administrator. Use home -> Servers and select the stopped servers that have “Machine Name” not in the cluster, like “CMSb” in my case. Delete these selected services using the button in the upper right, which I believe cleans up proprietary table entries that are not only annoying but can trigger “re-clustering” given the opportunity. Restart the good CMS.

    * If you were unwise enough to clone a CMS and just rename it for a new instance (perhaps virtual machines), then be careful because some registry items may just refer to directories for logs and such. These should not be cleaned up. In our XP Pro testing case of “CMSa” cloned and renamed to “CMSb” for testing, there was a “Documents and Settings\CMSa” folder on CMSb used for logging and such. While we wanted to remove CSMb’s registry items “CMSa” that had resulted from cloning and clustering from connecting to the common DB1, directory entries were not applicable for removal. In general, I do not recommend cloning a CMS, though I have not found anything that is problematic – just this one confusion.

    The boring details…
    ——————

    With regards to BO XI R2: how clustering works internally is a mystery, but it is equally illusive what external symptoms indicate clustering is active. After a few more days on this, I found there are a number of configurations through the registry and in the Central Management Server (CMS) proprietary DB that trigger, and help implement, clustering with willing CMS servers. CMSs seem adept at setting these up, and in many cases will quickly reestablish them if partially damaged, but I still find no action that formally cleans them up and separates. But, sometimes, “you gotta’ keep ’em separated”! That is: CMSs love to cluster, at the drop of a hat, and breaking them apart… well, remember those dogs in the neighborhood?

    How do they cluster? If you connect a CMS to a CMS database that was created from a “clusterable” CMS install (I believe this is an option on install, though I can’t recall), the new CMS will be added to the cluster, which changes registry entries on that one and others clustered, and I claim modifies some entries in the proprietary CMS database tables.

    I do agree there is a very high probability that clustering is only active if the CMSClusterMembers Registry Key is configured with multiple entries for the current cluster and the servers are running and communicating. Conversely, I find symptoms like the Central Configuration Manager (CCM) application menu at the top right labeled “Computer Name” do not always imply active clustering. In that case it is just a “recent” list, and while you would want to have the list show any real CMSs in your cluster, inclusion in the list does not confirm it is clustered. That one misled me, until I found and cleaned the recent list in HKEY_CURRENT_USER\Software\Business Objects\Configuration Manager “CurrentComputerList”. Inclusion within did not mean the CMS was definitely still “clustering”.

    If CMSa and CMSb are both pointed at DB1 they cluster themselves, but subsequently connecting CMSb to DB2 leaves CMSa still showing confusing signs. At minimum, CMSa’s “Services” list (elaborated below in step #3) still lists CMSb “services” as “stopped”, which I find more disconcerting than the “Computer Name” menu – especially since our production system has a pinger that checks the list and throws alarms. So, things may have been OK, but I was not. I like to sleep at night.

    Cleaning the CMSClusterMembers Registry Key on relevant CMS servers, then stopping others you wish to dis-associate from your CMS database, and then restarting (for good measure) the “good” ones might put you right enough. However, to avoid confusion you may have to do more cleanup, which are the 3 steps detailed in my steps at the top of this message.

    A step further (CMSa/DB1 cloned to CMSb/DB2):
    ——————————————–

    Finally, you may be foolish enough to also be cloning your CMS Database for testing, and this seems even worse. When you connect a CMS to the DB copy it will think it is part of the cluster, talking to your original CMS. I do not think this is a good idea; I doubt CMS authors had this kind of DB mess in mind when coding/testing. However, just having them cluster/connect did not mess up our source DB (though we did very little on the new CMS before shutting it down quickly).

    While CMS DB copy as well as CMS copy is not advised, we confirmed that stopping the new CMSb from talking to CMSa before it could cluster avoided mess. We copied the CMS DB1 -> DB2 using an Oracle copy**. Then we duplicated virtual machine CMSa and renamed the OS to CMSb, then put in “\WINDOWS\system32\drivers\etc\hosts” entries on CMSb before we put it on the net, to stop them from talking (confirming they could not ping each other by name). For example, I added “172.16.0.250 CMSa” and “172.16.0.250 CMSa.lan.domain.com” to CMSb’s hosts file, where “172.16.0.250” is a dead IP. With that, we could connect CMSb to DB2, and it worked without clustering CMSa/DB1 to death, though I would be cautious.

    ** (we also via the Crystal Copy in the CMS service, user the properties -> configuration to Specify a CMS)

12. Impressive comment/article Cris. Thanks!

13. CMSa/DB1 cloned to CMSb/DB2 – correction (DNS is not enough)

    In simple cases, just pointing a CMS you want to remove from a cluster to “test/test”, or another valid cluster or new DB, may be sufficient. If not, fixing Julian’s registry entry CMSClusterMembers with reboot may be enough, or you can try my three steps above to dig deeper.

    In CMSa/DB1 cloned to CMSb/DB2 it gets worse, and this follow-up is provided only for those who might have deeper problems (and to correct my claim that “DNS” fixes are enough). I do not recommend you try this stuff unless you have to, instead hope you might just find some tidbit of value in some way or another.

    For CMSa/DB1 cloned to CMSb/DB2 just hacking the DNS via a hosts file was not sufficient. At first it looked good, then I discovered I had the double list of “services” listed in the “CMC” (http://CMSb/businessobjects/enterprise115/admin) and they looked messed up (CMSa’s looked “running/disable” and CMSb’s looked dead). Moreover, while the original server looked OK that night, in the morning it was clustered again, and CMSa listed double services too (though not as messed up).

    Subsequent queries of the DBs and network tracing using Wireshark revealed that the services entries from the Database were enough to somehow allow the systems to talk despite having no DNS, and cluster. My only solution in this case was to clean up the clone before it could cluster to the original system, and clean up any mess still left after that.

    With Wireshark I immediately saw the cloned CMS reached out to the original CMS, despite the fact I could not find the IP listed in the registry or DBs of the either server (and DNS/hosts was hacked). I admit I only searched for IP as a decimal value, and it is possible it is stored somewhere as hex or just as a long integer. But, in the end, Wireshark showed that once I clean up the services as well as the registry, on reboot the systems did not talk (cluster).

    Here are my more dramtic cleanup steps (which I offer only as “insight” and do not recommend):

    CMS config: Central Configuration Manager (CCM) application
    CMC example URL: http://CMSb/businessobjects/enterprise115/admin, login as “Administrator”.

    1. Point the “cloned/new” CMSb at an invalid “test/test” database (CMS config).
    CMS config – stop the CMS service, then use the properties -> configuration -> specify
    2. Copy CMSa database DB1 to DB2.
    3. Point the “cloned/new” CMSb at the DB2 copy and then start it.
    CMS config – stop the CMS service, then use the properties -> configuration -> specify
    – systems will try and cluster here, you need to move fast –
    4. Immediately use the “cloned/new” CMSb’s “Central Management Console” (CMC):
    5. Go into “Servers”, select all services from the original CMSb, delete them using button in upper right.
    6. Stop the “cloned/new” CMS service in the CMSb config.
    7. Edit “cloned/new” registry and clean out any references to the original CMSb.
    8. Reboot the “cloned/new” CMSb OS.
    9. Repeat steps 7 & 8, getting concerned if it requires three loops.
    10. Rename the cluster on the “cloned/new” CMSb.
    CMS config – stop the CMS service, then use the properties -> configuration.
    11. In the CMCb “Services” select any red services and use “enable” in upper right.
    12. Confirm services on both machines using their CMCs.
    13. If there are problems on either machine, do steps 5-9, then 11-13 again.

    About the CMS DBs:

    One can’t examine a CMS DB directly, since most columns are enciphered, and the relations and abstractions are extensive. Instead you need to go through code that gathers data into represented objects. Unfortunately, the interface probably does not reveal all the data so it is not conclusive.

    However, using the BusinessObjects Enterprise SDK I was able to extract loads of data from the DB and search it as I pulled it out to confirm to my satisfaction that clustering is represented in the DB as well – this is might need help cleaning up. Sadly, since details are not conclusive, my conclusion is that the best cleanup is via registry, and restart, combined with CMC “services” operations.

    I used the following docs in combination with some sample code:

    http://www.sdn.sap.com/irj/boc/sdklibrary “XI Release 2” ->
    http://devlibrary.businessobjects.com/BusinessObjectsXIR2/en/devsuite.htm
    BusinessObjects Enterprise SDK
    .NET developer guide and API reference
    SDK Fundimentals
    How do I use the query language to retrieve classes from the CMS repository

    Docs revealed three categories of objects that can be pulled from the CMS DB: CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS. You pull these with SQL queries, which return rows of objects which vary within each category. All objects supported “toString()”, which gave substantial data insight (and could be used for substantial backwards engineering).

    My psuedo code from ColdFusion testing to search an object category for data is below, which illustrates the idea. For performance reasons it is strongly recommended you only do this (select “*” from table) on a test system. Note that some of the items in the “toString()” were “xml” packets that do not show if you dump the output as HTML in a brouwser (view source to see them).

    InfoStore = createObject(“java”, “com.businessobjects.InfoStore”);
    EnterpriseSession = CrystalSession.create(“Administrator”, “CMSb_password”, “CMSb”, “secEnterprise”);
    InfoStore.create(EnterpriseSession);
    InfoObjects = InfoStore.query(“select * from CI_INFOOBJECTS”);
    for (i=1; i lte arrayLen(InfoObjects); i=i+1) {
    InfoObj = InfoObjects[i];
    if (FindNoCase(“CMSa”,InfoOb.toString())) { // looking for CSMa entries in DB CSMb.
    try {
    writeoutput(“CI_INFOOBJECTS.” & InfoOb.getKind() & “ – “);
    } catch (any excpt) {
    writeoutput(“CI_INFOOBJECTS.[ERROR] – “); // getKind() not always supported.
    }
    writeoutput(Report.toString());
    }
    }

    I hope this is the last you hear from me, I am sick of BO XI R2.

    Cris Mooney

14. Hi,

    We Have planned to Create cluster Of CMS servers. But we have planned to installed CMS servers on different physical machines to create a fail over cluster. Is it possible to install only CMS servers on different physical machines.If it is possible to cluster the CMS servers on different Physical machines then, whether we need to install BO on all the physical servers? or Is there any way to install Only CMS on other machines

    Thanks,
    Guru

15. You can cluster CMS however you want. You can create multiple CMS on the same machine, on the same SIA (BO XI 3.X only), and on different machines. The only limits are that if the CMS on are the same machine or same SIA (also on the same machine) then you must give each CMS a distinct port number. If you are cluster CMS on different machines then you can have them all use the same port (6400 is the default CMS port).

    You do have to install BO on each server; however, you can choose during the installation to do a “Custom or Expand” option where you “Select which components you wish to install”. Then you can chose just to install CMS and deselect everything else.

16. Thanks A lot Julian,

    Your Tips worked out for me.

    Guru

17. Hi, I am new and working on XI 3.1 now.

    I have two CMS in CMC and would like delete one.
    Because I created one by mistake.

    But the delete button under Manage greyed out just for CMS.
    I can still delete other Objects.

    How could I delete a CMS?

18. Hi J.J., the easiest way to remove a CMS is to reinitialize the Server Intelligence Agent that is hosting the CMS. This can be done through the “serverconfig” admin tool (add new SIA and just put the same name as the existing one); however, it will wipe out any of your settings on any other servers.

    I am not looking at a 3.1 system now, but can you try to stop the CMS first and then try to delete it? Probably not, CMS are a bit “die-hard”.

19. Hi Julian,

    thanks for the reply. The CMS was stopped from the beginning and I was not able to start or disable it. It was basically uncontrollable.

    I will try your instruction.

    thanks

    J.J.

20. Hi,
    I am working with this BOE Reports.My server is pointed to another machine,now I am moving it to another one.But well my question is,I din’t take the backup of the reports I created which are stored in CMS repository.Now since my server is not running,so is there is any other way to get the backup of these files,b;cause i will be reinstalling the system again.plz let me know ASAP

21. Hi Sunny,

    Is your server not able to boot the OS? In such a case try out with another server using import wizard if input and output services of your server(Not running server).

    Regards,

    RK Raman.

22. Hi,

    I have a 2 server cluster that has been setup with Network Load Balancing. I can find zero information on how to set this up so that the web tier can point to the NLB address rather than the individual server addresses. The server names seem to be hardcoded into the repository so that if I point to the NLB address, even though the traffic goes to the right server/port, BOXI looks up the NLB name, doesnt find it in the repository and thus fails. This is very frustrating. It is my understanding that if I point to a particular CMS server then I lose all the NLB benefits as all the load would go to that one server in the first instance (although would then be distributed by BOXI), and more critically if that particular server goes down then the system will break even though the other server is still up.

    Any suggestions you might have are appreciated.

23. Never mind. As usual, as soon as you ask the question it works. Simply changing the name of the cluster to the NLB address in the SIA properties seems to be working. I had actually tried that configuration earlier and it wasnt working but I think maybe the CMS’ hadnt been restarted in the right order or something like that. There seems to be very little tolerance when installing with this particular configuration.

24. Hi Ian, I am glad you were able to get past this. I have certainly been in your shoes.

    If I were you I would not user an NLB at all. All that you need is to use a BO cluster name. This creates a simple software mechanism that will check all CMS servers defined in the cluster before giving up. Usually, you would rename the default cluster name (often a server’s name) to a generic easy to remember name. Then you would just as this in your web tier as your default CMS. For example, in BO XI 3.X you would put this in InfoViewApp, CmcApp, and OpenDocument. You would also define your cluster CMS members in a clusters.config file placed in your PlatformServices web application. I should dedicate an article to this.

25. Hi, i want to cluster the uat server, do i need to have anyother physical machine like Qa to do it or if i cluster the node to an existing cms will that be ok. How do we know that the server is clustered

    After doing the clustering do we need to modify web.xml file in the PlatformServices\WEB-INF\

    is it mandatory to modify web.xml in order to implement clustering on a server.If anybody wants anything more please let me know

26. Since you say “node” I am assuming you are talking about XI 3.X. Each BO cluster needs to have its own database schema at a minimum. Therefore, it is possible to have two nodes running on the same physical machine that are either in the same cluster (attached to the same CMS database) or in different clusters (attached to different CMS databases). So yes, you can cluster two different nodes running on the same physical box as long as each node uses a different SIA port.

    For web.xml/cluster.config it is not mandatory to input the cluster information, but it would provide higher availability. What do I mean? If two nodes each have a CMS and those CMS are clustered together then whenever a web session hits a single CMS that session will automatically be load balanced between the CMS. Load balancing between CMS is not determined by the web.xml for the BO application. So the advantage of listing all CMS in the cluster in the web.xml/cluster.config files is that if one of the CMS is down you can still log into the cluster through one of the CMS that is up and running.

27. yes i am talking about xi 3.1.from ur post i got to know that its not mandatory to input the cluster information into web.xml/cluster.config is it better to input the cluster information in web.xml/cluster.config. what will happen if i dont modify the web.xl/cluster.config and keep as it is, will it effect my performance.

28. Hi

    I have two cluster members in the BO CMC Setting, which have configured by mistake. Due to this Web Intelligence Server getting automatic down. How can I remove one cluster members.

    Regards

29. Hi Asok, if by “cluster member” you mean an additional CMS clustered to another than you can just delete the CMS through CMC. Also, if you mean a clustered Server Intelligence Agent (SIA) then you will need to delete that SIA from the machine where it is hosted. When you execute the delete you will need to have stopped all BO services on that machine (if possible) and have at least one CMS running in the cluster.

30. Hi,
    We are trying to cluster CMS but not getting any direction. ANy help is appreciated.

    We installed BO Server on system A and CMS database is on an oracle server.

    We installed BO on system B and select “Expand” option to cluster it with the existing BO on system A.
    Both system A and B are using same DB schema.

    Is this correct approad or am I missing something?
    It would be great if someone can provide me the detailed instruction.

31. Hi Santosh, you have just described the textbook method of clustering two CMS. Congratulations! In order to validate your new CMS cluster you can do any or all of the following:

    1) Log in to the Central Management Console (CMC) using one of the CMS’s server and port information. Log off. Log in to CMC again, but this time use the other CMS’s server and port information
    2) In CMC go the the “Servers” page and validate that both CMS are listed there.
    3) In CMC, go to the “Settings” page and then locate the section labeled “Cluster”. There you should see both CMS listed with their BO name, their server/machine name, and their port information.

    Please let us know what you find.

32. Clusters dont work very well over firewalls as they communicate with each other over many ports. I couldnt find any documentation on what ports are used – the admin guide does not list all ports actually used. I tried to capture the ports as they were used but every time I thought I had got them all another one would pop up. In the end I just disabled Windows firewall altogether.

33. Hi

    On the CMC in Settings -> Cluster, how can I remove a cluster member. Note this member doesn’t show as a SIA under Servers and was probably created using the serverconfig script.

    Thanks
    Bola

34. Hi Bola, do you see the CMS listed in the Servers page of CMC? If so, just delete it from here. Otherwise, we might have to dig deeper.

35. Hi Julian,

    Thanks for responding.

    No, it isn’t listed and like you said, I would have just deleted it from the list. I seem to remember it was created as a new SIA using the serverconfig script but was then delete from the CMC I think.

    So it shows as test01.cms(alx002:7400)

    Regards
    Bola

36. Hi Bola, CCM (Windows) or serverconfig.sh (Unix/Linux) might have something that lets you delete. Otherwise, I would look in ccm.config on all servers.

37. Hi Julian

    Thanks. I did delete the remote CMS using serverconfig.sh but stubbornly, it still shows on CMC – > Settings -> Cluster. I then saw a cluster.info.properties file but when I deleted entries for the unwanted CMS in this file, on BO restart the deleted entries reappeared. I suspect the info gets loaded on startup into this file but from where? Can the CMS database be queried for this info at all?

    Thanks
    Bola

38. Hi Bola, take a look using Query Builder. You could start with something like:
    
SELECT
*
FROM
ci_SystemObjects
WHERE
si_kind = 'Server'

    …and then refine the query as needed.

39. Hi Julian,

    We have two servers in a clusters and now we want to add a 3rd server in the same cluster for the Xcelcius Specific services and the concerns implementing the same are as:

    1) Can we have two active servers in BO cluster of 3 servers?
    2) Do we need full BOXI installation on P03 or a customized installation.In case of a custom install, what are the services that should be chosen/enabled for only Xcelcius use?

    3) In case of custom install, feasibility of enabling only selective services on P01 and P03 i.e. can we enable some services from p01 and others from p03. If yes, how?

    Kindly Revert

    Thanks and Regards
    Anil

40. Hi Anil,

    1) I am not sure what you are asking. But if you are asking could you cluster BO servers on three different machines and then occassionally shutdown one of those machines, then the answer is yes. This would be fine as long as at least one BO server of each mandatory BO server kind is running.
    2) I have experimented with custom/partial installations in the past and they have always resulted in regret. When installing BO software never choose a custom installation, unless your machine will only server as a web application server. If you plan to run any BO servers on it, like WebI, for example, then I suggest installing CMS, even if you will not use it. BO often hides fonts and other functions in side the CMS installation even though they have NOTHING to do with the CMS.
    3) Don’t do a custom install; however, there is no need to run all BO servers on each machine. I will write an article on this (if I haven’t already), but for now, just go into CMC and disable and stop the BO servers you do not need/want. Then delete them (in 3.1, use CMC in R2 use CCM on the machine).

41. Hi Julian
    I must say.. all these posts have been very informative and helpful. I am in the process of BO XI 3.1 migration. Since this is in a production environment, we need to install BOE on server 1, then on server 2 – make sure that they both are a part of the same CMS database and then cluster them. I have done in-place migrations earlier, however, they were on a single server. This would be the first time I would be adding a cluster and hence, I need a little detailed info on how to add a cluster. As far as my understanding goes, I could do it thru the CCM [Central configuration manager] of the server A. I would have to change the cluster name (stop the SIA, go to properties, go to Configuration tab and change the clustername (eg. BOPROD), start SIA. Follow the same on server B too so that SIA should run on same domain account.
    My first question is – when u say ‘change cluster name’, does it literally mean just modifying the name of the cluster and are there any specific formats you follow?
    After this step, I would be logging in to the CMC, go to Servers. My second question – how do you change the ‘File Store Directory’ and ‘Temporary Directory’ for Input and Output File Repository servers. When I browsed for this info, it said I could do it but I would need the UNC path [eg: \\xyz\share]. Not sure how this step goes.
    After applying this step to both servers, I would have to restart all input and output file repository servers from CMC; login to CMC -> settings -> cluster and look for the clustername and all clustermembers. So my 3rd and last question is: How do we check the cluster name and cluster members in registry
    Any response from you or any of the readers is highly appreciated
    Ilea N.

42. Hi Ilea, I assume your are talking about Windows servers, is this correct? Also, you say this is a migration, but can you explain are the production servers new servers? Do you have a new database? You mention “in-place migrations”, but I’m not sure this is one. Sorry my responses to your questions depends on your answers here. Also, what version of BO are you currently using?

43. Hi Julian ,

    We have the BO XI R2 with two CMS server with clustering concepts.Everday more than 400 jobs will run from this server. sometimes some of the daily reports are not ruuning.if i stop any one CMS server then its running. Just i would like to know the reason for these kind of issue?

44. yes.. its a Windows server.. the production servers have been running BO XI R2.. we are in the process of upgrading them to BO XI 3.1. In-place migration is where we are simply replacing the older version with the new one. Like on sever B, we would be cleaning it and doing a fresh install on it.

45. Hi Kannan, I suspect that there may be something wrong with your clustering, or with the communication between the CMS servers, or between the CMS servers and the Report Servers. You may want to experiment with different configurations and also look at the logs on the server to see if they point you to any causes.

46. Hi Ilea, I am glad to hear you are cleaning up the servers and then doing a fresh install. Be sure you start with the highest available full install for your target patch level.

    So, my understanding is that you are upgrading in place your database and your FRS (input/output). In this case you really don’t have many options and clustering will happen automatically during the installation as long as you provide the correct inputs.

    I have not done an upgrade of an XI R2 database to XI 3.1, but this is what I recommend trying:

    1) Get two test servers, 1 test database, and 1 test location to put your FRS. Make sure they are configured and running XI R2 successfully. If you can only get 1 test server this is OK.

    2) Shutdown completely all BO services.

    3) Wipe the test servers clean of BO.

    4) Initiate the install of the highest full install of XI 3.1 available, I think Service Pack 4 is a full install (if not SP3 is). Point the install at your test database. Provide the proper password for Administrator. Complete the install.

    5) Stop all BO services on this newly installed server. Using CCM rename the cluster from the server name to the name you desire.

    6) Start all BO services on this newly installed server. Test, look around

    7) You may need to run “update objects” in order to obtain the XI 3.1 versions of the auditing reports and other BO-provided reports and universes.

    8 ) If all is well, then leave this running, but shutdown all but the CMS.

    9) Go to the second test server, if there is one, and install the same full install as you did to server #1. Provide the database info and Administrator password as before. You should see that the installer takes care of setting up the cluster because you are pointing it to a database where a XI 3.1 CMS exists.

    10) After both servers are on the same patch version then you can advance 1 first to the next desired FixPack level and follow with the other.

    Please share your thoughts on this. Of course, I would review the BO documents on this. In place XI 3.1 upgrades are not my forte as I have always had the luxury so far of moving to new servers and databases.

    BTW, since you actually have two servers, another alternative is to do a migration upgrade. If you can get a new production database then you could basically remove one server from the current system. Install BO XI 3.1 to it and the new database. Then execute a migration from the old to the new using Import Wizard. Then when all is migrated, you could shutdown the 2nd server, wipe it and install XI 3.1 on it.

47. Hello Julian,

    I have 2 clusters with 3 servers each. I am using java sdk to logon to one cluster at a time. I logon to first one fine and then log off but then it dosent allow me to logon to 2nd one and gives an error that CMS service not found. If I do the other way around, it again lets me logon to 1st server but fails for the second one. I did some research and found that the issue is with the session oblject because it is a singelton and does not work with the second cluster. Can you please suggest a way I can logon to both servers one by one using java sdk.

48. I assume that you are properly logging off and closing the session. Please be sure you are doing at least this:
    
if (enterpriseSession != null)
{
boIEnterpriseSession.logoff();
session.invalidate();
boIEnterpriseSession = null;
}

    Now, if the above is already part of what you are doing then I would suggest creating separate Enterprise Session variables, such as boIEnterpriseSessionA and boIEnterpriseSessionB. Please report back if any of this helped.

49. Thanks for the suggestion but I am trying to logon to the 2 clusters using a standalone java application.

    I use a main method to invoke my logic.

    I get a session manager object and then enterprise seesion. It works fine for the first time but second time it throws an exception after getting the session object only. My theory is that since crystalenterprise returns a singelton, it is not able to return a new session object the second time.
    Is there a way i can get a new session object every time i connect to a cluster like same as in .net sdk where we do sessionManager = new SessionManager.

50. Hi,

    We are using BOXIR3 and are having 4 nodes in cluster. I want to remove one of the nodes. Can you please suggest me a way to remove the node. Is using serverconfig.sh the correct approach?