Product:
Cognos Analytics 11.1.7
Microsoft Windows 2019 server

Problem:
How do i change CA11 WLP to use balanced in java?

Suggested solution:

The log file cbs_run_WebSphereLiberty.log say “CBSBootstrapService attempt to load config from “C:\Program Files\ibm\cognos\analytics\bin64/bootstrap_wlp_winx64.xml”
This should mean that the WLP is controlled from the file bootstrap_wlp_winx64.xml. Open file in Notepad++
Change line 37 to;

param condName=”${java_vendor}” condValue=”IBM”>-Xgcpolicy:balanced</param>

save the file and restart the server, will give that WLP use garbage collection Balanced instead of default gencon. Then this will not help you, if you not have a big solution that maybe need it.

WLP settings for Planning Analytics is on the other hand stored in file C:\Program Files\ibm\cognos\tm1_64\bin64\bootstrap_wlp_tm1_winx64.xml

Normally you add the line -Xgcpolicy:balanced to the file C:\Program Files\ibm\cognos\tm1_64\wlp\usr\servers\tm1\jvm.options instead, of doing above.

Edit C:\Program Files\ibm\cognos\analytics\wlp\usr\servers\cognosserver\jvm.options to have the line -Xgcpolicy:balanced  will not work with CA11. You may need to something more….

More information:
https://www.ibm.com/support/pages/how-enable-garbage-collection-gc-logging-tm1-application-server

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

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

https://www.ibm.com/support/knowledgecenter/SSYKE2_8.0.0/com.ibm.java.vm.80.doc/docs/mm_gc_generational.html

Product:
Cognos Analytics 11.1.7
Microsoft Windows 2016 server

Problem:
After upgrade of Cognos and the IIS gateway settings the large dashboard with many columns does not work. If you use less columns the dashboard work. Error like this:

We can’t retrieve the data from data set….

Solution:
Inside IIS Manager on your Microsoft Windows server, check the values for Maximum URL length.
Go to your ibmcognos\bi folder and click on “request filtering”.

Click on edit feature settings on the right side.
Update to 8192 or 16000. (adjust other values as needed)
Click OK (the values are saved in C:\Program Files\ibm\cognos\analytics\webcontent\bi\web.config)
Restart the IIS service and test again.

The CA_IIS_Config.bat file should set this values in your windows server:

More Information:
https://www.cognoise.com/index.php?topic=34991.0

https://www.ibm.com/support/pages/we-cant-retrieve-data-data-set

Product:
Cognos Analytics 11.1.7
Microsoft Windows 2016 server

Problem:
On a installation where you use SSL only to the IIS gateway, and not to the Cognos dispatchers.
When try to login to Cognos Analytics HTTPS portal you get a error similar to this;
HTTPS Error 404.0 – Not Found…
Requested URL  https://cognosserver.domain.com:443/bi/
Physical Path  c:\inetpub\wwwroot\bi\

Solution:
Run the CA_IIS_Config script with HTTP instead of HTTPS, so you change the Reverse Proxy Inbound Rule to have Rewrite URL http://ca_servers/bi/{R:0} instead of HTTPS.
Add the certificate server name to the IIS manager – Default web site – bindings. Edit the settings for HTTPS port 443, so you have a host name in the host name field.

After any change to IIS, restart it from a DOS prompt with command: iisreset

From your web browser test that you can browse to the Gateway URL;
https://caservername.domain.com:443/ibmcognos/bi/v1/disp

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

https://www.ibm.com/support/pages/cleaning-temporary-java-workarea-cognos-analytics

https://www.ibm.com/support/pages/how-properly-clear-microsofts-internet-information-service-iis-configurations-setup-new-configuration-iis-support-ibm-cognos
https://www.ibm.com/support/pages/troubleshoot-ssl-gateway-iis

Product:
Cognos Analytics 11.1.7
Microsoft Windows 2016 Server

Problem:
After upgrade to CA 11.1.7 in a Multi server solution the event studio events are not running all the time, and also you get other errors in cogserver.log file.

Error:
CNC-ASV-0048 Error building report template: {0} CNC-ASV-0048 Error building report template: PRS-REQ-0760 The operation “/” “” “xts.run” is invalid.

