Product:
Cognos Controller 11.0.1200.28

Microsoft Windows 2022 Server

Issue:

Most users get that the Cognos Controller client hang, when they open some selection dialogs. For example – go to Maintain – Account Structure Reports – select codes – and click on the … for the account field, to get a list of all the accounts.  Here the Cognos Controller client hang, and you have to stop cognos controller from the task manager.

Possible Solution:

Do a optimize on the database from inside cognos controller client.

1. To run the optimization immediately, the system must be in single user mode. Go to Maintain > User > Single Mode and set the system to single mode.
2. Click Maintain > Database > Optimize. The Optimize Database window opens.
3. Select the Rebuild Structure Tables check box to rebuild the structure tables.
4. Select Rebuild Indexes (advanced option).
5. Click Run

 

Other things you can try to solve the issue are:

Clear the cache in cognos controller

Inside Controller Client program, via Maintain > Special Utilities > Clear Local Cache.

 

Change the cache folder for cognos controller client:

Launch Windows Explorer
4. Open the folder where Controller is installed.

• Default this is here: C:\Program Files\ibm\IBM Cognos Controller Local Client

5. Open the file “CCR.exe.config” inside Notepad++
6. Search for the entry similar to the following:
<add key=”CacheDir” value=””/>
7. Modify this entry appropriately, for example similar to the following:
<add key=”CacheDir” value=”D:\Controller\Cache” />
8. Save and test

Start Cognos Controller client, and try to open the same account list.

 

There are 3 types of cache folder used by Cognos Controller Client:
(1) Microsoft Internet Explorer cache at C:\Documents and Settings\%USERNAME%\Local Settings\Temporary Internet Files
(2) Microsoft .NET components at C:\Documents and Settings\%username%\Local Settings\Application Data\assembly
(3) Controller user cache files: at C:\Documents and Settings\%appdata%\Application Data\Cognos\ccr\

If there is damage files in this folders, can give strange errors inside Cognos Controller Client program.

 

More information:

Optimize the Database – IBM Documentation

FAQ – What does an ‘internal’ database optimise do, and how often should I run a database optimize?

https://www.ibm.com/support/pages/how-modify-controller-use-different-location-its-temporary-cache-files 

https://www.ibm.com/support/pages/error-systemxml-root-element-missing-inside-multiple-menus-controller-caused-appdata-redirected-unc-path 

https://www.ibm.com/support/pages/explanation-why-cognos-controller-client-side-cache-file-folders-can-be-very-large-and-how-housekeep-them

https://www.ibm.com/support/pages/how-automatically-clear-local-cache-when-closing-controller

https://www.ibm.com/support/pages/controller-microsoft-sql-database-optimisation-and-maintenance-proven-practice-best-practice 

https://www.ibm.com/support/pages/massive-sql-transaction-logs-caused-rebuilding-sql-indexes

https://www.ibm.com/support/pages/reducing-size-controller-database-deleting-period-locking-company-records-table-xacclock

 

You can use Cognos Controller database optimize function to make the following database changes:

• Remove Period Zero Values – clears the value 0 from selected period tables.
• Rebuild Structure Tables – which gives quicker access to data.
• Rebuild Indexes (advanced option) – Rebuilds all indexes in the database to enhance performance and give quicker access to data.
• Analyze Schema (advanced option) – Reanalyzes the schema for Oracle database.

Product:
Cognos Controller 11.0.1200
Windows Server 2022

Issue:

When press the excel icon in Cognos Controller, excel starts but there is no controller toolbar inside.

Solution:

Check that you have two lines for cognos controller in options-add in.

if not, ensure that one is not disabled.

1. Launch Excel

2. Click “File – Options”

3. Click “Add-ins”:

4. Change “Manage” to “Disabled Items” and click ‘Go’:

5. Highlight the Controller add-in (“cognos controller link for Microsoft excel (adxloader.Controller.ExcelLink.dll)”), and click “Enable“:

6. Test.

If that not helps, try to add the add-in manually.

More information:

https://www.ibm.com/support/pages/missing-menu-item-controller-excel-excel-add-not-visible-active-caused-com-add-inside-disabled-items 

 

Product:
Cognos Controller 11.0.12
Microsoft Windows 1016 server

Issue:

Error message about missing files when doing a upgrade installation of Cognos Controller 11.

Failed to copy file “d:\cognos controller upgrade\cntrl_11.0.1_win_ml\winx64h\./resource/utf-8\is_en_rc.txt” to destination “d:\program files\ibm\cognos\ccr_64\uninstall\./resource/utf-8\is_en_rc.txt”: No such file or directory.

If you press skip, you get a new message for other missing file.

Solution:

Check the size of the cntrl_11.0.1_win_ml.tar.gz   file – if it is less than 2 326 187 KB, you have the wrong file. Download again from IBM.

Parts and platforms	Details	eImage
IBM Cognos Controller 11.0.1 Microsoft Windows Multilingual	Required	M0DH2ML

 

A zip file of the size 409 587 KB is wrong.

More information:

https://www.ibm.com/support/pages/downloading-ibm-cognos-controller-1101

https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=icclo-installing-configuring-cognos-controller-one-computer

