Skip to Content
0
Former Member
Jun 25, 2009 at 10:41 AM

ccm.config issue - cluster

459 Views

<pre>Hi there,

XI 3.1 , Linux

We have a very strange situation.

We built a cluster for two servers bo1 and bo2 - they had SIA nodes called SIA1 and SIA2 respectively

A week or two ago, the BO repository became corrupted and we had to re-initalise it

This meant re-building the cluster. This necessitated the creatiion of a new SIA node for bo2 called SIAII (not my idea!!)

We did this using cmsdbsetup

This appeared to work and we appeared to have a working cluster

We noticed yesterday that a scheduled webi doc created on bo1 that was to run every 15 minutes was intermittently failing - about 3 out of 10 instances failed.

When we dug deeper, we were able to establish that the webi doc failed when the request was passed to bo2 - indeed it appeared to bring down the wireportserver.exe (both of them)

We re-checked the cluster via cmsdbsetup and everything looked fine.

Then we checked the ccm.config for bo1 and bo2 and things look a little strange. I believe a colleague may edited ccm.config incorrectly - there were 2 sets of entries in ccm.config for bo2 - one for SIA2 and another for SIAII. Perhaps the wrong one was removed/edited

Below is the comparsion of the 2 ccm.config files (bo2 on the left; bo1 on the right)

Neither have anything ins CLUSTER_NAMESERVER="" - is this correct

MYSQLHOSTNAME is incorrect on both

CMSCLUSTER="no" ?

On bo2 the node name is SIANODENAME="SIA2"

We looked at the registry entries and we can see entries for the old SIA...

Real question here is whether the ccm.config is accessed when one member of the cluster passed a report request to the other cluster member - would this be our issue?

SERVICENAME_AUDIT="BOE120_AUDIT"                                SERVICENAME_AUDIT="BOE120_AUDIT"
NAMESERVER="bo2"                                              | NAMESERVER="bo1"
DBTYPE="MySQL"                                                  DBTYPE="MySQL"
INSTALLTYPE="new"                                               INSTALLTYPE="new"
REINIT="yes"                                                    REINIT="yes"
BOBJEVERSION="12.0"                                             BOBJEVERSION="12.0"
SHUTDOWNPORT="8005"                                             SHUTDOWNPORT="8005"
REGFILE="/home/BOXI/bobje/data/.bobj"                           REGFILE="/home/BOXI/bobje/data/.bobj"
DBTYPE_AUDIT="MySQL"                                            DBTYPE_AUDIT="MySQL"
CLUSTER_NAMESERVER=""                                           CLUSTER_NAMESERVER=""
CONNECTORPORT="8080"                                            CONNECTORPORT="8080"
SIAPORTNUMBER="6410"                                            SIAPORTNUMBER="6410"
BOBJELANG="en"                                                  BOBJELANG="en"
BOBJELICENSEKEY="XXXX-xxxxxx-xxxxxxxxx-xxxx"                    BOBJELICENSEKEY="XXXX-xxxxxx-xxxxxxxxx-xxxx"
MYSQLHOSTNAME="127.0.0.1"                                       MYSQLHOSTNAME="127.0.0.1"
PRODUCTID_NAME="BusinessObjects"                                PRODUCTID_NAME="BusinessObjects"
PRODUCTID_VER="12.1"                                            PRODUCTID_VER="12.1"
LOCALNAMESERVER="bo2"                                         | LOCALNAMESERVER="bo1"
PIDDIR="/home/BOXI/bobje/serverpids"                            PIDDIR="/home/BOXI/bobje/serverpids"
CMSCLUSTER="no"                                                 CMSCLUSTER="no"
REDIRECTPORT="8443"                                             REDIRECTPORT="8443"
SIANODENAME="SIA2"                                            | SIANODENAME="SIA"
DEFAULT_NAMESERVER="bo2"                                      | DEFAULT_NAMESERVER="bo1"
INSTALL_DIR="/home/BOXI/bobje/"                                 INSTALL_DIR="/home/BOXI/bobje/"
BOBJEUSERNAME="toronto1"                                        BOBJEUSERNAME="toronto1"
CMSNAMESERVER="bo2"                                           | CMSNAMESERVER="bo1"
DATABASEUID="toronto1"                                          DATABASEUID="toronto1"
INSTALLMYSQL="yes"                                              INSTALLMYSQL="yes"
BOBJEDIR="/home/BOXI/bobje/"                                    BOBJEDIR="/home/BOXI/bobje/"
BOBJEINSTALLLOCAL="system"                                      BOBJEINSTALLLOCAL="system"
SERVICENAME="BOE120"                                            SERVICENAME="BOE120"
CMSPORTNUMBER="6400"                                            CMSPORTNUMBER="6400"
CLUSTERPORTNUMBER="6400"                                        CLUSTERPORTNUMBER="6400"
SERVICEPORT="3306"                                              SERVICEPORT="3306"
SERVICEPORT_AUDIT="3306"                                        SERVICEPORT_AUDIT="3306"
MYSQLHOSTNAME_AUDIT="127.0.0.1"                                 MYSQLHOSTNAME_AUDIT="127.0.0.1"
SIAIILAUNCH='"/home/BOXI/bobje/enterprise120/generic/bobjrest | SIALAUNCH='"/home/BOXI/bobje/enterprise120/generic/bobjrestar

</pre>

Edited by: jemstar on Jun 25, 2009 12:42 PM