javax.net.ssl.SSLPeerUnverifiedException: Certificate for <servername> doesn’t match any of the subject alternative names:…

CNC-SDS-0222 An error occurred while trying to send a message in message manager

Suggested Solution:

Upgrade your installation to the latest Fix Pack of CA11.1.7
https://www.ibm.com/support/pages/ibm-cognos-analytics-11x-fix-lists

If you restart the IBM Cognos windows service by some script, change the script to instead use the Cognos Configuration program to do the restart. Create a CMD file with this content:

REM https://ss64.com/nt/call.html

call “C:\Program Files\ibm\cognos\analytics\bin64\cogconfig.bat” -stop

PING -n 31 127.0.0.1>nul

call “C:\Program Files\ibm\cognos\analytics\bin64\cogconfig.bat” -s

Name the file c:\scripts\birestart.cmd and put your schedule software to use that, instead of the NET STOP command, as stopping Cognos BI from windows may corrupt some temp files.

CA 11.1.7 demands that all server names are in FQDN format.
Stop the Cognos BI service on Windows from Cognos Configuration.
Update all the server name in Cognos Configuration to be FQDN and lowercase. Also ensure the Server Common Name, under Security – Cryptography -Cognos, is the FQDN server name.

Environment
Gateway URI
External dispatcher URI
Internal dispatcher URI
Dispatcher URI for external applications
Content Manager URIs
Environment > Configuration Group
Group contact host
Member coordination host
Security > Cryptography > Cognos
Server common name
Subject Alternative Name > DNS names
Subject Alternative Name > IP addresses
Note: You must at DNS names enter both the FQDN and HOSTNAME to make the logging to work.
Check that the windows firewall does not block the port used by cognos – particular ports 9300, 9362, 4300, 5701, 9301. They need to be open between Cognos servers.

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

Before start of the Cognos from Cognos Configuration, clean out some folders to ensure there are no old settings around.
Backup and then remove the analytics/configuration/data/flipper folder
Backup and then remove the analytics/configuration/data/discovery folder
Backup and then remove the analytics/wlp/usr/servers/cognosserver/workarea folder
Backup and then remove the analytics/wlp/usr/servers/dataset-service/workarea folder
Backup and then remove the analytics/javasharedresources folder
Backup and then remove the analytics/temp folder
Backup and then remove the analytics/logs folder
Backup and then remove the analytics/data folder

You can check the setup of Configuration Group by browse in IE to the server first on
http://paservername.domain.com:9300/bi/v1/disp
and login, then change the URL in IE, and browse to http://paservername.domain.com:9300/bi/v1/flipper/diag
This json file can be saved.

If you have old reports that fails, please try to upgrade the reports to the latest version.

  1. Open IBM Cognos Administration.
  2. On the Configuration tab, click Content Administration.
  3. Click the arrow on the new content maintenance button New content maintenance on the toolbar, and then click New Report Upgrade
  4. Type a name for the upgrade task and, if you want, a description and screen tip. Click Next.
  5. Select the packages and locations for the report specification you want to upgrade. Click Next.

    If you upgrade report specifications by folder, all reports in the folder will be upgraded.

  6. Choose one of the following:
    • Save and run once opens the run with options page.
    • Save and schedule opens the scheduling tool.
    • Save only allows you to save the upgrade so that you can run it at a later time.

    Give time to upgrade all reports and all templates in your Cognos solution. To upgrade users my folders, select Directory – My Folder of AD (your namespace).

If schedule or events are not working, try dropping the NC* tables with this script:

1. Stop the Cognos Service
2. Take a physical backup of the Content Store or Notification database
3. Select the appropriate folder for your content store or notification database type ,like C:\Program Files\ibm\cognos\analytics\configuration\schemas\delivery\sqlserver for SQL.
4. Run NC_DROP_MS.sql against the content store or notification database in Microsoft SQL Management Studio.
4. Restart Cognos Services.

Should dropping the NC* tables not resolve the issue, then restore the content or notification store from the last backup version.

CA 11.1.x have made changes to the IIS setup for URL rewrite, manually change IIS settings to the new values or use the script in folder: C:\Program Files\ibm\cognos\analytics\cgi-bin\templates\IIS
https://www.ibm.com/support/pages/automate-configuration-microsofts-internet-information-service-support-ibm-cognos-analytics