To log a ticket with IBM support go to: https://www.ibm.com/mysupport/s/?language=en_US

IBM Documentation: https://www.ibm.com/docs/en/cognos-controller

Product:
Cognos Controller 11.0.12

Microsoft Windows 2022 server

Issue:

User get a error when they try to login to Cognos Controller after you have upgraded the software on the server.

Solution:

Ask the user to install the new Cognos Controller client that match the version you have installed on the windows server.

This is often done by central distribution system, like Software center.

INSTALLATION INFORMATION
IBM Cognos Controller Version 11.0.1200.28
Integration Version 11.0.1200.8
Install/Updater Kit Version 11.0.1200.36

 

More information:

https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=icclo-installing-configuring-cognos-controller-one-computer 

https://www.ibm.com/support/pages/troubleshooting-error-invalid-database-version-version-controller-requires-database-version-710-when-launching-controller 

https://www.ibm.com/support/pages/how-install-controller-local-client

 

Product:
Cognos Controller 11
Microsoft Windows 2022 server

Issue:

Error when you try to setup the Cognos Controller web, by running bat command to add the databases.

D:\Program Files\ibm\cognos\ccr_64\fcmweb>SyncDBConf.bat ..\data wlp\user\shared\config\datasources
Found 6 udl files in ..\data

FATAL ERROR: ‘java.io.FileNotFoundException: D:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\user\shared\config\datasources\datasources.xml (The system cannot find the path specified.)’
:D:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\user\shared\config\datasources\datasources.xml (The system cannot find the path specified.)
Datasources updated.

Solution:

Try to Find the config.js file in C:\Program Files\IBM\cognos\ccr_64\frontend folder
Open the file in a text editor and make the following changes:

/* IBM SOURCE CODE HEADER START

* =====================================================================

* IBM Confidential

*

* IBM Cognos Products: ccr

*

* © Copyright IBM Corp. 2023

*

* The source code for this program is not published or otherwise

* divested of its trade secrets, irrespective of that has been

* deposited with the U.S. Copyright Office.

* =====================================================================

* IBM SOURCE CODE HEADER END */

var fs = require('fs');




module.exports =

{

"proxies": [{

"urlPath": "fcm.web",  //root context for Controller Web backend

"enabled": true,      //forward requests through UI service




"options": {

"ws": true,




// details for Controller web backend connection

"target": {

"host": "controllerservername.domain.com",

"port": 3000,

"protocol": "http:" //set https: for SSL

},

"secure": true  //set this to false if Controller Web Backend is using Self Signed certificates

}

},

{

"urlPath": "ibmcognos",  //root context for Controller Server Backend

"enabled": true,      //forward requests through UI service




"options": {

"ws": true,




//details for Controller Server connection

"target": {

"host": "controllerservername.domain.com",

"port": 80,

"protocol": "http:" //set https: for SSL

},

"secure": true  //set this to false if Controller Server Backend is using Self Signed certificates

}

}],







//Details for Controller UI service 

"expressJs": {

"host": "controllerservername.domain.com", //interface used by Controller Web UI Service

"port": "9080",              //port used by Controller Web UI Service

"adminContext": "admin",

"enableAdminApp": true,

"enableRemoteExcel": false,

"enableClient": false,

"enableFap": true,

"enableFileSettings": true,

"enableIBMIDAuth": false,

"enableEncryption": false,

"allowedOrigin": '{allowedOrigin}',

"oidcProvider": 'IBMid', //IBMid or google or azure

"options": {




//Add ssl object with path to certificates file below for using HTTPS 

//Note: the protocol in proxies section must also be set to HTTPS

                /*

                "ssl": {

// certificates

"key": fs.readFileSync(__dirname+"/keyfile.key"),  //__dirname points to ccr_64\frontend

                    "cert": fs.readFileSync(__dirname+"/cert.crt"),

                    "passphrase":"changeit"

}

*/

},




//false to enable "real time updates" feature for all the users

//true to disable "real time updates" feature for all the users

"disableRealTimeUpdates": false

},

ibmIDConfig: {

"discoveryEndpoint": "{discoveryEndpoint}",

"client_id": "{client_id}",

"client_secret": "{client_secret}",

"redirect_uris": ["{basePath}/auth/sso/callback"]

},

"entryPoints":

{

"paLink": "http://tm1servername.domain.com:9510/tm1web"

},

}

Reboot the Microsoft Windows Server, and then try to run the SyncDBConf.bat command again.

More Information:

https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=only-configuring-controller-web

Product:

Cognos Controller 11

Microsoft Windows 2022 server

Issue:

You click on the excel icon in cognos controller to start Excel program. The excel program starts very small.

Solution:

Remove the ccr.exe properties to adjust screen resolution (change high DPI settings)  or

open a excel document first in excel, before you login to cognos controller from excel, and run a report.

You have change the ccr.exe properties to not make cognos controller shrink when you open a java menu inside the cognos controller program. This is done by go to C:\Program Files\IBM\IBM Cognos Controller Local Client folder.
Right click on CCR.exe > Properties > Compatibility > Change high DPI settings > Check Override high DPI scaling behavior. Scaling performed by: System (Enhanced).

