Product:
Cognos Analytics 11.0.12
Microsoft Windows Server 2016

Problem:
After a reboot the Cognos BI Service does not start.

Error message in Cognos Configuration:
CFG-ERR-0103 Unable to start IBM Cognos service. Execution of the external process returns an error code value of ‘-1’.

Error message in Windows services when starting is that the password is wrong.

Possible solution:
A group policy have removed the service account for Cognos, from the local windows policy:
“Log on as a Service”. Add the Cognos windows service account back to the group.
Go to control panel – administration tools
Go to Local Security Policy
Expand Security settings – Local Policies – User Rights Assignment.
Click on Log on as a service.
Click Add user or group.
Add your user, and click OK all the way.

or you can enter the password again, then it will be automatically added to the group.

More Information:

https://www-01.ibm.com/support/docview.wss?uid=swg22002530

Product:
Cognos Analytics 11.0.12
Microsoft Windows Server 2016
Oracle 12 Database

Issue:
After changing the IBM Cognos service to use a windows service account instead of local system, the Cognos Analytics service does not start.

Error Message:
15:42:12, ‘LogService’, ‘StartService’, ‘FAILED’.
15:42:12, ‘LogService’, ‘StartService’, ‘Success’.
15:42:12, CAF-WRN-0010 CAF input validation enabled.
15:42:12, CAF-WRN-0021 CAF Third Party XSS checking disabled.
15:42:17, ‘ContentManager’, ‘getActiveContentManager’, ‘Failure’.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.
15:42:17, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5036 Content Manager failed to connect to the content store. The connection string is “jdbc:oracle:thin:@servername.domain.com:1521/instancename.domain.com”. The error encountered is: “ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified ” Cause: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified Stack trace: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

Solution:
Change the region settings on the server for the Service account to English (United States).

More Information:
The Oracle driver have a NLS setting in registry, the windows region setting need to match this value to make the Cognos service to start.

Start REGEDIT and go to [HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraClient12Home1] check there the value “NLS_LANG”=”AMERICAN_AMERICA.WE8MSWIN1252”.

http://www.dba-oracle.com/t_ora_12705_resolution.htm

Product:
Cognos Analytics 11.0.12  (kit_version=11.0.12.18062512)
Microsoft Windows Server 2016

Problem:
When in Cognos Connection you go to Administration console. Click on system in left column to have a view of the system health. You get a error instead of the Metrics-system tab.

Error Message:
SOAPFaultException
PRS-TRS-0902 The “XSLT” transform instruction encountered an error while processing the source at location “/cogadmin/transforms/gen-ui-markup/metrics.xslt”.
PF-COM-6204 The complete error has been logged.

Possible cause:
After replace the oracle driver in folder C:\Program Files\ibm\cognos\analytics\drivers to ojdbc7.jar file, the restart of the servers was not done correct.

Solution:
Restart the content manager server first.
Wait to it is finish.
Then restart the other CA (BI REPORT) servers.
Wait until they all are up.

More information:
http://www-01.ibm.com/support/docview.wss?uid=ibm10726007
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_databaseconnectivityforcontentstore_stepsfororacle.html#DatabaseConnectivityforContentStore_StepsforOracle

Product:
Cognos Analytics 11.0.7
Microsoft Windows 2012 server

Issue:
When you surf to Cognos Connection in a new setup of CA11 you get different error messages

Surf to: https://servername.domain.com/ibmcognos
Error: This page cant be displayed
Make sure the web address is correct
Look for the page with your search engine
Refresh the page in a few minutes

Surf to: https://servername.domain.com/ibmcognos/ibmcognos/ibmcognos
Error: server error in /ibmcognos application
the length of the URL for this request exceeds the configured maxUrlLength value.

Surf to: http://servername.domain.com/ibmcognos/bi/
Error: The website declined to show this webpage
Most likely causes:
This website requires you to log in

Surf to: https://servername.domain.com/ibmcognos/bi
Error: A blank page in Internet Explorer

