Product:

Cognos Controller 10.4.2
Microsoft Excel 2013
Microsoft Windows 2019 server

Issue:

Data entry does not work in Cognos Controller Client for a few users on the Citrix platform.

Error message:

ControllerForms12 … Object variable or With block variable Object reference not set … ActivateDataEntryForm…

Error launching menu item “Controller Link”

Unable to get the FullName property of the addin class at System.Runtime.Type.ForwardCallToInvokeMember .. a WrapperTypes.

Suggested solution:

Open Excel that is used with Cognos Controller for the user who have issues.

Go to Options – Add-ins, click on the Go button at the bottom for Excel Add-Ins.

Uncheck the link for “Cognos Controller Link for Microsoft Excel” add-in, press OK, and exit excel.
Log off Citrix session and log off Citrix Connection Center.
Log out from your computer and log in again.
Start Excel in Citrix as before.

Go to Options – Add-ins – Go button for Excel Add-ins.

Click on Browse

Find C:\Program Files\ibm\IBM Cognos Controller Local Client\adxloader.Controller.ExcelLink.dll
Click Open.
On question that “a file named C:\Program Files\ibm\IBM Cognos Controller Local Client\adxloader.Controller.ExcelLink.dll  already exists in this location. Do you want to replace it?” Click YES.
Remove any other add in, that can interfere, like Thinkcell.
Click OK
Exit Excel.

Start Cognos Controller client and try again.

Ensure the user have the same version of Excel on Citrix as on other Citrix servers or on her laptop.

More Information:

https://www.ibm.com/support/pages/apar/PI49914

https://www.ibm.com/support/pages/unable-get-fullname-property-addin-class-when-attempting-log-controller-link-within-controller 

https://www.ibm.com/support/pages/standard-error-controllerforms-openworkbook-object-reference-not-set-when-opening-or-switching-between-data-entry-forms

https://www.ibm.com/support/pages/standard-error-number-5-server-was-unable-process-request-different-menu-items

Product:
Cognos Controller Web 10.4.2
Microsoft Windows 2019 server

Issue:

After applied a DNS alias to the Cognos Controller server, the users can not login to the Controller Web.

They get a error like Server is not reachable or still initializing, please refresh the page in a few seconds

Solution:

You must update the D:\Program\ibm\cognos\ccr_64\frontend\config.js file with the URL the end user will use to access Cognos Controller Web.

If you change it from a server-name to a DNS alias, then open config.js in notepad++

 //Details for Controller UI service 