https://www.ibm.com/support/pages/controller-screen-shrink-after-opening-java-related-menu-function 

If user need to send report to Excel, they need to have an Excel book open first before run send to Excel. Otherwise the Excel will shrink after apply setting.

More Information:

https://www.ibm.com/support/pages/screen-shrinks-after-opening-java-related-menu-function-caused-limitation-apar-pi94499 

https://www.ibm.com/support/pages/controller-screen-shrink-after-opening-java-related-menu-function 

Product:
Cognos Controller 11.0.1200
Microsoft Windows 2019 server
Microsoft SQL 2016 server

Issue:
How install Cognos Controller 11?

Solution:

This are an example of the steps to install Cognos Controller 11.  (Some information below may be incorrect or not needed)

For best guides follow the IBM documentation.  https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=icclo-installing-configuring-cognos-controller-one-computer

Before any work with Cognos Controller – take a extra SQL backup of the database.

Download the software from here:

You need to get both the RTM version and any fix pack you need to install.

https://www.ibm.com/support/pages/downloading-ibm-cognos-controller-1101

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

Install IIS on the server that will run Cognos Controller. Microsoft .NET Framework 4.7.2 must be installed on the Controller Web Services Server computer. Install sqlncli.msi driver version 11.4.7462.6 or later version for SQL server.

Select the following when you add the Web Server (IIS) role to the windows server:

Cognos Controller 11 only supports Microsoft SQL server database,  you need to create one database, if you not already have one from an old version of Cognos Controller. Ensure that the database collation sequence is case insensitive, and is the same for both the SQL server (tempdb database) and the Controller database. (Recommended:  SQL_Latin1_General_CP1_CI_AS ) Controller tables owned by dbo are not supported. If you have dbo as the default table owner you must change it, easiest is to create a new database from start in SSMS.

To create a schema named cognos:

IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'cognos'))
BEGIN
EXEC ('CREATE SCHEMA [cognos] AUTHORIZATION [dbo]')
END

To change schema on one table:

ALTER SCHEMA cognos
TRANSFER dbo.Employees

To change default schema for a user in SQL:

ALTER USER cognos WITH DEFAULT_SCHEMA=cognos EXECUTE AS USER='cognos'

 

If you do a upgrade of Cognos Controller 11 on a old server, you need to uninstall the previous Cognos Controller 10 version first.

Check if the anti-virus software on the Windows server is compatible with you installing of software.

Copy the installation media to the server and unzip it.

Run (as a administrator) the issetup.exe from folder C:\install\cntrl_11.0.1_win_ml.tar\winx64h\ to install Cognos Controller.

Click Next

Mark I agree and Click Next

Mark non-production (if not production server) and click Next

Click Yes

Normally you select all. In some cases the FAP is only installed on your TM1 server. Controller Web is only needed if you going to use it.

Click Next.

Click Next

Click Next

Wait until it is done

Click Finish.

In the log file you can find this messages:
Install component: VFP
Component Version: VFP-AW64-ML-RTM-9.0.2120.0
File “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfp9r.dll” successfully extracted.
File “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfp9renu.dll” successfully extracted.
File “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfp9t.dll” successfully extracted.
File “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\vers\vfp-winx64h-app-9.0.2120.0-inst.ver” successfully extracted.
File “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\vers\vfp-winx64h-app-inst.ver” successfully extracted.
Successfully created directory “C:\Windows\system32\server\”.
Successfully copied file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfp9r.dll” to file “C:\Windows\system32\server\vfp9r.dll”.
Self registration of file using command line “C:\Windows\system32\regsvr32.exe /s “C:\Windows\system32\server\vfp9r.dll””.
Error: Failed system command “C:\Windows\system32\regsvr32.exe /s “C:\Windows\system32\server\vfp9r.dll””.
Error: Application has returned exit code “3”.
Successfully deleted file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfp9r.dll”.
Successfully set value “C:\Windows\system32\server\vfp9r.dll” for key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs”.
Successfully copied file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfp9renu.dll” to file “C:\Windows\system32\server\vfp9renu.dll”.
Self registration of file using command line “C:\Windows\system32\regsvr32.exe /s “C:\Windows\system32\server\vfp9renu.dll””.
Error: Failed system command “C:\Windows\system32\regsvr32.exe /s “C:\Windows\system32\server\vfp9renu.dll””.
Error: Application has returned exit code “4”.
Successfully deleted file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfp9renu.dll”.
Successfully set value “C:\Windows\system32\server\vfp9renu.dll” for key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs”.
Successfully copied file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfp9t.dll” to file “C:\Windows\system32\server\vfp9t.dll”.
Self registration of file using command line “C:\Windows\system32\regsvr32.exe /s “C:\Windows\system32\server\vfp9t.dll””.
Error: Failed system command “C:\Windows\system32\regsvr32.exe /s “C:\Windows\system32\server\vfp9t.dll””.
Error: Application has returned exit code “3”.
Successfully deleted file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfp9t.dll”.
Successfully set value “C:\Windows\system32\server\vfp9t.dll” for key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs”.
Successfully deleted file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\vers\vfp-winx64h-app-9.0.2120.0-inst.ver”.
Successfully deleted file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\vers\vfp-winx64h-app-inst.ver”.
Successfully added value “1” for key “VFP” under section “Component List” in file “C:\Program Files\ibm\cognos\ccr_64\uninstall\uninst.ini”.

