Product:
Cognos Controller 10.4.2
Microsoft Windows 2012 R2 Server

Issue:
In Cognos Controller the IBM license is for users and servers. The user part is divided in Administrators and Standard Users.  The limit is that the Standard Users should not have access to all the menu points on the Maintain menu. How do we set this up?

Solution:
Create a security group called ST = standard user, and limit access to menu items as shown below.

Then use this menu group as template when you create other menu security groups in Cognos Controller- if you want the data entry people only to have access to less number of menus.

Log into Cognos Controller Client as a administrator (ADM) user.

Go to maintain – rights – security groups.

Create a new security group, by click on new icon.

Name it ST, Standard User and scroll down to select all menu points that should be set to Not Available.

Then for each menu a standard user, should not see, you need to select it and click “Not Available”.

Important, that Jobs menu above is set to red “Not Available”.

Submission – Tasks – Define, is a new function for Cognos Controller, so if you upgrade from a old version of Cognos Controller this menu will be active and set to allow – giving that all your old users become Administrators. You need to go into Security Groups and set “Not Available” on this new functions (after a upgrade).

“Manage Active Users” can in some cases be allowed for a “Standard User”.

When all fields need are set to “Not Available” click save icon.

Now click on save as icon to create a new security group with this as base;

Give it a good name, and then select the menu points your data entry users should not see, and also mark them as Not Available.

Here you need to decide what menu point your different users groups need. Save the new group.

Then you go to Maintain – Rights – Users.
On each user go to limitations and select your new security group.

Click on Save icon.
Now it may be needed, that you run a optimization of the database for the changes to take affect.

Go to maintain – rights – reports and click on Generate (to get a License Management Report as PDF)

Save the pdf to a folder you can find.
Open the UserReport.pdf file in your Adobe reader or web browser.

Now you should have more standard active users in the report.

The information is also stored in a SLMT tag file for each database, in a unique folder for each database, on the Cognos Controller main server.

C:\Program Files\ibm\cognos\ccr_64\SLMTagData\UK, is the folder for the UK database.

Where you can see historical values from your Controller installation.

In folder C:\Program Files\ibm\cognos\ccr_64\swidtag you find the file that the ILMT tool should check to find what version of Cognos Controller you have installed.

 

More Information:
https://www.ibm.com/support/pages/controller-licensing-what-difference-between-administrator-and-non-administrator-user

http://public.dhe.ibm.com/software/passportadvantage/PA_Agreements/PA_Agreement_International_English.pdf

https://www.middlecon.se/vad-ar-ilmt-och-vem-behover-bry-sig/

https://www.ibm.com/support/pages/faq-what-does-internal-database-optimise-do-and-how-often-should-i-run-database-optimize

https://www.ibm.com/docs/en/cognos-controller/10.4.1?topic=environment-monitoring-license-usage

https://www-03.ibm.com/software/sla/sladb.nsf/lilookup/B2CD5F784772CDB08525860A0058085C?OpenDocument

Product:

Cognos Controller web 10.4.2
Microsoft Windows 2012 R2 server

Issue:
Upgrade of controller web to later version with SSO (CAM login), you get a error after you select the database in the controller web page.

Error message:

The website declined to show this webpage
Most Likely causes:
This website requires you to login.

This error (HTTP 403 Forbidden) means that Internet Explorer was able to connect to the website, but it does not have permission to view the webpage.

Solution:

The file D:\Program Files\ibm\cognos\analytics\templates\ps\portal\variables_CCRWeb.xml

may contain the wrong information.

Open variables_CCRWeb.xml in Notepad++

Change line <CRNenv c_cmd=”http://servername.domain.com:9080/fcm.web/#!/CamLogin”>

to

<CRNenv c_cmd=”http://servername.domain.com:9080/#!/CamLogin”>
<cookies>
<param name=”cam_passport”/>
</cookies>
</CRNenv>

The extra fcm.web is from the old version of Controller web.

Save the file again.

Restart the 3 Cognos Controller Web services.

Try to browse to http://servername.domain.com:9080/ to see if Controller Web works.

More Information:

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

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

https://www.ibm.com/support/pages/controller-web-does-not-fully-logout-authenticated-users-unless-web-browser-closed-using-cam-authentication

The log files for controller web is found in folders:

D:\Program Files\ibm\cognos\ccr_64\frontend\logs\fcmwebui-stdout.2021-04-23.log

D:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\usr\servers\fcm.web\logs\fcmweb-stdout.2021-04-23.log

Product:

Cognos Controller 10.4.2

Issue:

When run a standard report in Cognos Controller, and select PDF format, the report have a “adobe tools” menu on the right side.

Solution:

Press CTRL+H to hide it.
or
Click on the arrow (in yellow in above picture) .
or
Select  view – show/hide – tools.

 

More information:

https://helpx.adobe.com/acrobat/kb/disable-right-hand-pane-in-acrobat-reader.html

https://community.adobe.com/t5/acrobat-reader/how-do-i-remove-the-right-hand-pane-in-reader-dc-locked/td-p/7021654

Product:
Cognos Controller 10.4.2 FAP service
Microsoft Windows 2016 Server

Issue:
When doing a FAP IP, there is a error message in the process:

Can not update TM1 since data trickle table was purged while the TM1 server was down, try doing a new initial publish to solve problem