Check the rules under ibmcognos and bi folder in IIS manager. Compare yours to the latest webpage https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_gateway_iis.html

  • Name is Event Studio.
  • Pattern is ^(ags|cr1|prompting|ccl|common|skins|ps|cps4)/(.*)
  • Open the Conditions section.
  • Change the Logical Grouping to Match Any
  • Click Add.
    • Condition input is {HTTP_REFERER}
    • Check if input string is Matches the Pattern
    • Pattern is v1/disp
    • Check Ignore case.
  • Click Add
    • Condition input is {HTTP_REFERER}
    • Check if input string is Matches the Pattern
    • Pattern is (ags|cr1|prompting|ccl|common|skins|ps|cps4)/(.*)\.css
    • Check Ignore case.
  • Action type is Rewrite
  • Rewrite URL is /ibmcognos/{R:0}
  • Check Stop processing of subsequent rules.
  • Click Apply and Back to Rules.

In IIS Manager on the Application Pool for Cognos (ICApool) change to 10 for Maximum Worker Processes, if you have many users in Cognos.

 

If nothing helps – contact Cognos Support.

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

https://www.ibm.com/support/pages/cognos-analytics-1117-interim-fix-2

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_new.doc/ca_new.pdf

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

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

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

https://ss64.com/nt/call.html

https://www.computerhope.com/call.htm
https://www.ibm.com/support/pages/troubleshoot-ssl-gateway-iis

Product:
Cognos Analytics 11.1.7
Microsoft Windows 2016 server

Problem:
There are 3 jave.exe on the Cognos Analytics server, what are they for?

Solution:
Java.exe (with most memory usage is Query Service, if you use Dynamic Cubes) command line c:\program files\ibm\cognos\analytics\ibm-jre\jre\bin\java.exe
Java.exe (with command line ..\ibm-jre\jre/bin/java.exe is the Content Manager and WLP service for the cognos portal) it have -Xgcpolicy:gencon
Java.exe (with least memory usage is the exploration engine in CA11) command line c:\program files\ibm\cognos\analytics\ibm-jre\jre\bin\java.exe” -Xms1024m -Xmx8192m -XX:MaxDirectMemorySize=512m

The 3 java.exe process for exploration in CA11 is part of the query service and is configured with advanced parameters in cognos connection;
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_ca_query_coprocessing.html

  1. From Manage > Administration console, open Cognos Administration.
  2. On the Configuration tab, click Dispatchers and Services, and click your dispatcher name.
  3. In the list of services, locate the Query service, and click its properties icon Set properties.
  4. On the Settings tab, under Category, select Environment.
  5. Next to Advanced settings, click Edit.
  6. Select the Override the settings acquired from the parent entry check box.
  7. Type or copy the parameter names and their values, from the Cognos documentation.
  8. Click OK.
  9. Restart the Query service.

The Java.exe for Query Service memory usage is also controlled from cognos connection.

JVM heap size limit for the query service: Specifies the maximum size, in MB, of the JVM heap.

JVM garbage collection policy: Specifies the garbage collection policy used by the JVM.

Go to Cognos Administration page, and click on System in the left.
Click the arrow at All servers and select Services – Query.
Now you only see the QueryService for each server. Click on arrow and select Set properties.
Change the Initial JVM heap size for the query service to a unique value like 2048, then after a restart it is easier to tell the jave.exe apart from each other.

The Java.exe for content manager and WLP is setup from inside Cognos Configuration.
If you have the RAM in the server, it can be increased to 24576 MB.  The start up time of Cognos will be longer, when the WLP use more memory.

  1. Start IBM Cognos Configuration.
  2. In the Explorer window, expand Environment > IBM Cognos services, and then click IBM Cognos.
  3. In the Properties window, change the value for Maximum memory in MB.
    • To reduce the startup time, memory footprint, and resources that are used, use the default setting of 8192.
    • This value can be adjusted based on available system resources.
  4. From the File menu, click Save.

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

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

https://www.cognoise.com/index.php?topic=36704.0

Product:
Cognos Analytics 11 CP4D
Linux

Problem:
How report on a DB2 database?

Suggested Solution:
Depending on what data source you are going to connect to – the way may be different.
https://www.ibm.com/support/producthub/icpdata/docs/content/SSQNUZ_current/cpd/access/data-sources.html