Install component: VFPCOM
Component Version: VFPCOM-AW64-ML-RTM-9.0.2123.0
File “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfpcom.dll” successfully extracted.
File “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\vers\vfpcom-winx64h-app-9.0.2123.0-inst.ver” successfully extracted.
File “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\vers\vfpcom-winx64h-app-inst.ver” successfully extracted.
Successfully copied file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfpcom.dll” to file “C:\Windows\system32\server\vfpcom.dll”.
Self registration of file using command line “C:\Windows\system32\regsvr32.exe /s “C:\Windows\system32\server\vfpcom.dll””.
Error: Failed system command “C:\Windows\system32\regsvr32.exe /s “C:\Windows\system32\server\vfpcom.dll””.
Error: Application has returned exit code “3”.
Successfully deleted file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\server\vfpcom.dll”.
Successfully set value “C:\Windows\system32\server\vfpcom.dll” for key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SharedDLLs”.
Successfully deleted file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\vers\vfpcom-winx64h-app-9.0.2123.0-inst.ver”.
Successfully deleted file “C:\Users\ADMINI~1\AppData\Local\Temp\COG_2\vers\vfpcom-winx64h-app-inst.ver”.
Successfully added value “1” for key “VFPCOM” under section “Component List” in file “C:\Program Files\ibm\cognos\ccr_64\uninstall\uninst.ini”.

Above error in log file show that the COM objects for Cognos Controller was not installed. Uninstall cognos controller and do the installation again.

 

Error: Failed to retrieve environment variable “JAVA_HOME”.
Error: Processing XML file “C:\Program Files\ibm\cognos\ccr_64\bin\wct\ccrconfigwebserver.xml” returned errors. View the file “C:\Program Files\ibm\cognos\ccr_64\instlog\isconfig-CNTRL-20240315_1517.log” for details.
Successfully added value “1” for key “CCRWEBSERVER_VERC” under section “Component List” in file “C:\Program Files\ibm\cognos\ccr_64\uninstall\uninst.ini”.

Above error is common, but should not affect the software performance.

 

Error: Processing XML file “C:\Program Files\ibm\cognos\ccr_64\frontend\fcmconfigfrontendserver.xml” returned errors. View the file “C:\Program Files\ibm\cognos\ccr_64\instlog\isconfig-CNTRL-20240315_1517.log” for details.
Successfully added value “1” for key “CCRFCMFRONTEND_VERC” under section “Component List” in file “C:\Program Files\ibm\cognos\ccr_64\uninstall\uninst.ini”.

Above error we have no clue what it is.

 

Run the upgrade/fix pack from folder like C:\install\up_cntrl_winx64h_11.0.1200.36_ml.tar\winx64h\issetup.exe

Click Next

Click Next

Select same path as before and click Next

Click Next

Wait

Click Finish.

Reboot the windows server.

Check the cmplst.txt file that the correct controller version is installed:

LICENSE_CONTROLLER_version=LICENSE_CONTROLLER-AW64-ML-RTM-11.0.1.2-0
LICENSE_CONTROLLER_name=IBM Cognos 8 License
SWTAG_NP_CONTROLLER_version=SWTAG_NP_CONTROLLER-AW64-ML-RTM-11.0.1.5-0
SWTAG_NP_CONTROLLER_name=SWTAG CONTROLLER – Non-Production
CONTRL_version=CCR-AW64-ML-RTM-11.0.1.203-0
CONTRL_name=IBM Cognos Controller
LICENSE_FP_CONTROLLER_version=LICENSE_FP_CONTROLLER-AW64-ML-RTM-10.4.2200.4-0
LICENSE_FP_CONTROLLER_name=IBM Cognos License
[Product Update Information]

CONTRL_UPDATE_version=CCR-AW64-ML-RTM-11.0.1200.36-0
CONTRL_UPDATE_name=IBM Cognos Controller Update
[Main Applications]

Copy the sqljdbc42.jar driver to folders like C:\Program Files\ibm\cognos\ccr_64\server\FAP\lib and C:\Program Files\ibm\cognos\ccr_64\server\integration and C:\Program Files\ibm\cognos\ccr_64

Start Cognos Configuration and setup the values needed, start with the database connection to your Cognos Controller database.

See more details in how to setup old cognos controller here https://www.ibm.com/support/pages/node/213339

 

The provider should be SQLNCLI11.1 and data source is the name of the windows database server. You should use a db server name and not ip address.

Click test connection, click save icon, and then click run icon – to start the DBCONVERT program. Here you need to upgrade your Cognos Controller database to the new version.  https://www.ibm.com/support/pages/ibm-cognos-controller-builds-ccr-name-and-database-version