Solution:
Go to Internet Information Services Manager
Check if you have set a HTTP redirect on the default web site, remove and try again.
Check if you have bindings on the default web page, if HTTPS is setup to a specific server name. Try with HTTPS set to a blank host name in the IIS Site binding setting.
Check if you have marked Require SSL for the Default Web Site, in IIS.

Product:
Cognos Analytics 11.0.12 Framework Manager
Microsoft Windows 2012 server

Problem:
When connecting to the Cognos Gateway from Framework Manager, you get an error after login.

Error message:
Script Error
An error has occurred in the script on this page
Line: 43
Char: 3
Error: ‘requirejs’ is undefined
Code: 0
URL: https//caservername.domain.com/ibmcognos/bi?b_action=xts.run&m=portal/ close.xts
Do you want to continue running scripts on this page?

Possible solution:
If SSO is enabled, and the client computer is in a different domain than the server computer, you can get similar errors. Turn off SSO on the IIS server and try again.

If SSO was enabled while running the script tool to setup IIS for CA11, you can disabled it again in IIS Manager. During the execution of the tool, SSO is configured. To disabled it, perform the following:
1. Open IIS Manager.
2. Expand the web site and alias that was created.
3. Single click on the bi folder.
4. Click on URL Rewrite.
5. Find SSO Login. Single click on it and on the right hand action pane, click on disabled Rule.
6. Find Legacy SSO. Single click on it and on the right hand action pane, click on disabled Rule.

Can also be that you have enter the wrong URI for the gateway inside Cognos Configuration for Framework Manager.
Update Gateway URI to be https://caservername.domain.com:443/ibmcognos/bi/v1/disp
Save and try again.

More information:

http://www-01.ibm.com/support/docview.wss?uid=swg22000097

Product:
Cognos Analytics 10.0.12 Framework Manager
Microsoft Windows 2012 server

Problem:
Error when importing certificate file to cognos keystore with IKEYMAN.EXE.

You have setup SSL to the IIS server for the Cognos gateway. To be able to connect with client tools you import certs to cognos keystore.

Go to folder C:\Program Files (x86)\ibm\cognos\model\jre\bin
Click on IKEYMAN.EXE to start the program
Open the certificate store file from folder C:\Program Files (x86)\ibm\cognos\model\configuration\certs
Enter the password
Click Import to import your certificate file
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_pa_use_ibmkeymgmt.html

Error message:
An IO exception has occurred
DER input, integer tag error

Solution:
The format of the certificate is wrong, please try a pfx file instead.

Error message:
An IO exception has occurred
invalid keystore format

Solution:
Wrong format selected when you open the file, please try PKSC12 instead.

More information:
https://www-01.ibm.com/support/docview.wss?uid=swg21339658

Product:
Cognos Analytics 11.0.10
Microsoft Windows Server 2016

Issue:
When you try to insert a picture in a report, I get a error that WebDAV is missing.

Possible Workaround:
Enter the path and name of the picture direct in the dialog.
Enter ../samples/images/alex_active.png

The pictures have moved to C:\Program Files\ibm\cognos\analytics\webcontent\bi\samples\images
from previous folder C:\Program Files\ibm\cognos\c10_64\webcontent\samples\images.

Start File Manager and check where the pictures are stored on your server. Copy any company pictures to a common folder that is accessible from the web.

Install webdav:
http://www-01.ibm.com/support/docview.wss?uid=swg22002398
More Information:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_frmat_rep_insert_graphics.html
The webdav only works on the IIS server:

http://www-01.ibm.com/support/docview.wss?uid=swg21984684

Product:
Cognos Analytics 11.0.x
Microsoft Windows Server 2012 R2

Issue:
Before a upgrade, got a error, when doing a Export of Content in Cognos Connection.
This is in a multiserver Cognos BI setup, where there are more than one CM (Content Manager) server – that as best practice are setup to share a file share folder for deployments.

Error messages:
CM-CFG-5081 The deployment folder does not exist in the file system.

Possible solution:
Login to the active Content Manager server.

Check in Cognos Configuration, that Environment – Deployment files location : point to ../deployment. If it points to a file share like \\servername\deployment, then you need to check that the windows services IBM Cognos is run by is a Windows user and not Local System.
Access to file shares is only possible when the IBM Cognos services is run by a Active Directory user account (a service account). If you use local system, then the cognos program can not access file shares on other servers.