Login to Cloud pak for data to setup the data source (this is only for Cognos Content Store called BLUEDB).


Click on menu icon to get to the connections

Click on new connection

Enter a name for the connection and click on the drop down menu to select type of data source. When you select DB2, you get other fields to complete.

Enter the IP address of the database server host.
Enter the port for the DB2 database, default is 50000 – but this you need to change when you setup your DB2 server, to something else like 50500.
Enter the name of the database.
Enter the name of the user to access the database (can be DB2 default user db2inst1) and enter the password.
Scroll down and click on Test connection.

Click on Create.

You have now a data source in CP4D.

Click on menu and select My instances – to see what applications are running.

Click on the dots to open the menu on the right side of your application, and click on open to go to Cognos Analytics.

If security is setup correct, you should be logged in automatically.

To setup a data source for CA11, you can use the same as you done in CA11 on Windows. Described below;

Setup in Cognos Analytics 11

Click on Manage icon in lower left corner and select Data Server Connections

Click on + to create a new data connection, the dialog will expand to the right.

Select DB2 in this case

First enter the jdbc:db2://192.168.1.15:50500/SAMPLE2 to your database.
Scroll down and click close
Select Use the following signon

Click on ? to create a new signon, enter the user and password that will connect to the DB2 database.
Change the name for the connection to SAMPLE2.

Change the name of the connection and click save.

Click on Test and after success, click on schemas tab.

Click on dots to show the options, and click on Load metadata.

Wait for the metadata to load.

Click on new icon and select Data module.

Click on the data icon and select your data source from the list. New dialog opens automatic.

Click on the schema to work with and click OK.

Click on Discover related tables and click Next

Cognos Analytics will show in word diagram the most popular fields. Select 3 of them and click next.


Table relations is shown, click OK.

Click on save icon in top left corner.
Select to save as.

Click on my content or the folder where you want it to be saved.
Enter a name for the data module.
Click on save.

Click on new icon and exploration.

Select the folder, select the data module and click add.

Enter a table name or click on the boxes to select the data you want to find out about.

Select one of the charts on the right, if they fit your question.

When you are satisfied with your chart, click save icon to store the report in the folders inside Cognos Analytics.

More information:
https://www.youtube.com/watch?v=XkOkje0tXgI
https://www.youtube.com/watch?v=0NtellENB88
https://www.youtube.com/channel/UCS3gkkTTvLOc9HTUJSNeOxg
https://www.ibm.com/cloud/garage/dte/tutorial/ibm-cognos-analytics-1113-getting-started-exploration-0/
https://www.ibm.com/support/producthub/icpdata/docs/content/SSQNUZ_current/wsj/manage-data/conn-cognos.html

Product:
Cognos Analytics 11.1.6 Product_version=11.1 R6
Microsoft Windows 2016

Problem:
Error when start cognos from cognos configuration like this;
[Check NIST 131A conformance]
[ WARNING ] CAM-CRP-1632 The selected PDF Confidentiality algorithm is not permitted by the NIST SP 800-131A standard. You must change the selected algorithm to a stronger algorithm such as ‘AES-256’. Note that you may need to install the JRE’s unlimited jurisdiction policy files to enable all of the supported algorithms

Solution:


Open first Cognos Configuration and check that it says 128 at Cryptography > Cognos > field “PDF Confidentiality Algorithm – Advanced encryption standard with Cipher Block Chaining (CBC) mode 128 bit key”. Stop cognos service and close Cognos Configuration.
Backup the files in folder C:\Program Files\ibm\cognos\analytics\ibm-jre\jre\lib\security\ to c:\temp\security


Download the new policy zip file from https://public.dhe.ibm.com/ibmdl/export/pub/systems/cloud/runtimes/java/security/jce_policy/
Unzip the file in a new folder (c:\install), creating folder C:\install\unrestricted.


Copy the two new files (US_export_policy.jar and local_policy.jar)to folder C:\Program Files\ibm\cognos\analytics\ibm-jre\jre\lib\security\policy\unlimited


Open Cognos Configuration and go to Cryptography > Cognos. Change PDF Confidentiality Algorithm and Confidentiality Algorithm to Advanced encryption standard with Cipher Block Chaining (CBC) mode 256 bit key.