Updater Kit	Build	FCM Web	Client (classic)	CCR Version	DB Version	Comment
11.0.1200.1015	11.0.1200.55	11.0.1200.10	11.0.1200.8	11.0.1.2 IF2	1015
11.0.1200.1002	11.0.1200.37	11.0.1200.10	11.0.1200.8	11.0.1.2 IF1	1015	Available on Passport Adv. (full installation)
11.0.1200.36	11.0.1200.28	11.0.1200.10	11.0.1200.8	11.0.1 FP2	1015	Generally available (FixCentral)
11.0.1000.8	11.0.1000.6	11.0.1000.1	11.0.1000.2	11.0.1 FP1	1013	Generally available (FixCentral)
11.0.1.203	11.0.1.148	11.0.1.144	11.0.1.117	11.0.1	1012	Available on Passport Adv. (full installation)
11.0.0.1009	11.0.0.39	11.0.0.93	11.0.0.22	11.0.0.0 IF1	1011	Generally available (FixCentral)
11.0.0.106	11.0.0.34	11.0.0.85	11.0.0.17	11.0.0.0 RTM	1011	Available on Passport Adv. (full installation)
10.4.2200.222	10.4.2200.228	10.4.2200.79	10.4.2200.77	10.4.2.2 IF9	1010

 

If you have a demand for TLS 1.2 in your Windows environment or run old version of Windows, then you can get a error like below when you click “connect”.

** ERROR: com.microsoft.sqlserver.jdbc.SQLServerException: Drivrutinen kunde inte upprätta en säker anslutning till SQL Server med SSL-kryptering (Secure Sockets Layer). Fel: “Unexpected rethrowing”.

Can it be that SQL Server 2005 that uses 3DES algorithm in TLS connection and with new versions of JRE, this algorithm is disabled, Or the database is an older database (like SQL Server 2014) which does not allow higher security standards like TLS 1.2.

Then You need to start DBCONV program from a bat file with this settings (save it in a text file called DBCONV.BAT and run it) :

https://www.ibm.com/support/pages/how-configure-force-controller-use-tls-12 


"C:\Program Files\IBM\cognos\ccr_64\bin\jre\8.0\bin\java.exe" -cp com.ibm.cognos.ccr.dbconv.ui.DbConvGUI"C:\Program Files\ibm\cognos\ccr_64\bin64\jre\8.0\bin\javaw.exe" -Dcom.ibm.jsse2.overrideDefaultTLS=true -Dcom.ibm.jsse2.overrideDefaultProtocol=TLSv12 -cp "C:\ProgramFiles\ibm\cognos\ccr_64\DbConv.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\antlr-3.2.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\ccr-common.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\ccr-integration-server.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\ccr-integration.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\ccr-xml.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\cglib-nodep-2.1_3.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-beanutils-1.8.3.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-beanutils-bean-collections-1.8.3.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-beanutils-core-1.8.3.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-cli-1.1.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-codec-1.8.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-collections-3.2.1.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-dbcp-1.2.2.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-io-2.4.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-lang-2.3.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-logging-1.1.1.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\commons-pool-1.3.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\db2jcc.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\DBConv.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\icu4j-4_8_1_1.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\jsr173_1.0_api.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\jython.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\log4j-1.2.8.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\ngtm1api.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\ojdbc6.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\resolver.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\spring.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\sqljdbc42.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\stringtemplate-3.2.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\xbean.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\xbean_xpath.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\xmlbeans-qname.jar";"C:\Program Files\ibm\cognos\ccr_64\server\integration\xmlpublic.jar" com.ibm.cognos.ccr.dbconv.ui.DbConvGUI

 

If this is a new empty database – you need to click Create DB (this will erase the database, and create a empty controller database).

Then do a upgrade of the cognos controller database.

You should get to above picture without errors, if the upgrade of the cognos controller database was successful.

Click Close

 

Setup of IIS Manager:

1. In the Internet Information Services (IIS) Manager,  select Application Pools.
2. Create a new Controller application pool and then from the Actions pane, select Advanced Settings.
3. Set the .Net CLR Version to v.4.0.
4. Set Enable 32-Bit Applications to False.
5. Set Identity to LocalSystem and time-out to 600.
6. Click OK.
7. 
8. If you do not have CA11 installed, you can point the ibmcognos virtual directory to a empty folder like webcontent.
9. Expand Sites and under your web site, create the following virtual directories as shown in the table. If you are installing on the same machine as IBM Cognos Analytics, create the virtual directories under the ibmcognos virtual directory.
   

   Alias	Location
   controller	controller_install_location\ccrvdir
   controllerbin	controller_install_location\webcontent\ccr

10. Select the controller virtual directory.
11. double click on HTTP redirect. 
12. Select Redirect Requests to this destination and enter the following path:
    /controllerbin/app.publish/CCR.application
    
    
13. Click Apply.
14. Right-click your web site and click Add Application.
    1. Set Alias to ControllerServer.
    2. Set Application pool to Controller.
    3. In the PhysicalPath field, enter controller_install_location/ControllerProxyServer.
       
       
    4. Click OK.
15. When you only use native login in Cognos Controller, keep the authentication in IIS to Anonymous Authentication.
    

 

On the Cognos Controller server Open C:\Program Files\IBM\cognos\ccr_64\ControllerProxyServer\Web.config and add

<add key="ccrReports" value="http://[servername]:9082/fcm.reports/report" />

 