"expressJs": {
"host": "cognoscontroller.domain.com", //interface used by Controller Web UI Service
"port": "9080", //port used by Controller Web UI Service
"options": {

Change the interface value to your DNS alias. The controller web backend connection at line 14 can be left with the server host name.

Save the file.

Restart the 3 Controller web services.

More Information:

https://www.ibm.com/support/pages/troubleshooting-server-not-reachable-or-still-initializing-please-refresh-page-few-seconds-error-launching-controller-web

Product:
Cognos Controller 10.4.2
Microsoft Windows 2019 server

Issue:
After upgrade of Cognos Controller to a new version, the users get a error message when they start Cognos Controller Client program.

“The version of Controller requires database version 992.”

Solution:

Wait for the IT department to upgrade the Cognos Controller Client installation on the Citrix server you are using. Cognos Controller 10.4.2 use database version 1010.

More Information:

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

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

Product:
Cognos Controller 10.4.2
Microsoft Windows 2019 server

Issue:
When you login to cognos controller client, you get a error message of this kind;

Number: 76
Source: mscorlib
Description: Could not find a part of the path ‘C:\Users\nnnnn\AppData\Roaming\Cognos\CCR\ADMdb_cognoscontroller.local,1433CognosControllerdatabase’.
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.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc)

Suggested Solution:

Click OK to get past the error message, and still login to Cognos Controller Client program.

Clear the local cache by going to Maintain – Special Utilities – Clear Local Cache.

Close Cognos Controller program and try to login again. Did the error go away?

Can be garbage in the cache of files in folder C:\Users\nnnn\AppData\Roaming\Cognos\ccr, that are cleared by this action.

More Information:

https://www.ibm.com/support/pages/standard-error-76-could-not-find-part-path-when-launching-controller

Product:
Cognos Controller 10.4.2
Microsoft Windows 2019 server

Issue:
When open FAP.UDL file with DBCONV.exe program to upgrade the database you get a error.

ERROR: java.lang.NullPointerException

Possible solution:

The UDL file does not contain a password.

Copy the fap.uld file to folder D:\Program files\ibm\cognos\ccr_64\Data

Open the file in Cognos Controller configuration and add a password.

Click on test connection icon.

Click on arrow to start the Database conversion program.

Select FAP DB.

Click Connect.

Check if the numbers are different, then you need to click on Upgrade button.

Close the program.

Remove the fap.udl file from the \ibm\cognos\ccr_64\Data folder.

Also, ensure the SQLJDBC42.JAR file is in the folder D:\Program files\ibm\cognos\ccr_64

More Information:

https://www.ibm.com/support/pages/javalangunsupportedoperationexception-jre-version-16-error-when-using-database-conversion-utility-dbconv

https://www.ibm.com/support/pages/could-not-create-view-could-not-create-controller-type-failed-launch-javalangnullpointerexception-launching-java-related-functionality-caused-invalid-ccrjavahome-variable

Product:
Cognos Controller 10.4.2 if8 CONTRL_UPDATE_version=CCR-AW64-ML-RTM-10.4.2000.1064-0
Microsoft Windows 2016 server
Planning Analytics 2.0.9.11  TM1-AW64-ML-RTM-11.0.911.20-0

Issue:
After upgrade of TM1 (Planning Analytics) to a newer version than 2.0.9.4 then the Cognos Controller FAP does not work.
The FAP IP stop with a error.

The TM1ProcessError can be:

Cannot convert field number 17, value “123456” to a real number

Error: Data procedure line (0): 01004[Microsoft][ODBC SQL Server Driver]String data, right truncation

Solution:

Upgrade Cognos Controller software to a later version.

https://www.ibm.com/support/pages/download-ibm-cognos-controller-1042-if17

1. Install Controller 10.4.2 IF 17
2. Stop the Windows service of the TM1 server that is connected to FAP.
3. Stop the Windows service IBM Cognos FAP Service.
4. Manually delete the existing <…>MonthlyCompanyDetails_TextImportData TI process from inside TM1 Architect.
5. Start the Windows service of the TM1 server that is connected to FAP.
6. Start the Windows service IBM Cognos FAP Service.
7. Do a full FAP IP.

More information:

https://www.ibm.com/support/pages/cannot-run-ti-process-monthlycompanydetailstextimportdata

These errors occur because Planning Analytics 2.0.9.4 and later does not support FAP jobs with comments containing more than 2047 characters.  The existing <…>MonthlyCompanyDetails_TextImportData TI process that you upgraded from your previous TM1 environment does not adhere to this new limitation.

If you upgrade Planning Analytics 2.0.9, you must upgrade Cognos Controller 10.4.2 to a later version.

https://www.ibm.com/support/pages/how-upgrade-controller-1042x-later-interim-fix-if-fix-pack-patch-level

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

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

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

Product:
Cognos Controller 10.4.2
Microsoft Windows 2016 server

Issue:

We need to install a fix pack/interim fix to cognos controller – do we also need to upgrade the cognos controller client?

Suggested solution:

Do a test upgrade in your test environment, and see if the client works without upgrade the Cognos Controller client.

When you do a installation of a new version, you must upgrade the cognos controller client. But if you only install a Interim fix then the client installed can be used without upgrading.

Any fixes that are in the client side, like help – content issues, will not be solved.

Recommendation is to always upgrade the cognos controller client too.

Before installation we had in the client this version:

after installation we had this in cognos controller client – help – system info:

The client looks like it is working, but not any bugfixes that are in the Cognos Controller client code is not part of the solution.

Supported is to have both cognos controller client and cognos controller server at the same version.

You can check the version of cognos installed in the cmplst.txt file, often found in folder D:\Program Files\ibm\cognos\ccr_64

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

When doing a upgrade of cognos controller to a interimfix it is important that you;

Note down cognos controller configuration for report server URL.

Specifically, stop the following Windows services:

• IBM Cognos
• IBM Cognos Controller Batch Service
• IBM Cognos Controller Consolidation
• IBM Cognos Controller Java Proxy
• IBM Cognos Controller Reports
• IBM Cognos Controller Web
• IBM Cognos Controller Web Spreadsheet Service
• IBM Cognos Controller Web UI
• IBM Cognos FAP Service
• WWW service

Stop COM+ object for Cognos Controller.

Backup the controller web folder

D:\Program Files\ibm\cognos\ccr_64\fcmweb and D:\Program Files\ibm\cognos\ccr_64\frontend

Check that no JAVA processes is running, before you start the upgrade.

After upgrade, Cognos Controller Web need to be reconfigured.

More information:

https://www.ibm.com/support/pages/how-upgrade-controller-1042x-later-interim-fix-if-fix-pack-patch-level

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

Currently Supported Versions of Controller (incl. Interim Fixes):

https://www.ibm.com/support/pages/download-ibm-cognos-controller-1042-if17

https://www.ibm.com/support/pages/how-installupgrade-controller-serverclient

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

Product:

Cognos Controller 10.4.2

Microsoft Windows 2019 server

Issue:

At new installation, i after selection of database, in cognos controller client, are then stuck.

No more information.

Solution:

The cognos controller client uses port 80 to talk to the cognos controller server, but after the selection of database, it will if SSO is active, connect to Cognos BI to validate the user.

This happens on the port listed in Cognos Controller Configuration as Report Server.

If this is port 9300, then port 9300 need to be open in firewall between server and client. This is not the normal case.

You should instead change the Cognos Controller Configuration for Report server to use port 80.

Wrong line at report server:

http://caservername.domain.com:9300/bi/v1/disp

Correct line at report server:

http://caservername.domain.com/ibmcognos/bi/v1/disp

More information:

https://www.ibm.com/support/pages/controller-logon-window-does-not-appear-or-webpage-cannot-be-found-appears-after-selecting-database-caused-incorrect-report-server-settings

Product:

Cognos Controller Web 10.4.2

Microsoft Windows 2019 server

Issue:

Controller Web does not work.

When you check the log file in folder D:\Program\ibm\cognos\ccr_64\fcmweb\wlp\usr\servers\fcm.web\logs you see text like

2022-04-11 15:47:15 | | ERROR | [com.ibm.cognos.fcm.wmc.ccrws.DefaultCcrClientFactoryInitializer] CCR WS API not initialized yet [error=2 counts of InaccessibleWSDLException.
]. Retrying in 1000 ms…

Solution:

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

Open file com.ibm.cognos.fcm.web.properties in notepad++

Ensure that the ccrwsUrl=http://servername.domain.com/ibmcognos/controllerserver/ccrws.asmx points to the correct server.

More Information:

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

Product:

Cognos Controller 10.4.2
LICENSE_CONTROLLER_version=LICENSE_CONTROLLER-AW64-ML-RTM-10.4.2000.2-0
CONTRL_UPDATE_version=CCR-AW64-ML-RTM-10.4.2000.1098-0

Microsoft Windows 2016 Server

Microsoft  SQL server 2019

Issue:

After change in Windows Server for SQL database, to not allow TLS 1.0 and TLS 1.1 protocol the Cognos Controller and FAP program can not connect to the SQL database. You have not enabled HTTPS in Cognos Configuration, therefor Cognos is not using SSL to the clients.

Cognos Analytics who uses the SQLJDBC42.JAR driver, works fine.

Error message:

TM1.SQLAPI   08001[Microsoft][ODBC Driver 11 for SQL Server]SSL Provider: An existing connection was forcibly closed by the remote host.

TM1.SQLAPI   E16) Cannot connect to ODBC data source “ControllerDatabase”  08001[Microsoft][ODBC Driver 11 for SQL Server]SSL Provider: An existing connection was forcibly closed by the remote host.

