Product:
Cognos Analytics 11.1.x
Microsoft Windows 2019 Server

Problem:
How add links to webpage with instructions for the users?

Linking a website URL to my Cognos Analytics 11.0.4+ Welcome Page

Solution:
You can add a extra menu with links to your (HTML, PDF) pages.

On the CA11 server go to the folder C:\Program Files\ibm\cognos\analytics\samples\extensions

Create a new empty folder, called c:\extra.

 

Copy the SampleExtensionMenuUrlLinks.zip file to the c:\extra folder.

Unzip the file SampleExtensionMenuUrlLinks.zip.

Go into the new folder SampleExtensionMenuUrlLinks and open the file spec.json in notepad++

In this example there are two menu items you can edit to use for your needs.
Edit the “label”: “IBM website”, and “options”: {“url”: “http://www.ibm.com”} lines.

You need to have a document to share with the users, we copy a pdf file to a new folder c:\doc

on a server where you have IIS installed, so you can in inside IIS manager share this files.

Start IIS manager and go to your default site.

Mark the Default Web Site and right click and select Add Virtual Directory

Enter a alias as Doc and change the physical path to your folder c:\doc. Click OK when done.
Now you can place any files in this folder (like HTML or PDF) that you later can share in Cognos portal by updating the json file.

In our example we change the second label to Instructions and the second options to “http://windatacenter/doc/Instructions_cognos.pdf” – you need to change that line to use your windows server name (not my windatacenter) and the pdf file name to your pdf file name. Do not use a space in the file name. Save the spec.json file.

Go up to extra folder, and use 7zip to create a zip file again.

All files in the folder should be compressed to a zip file. You can give the zip file a new name if you like.

Now you need to update CA11 with this extension that will change the looks of Cognos Connection.

Login as administrator, click on manage and customization.

Click on tab Extensions, and click on the upload icon.

Select your newly created zip file and click open.

The extension is loaded into the Cognos store. You need to logout and in again to see the effect.

You get a new LINKS menu with two options, we have only changed the second one to Instructions. If you click on that the PDF should open.

You may get above message in Internet Explorer and need to click Open to open the pdf in a reader.

If you have issues, please try with chrome first – go to you Cognos Analytics web site.

Click on links.

Click on Instructions.

The pdf should open in chrome browser.
Any files placed in your c:\doc folder is accessible for any user that can browse to your IIS server.
You provide the direct links in Cognos to make it easier for the users to find a specific file.

More Information:

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ag_manage.doc/t_ag_manage_cust_home.html

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_mng_cust_cr_home.html

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_ag_cust_extensions.html#cust_sample_extensions

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_mng_cust_manage.html

You can in Microsoft Word export a word doc to a HTML file, select export from file menu, and select change file type to “Single File Web Page” and click save as.

Select a easy name and select html or mhtml.

Copy the file to your web server (IIS) and then update the first link in the json file.

So it should be like this “options”: {“url”: “http://windatacenter/doc/cognos.mht”}

instead of “options”: {“url”: “http://www.ibm.com”}

Save the file, and do the zip and upload steps again. Logout and in to CA11 again, to see the new link.

Product:
Cognos Analytics 11.1.x
Microsoft Windows server 2019

Problem:
How alert Cognos users about a important change?

Solution:
Add a banner that show when the user login to Cognos Connection portal.

Log in to Cognos Analytics as a administrator and click on Manage.

Click on Configuration.

Click on System.

Scroll down to Advance Settings, and fill in values for Custom settings.
Add Key: Glass.enableBanner and as Value, true. Click Apply button.

Repeat for your message text.
Add Key: Glass.bannerMessage and as Value, Your Message!!. Click Apply button.

Log out and in to Cognos Analytics to see the result.

You can click the X on the right to remove the message for this session.

More information:
https://www.atlanticcognosanalytics.com/post/what-s-new-in-cognos-11-1-4-new-welcome-screen
https://www.ibm.com/support/pages/apar/PH18436

Creating and Setting a Default Welcome Page for Cognos Analytics 11.0.4+

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ag_manage.doc/c_ag_cust_extensions.html#cust_sample_extensions

Product:
Cognos Analytics 11.1.5 Jupyter notebook
Linux Red Hat Server 7.7

Problem:
During setup of SSL(TLS) support on the jupyter notebook, we can not run the build script.

Error message:
chmod: cannot access ‘/srv/proxy.key’: No such file or directory

Solution:
On the linux jupyter server. Connect to it with PUTTY or WinSCP.
Open the Dockerfile_hub file (it is in the folder where you unpacked the jupyter files e.g. /ibm/jupyter/dist/scripts)
check that after first “USER root” command there is this command line;
 COPY build-tmp/hub  /srv
if it is not, add it and remark out the same command line later in the file.

Save the file.
Then go to the /ibm/jupyter/dist/scripts/unix folder
Run ./build.sh

if there is no errors
Run ./startup.sh

Then continue with the setup of SSL for jupyter notebook.

More Information on how setup HTTPS for jupyter notebook:
https://www.ibm.com/support/pages/node/6116296
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/c_inst_jupyter.html

https://www.ibm.com/support/pages/jupyter-notebooks-1115-does-not-work-when-proxykey-has-insufficient-permissions

Product:
Cognos Analytics 11.1.5 framework manager
Product_version=11.1 R5
Microsoft Windows 2016 server

Problem:
When saving FM cognos configuration changes, you get a error.

Error message:
BMT-MD-0003 CST-AOM-0016 A SAX error with the message ‘Invalid document structure’ occurred while processing the request.

Solution:
Check the values Dispatcher URI for External Applications in Framework Manager configuration (<fm_home>/bin/cogconfigw.exe)
Under Environment locate setting Dispatcher URI for External Applications
check it to be in format: http://dispatcher.server.sample:9300/p2pd/servlet/dispatch

The value for http://dispatcher.server.sample:9300//p2pd/servlet/dispatch have a extra slash, change to http://dispatcher.server.sample:9300/p2pd/servlet/dispatch
and the save should work.

Product:
Cognos Analytics 11.1.5 framework manager
Product_version=11.1 R5
Microsoft Windows 2016 server
Problem:
When inside Framework Manager you select language, to create a new FM project, you get a error.
This after a install of FM to a new server, and try to connect to a BI server that was upgraded from CA 11.0.12 to CA 11.1.5 by an in-place upgrade.

Error message:
BMT-MD-0003 CCL-BIT-0005 A socket reported a communication error.
CAM_Connect=0xfffffff4 -12CAM-CRP-0026 The underlying socket: ‘xx.xx.xx.xx:9300’ returned an error.10056Could not connect the socket, errno: 0x2748(10056)

error in file cognosserver.log
[ ERROR ] CAM-CRP-1193 An error occurred while attempting to contact the active Content Manager to update the local CA information. Check your configuration to ensure that the configured URIs are valid and that there are services running at those locations. Reason: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
or in C:\Program Files\ibm\cognos\analytics\logs\p2pd_messages.log
[5/7/20 12:44:52:435 CEST] 0000029d com.ibm.ws.channel.ssl.internal.SSLHandshakeErrorTracker E CWWKO0801E: Unable to initialize SSL connection. Unauthorized access was denied or security settings have expired. Exception is javax.net.ssl.SSLHandshakeException: no cipher suites in common

Solution:
Go into the Cognos Configuration on the CA11 server and in the Framework Manager Configuration on the client computer.
Compare the listed of supported ciphersuites.

If the FM configuration is missing the setup on the CA11 server, add the missing chiper sets.
Save and try again.
In most cases you must have the same list on both FM configuration and the CA11 server cognos configuration.
Change the FM configuration to be exact as the CA11 server.
Save and try again.

Above the default setting for FM 11.1.5 version.

Above the default setting for CA 11.0.13 FP1.

More information:

https://www.ibm.com/support/pages/support-256-bit-cipher-suites-cognos-configuration

Product:
Cognos Analytics 11.1.5 framework manager
Product_version=11.1 R5
Microsoft Windows 2016 server

Problem:
When using the Framework Manager you get a error, when you try to use a oracle database connection. A planning analytics data source is working fine.
When testing the oracle data source in cognos connection it is working fine for both CQM and DQM.

Error message:
BMT-IMP-0002 Failed to execute metadata request. DPR-ERR-2079 Firewall Security Rejection. Your request was rejected by the security firewall.

Solution:

Update Framework Manager configuration
Under Environment locate setting Dispatcher URI for External Applications
and update it to be in format:
http://dispatcher.server.sample:9300/p2pd/servlet/dispatch
change it from the old value of
http://dispatcher.server.sample:9300/bi/v1/disp

More information:
https://www.ibm.com/support/pages/framework-manager-bmt-imp-0002-failed-execute-metadata-request-dpr-err-2079-firewall-security-rejection-your-request-was-rejected-security-firewall

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/c_reviewthedefaultsettings.html

Default port settings for Cognos Analytics components

The following table lists the default ports and URI settings for IBM Cognos Analytics.

Table 1. Default port settings for Cognos Analytics components
Setting Default Value Description
Content Manager URI http://localhost:9300/p2pd/servlet The URI to Content Manager.
Gateway URI http://computer_name:port/bi/v1/disp The URI to the gateway.
Dispatcher URI

(Internal, External)

http://localhost:9300/p2pd/servlet/dispatch The URI to the dispatcher.
Dispatcher URI for external applications http://localhost:9300/bi/v1/disp The URI to the dispatcher.

Product:
Cognos Analytics 11.1.5
Microsoft Windows 2016 server
Linux red hat 7.7 or other flavor

Problem:
How install cognos jupyter notebook on linux?

Solution:
Download the file from IBM;
IBM Cognos Analytics for Jupyter Notebook 11.1.5 Linux x86-64 Multilingual CC4QEML
https://www.ibm.com/support/pages/downloading-ibm-cognos-analytics-11150

Install instructions:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_inst_jupyter.html
Check what linux version jupyter notebook is supported on.

Help for linux commands:
https://ss64.com/bash/

Login to your linux server with putty:
https://www.ssh.com/ssh/putty/windows

Change to root user
sudo su

Check free disk space on server with
df -h

Ensure you have 200 GB free for you IBM folder and 200 Gb free for you folder where you store the docker containers.

Install docker:
 sudo yum install -y docker
sudo systemctl enable docker.service
sudo systemctl start docker.service

Create the docker user:
groupadd docker
useradd -G docker dockeruser

Create the folders we need:
mkdir -p /ibm/jupyter
mkdir -p /ibm/install

Copy the media with WINSCP to linux box folder /ibm/install
https://www.doteasy.com/web-hosting-getting-started/uploading-your-web-files-using-winscp-windows

Create a text file in Notepad++ with below content:


#
# Replay feature output
# ———————
# This file was built by the Replay feature of InstallAnywhere.
# It contains variables that were set by Panels, Consoles or Custom Code.

#false
#—–
BISRVR_CA_INSTALL=0

#true
#—-
BISRVR_CA_TOOLS_INSTALL=1

#false
#—–
CA_FM=0
CA_LCM=0
CA_DCUBEMODEL=0
CA_DQA=0

#true
#—-
CA_JUPYTER=1

USER_INSTALL_DIR=/ibm/jupyter


Save the file as responsefile.properties in folder /ibm/install

Change the rights on the file, so dockeruser can access it
chown dockeruser:docker responsefile.properties

Run the unattended install:
Make dockeruser able to run docker commands
 chmod 666 /var/run/docker.sock

Change to dockeruser
sudo su dockeruser

Go to the /ibm/install folder
 cd /íbm/install

Enter this command
 ./ca_instl_lnxi38664_2.0.191205.bin -DREPO=/ibm/install/ca_jupyter_lnxi38664_11.1.5.zip -f responsefile.properties -i silent

Check the log file for errors – in folder /ibm/jupyter/uninstall/logs

Install jupyter:

Go to folder /ibm/jupyter/dist/scripts/unix

Enter ./install.sh to run the installation

When finish, test the notebook, from IE browse to it at http://linuxservername:8000

If above show, then you are a success, go then to Cognos Analytics.

 

If you get a error during install like;

Error step 3/12 : Copy –chown=ca_user:users pip.conf $HOME/.config/pip/ .
Unknown flag: chown

Above error is solved by replace the file “Dockerfile_server_instance” with this content:


# IBM Cognos Products: Notebook

FROM ca_jupyter_server_instance_original:installed

USER ca_user

WORKDIR $HOME

# copy additional_packages & install if not empty

# COPY –chown=ca_user:users pip.conf $HOME/.config/pip/.

# COPY –chown=ca_user:users additional_packages.txt .

# Change below

COPY additional_packages.txt  .

USER root

RUN chown ca_user:users additional_packages.txt

USER ca_user

WORKDIR $HOME

COPY pip.conf $HOME/.config/pip/.

USER root

RUN chown -R ca_user:users $HOME

USER ca_user

WORKDIR $HOME

# Stop change

RUN if [ -s additional_packages.txt ]; then \

pip install –user -r additional_packages.txt; \

fi \

&& rm additional_packages.txt

# install certificates for trusted external servers as root

USER root

WORKDIR /tmp

COPY build-tmp certificates

RUN if [ `ls -1 /tmp/certificates/*.crt 2>/dev/null | wc -l` -ne 0 ]; then \

cp /tmp/certificates/*.crt /usr/local/share/ca-certificates/; \

chmod 754 /usr/local/share/ca-certificates/*.crt; \

update-ca-certificates; \

fi \

&& rm -rf certificates

# switch to notebook user

USER ca_user

WORKDIR $HOME


Save the file as Dockerfile_server_instance2
Copy the file over to  /ibm/install/ folder on the linux server
Rename the Dockerfile_server_instance to Dockerfile_server_instance_org
Rename the Dockerfile_server_instance2 to Dockerfile_server_instance

Change access to the file
chmod 755  Dockerfile_server_instance

Run the install again from the unix folder
./install.sh

 

https://pypi.org/project/pixiedust/#files

If you get a error like Could not fetch URL https://pypi.org/simple/pixiedust/: There was a problem confirming the ssl certificate HTTPSConnectionPool (host=’pypi.org’, port=443): Max retries exceeded with url: /simple/pixiedust….

Then the Linux box have not access to internet, and can not download the software. Solve by temporary allow the Linux box Internet access during installation.

You can also try to do this steps:

Open IE on your laptop and paste this line, to download the tar file.

https://files.pythonhosted.org/packages/16/ba/7488f06b48238205562f9d63aaae2303c060c5dfd63b1ddd3bd9d4656eb1/pixiedust-1.1.18.tar.gz

Copy the pixiedust-1.1.18.tar.gz file over to /ibm/install folder on linux server with WINSCP program.

Change the user access
chown dockeruser:dockeruser pixiedust-1.1.18.tar.gz

Extract the file with command
  tar -xvf pixiedust-1.1.18.tar.gz

Change the owner of all files in folder with command
chown dockeruser:docker pixiedust-1.1.18

Go to folder /ibm//jupyter/dist/scripts

Edit the file additional_packages.txt

nano additional_packages.txt

Comment out all the lines and then add the following line:

–no-index –find-links=/ibm/install/pixiedust-1.1.18  pixiedust

Save the file and exit nano program

Go to the folder unix and run the install again;

cd /ibm/jupyter/dist/scripts/unix

 ./install.sh

Change on IIS server:

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_gateway_iis.html

  • If you want to integrate Cognos Analytics for Jupyter Notebook Server, you must add a rule to map WebSocket requests from IBM Cognos Analytics notebooks to the back end Jupyter Notebook Server.

For more information, see Installing IBM Cognos Analytics for Jupyter Notebook Server.

Important You must also install WebSocket Protocol support in IIS. For more information, see WebSocket <webSocket> (https://docs.microsoft.com/en-us/iis/configuration/system.webserver/web socket).

  1. Select the ibmcognos alias. Click on URL rewrite icon.
  2. Click Add Rules > Inbound Rules > Blank Rule .
    • If proxies are not already enabled, you are prompted to enable. Click OK.
    • The server name and port are defined in the config.conf file when you configure Jupyter Notebook Server.
    • Select the newly created rule and click Edit.
    • Pattern is v1/jupyter/(user/[^/]*)/(api/kernels/[^/]+/channels)
    • Action type is Rewrite.
    • Rewrite URL (for SSL configurations) is https://jupyter_host_name:jupyter_host_port/bi/v1/jupyter/{R:1}/{R:2}

Note For non-SSL configurations use the following rewrite URL: http://jupyter_host_name:jupyter_host_port/bi/v1/jupyter/{R:1}/{R:2}

    • Check Append query string.
    • Check Stop processing of subsequent rules.
    • Click Apply and Back to Rules.
  • exit iis manager.

If above step is missed you get above error.

Enable jupyter notebook in CA11

Login to CA11 as administrator


Go to Manage
Click on configuration
Click on system
Click on environment
At Jupyter service location enter linux server name as

 http://linuxservername.domain.com:8000

Click Apply
Refresh the web page in the web browser (IE)
Click on new
Click on notebook

Enter import pixiedust to test

Import Samples to Cognos Analytics versions 11.1.5

  1. Copy the deployment archive, IBM_Cognos_Notebook_Samples.zip, for the notebook samples into the deployment folder: cognos_analytics_server_install_location\deployment.
  2. Go to Manage > Administration console and open IBM Cognos Administration.
  3. On the Configuration tab, click Content Administration.
  4. On the toolbar, click the New Import icon New import icon.
  5. Select IBM_Cognos_Notebook_Samples in the first step of the New Import wizard.
  6. At the Run with options screen, ensure that Do not Assign new IDs during import is selected. Click Run and complete process using default settings.
  7. After the import is complete, you can navigate to the notebook samples by clicking Team content > Samples > By feature > Notebooks.

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ig_smples.doc/c_jup_not_samples.html

https://www.ibm.com/support/pages/node/1125165 

The docker images are normally in folder /var/lib/docker/overlay2 folder

https://www.freecodecamp.org/news/where-are-docker-images-stored-docker-container-paths-explained/

More Information:

https://www.edx.org/course/fundamentals-of-red-hat-enterprise-linux

https://www.redhat.com/en/services/training/rh024-red-hat-linux-technical-overview

The folder dist/scripts/unix contains all the scripts that you need to run.

Script Purpose
build.sh Run this to rebuild the images, after you change config.
config.conf Edit this configuration file to change Jupyter parameters.
install.sh Run this to load and start the Docker containers.
prune.sh Run this to remove old Docker images.
start.sh Run this to start the Jupyter server.
stop.sh Run this to stop the Jupyter server.
uninstall.sh Run this to uninstall Jupyter server.

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_inst_jupyter.html

Product:
Cognos Analytics 11.1.5
Microsoft Windows 2012

Problem:
In a Cognos solution where you have a multi-server setup of Cognos Analytics, more than one Cognos BI server, you get strange errors in teams or story’s.

Solution:
In newer versions of CA11, can you test the Configuration Group to ensure it works.
Right click on Configuration Group inside Cognos Configuration and select Verify.

If the windows server with CA11 installed, have more than one network card, it is important to enter the network cards IP for that card that is used for communications between the CA11 servers.

Group contact host should be the IP to the Cognos Content Manager server that act as Configuration Group master.
Member coordination host should be the local windows servers IP number, that will be used for communications between the servers. This is often the same IP number that is used by client if they access the CA11 direct on port 9300.

Enter Ping ca11servername.domain.com from you client computer to find the possible address to use.

Product:
Cognos Analytics 11.1.4
Microsoft Windows 2016 Server

Problem:
Cognos Analytics uses a lot of CPU on the server and creates a lot of DMP files that fills up the hard disk.
A restart of the windows server does not help, Cognos Java process start up and uses a lot of CPU.
Even though there are no users in the system.

Solution:
On the Windows server, set the IBM Cognos service to manual.
Stop the IBM Cognos Service.
(to be sure, reboot the windows server, to clean out any lost processes)
Clean out temp report files by renaming the \temp and \data folders.
Check in Cognos Configuration the location of the temp and data folders.
Change C:\Program Files\ibm\cognos\analytics\temp to C:\Program Files\ibm\cognos\analytics\temp_old
Do the same for the \data folder.
Create a new \temp and a new \data folder.
Start IBM Cognos service.
Check that Cognos Connection is working, and there are no unusual CPU activity.
If all is OK, change Cognos Service to automatic.
Remove the temp_old and data_old folders.

To prevent BIBUS dump files to be created, change value in the file /configuration/cclWinSEHConfig.xml to

<configuration>

            <env_var name=CCL_HWE_ABORT value=0:0/>

</configuration>

To remove dump files from the Query process, you need in Cognos Configuration go to Administration tab.

Click on system – click on the dispatcher listed – select QueryServices – right-click and select Set properties.

Go to “Additional JVM arguments for the query service (Requires QueryService restart)” on last page.
Enter value:  -Xdump:heap+system:none
Press OK.

Exit Cognos Connection Administration.

More Information:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.cbi.doc/manuals.html

https://www.ibm.com/support/knowledgecenter/en/SSYKE2_7.0.0/com.ibm.java.aix.70.doc/diag/tools/dumpagents_removing.html