Ensure you use space and not tabs inside the config file. Change the localhost settings to the servername in cognos controller configuration, so the client program can find the cognos controller server.

Go to folder C:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\etc\
Open the file server.env inside notepad++
Add the following line:
JAVA_HOME=C:/Program Files/IBM/cognos/ccr_64/fcmweb/jre

Save the changes to the file.

 

Setup of Cognos Configuration:

Use FQDN server name instead of only the server name.

Above should you not change, it is configured from the report server settings.

Above you must fill out with the full server and domain name.

Start the batch service in Cognos Controller.

https://www.ibm.com/support/pages/summary-description-windows-services-ibm-cognos-controller-typically-found-controller-application-server

 

 

When you run a report in Cognos Controller 11 and get a error like:

HTTP Error 404.0 – Not Found

The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

The value in cognos controller configuration report server (http://localhost/ibmcognos/cgi-bin/cognos.cgi) is pointing to a not working website server. Try to change it to http://cognosanalyticsserver/ibmcognos/bi/v1/disp and ensure that all IIS functions are installed in the Web Server.

HTTP Error 405.0 – Method Not Allowed

The page you are looking for cannot be displayed because an invalid method (HTTP verb) is being used.

Then you maybe are pointing to a none existent CA11 server in cognos controller configuration report server section. Add the “ccrReports” value in web.config to solve it (this will use the Cognos Controller internal report server).

 

This can be that we are using a wrong database connection, try to connect to a other SQL version than 2016.

If you do not have a adobe pdf viewer installed on your laptop. Add the value <add key=”useInternalPdfViewer” value=”true” /> to the servers web.config file. Then cognos controller should use its internal pdfviewer.

You have to reboot the windows server, for the service FCMREPORTS to get any changes to the web.config file to take affect.

You get above error when you run a report in Cognos Controller, when the java is not correct point out in the server.env file for IBM Cognos Controller Reports.

 

Setup of connection to Cognos Analytics:

If you use CA11 for authentication, then in cognos configuration enter the Report Server to http://CAservername.domain.com/ibmcognos/bi/v1/disp and Dispatcher URI to http://CAservername.domain.com:9300/p2pd/servlet/dispatch

You need to create the roles Controller Administrators and Controller Users in CA11 if it is a new installation, then add the users that should use cognos controller to above roles. Follow IBM documentation for more exact steps.

And The Controller Administrators role must be a member of the Controller Users role in Cognos Analytics.

Setup of the Cognos Controller Client:

To install the cognos controller client copy the file ccrlocalclient64.msi to a local folder (c:\install) from C:\Program Files\ibm\cognos\ccr_64\webcontent\ccr folder on the the windows server.

Create a setupccr.bat file with this content:

msiexec.exe /qb /i CCRLocalClient64.msi WSSURL=”http://controllerservername.domain.com/ibmcognos/controllerserver”

Run the bat file as administrator to install the cognos controller client silent.

After you login to Cognos Controller client, you can check the version in help menu – system info.

If you get a error like WebView is missing, then you must install WebView on the client from https://developer.microsoft.com/en-us/microsoft-edge/webview2/?form=MA13LH#download  to get the Help menu to work properly inside cognos controller client.

Under Evergreen Standalone Installer, click the x64 download button.

Download and run the installer file MicrosoftEdgeWebView2RuntimeInstallerX64.exe

If you when you test menu – maintain – jobs – define, get a error like this:

com.ibm.cognos.ccr.integration.IntegrationFacadeException: org.eclipse.core.runtime.adaptor.EclipseStarter failed!
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:168)
at java.lang.Thread.run(Thread.java:825)
Caused by: com.ibm.cognos.ccr.common.FatalException: Failed to launch!
at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(Unknown Source)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:166)
… 1 more
Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: Unable to find instance of model of type: configproperty[ConfigPropertyModel]

Check if it works better if you use a newer SQL server version, that can communication with the TLS security that the java parts need.

You can try to setup all this:

https://www.ibm.com/support/pages/how-configure-force-controller-use-tls-12

 

To setup Controller FAP, there are a few new steps, that is outlined here that you must follow:

https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=administration-fap-web-configuration

 

More Information:

https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=icclo-installing-configuring-cognos-controller-one-computer

https://www.ibm.com/support/pages/which-sql-collations-are-supported-controller

https://www.ibm.com/support/pages/how-enable-local-pdf-rendering-when-running-standard-reports-enabling-pdfviewer-using-parameter-useinternalpdfviewer

https://simonlearningsqlserver.wordpress.com/tag/changetable/

https://www.ibm.com/support/pages/server-not-reachable-or-still-initializing-faulting-application-path-cprogram-filesibmcognosccr64frontendprunsrvexe-launching-controller-web-caused-corrupt-configjs-file

https://github.com/microsoft/mssql-jdbc/releases/tag/v10.2.0

https://www.ibm.com/support/pages/how-configure-force-controller-use-tls-12

https://www.ibm.com/support/pages/how-install-deploy-controller-client-silently-without-user-input

 

 

Product:
Cognos Controller 11.0.1

Issue:

Do you have a checklist of what is needed to do, when you upgrade to Cognos Controller 11?

Solution:

Best is if you create a own checklist for your environment, that you can use it at every upgrade. Below is a suggested as a starting point, that you can develop further.

Download from here: 

Downloading IBM Cognos Controller 11.0.1 

 

Parts and platforms	Details	eImage
IBM Cognos Controller 11.0.1 Microsoft Windows Multilingual	Required	M0DH2ML
IBM Cognos Analytics Client 11.2.4.1.1 Multiplatform Multilingual	Optional	M0BRXML
IBM Cognos Analytics installer 3.6.46 Microsoft Windows Multilingual	Optional	M0BRWML
IBM Cognos Analytics Server 11.2.4.1.1 Microsoft Windows Multilingual	Optional	M0BRVML

 

You must download the RTM program and then the fix packs.

IBM Cognos Controller 11.0.x Fix List 

IBM Cognos Analytics Fix Lists 

analytics-installer-3.7.21-win.exe (174.73 MB)

caclient-11.2.4-2401220500.zip (1.49 GB)

casrv-11.2.4-2401220500-winx64h.zip (6.98 GB)

Get file up_cntrl_winx64h_11.0.1200.36_ml.tar.gz that is for Cognos Controller 11.0.1 fix pack 2.

Detail upgrade instruction here: 

https://www.youtube.com/watch?v=NgNdM3EiPlA 

Upgrading IBM Cognos Controller – IBM Documentation 

Installing fix packs – IBM Documentation 

Cognos Analytics 11.2.4 can be installed on top of CA 11.1.7.  The installation will overwrite the images folder, and upgrade the content-store database to a different schema version that will not work with the old CA11 version, therefore you must take a backup of the SQL database before.
Cognos Analytics 11.1.x end of support (EOS) is 2024-04-30 – but you can buy extended support.

Cognos Controller 11 needs to be installed fresh. You need to uninstall and remove the old version of CC 10 on your server before you install Cognos Controller 11.
Cognos Controller 10.4.2 end of support (EOS) is 30-Sep-2024.  Lifecycle policy Standard (S): minimum 3 years support with extension of 2 years.

Cognos Analytics upgrade  (if you decide to upgrade Cognos Analytics)		Date
Copy the media to local hard disk on server	d:\install
Export configuration from cognos configuration to backup folder	d:\temp\backup
Backup the CA11 images folders and any custom images folders you use like D:\Program Files\ibm\cognos\analytics\webcontent\bi\images or D:\Program Files\ibm\cognos\analytics\webcontent\bi\samples\images
Backup the controller config file D:\Program Files\ibm\cognos\analytics\templates\ps\portal\ variables_CCRWeb.xml
Backup PA variables_TM1.xml files from D:\Program Files\ibm\cognos\analytics\templates\ps\portal
Backup PA planning.html and PMHub.html files from D:\Program Files\ibm\cognos\analytics\webcontent
Backup PA tm1web.html files from D:\Program Files\ibm\cognos\analytics\webcontent\bi\tm1\web
Backup web.config from D:\Program Files\ibm\cognos\analytics\webcontent
Backup the SQL database for content store
Backup the SQL database for audit
Take a screenshot of cognos configuration environment page
Take a screenshot of the members of cognos administrator group
Take a screenshot of the members of cognos controller administrator group
Take a screenshot of the members of cognos controller user group
Check that firewall ports are open	Port 25, 80, 9300, 9362, 1433, 389 etc for BI.
Stop the Cognos Services and set them to manual, reboot the windows server to ensure no Cognos processes are running before you start the installation
Run the setup program for IBM Cognos Analytics Server 11.2.4.1.1, the installation will take a long time.
Run the setup program from casrv-11.2.4-2401220500-winx64h.zip ( CA 11.2.4 FP3). You can install the fix pack media direct, it is a full installation.
Open Cognos Configuration and click save
Ensure the SQL driver is in the folder D:\Program Files\ibm\cognos\analytics\drivers	Copy back any planning.html files you have backed up
Start the Cognos BI service
Check that you can login to IBMCOGNOS
Check file exist in D:\Program Files\ibm\cognos\analytics\templates\ps\portal\ variables_CCRWeb.xml

 

When CA11 is up and running, then you can install Cognos Controller.

https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=new-components-in-controller-1100