Possible Solution:
Login to the FAP client program.
In the Data Marts tab click on STOP after you have selected your active data-mart.

In the Sources tab select your active database, and click on STOP.

Then in Sources tab click on START, this will set the Last Purged Index to 0.
Go to the Data Marts tab and click on START.

Go to the Logs tab and check mark “Update Automatically”.
Wait 30 min, to see that the FAP process works without errors.

More Information:
If above does not work, then you need to do a reset of the tables as this article:

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

https://www.ibm.com/support/pages/can-not-update-tm1-data-trickle-table-was-purged-while-inside-fap-client

 

Product:
Cognos Controller 10.4.2
Microsoft SQL database server

Issue:
After a restore of a production database to a test environment, the users can not save anything from inside Cognos Controller client, in the test enviroment.

Error Message:

FrangoClient.fm.UserAndInstallationRights.SaveUser.FrangoClient….

Server was unable to precess request –> System.Exception: xbo….

 

Possible solution:
Check with the Database Administrator (DBA) if any thing have been done during the restore.

If the controller database index are dropped, then the users can not save from inside Cognos Controller.

Do a new restore of the Controller database and try again.

More information on restore of database:

https://www.ibm.com/support/pages/how-migrate-upgrade-upsize-existing-database-new-later-version-controller

Product:
Cognos Controller 10.4.2 if7
Microsoft Windows 2012 Server
Issue:
How create a MST file to my Cognos Controller Client installation?

Suggested Solution:
Download msi45sdk.msi from Microsoft, and install it. You will find C:\Program Files (x86)\Orca\orca.exe to use.

Copy the ccrlocalclient64.msi to an empty folder on your computer.
You find ccrlocalclient64.msi in folder C:\Program Files\ibm\cognos\ccr_64\webcontent\ccr
Start ORCA
Go File – Open and select your CCRLocalClient64.msi file.
Click Open.

To note the changes you do, you must first select Transform – New Transform


Scroll down to property, and on the right side click on WSSURL value field to update it with your Cognos Controller Server name.

Enter http://servername.domain.com/ibmcognos/controllerserver

To set that users should not be able to select database in controller client at login, instead use the database you have named “default”, add the property CHANGEDB

Right click on empty space and select Add Row

Click on the property row and enter the CHANGEDB word in the field below, as in picture.
Click on the value row and enter the value false.
When all values is filled in you click on OK button.

Go to Xmlfile

Right click on empty space and select Add Row

Fill in the values with this lines:

ModifySelectDb

[#CCR.exe.config]
/configuration/profile/Settings/add[\[]@key=’SelectDb'[\]]
value
[CHANGEDB]
0
CCR.exe.config.setup

Values inside [ ] are variables that is replaced with the property value.

Click OK button.

Go to Transform – Generate Transform

Select folder to save the mst file in. Enter a name and click Save.

Exit ORCA without saving changes to CCrLocalClient64.msi file.

Put the msi and mst file in the same folder, and enter this command from that folder:

msiexec /i CCRLocalClient64.msi TRANSFORMS=production.mst /qb

Above command will install Cognos Controller client with your parameters in the mst file.

To uninstall cognos controller client, you can use this command:

MsiExec.exe   /x  {E1A50832-9F0C-4CE1-9A55-AAD8BF8A7700}  /qb

The number E1A50832-9F0C-4CE1-9A55-AAD8BF8A7700 you find in the property – productcode.

This is for the registry value of the installation.

Exist in this places in Windows registry:

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\23805A1EC0F91EC4A955AA8DFBA87700]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\23805A1EC0F91EC4A955AA8DFBA87700\InstallProperties]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{E1A50832-9F0C-4CE1-9A55-AAD8BF8A7700}]

There is a different productcode for each version of Cognos Controller Client.

More information:

https://www.advancedinstaller.com/user-guide/msiexec.html

https://support.venafi.com/hc/en-us/articles/215911917-Error-Uninstall-an-MSI-and-msiexec-fails-asking-for-path-of-old-MSI

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

https://www.advancedinstaller.com/user-guide/win-sdk-tools.html

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

https://www.actualinstaller.com/articles/updater.html

Product:
Cognos Controller Web 10.4.2

Issue:
User can not enter the date in a form. See / instead of – for the date format.

Solution:
The date format is controlled by the Windows region settings in your laptop or on your citrix server.
Keep in mind that some date format is in the other order e.g. day-month-year can be month/day/year.

Go to control panel – region, to change the settings to Swedish if you want.

Other information:

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

Product:
Cognos Controller 10.4.2

Issue:
After change of SQL server to Cognos Controller, ERO reports does not work.

Error message:

Solution:
Ask the DBA to ensure that the SQL login (frango) you are using to the Controller database have the server roles: bulkadmin and public

You check what SQL login you are using in Cognos Controller Configuration.

 

More information:

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

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

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

Product:
Cognos Controller Web 10.4.2

Issue:
When open a period to work with you get this error

Invalid forms
There are invalid forms for Submission 1. Please check the form definition and process the form layouts or contact your administrator

Suggested solution:
Check a other period and company if that works.
Can be that this period contains forms that you do not use, like forms that do not contain any accounts, they will not work in controller web.

More information:

To open a company for submission click on the z icon.

https://www.advectas.com/sv/kunskapsbank/webinar-fa-ut-mer-av-cognos-controller-kom-igang-med-cognos-controller-web/