IBM Support

Cannot View Report Output and Missing Locale Settings in My Preferences

Troubleshooting


Problem

*** Note: This only applies to releases up to 11.0.3 ***
When trying to view saved report output in Cognos 11 in the View Versions pane, clicking on the timestamp to expand the report output versions does not do anything. The locale settings (timezone, language, etc) in My Preferences appears blank.

Cause

This is due to redundant Zookeeper processes in the environment. When performing a distributed install, if a "new installation" is selected for the additional installs instead of connecting to an existing server, this leads to multiple Zookeepers running independently across the environment.

Diagnosing The Problem

The browser's developer tools (eg IE F12 developer tools) console shows "Invalid character while parsing supportedContentLocales" when trying to view output versions.

Resolving The Problem

Only keep Zookeeper on the active cm, and remove other Zookeeper processes and have them point to CM Zookeeper.

Steps:

1) Start up content manager (no change), this keeps the zookeeper running 
2) Go to each one of the dispatcher and standby content manager to remove zoo keeper. Details as the following 
a) rename zoo.cfg to zoo.cfg.old 
b) go to cognos configuration's environment section, and click the pen. In popup windows, remove the entry, and then click retrieve. Provided username/password, and namespace id, it will retrieve a link pointing to the content manager. 

c) start the dispatcher. 

The above configuration does not support CM failover well, therefore additional steps are needed.

======================redundant zookeeper=========================
Assume there are 3 servers: CogServer1 (CM1), CogServer2 (CM2), CogServer3 (CM3 or APP).

1. Before configuring multiple zookeeper servers, make sure you've launched Cognos Configuration for each server and have all URLs configured properly, saved and started properly.

2. Next, stopped all 3 servers.

3. We assume these ports will be used on each server for zookeeper:

CogServer1: client port = 2181, server ports = 2888:3888
CogServer2: client port = 2281, server ports = 2788:3788
CogServer3: client port = 2381, server ports = 2688:3688

If those ports are not avaliable on the server, you may use different ones.

4. On CogServer1:

. go to <CogServer1_installroot>/configuration/data folder (create one if not exist yet), create (or update if already exist) a text file called "myid", and put only string "1" in the file.

. go to <CogServer1_installroot>/zookeeper/conf, open zoo.cfg file, and have the following entries in:

autopurge.purgeInterval=1
server.1=<CogServer1>:2888:3888
server.2=<CogServer2>:2788:3788
server.3=<CogServer3>:2688:3688
clientConnStrings=<CogServer1>:2181,<CogServer2>:2281,<CogServer3>:2381
initLimit=5
syncLimit=2
autopurge.snapRetainCount=3
snapCount=400
clientPort=2181
tickTime=2000
dataDir=<CogServer1_installroot>/configuration/data
preAllocSize=5000

. go to <CogServer1_installroot>/configuration folder, open file installData.properties, and have the following entries in there:

localZookeeper.clientPort=2181
localZookeeper.serverPorts=2888:3888
zkservers.count=0

5. On CogServer2:

. go to <CogServer2_installroot>/configuration/data folder (create one if not exist yet), create (or update if already exist) a text file called "myid", and put only string "2" in the file.

. go to <CogServer2_installroot>/zookeeper/conf, open zoo.cfg file, and have the following entries in:

autopurge.purgeInterval=1
server.1=<CogServer1>:2888:3888
server.2=<CogServer2>:2788:3788
server.3=<CogServer3>:2688:3688
clientConnStrings=<CogServer1>:2181,<CogServer2>:2281,<CogServer3>:2381
initLimit=5
syncLimit=2
autopurge.snapRetainCount=3
snapCount=400
clientPort=2281
tickTime=2000
dataDir=<CogServer2_installroot>/configuration/data
preAllocSize=5000

. go to <CogServer1_installroot>/configuration folder, open file installData.properties, and have the following entries in there:

localZookeeper.clientPort=2281
localZookeeper.serverPorts=2788:3788
zkservers.count=0

6. On CogServer3:

. go to <CogServer3_installroot>/configuration/data folder (create one if not exist yet), create (or update if already exist) a text file called "myid", and put only string "3" in the file.

. go to <CogServer3_installroot>/zookeeper/conf, open zoo.cfg file, and have the following entries in:

autopurge.purgeInterval=1
server.1=<CogServer1>:2888:3888
server.2=<CogServer2>:2788:3788
server.3=<CogServer3>:2688:3688
clientConnStrings=<CogServer1>:2181,<CogServer2>:2281,<CogServer3>:2381
initLimit=5
syncLimit=2
autopurge.snapRetainCount=3
snapCount=400
clientPort=2381
tickTime=2000
dataDir=<CogServer3_installroot>/configuration/data
preAllocSize=5000

. go to <CogServer1_installroot>/configuration folder, open file installData.properties, and have the following entries in there:

localZookeeper.clientPort=2381
localZookeeper.serverPorts=2688:3688
zkservers.count=0

7. Start the 3 servers in order. Please note you'll need to start the prime CM install first, then standby CM and APP installs.

Now you should have a cluster of zookeepers with 3 nodes in it. Stop one of the server will not impact the configuration. Stop 2 of them will make configuration not working.

Related Information

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.0.0, 11.0.1, 11.0.2, 11.0.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 October 2019

UID

swg21990447