Cognos Controller 11 upgrade		Date
Copy media to server	d:\install
Backup all Controller database in SQL server
Export configuration from cognos configuration to backup folder	d:\temp\backup
Backup the acl files in D:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer
Backup the web.config file in D:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer
Take screenshots of application pools and iis timeout settings
Take screenshots of every setting in Cognos Controller configuration	Controller configuration is erased when installing a new version, so you need to enter the values back
Backup all under D:\Program Files\ibm\cognos\ccr_64\fcmweb
Backup all under D:\Program Files\ibm\cognos\ccr_64\frontend
Backup the udl files in D:\Program Files\ibm\cognos\ccr_64\Data
Backup properties file from D:\Program Files\ibm\cognos\ccr_64\server\FAP
If HTTPS is used, backup all certificate stores
Stop all IBM Cognos Controller services
Uninstall the previous version of Cognos Controller
Reboot the server
Install the new version of Cognos Controller
Stop Internet Information Services (IIS) Manager (the Default Web Site) Stop IBM Cognos Controller Consolidation
Go to the folder C:\Program Files\ibm\cognos\ccr_64 Search recursively for all instances of the subfolder workarea. Delete all instances of the workarea folder that appear in the search results.
Install the new fix pack of Cognos Controller
Place the SQL driver sqljdbc42.jar in D:\Program Files\ibm\cognos\ccr_64\server\integration
Place the SQL driver sqljdbc42.jar in D:\Program Files\ibm\cognos\ccr_64
Add back the information in Cognos Controller configuration and click save
Create the virtual directories in WWW for Cognos Controller	https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=icccoc-configure-web-server
Update the files for Controller Web with old information	https://www.ibm.com/support/pages/node/791535
Upgrade your Controller application databases	https://www.ibm.com/support/pages/ibm-cognos-controller-builds-ccr-name-and-database-version
Create a UDL file and Upgrade your FAP database
If FAP service is on other server, install FAP there
Add back the FAPService.properties file
Upgrade the Cognos Controller client on the server – can you login?	https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=installers-installing-stand-alone-controller-client
Start FAP service – any error in log file?
Create the Cognos Controller Client package for silent installation
Reboot windows server and check you can login to cc

 

https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=administration-fap-web-configuration

More information:

https://www.ibm.com/support/pages/cognos-analytics-continuing-support 

https://www.ibm.com/support/pages/how-install-deploy-controller-client-silently-without-user-input

https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=analytics-silent-installation-uninstallation-configuration 

https://www.aramar.co.uk/latest-version-of-ibm-controller-version-11-0-1/ 

https://www.ibm.com/support/pages/how-configure-financial-analytics-publish-fap-allow-publishing-controller-data-planning-analytics 

https://www.element61.be/en/resource/why-engage-ibm-tm1-fap-top-your-consolidation

https://www.ibm.com/docs/en/cognos-controller/11.0.1?topic=only-whats-new

https://www.ibm.com/support/pages/ibm-cognos-controller104x

Product:
Cognos Controller 10.4.2200.88
Microsoft Excel 64 bit Microsoft® Excel® for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20684) 64-bit
Microsoft Windows 11

Issue:

After upgrade to Excel 64 bit, Excel crash at start. The add in for Cognos controller can be for the 32 bit version of the Excel program.

Solution:

Inside Excel, go to file – options.

Go to Add-ins dialog.

‘Manage‘ is set to ‘Excel Add-ins‘, and click ‘Go’.

Remove the mark for the first Cognos Controller line (adxloader.controller.excellink). Should look like this when it is correct.

Click OK.

‘Manage‘ is set to ‘COM Add-ins‘, and click ‘Go’.

The Cognos controller link should point to the 64 bit version of the dll, as above.

Click OK.

Recommendation, is to start Cognos Controller program first, and from inside Cognos Controller click on the icon for excel, to start Excel.

Be patient, Excel take a long time to start.

If you check Excel add-ins when Cognos controller is running it can look like this:

 

More Information:

https://www.ibm.com/support/pages/controller-excel-link-disappears-after-excel-crashes

https://exploringtm1.com/use-architect-or-perspectives-10-2-x-to-planning-analytics/ 

https://www.ibm.com/support/pages/office-365-supported-ibm-cognos-controller

https://www.ibm.com/support/pages/ibm-cognos-controller-has-fired-exception-when-updating-layout-caused-microsoft-excel-2016-defect

https://www.add-in-express.com/creating-addins-blog/release-excel-com-objects/

Product:
Cognos Controller 10.4.2
Microsoft Windows Server 2022

Issue:

Suddenly user can not login to cognos controller.

They get a error like this:

System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentNullException: Value cannot be null.
Parameter name: uriString
at System.Uri..ctor(String uriString)
at System.Web.Services.Protocols.WebClientProtocol.set_Url(String value)
at Cognos.Controller.Common.CRNBridge.CRNBridge.set_EndPointURL(String sURL)
at Cognos.Controller.Proxy.CCRWS.GetUserInfo(String sGuid, String sUser, String passportId)
— End of inner exception stack trace —
at Cognos.Controller.Forms.Common.Main.DoLoginCognos8(Form& frm, Boolean runtimCheck)
at CCR.AppContext.DoLogin()
at CCR.AppContext.Login()

Solution:

Restart the IIS service on the Cognos Controller server.

 

Steps to check the issue:

Login to the Cognos Controller server (via remote desktop).

Check that all IBM Cognos service are running.

Start IE and browse to CA11 – does it work?

http://controllerserver.domain.com/ibmcognos

Start IIS manager and check that all application pools are running.

Go to Components service from control panel administration. Expand COM+ components.

Ensure that “IBM Cognos Controller Consolidation” is running. If not, then restart the IIS from inside IIS manager program.

Check the windows event log for any error message, that can explain why any of above processes have stopped.

More Information:

https://blog.ittoby.com/2014/07/why-schannel-eventid-36888-36874-occurs.html 

https://allthingscognos.wordpress.com/category/cognos-controller/