Right-click on supported ciphersuites and select “Reset to Default”.

Save the configuration and start the Cognos service.

 

More information:
https://www.ibm.com/support/pages/check-nist-131a-conformance-warning-while-starting-cognos-services

Product:
Cognos Analytics 11.1.3
Planning Analytics Tm1 Perspective

Problem:
After adding more namespaces in Cognos Analytics to be able to select from two domains (active directory) the user of TM1 Perspective get a blank drop down page in the CA11 login.
Only a few users are affected, user with different version of Microsoft Excel got it working.

Suggested Solution:
On the client computer or on the citrix server where TM1 Perspective Excel plug in is installed and used, take a backup of the users windows registry.

Enter REGEDIT in the START search field.
From inside REGEDIT expand HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\MAIN\FeatureControl and right click and select export;

Save the file, and repeat the backup for the other branches listed below.

Then apply this values in REGEDIT to solve the issue.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\MAIN\FeatureControl\FEATURE_BROWSER_EMULATION]
“Excel.exe”=dword:00002af8
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\InternetExplorer\MAIN\FeatureControl\FEATURE_BROWSER_EMULATION]
“Excel.exe”=dword:00002af8
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\MAIN\FeatureControl\FEATURE_USE_WINDOWEDSELECTCONTROL]
“Excel.exe”=dword:00000000
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\InternetExplorer\MAIN\FeatureControl\FEATURE_USE_WINDOWEDSELECTCONTROL]
“Excel.exe”=dword:00000000

More Information:
https://www.ibm.com/support/pages/namespace-drop-down-appears-blank-cognos-analyticscognos-bi-login-page-while-attempting-login-planning-analytics-cam-authenticated-server-perspectives
https://www.ibm.com/support/pages/custom-sign-view-could-not-be-found

Product:
Cognos Analytics 11.1.6
Microsoft Windows 2016 server

Problem:
How do I put the company name on the CA start page?

Solution:
Logon to your Cognos Analytics server and go to folder C:\Program Files\ibm\cognos\analytics\samples\themes. Unzip SampleTheme.zip in a new folder.

Open spec.json file in notepad++

Change the company name to your name and save the file.

You need to change the logo png files to your company logo with a picture software. Go to the images folder.

You must keep the size the same of the original png file.

The logo_large.png are 364 x 200 pixels.
The logo_small.png are 54 x 30 pixels.
Open your company png file in Windows Paint, and select change size. Enter the new format.

Save as large.png
Change the format again to small, and save that picture as small.png
Copy the two png files to your sample images folder.

Remove the old logo_large.png and logo_small.png files.
Rename your files to logo_large.png and logo_small.png respectively.

Rename the folder to your company name, in our example PAC.

Open spec.json again in notepad++

Change the name to your company name, in our example PAC.
Save the file.

Go to the folder above, e.g. samples.

Zip your new folder to a zip file.
Login to Cognos Analytics as a administrator.

Click on Manage and Customization.

Under Themes, click on upload team icon.
Find your new file and select it.

When it is loaded into Cognos Analytics select it and click apply.

You need to logout and in again to have the new team shown.

 

 

If you want to change more, like the background picture and text, you can do this https://quebit.com/askquebit/IBM/creating-and-setting-a-default-welcome-page-for-cognos-analytics-11-0-4/

Upload the Samples_for_Install deployment archive. (To ensure you have all demo reports)
Use Manage > Administration console to open IBM Cognos Administration.
On the Configuration tab, click Content Administration.
On the toolbar, click the New Import button.
Select Samples_for_Install in the first step of the New Import wizard and complete the remaining steps of the wizard.

Find the SampleWelcome.zip file in folder C:\Program Files\ibm\cognos\analytics\samples\extensions
Extract the zip file in a separate folder. Change the name of the folder to Welcome.

Open spec.json file in notepad++

Search and replace Sample_Welcome with Welcome.

Replace the titles to your company name.
Save the file.
Go into the image folder.

Change logo_large.png to your logo in format 374×200 pixels.
Change welcome_background.jpg to a picture of your office in size 1920×1280 pixels.
You can find free pictures at https://pixabay.com/
You can resize a picture at https://www8.lunapic.com/editor/
Go to the C:\Program Files\ibm\cognos\analytics\samples\extensions\Welcome\js\views folder and update the SampleWelcomeView HTML file with correct path.

