Product:
IBM Cognos Controller CONTRL_UPDATE_version=CCR-AW64-ML-RTM-11.1.1002.5-0

Microsoft Windows 2019 server

Issue:

How upgrade the client?

Suggested solution:

This are the steps we do on a laptop to upgrade the IBM cognos controller client program.

In excel the add-in is installed as this:

Some values can be found in the registry at Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel

Uninstall the previous version first, from windows control panel. That is in folder C:\Program Files\IBM\IBM Cognos Controller Local Client.

After you have uninstall Cognos Controller, you get this message when you start Excel.exe.  The above folder is gone and the files in it.

When you go into the excel options add-ins you find this message, it looks like the add-in is installed – but it is not.

Should this be removed before installation of the new Cognos Controller client? If the installation works as it should, it will handle it as is.

Run the installation of the cognos controller client from CCRLocalClient64.msi file.

Click Next

Enter the FQDN name to the cognos controller server here and press Next.

Click Next (notice the new folder to the program)

Click Install

Click Finish

The new IBM controller client is installed.

Start the IBM controller program from the start menu.

Select your database and enter your name and password if needed.

When logged in try to only start Excel from inside Cognos Controller client program, by press the excel icon.

And excel start without any controller tool bar – then the com add-in have been disabled.

You need to go to the options – add-ins – com add-ins and mark the above controller link for microsoft excel and press ok.

Restart Excel and Cognos Controller program.

Go into cognos controller and press excel icon – it should start up the Excel with this controller options.

If you look inside Excel options – add-ins it should look like this.

There should only be two controller link for microsoft excel, and they should point to the correct folder.

In many cases when above does not work, it can be error in REG VALUE

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options]

“OPEN”=”/R \”C:\\Program Files\\IBM\\IBM Controller Local Client\\adxloader64.Controller.ExcelLink.dll\””

Check the registry from a working installation, and compare to the not working installation of Excel.

If you have issues with the Cognos Controller link to excel, do a reinstall of your Microsoft Office program first.

If the installation is done correct, the files should have the same date. There is 282 files in the Controller client folder for version 11.1

 

If you get a error like this: (then the database connection is not working and the sql username and password is not correct)

System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentException: Login failed for user ‘cognos’.
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at FrServerB.ServerInfo.GetDBRelease(String sGuid, String sUser)
at Cognos.Controller.Proxy.CCRWS.ServerInfo_GetDBRelease(String sGuid, String sUser)
— End of inner exception stack trace —

If you get a error like this when you try to run a report: (You have to go into Excel – options – add-ins and COM add-ins, and mark the controller link for Microsoft Excel, to make it active).

If you try to remove the excel add-in you should get a message like this – only admins can remove the add-in.

If both the excel add- ins are inactive, then nothing happens in the excel. You need to go into both Excel add-ins and COM add-ins and active the controller link for Microsoft Excel.

If you get a error in the Excel add-in dialog like this; (then you have deactivated the add-ins in wrong order)

Exception from HRESULT: 0x800AC472
at Microsoft.Office.Interop.Excel._Application.set_EnableEvents(Boolean RHS)
at Cognos.Controller.ControllerForms12.clsDataEntry.DoLogoff()
at Cognos.Controller.XL.ControllerXL.xllController.ExitXll(Boolean LoggingOff)
at Cognos.Controller.XL.ControllerXL.xllController.DoLogout()

 

More Information:

• Your client computer needs this:
• Microsoft Excel for Microsoft 365.
• Microsoft Edge Runtime.
• Microsoft .Net 4.5 or later.

https://www.ibm.com/docs/en/controller/11.1.0?topic=installers-installing-stand-alone-controller-client

https://greenshot.org/

 

Product:
IBM Cognos Controller 11.1 CONTRL_UPDATE_version=CCR-AW64-ML-RTM-11.1.1002.5-0
Microsoft Windows 2022 server

Issue:

When testing Controller Web in a new installation – you get error: Unable to load requested view. Displaying home view instead.  This is when using Native security in Cognos Controller, and installed on a single server.

Solution:

The new version of IBM Controller Web use a different port for the end user, browse to http://controllerservername.domain.com:9085/

then it will work.

You may also need to update the config files, before it will work. The steps to setup controller web are from IBM this

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

 

 

This steps are similar to previous version of Controller Web setup.

Go to the C:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\etc and open server.env in notepad++

change the line to

JAVA_HOME=C:/Program Files/IBM/cognos/ccr_64/fcmweb/jre

save the file.

Open CMD and go to folder C:\Program Files\ibm\cognos\ccr_64\fcmweb

Run command:

SyncDBConf.bat ..\Data wlp\usr\shared\config\datasources

Go to folder C:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\usr\servers\fcm.web

Open file com.ibm.fcm.web.properties in Notepad++  ( please note the name: com.ibm.fcm.web.properties )

Add the lines

ccrwsUrl=http://win2022pal/ibmcognos/controllerserver/ccrws.asmx
loginMode=NATIVE

Save the file.

(adjust the path/url to your server setup).

Stop the IBM controller services  – and start them for the changes to take affect.

But you need to do this changes to:

Go to folder C:\Program Files\ibm\cognos\ccr_64\frontend

Open config.js in notepad++

Enter the servername url in this 3 places, use FQDN instead of only servername as I do in the example.

Then further down enter the servername (fqdn), and change the port number on line 71 from 9086 to 9085.

Keep the Apostrophe sign as is.

Go to folder C:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\usr\servers\fcm.glass

Open server.env in notepad++

Normally you only need to change the c: to d: if you have installed the cognos controller program to the d: drive with default paths.

Save the file.

Open bootstrap.properties in notepad++ if you have change any other files, to use a different port.

Normally you do not need to change above file.

Restart the Windows server and see if it works.

Log files can be found in a folder like C:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\usr\servers\fcm.web\logs

 

If you get error like: Not Found
The application or context root for this request has not been found: / you are going to the wrong port. The User should browse to this address:

http://[servername]:9085/

From IBM documentation:

 

 

When it works – it should look like this:

More Information:

https://www.ibm.com/docs/en/controller/11.1.0?topic=options-configuring-controller-embedded-report-library 

https://en.wikipedia.org/wiki/List_of_typographical_symbols_and_punctuation_marks 

 

Product:

IBM Cognos Controller 11.1
Microsoft Windows 2019 server

Issue:

New installation of IBM Controller 11.1, when the client run a standard report in Cognos Controller client program. The EDGE or adobe acrobat is also started and show the PDF file – even the PDF file is show inside the Controller program dialog.

 

Solution:

1. Ensure no one is logged into cognos controller client.

2. Logon to the Controller application server

3. Browse to the folder ‘ControllerProxyServer’. Can be C:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer

4. Create a backup copy of the file: web.config

5. Use Notepad++ to edit the file web.config

6. Locate the section <appSettings>

7. Add the following line into that section:

<add key="useInternalPdfViewer" value="true" />

8. Save the file and restart the service.

 

More information:

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

Product:
IBM Cognos Controller 11.1
Microsoft Windows 2022 server

Issue:

After a new install of IBM Cognos Controller 11.1, the reports give a error inside the client, something like this

Solution:

Even the documentation say, The installation of IBM® Cognos Analytics is needed only for using the Cognos Access Management authentication. You must enable the embedded report system to make it not ask for CA11 support.

Go to the Windows server where you have installed Cognos Controller 11.1

Go to folder C:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer

Open file web.config in notepad++

Add the line <add key=”ccrReports” value=”http://myserver.example.com:9082/fcm.reports/report” />

Save the file.

Open file server.env from folder C:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer

Add the line JAVA_HOME=C:/Program Files/IBM/cognos/ccr_64/fcmweb/jre

Adjust the paths to your setup, like if you have installed on d: drive it should be JAVA_HOME=D:/Program Files/IBM/cognos/ccr_64/fcmweb/jre

Save the file.

Restart the windows server.

Now the cognos controller client does not need the CA11 services, as long you use NATIVE security mode.

Looks like you can leave this at default values, when you use NATIVE security mode:

Then you need to setup the client distribution server correct.

Next issue you will have is to configure EDGE on the client to open inside the cognos controller program, and not outside as a separate PDF reader.

You can try this (but it may not work):

To make Microsoft Edge open PDFs in an external application instead of the browser, follow these steps:

Method 1: Change Edge PDF Settings

1. Open Edge and go to edge://settings/content/pdfDocuments
   • You can also navigate manually:
     • Click the three-dot menu (⋯)
     • Select Settings
     • Go to Cookies and Site Permissions → PDF documents
2. Enable “Always download PDF files”
   • This forces Edge to download PDFs instead of opening them in the browser.
3. Set a Default PDF Viewer in Windows
   • Right-click any PDF file in File Explorer
   • Click Open with → Choose another app
   • Select your preferred PDF viewer (Adobe Acrobat, Foxit, etc.)
   • Check “Always use this app to open .pdf files”
   • Click OK

Now, when you click on a PDF in Edge, it will download and open in your default PDF viewer.

 

More information:

https://www.ibm.com/docs/en/controller/11.1.0?topic=options-configuring-controller-embedded-report-library

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

https://www.ibm.com/docs/en/controller/11.1.0?topic=environment-cognos-analytics

https://www.ibm.com/docs/en/controller/11.1.0?topic=releases-whats-new-in-1110

Product:
IBM cognos controller 11.1
Microsoft Windows 2022 server

Issue:

When you start the cognos controller client you get a error, like this:

System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentException: Access to the registry key ‘HKEY_LOCAL_MACHINE\Software\VB and VBA Program Settings\FrangoController\Settings’ is denied.
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at FrServerB.LocalConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
at FrServerB.ConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
— End of inner exception stack trace —
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at Cognos.Controller.Direct.ConnectionDirect.SetSelectDb(Boolean bSelectDb)
at CCR.AppContext.SelectDb()
at CCR.AppContext.Login()

Solution:

Change the DefaultAppPool on the IIS server to use localsystem as the user for the service.

Go to IIS manager

Expand the application pool

Select the pool used by controllerservice

Click on advance settings

Change identity to localsystems

Click ok

Restart the iis from inside IIS manager.

 

More Information:

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

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

Product:
IBM Cognos Controller 11.1
Microsoft Windows 2022 server

Issue:

When you check the controller com+ components, you get a error in the web browser like this:

Server Error in ‘/’ Application.

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable.  Please review the following URL and make sure that it is spelled correctly.

Requested URL: /ibmcognos/controllerserver/ccrws.asmx

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4494.0

 

Solution:

You may not have created the virtual directory’s correct under the virtual directory IBMCOGNOS, therefor they are not visible.

Create the cognos controller directory’s in correct place.

Then when the test works, it should look similar to this:

http://nameofyourserver/ibmcognos/controllerserver/ccrws.asmx

Other issues, could be, that not all files was installed. Run the installation of IBM Controller again on the server.

 

More Information:

https://www.ibm.com/docs/en/controller/11.1.0?topic=iccoc-configure-web-server

https://www.ibm.com/docs/en/controller/11.1.0?topic=options-configuring-controller-embedded-report-library

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

Product:
IBM Controller 11.1 (before Cognos Controller 11.0)

Microsoft Windows 2022 server

Issue:

When you run a standard report inside Cognos Controller Client, you get a error, like this:

The PDF report is not shown.

If you check windows application log on the controller server, you see this message:

Error occured at 2025-03-09 15:13:11 in IBM Cognos Controller, Error No=5, Source=FrangoDirect.StandardReportD.GetCCRReportSystem.Web.Services, Description=System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentException: Unable to connect to the remote server
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)…..

Solution:

The report service is not started, start the windows service: IBM Controller Reports   (FCMREPORTS)

 

More information:

https://www.ibm.com/docs/en/controller/11.1.0?topic=options-configuring-controller-embedded-report-library

https://www.ibm.com/docs/en/controller/11.1.0?topic=SS9S6B_11.1.0/com.ibm.swg.ba.cognos.ctrl_inst.doc/t_installfixpacks.htm

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

