<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