You may remark or update the other text in HTML file for you company information.

On line 10 set <!–  …..  –> to remove the video link in the example file.

save the file.


Go up one folder, and zip the welcome folder to welcome.zip file.

Login to Cognos Analytics as administrator.
Click on Manage.
Click on Customization.
Click on Extensions.

Click the upload icon.
Find your zip file in C:\Program Files\ibm\cognos\analytics\samples\extensions folder.
Open it and see the extension load.

You need to change the home page to make it be visible.

Go to Manage-Customization-Views-home and select the new view PAC.
Click Apply.
Log out and in again.

The selection of Themes control the text in the top blue banner.
The selection of view, tell what extension will be used at the main canvas (perspective).

You can preview at http://servername.domain.com/ibmcognos/bi/?perspective=sampleWelcome

You can set that users that belong to a cognos group, will see a specific view.

Go to Manage – Accounts – Cognos – Analytics Explorers – Customization – Home page Default – PAC.
Click Apply.

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

http://queryvision.com/kb/supporting-portal-pages-portal-tabs-ibm-cognos-analytics-11-x/
https://www.ibm.com/support/pages/node/553135
https://www.ibm.com/support/pages/how-users-default-home-page-changed

https://quebit.com/askquebit/IBM/creating-and-setting-a-default-welcome-page-for-cognos-analytics-11-0-4/

Product:
Cognos Analytics 11.1.6
Microsoft Windows 2016

Problem:
How do i install CA 11 on Windows 2016?

Check here how to install CA11.1.x https://www.ibm.com/support/pages/how-install-cognos-analytics-111x

Here are the new features of 11.1.6 http://ibmblueview.com/cognos-analytics-11-1-6-whats-new/

Suggested Solution:
Download the software from IBM; ttps://www.ibm.com/support/pages/downloading-ibm-cognos-analytics-11160
Download from Passport Advantage.

Part Image Category
IBM Cognos Analytics Server 11.1.6 Microsoft Windows Multilingual CC5HYML Required
IBM Cognos Analytics Installer 2.0.200319 Microsoft Windows Multilingual CC5I5ML Required
IBM Cognos Analytics Client 11.1.6 Multiplatform Multilingual CC5I4ML Recommended
IBM Cognos Analytics for Jupyter Notebook 11.1.6 Linux x86-64 Multilingual CC5IHML Required
IBM Cognos Analytics for Jupyter Notebook 11.1.6 Microsoft Windows Multilingual CC5IIML Recommended
IBM Cognos for Microsoft Office 11.0 Microsoft Windows 32-bit Multilingual CNPX0ML Recommended
IBM Cognos for Microsoft Office 11.0 Microsoft Windows 64-bit Multilingual CNPX1ML Recommended
IBM Planning Analytics for Microsoft Excel 32-bit 2.0.47 Microsoft Windows Multilingual CC469ML Recommended
IBM Planning Analytics for Microsoft Excel 64-bit 2.0.47 Microsoft Windows Multilingual CC46AML Recommended
IBM Cognos Transformer 11.0.0.68 Microsoft Windows Multilingual CC3L6ML Recommended

Update the Microsoft Windows 2016 server to latest fix packs.

Download the latest fix pack for Cognos Analytics. You must install the fix pack.
https://www.ibm.com/support/pages/node/6207165

Set IE Enhanced Security Configuration to off, in Server Manager – Local server.

Set Data Execution Prevention (DEP) off (Turn on DEP for essential Windows programs and services only) and set Power Options to High Performance in Control panel.

For many cognos program, it may be needed to also install this on the server;

Install Microsoft Visual C++ 2010 SP1 Redistribution Package

http://www.microsoft.com/en-gb/download/details.aspx?id=13523

https://download.microsoft.com/download/1/6/5/165255E7-1014-4D0A-B094-B6A430A6BFFC/vcredist_x64.exe

Install SQL 2012 native client

https://download.microsoft.com/download/B/E/D/BED73AAC-3C8A-43F5-AF4F-EB4FEA6C8F3A/ENU/x64/sqlncli.msi

Install NET Framework 4.7.2