Product:
Cognos Controller 11
Microsoft Windows 2022 server

Issue:
I want to upgrade Cognos Controller – what files should i download?

 

Solution:
Check the different IBM web pages, to find out the latest version. As IBM changed the name of IBM Cognos Controller to IBM Controller, old links are not valid.

First you need to download the “base” RTM files from IBM passport portal.

Then you need to find the latest fix pack for the product, check the “what’s new” section to find the latest versions.

https://www.ibm.com/docs/en/announcements/controller-111-introduces-new-look-new-features-providing-benefits 

Or you can check the fix list to find the latest version:  https://www.ibm.com/support/pages/node/7173282 

Then search the IBM Fix central for the latest fix pack to download.

In https://www.ibm.com/support/fixcentral  you can browse for the latest fixes for your product.

Select the product, and click continue to get to a page where you can select “browse for fixes”, then you get a list of all the fixes.

In the list, select the latest fix, and click continue. Select download method, simplest is Download using your browser (HTTPS), and click continue.

Click on the blue file name to download the fix pack for your IBM application.

This date, the file up_cntrl_winx64h_11.1.1002.5_ml.tar.gz (2.38 GB)  is the one you should download. In a few weeks there maybe be a new fix pack.

This page can also help find the latest version of IBM Controller:

https://www.ibm.com/support/pages/ibm-controller-and-ibm-cognos-controller-builds-ccr-name-and-database-version 

Latest fix pack for Cognos Analytics can be:

https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=120x-release-1204-october-2024 

https://www.ibm.com/support/pages/ibm%C2%AE-cognos-analytics-fix-lists 

Search fix central for above fix (interim fix: 12.0.4-BA-CA-Win64-IF002) , for your OS, in case of Microsoft Windows you should download files:

analytics-installer-3.7.38-win.exe (234.48 MB)

casrv-12.0.4-2501300500-winx64h.zip (7.23 GB)

Latest fix pack for Planning Analytics can be:

https://www.ibm.com/docs/en/planning-analytics/2.1.0?topic=features-whats-new-in-planning-analytics 

https://www.ibm.com/support/pages/ibm-planning-analytics-21-fix-lists 

 

Search fix central for above, and you should download this planning analytics files for use with Windows 2019 server:

tm1_winx64h_2.1.7.1_ml.tar.gz (1.42 GB) = the planning analytics server (tm1).

IBM_PAfE_x86_2.1.7.2.xll (7.83 MB) = the new tm1 perspective replacement e.g. pax.

tm1web-11.0.100-24120513-2.1.7-winx64h_bundle.zip (706.64 MB) = for the tm1web installation.

ipa_workspace_win_2019_2.1.7.219.zip (4.78 GB)  = for paw installation.

(if you have a Windows 2022 server for PAW, then you need to download this file instead ipa_workspace_win_2022_2.1.7.49.zip (4.69 GB) )

Then check the supported environments, to ensure that your download products can work with each other.

Cognos Controller 11.1 support this version of the other products:

IBM Cognos Analytics 12.0.4 support this version of the other products (as data source) :

Planning analytics 2.1.7 support this version of the other products (this is for authentication):

If you need to import data from a SQL database for Planning Analytics 2.1.7 it supports:

 

Please check that cognos controller and cognos analytics support the version of SQL database you are using.

 

More information:

https://www.ibm.com/support/pages/ibm-planning-analytics-local-217-now-available-download-fix-central-0 

https://www.ibm.com/software/reports/compatibility/clarity/index.html 

Product:

Cognos Controller 11.0.1200
Microsoft Windows 2019 server

Issue:

Cognos Controller use can not open excel from data entry – the open button is grey, or the when they click on the excel icon, the excel crash with error like this:

Unable to cast COM object of type ‘Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Excel._Application’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D5-0000-0000-C000-000000000046}’ failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155).

Solution:

Restart the laptop and reinstall Microsoft Office is the solution.

 

 

More Information:

https://www.ibm.com/support/pages/user-not-automatically-logged-excel-link-when-using-controller-client-excel-based-functionality-example-data-entry-leading-security-error-1-errors 