Change to ../deployment.
Save and restart the services from inside Cognos Configuration.
Test to run the export again.

Check in folder c:\program files\ibm\cognos\analytics\deployment that the file exists.

Product:
Cognos Analytics 11.0.12 kit_version=11.0.12.18062512
Microsoft Windows Server 2012 R2 (Windows NT 6.2)

Issue:
After upgrade of CA11, when you save the Cognos Configuration you get a error message.
This is in a multi server installation, and this can happen if the Cognos services are started in the wrong order.

Error message:

Solution:
Reset the certificates on the server where you have the error.

1. Stop the running of your cognos service in Cognos Configuration.
2. On the Content Manager computer, click ‘File > Export As’. (and the other cognos servers)
3. Choose ‘Yes’ at the prompt and save the file. For example, name it ‘backup.xml’ which will be stored in the c11\configuration folder.
4. Close Cognos Configuration.
5. On the Content Manager computer, create a backup of the following files and directories before moving them to a different, secure location (as during the cryptographic keys regeneration process they will be re-created):

The files are:
c:/program files/ibm/cognos/analytics/configuration/cogstartup.xml
c:/program files/ibm/cognos/analytics/configuration/caSerial
c:/program files/ibm/cognos/analytics/configuration/certs/CAMCrypto.status
c:/program files/ibm/cognos/analytics/configuration/certs/CAMKeystore
c:/program files/ibm/cognos/analytics/configuration/certs/CAMKeystore.lock
c:/program files/ibm/cognos/analytics/temp/cam/freshness

The directory is
c:/program files/ibm/cognos/analytics/configuration/csk

6. In the c11\configuration folder, rename ‘backup.xml’ to ‘cogstartup.xml’.
7. Open Cognos Configuration, save the configuration and start the services.

8. Repeat steps 1-7 on all computers that have Cognos Analytics Server components installed.
If needed – if it is only one CA11 that have issues, start with only change on that server.

You can surf to http://ca11cm_servername:9300/p2pd/servlet to see if the CM is up.

Text is from this website:
http://www-01.ibm.com/support/docview.wss?uid=swg21995088

How to upgrade CA11

http://www-01.ibm.com/support/docview.wss?uid=swg21994915

Product:
Planning Analytics 2.0.3 (Tm1)
Cognos Analytics 11.0.9 (Cognos BI)
Microsoft Windows 2012 R2 Server

Issue:
When a user is added to a AD group, that then is added to Cognos group, and the Cognos Group is added in the TM1 application as a group. And that group is given access to cubes and dimensions inside TM1. When user login to TM1WEB, he can not see the cubes.
If you look inside TM1 Architect, there is no X for him under the Cognos\group. So Cognos have not understand that he belongs to a AD group.

Solution:
IBM Cognos service run as local system in Windows server.
The Active Directory is setup to allow user to login but not to see other users details, like groups.

You need to at Namespace – Resource Properties – Binding credentials enter the name and password of a user that have the rights to READ the Active Directory and see what groups a user belongs to.

When you right click on namespace in cognos configuration and select test, you will first validate the user and there after try to get a list of the groups the user belongs to.

You need the binding credentials if AD is not configured to allow anonymous bind.

In TM1 you can add the Cognos group or the AD group direct into TM1 Architect under security – client/groups. Click on Groups and Add New Group. Click on your namespace and search for the group you want to add. When it is added it will look similar, as in the picture above.
If a user is successful to login and belongs to a group, there will be a X under that group for that user. User AD/roger can we see belongs to the Cognos group “TM1 users”.

Then you have to, inside your TM1 application, give the groups the access they need to the different cubes and dimensions.

More Information:
https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.inst_cr_winux.10.2.2.doc/t_inst_activedirectoryserver_process.html

https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_dg_dvlpr.10.2.2.doc/c_controllingaccesstotm1objects_n60007.html

https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.3.0/com.ibm.swg.ba.cognos.prfmdl_ug.10.3.0.doc/c_prfmdl_setting_up_security.html