https://support.microsoft.com/sv-se/help/4054530/microsoft-net-framework-4-7-2-offline-installer-for-windows

Install IIS by in Server Manager go to Roles and Features and click on Add Roles and Features.

Select Web Server (IIS) and click OK

Select HTTP Activation and click Add Features.

Select HTTP Redirection and WebDav Publishing.

Select Windows Authentication and IIS Management Scripts and Tools.

Select WebSocket Protocol.

Copy the Cognos files to a file share that you can access from the windows server.

Start the installation by running the ca_instl_win_2.0.2003191.exe file.

Press next on most dialogs, on the dialog to choose a file click choose.

Select the casrv-11.1.6-2005071525-winx64h.zip file and click open and next.

Select IBM Cognos Analytics and click next.

Select “Make shortcut visible to all users in the start menu” and click next.

Select Custom and click next.

Select all and click next and click install.

The driver JAR file sqljdbc42.jar is the file you need for IBM® Cognos® Analytics. Download sqljdbc42.jar from https://download.microsoft.com/download/F/0/F/F0FF3F95-D42A-46AF-B0F9-8887987A2C4B/sqljdbc_4.2.8112.200_enu.exe

Copy file sqljdbc42.jar into folder c:\program files\ibm\cognos\analytics\drivers

Start Cognos Configuration as administrator, most localhost values should already be replaced with windows full servername. Ensure that all servernames are in lowercase minuscule.

Enter IP address to servers in configuration group if your servers have more than one network card.

Suggest you limit access to cognos analytics to people that are part of any of the cognos security groups. Inactivity timeout in seconds can be set to a higher value, like 28800, for cognos controller installations.

Create a namespace for you Active Directory connection.

If you want to setup LDAP follow this guides https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_ldapauthentication_process-element.html

Set the Namespace ID to the same as the namespace, and add the host and port to you DC.

 

Set Allow anonymous access to False.

Add the domain and any other cognos server names to the allowed CAF list.

Delete the DB2 content store and create a new Content Store for SQL server.

Enter the sql server name and port number and the other values.

If you use a lot of scheduled reports, you may benefit to have a separate notification database.

Setup mail connection http://cognospaul.com/2016/08/17/gmail-smtp/

Save and start the cognos service.

Test to login by surf to your server at http://caservername.domain.com:9300/bi/v1/disp

https://www.aramar.co.uk/blog/2020-april/cognos-analytics-11-1-6-packed-full-of-new-featu

On your IIS web windows server download and install the Application Request Routing.

https://www.iis.net/downloads/microsoft/application-request-routing

Install rewrite_amd64_en-US.msi and requestRouter_amd64.msi

Manual setup of IIS here https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_gateway_iis.html

Get the script to run for IIS from folder C:\Program Files\ibm\cognos\analytics\cgi-bin\templates\IIS

open the CA_IIS_Config.bat file in notepad++

Enter you Cognos Analytics server and your jupyter notebook servername and port. Set True to use SSO. Save the file and run CA_IIS_Config.bat from a elevated command prompt.

Press Y

Test to surf to http://servername.domain.com/ibmcognos

To create a easy SSO, add this parameters to Cognos Configuration, under Security – Authentication – AD – Namespace – Resource Properties – Advanced properties:
singleSignOnOption  =   IdentityMapping

Save and Restart the cognos service.  (Your CA IIS script need to enabled SSO first).

Open firewall ports 80 and 443 for clients, and ports 9300, 9362, 4300, 5701, 9301 for additional Cognos servers.

Setup webdav in IIS;
https://www-01.ibm.com/support/docview.wss?uid=swg22002398&aid=1

To stop old dump files, open the cclWinSEHConfig.xml file from the C:\Program Files\ibm\cognos\analytics\configuration folder. Set “CCL_HWE_ABORT” value=”0″

Import Audit report samples, and create a Audit database.
https://www.ibm.com/support/pages/how-configure-audit-reporting-cognos-analytics 
Set logging to Basic.

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

How setup SSL for Cognos:
https://www.ibm.com/support/pages/how-add-3rd-party-ca-allow-ssl-between-components-ibm-cognos-analytics-11

https://www.ibm.com/support/pages/configuring-ibm-cognos-analyticsbi-https-enabled-web-server

More Information:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/c_configuringcognos8.html

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