https://www.ibm.com/support/pages/troubleshooting-user-not-automatically-logged-excel-link-when-launching-functionality-main-controller-program-ccrexe

https://www.ibm.com/support/pages/user-not-automatically-logged-excel-link-when-launching-functionality-main-controller-program-caused-corrupt-xuser-table 

https://www.ibm.com/support/pages/open-button-greyed-out-intermittently-cannot-open-any-data-entry-forms 

https://www.ibm.com/support/pages/troubleshooting-interface-not-registered-exception-hresult-0x80040155-when-trying-use-data-entry-reported-values 

https://www.ibm.com/support/pages/unable-cast-com-object-type-queryinterface-call-com-component-interface-not-registered-0x80040155-error-launching-excel-link-controller-caused-orphan-registry-key

Product:
Microsoft SQL server

Cognos Controller 11.0.1

Issue:

Open account define take long time to open – can it be that we need to index the database?

If the issue is only for one user – please ask that user to inside cognos controller client run “clear local cache”, to see if it helps.

Check if you move the user to a diffrent subnet, e.g. move from LAN to WIFI at the office, does it help?

Does it help to run it over VPN to the office?

If the issue is for all users, but on a specific network, it can be a windows group policy to the client computer that give the issue.

Create a ticket to your IT department, and ask them to check intune policy and firewall and network, when you reproduce the issue.

 

Solution:

Enter below script in SSMS for your cognos controller SQL server database, to check when it was last updated:

• SELECT *,
• STATS_DATE(object_id, stats_id) AS LastStatsUpdate
• FROM sys.stats
• WHERE left(name,4) = ‘NC_X’ order by laststatsupdate

 

Below SQL script will list the size of the tables in the database:

 

;with cte as ( 
SELECT 
t.name as TableName, 
SUM (s.used_page_count) as used_pages_count, 
SUM (CASE 
WHEN (i.index_id < 2) THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count) 
ELSE lob_used_page_count + row_overflow_used_page_count 
END) as pages 
FROM sys.dm_db_partition_stats AS s 
JOIN sys.tables AS t ON s.object_id = t.object_id 
JOIN sys.indexes AS i ON i.[object_id] = t.[object_id] AND s.index_id = i.index_id 
GROUP BY t.name 
) 
,cte2 as(select 
cte.TableName, 
(cte.pages * 8.) as TableSizeInKB, 
((CASE WHEN cte.used_pages_count > cte.pages 
THEN cte.used_pages_count - cte.pages 
ELSE 0 
END) * 8.) as IndexSizeInKB 
from cte 
) 
select TableName,TableSizeInKB,IndexSizeInKB, 
case when (TableSizeInKB+IndexSizeInKB)>1024*1024 
then cast((TableSizeInKB+IndexSizeInKB)/1024*1024 as varchar)+'GB' 
when (TableSizeInKB+IndexSizeInKB)>1024 
then cast((TableSizeInKB+IndexSizeInKB)/1024 as varchar)+'MB' 
else cast((TableSizeInKB+IndexSizeInKB) as varchar)+'KB' end [TableSizeIn+IndexSizeIn] 
from cte2 
order by 2 desc

If it is a SQL Index issue, then normally all cognos controller users are affected.

 

More information:

https://www.ibm.com/support/pages/suddenly-slow-example-3-minutes-compared-10-seconds-open-data-entry-form-even-if-only-one-user-active-caused-out-date-statistics

https://www.ibm.com/support/pages/xdbaudit-database-table-used-auditing-instead-xdbtrickle-controller-102-onwards

Manually purge the ‘xdbaudit’ table from audit information by performing the following steps:
1. Obtain a short period of downtime (no other users on the system)
2. Logon to Controller as an administrator
3. Click “Maintain – User- Single Mode”
4. Click “Maintain – System Audit Log – Configuration”
5. Choose how recent the audit data they wish to keep
6. Enter that chosen value (for example ’30’) into the section “Delete Data change details older than (days)”:

7. Click “delete”.

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