Above error when you test the UDL connection to the SQL server.

Above error when you try to login to Cognos Controller.

Could not connect to database. Database CTRL blacklisted. It will be considered again in 20 minutes.
Client unable to establish connection
TCP Provider: An existing connection was forcibly closed by the remote host.

Solution:

Upgrade the SQLNCLI.MSI program to a later version.

Download a new SQL 2012 driver from Microsoft and install that in your Controller Windows server.
https://www.microsoft.com/en-us/download/details.aspx?id=50402

Also install same SQLNCLI.MSI driver on your TM1 server where you have the FAP service running.

Above is the working driver, you should download from Microsoft. Driver version 11.4.7001.0 is correct.

Go to the Control Panel on your Cognos Controller computer and check installed version of SQL 2012.

Above is the working version of SQL 2012 driver, if you not have it – you must install it for Cognos Controller.

Above drivers does not work when you have turned off TLS 1.0 and TLS 1.1, to the SQL server.

When you install the new SQL client, you need to stop IBM Cognos Controller Batch Service and IBM Cognos FAP Service. Otherwise you will be reminded as below.

More Information:

https://www.ibm.com/support/pages/sqlncli111-provider-not-registered-local-machine-when-testing-database-connection

https://docs.microsoft.com/en-us/answers/questions/28268/sql-native-client-110-support.html

https://www.ibm.com/support/pages/ssl-provider-error-0-existing-connection-was-forcibly-closed-remote-host-error-when-launching-controller-client

https://docs.microsoft.com/en-us/troubleshoot/windows-server/identity/apps-forcibly-closed-tls-connection-errors

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

https://www.ibm.com/support/pages/how-enable-ssl-https-cognos-controller

https://www.ibm.com/support/pages/how-configure-controller-use-tls-formerly-ssl-connect-microsoft-sql-database-transit-database-encryption