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

ca11 error3

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.

ca11 error2
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:

ca11 error1

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:
Cognos Planning 10.2.1 PLANADMIN_version=PLANADMIN-AW32-ML-RTM-10.2.1000.1-0
Microsoft Windows 2016
Microsoft SQL 2016 server

Issue:
Can not start Cognos Planning client programs on new computer where the new Client software is installed for Cognos Planning.

Download cognos planning from here:
http://www-01.ibm.com/support/docview.wss?uid=swg24043953

Error message:

A fatal error has occured in the startup section of the application.

The application will be terminated.

Please report the following information:
Section: Message Init
Could not create or read file:  c:\program files (x86)\ibm\cognos\c10\bin\Language\English\MESSAGES.AMC

ep1

ep2

Solution:
The user that start the planning programs first time, they need to have write access to the folder where the program is installed. Because the program will create a file called MESSAGES.AMC.

On the client computer go to the folder c:\program files (x86)\ibm\cognos\c10 and right click.
Select Properties.
Select Security tab.
Select Users in list and click Edit.
Select Users and click in Modify at the Allow column.
Click OK.
Click OK.

This should give all users on that computer write access to the folder C10, try to start your Cognos Configuration or Cognos 10 Planning Analyst program again.

More info:
http://www-01.ibm.com/support/docview.wss?uid=swg21635667

Product:
Planning Analytics 2.0.4 (TM1)
Microsoft Windows 2016 server

Problem:
TM1 Architect is connecting the TM1 applications on the wrong network card on the Microsoft Windows server.

Possible solution:
The default network card with the lowest metric value is selected from all network cards to be the default network card. Use Get-NetIPInterface to see metrics.

Start Powershell on the Windows server
Enter: Get-NetIPInterface
This will list the network interfaces on the server.
Check the value for ifIndex and InterfaceMetric (A low value indicates a higher priority.)
The card with lowest value for InterfaceMetric will be used by TM1.
Is this the correct one? or is it for a backup network?

ifIndex InterfaceAlias AddressFamily NlMtu(Bytes) InterfaceMetric Dhcp ConnectionState PolicyStore
——- ————– ————- ———— ————— —- ————— ———–
18 Ethernet 2 IPv6 2800 20 Enabled Connected ActiveStore
1 Loopback Pseudo-Interface 1 IPv6 4294967295 50 Disabled Connected ActiveStore
18 Ethernet 2 IPv4 2800 20 Disabled Connected ActiveStore
12 Ethernet IPv4 1500 10 Enabled Connected ActiveStore
1 Loopback Pseudo-Interface 1 IPv4 4294967295 50 Disabled Connected ActiveStore

Change with Set-NetIPInterface, for example:
Set-NetIPInterface -InterfaceIndex -InterfaceMetric
Example
Set-NetIPInterface -InterfaceIndex 12 -InterfaceMetric 50
Set-NetIPInterface -InterfaceIndex 18 -InterfaceMetric 10
Above will make card 18 to be the new default.
Check the ip address of the card by enter IPCONFIG
Ethernet adapter Ethernet 2:

Connection-specific DNS Suffix . :
Link-local IPv6 Address . . . . . : fe80::a8cd:d4c4:120e:3ed1%18
Autoconfiguration IPv4 Address. . : 169.254.62.209
Subnet Mask . . . . . . . . . . . : 255.255.0.0
Default Gateway . . . . . . . . . : 25.255.255.254

Start TM1 Architect
Expand an TM1 application
See in the right side the IP address that will be used.

More information:
https://docs.microsoft.com/en-us/windows-server/networking/technologies/network-subsystem/net-sub-interface-metric
https://social.technet.microsoft.com/Forums/windows/en-US/cb8dac7f-5f04-42b1-8065-a95c946f6ec2/change-network-adapter-priority-order?forum=ws2016

Product:
Cognos Controller 10.3.1 (version 10.3.1100.166)
Cognos Analytics 11.0.8.11
Microsoft Windows 2012 R2 Server

Problem:
After upgrade of Cognos Controller Client on Citrix server, the help menu does not work.

Error message:
Error Launching menu item “Help”.
Could not find a part of the path ‘c:\program files (x86)\IBM\IBM Cognos Controller\ctrl_ug_fapug_contectlinks.csv’.
at system.Net.FileWebRequest.EndGetResponse(IAsyncResultasyncResult) at…

Possible solution:
The file ccr.exe.config contain the wrong path. Open C:\Program Files\ibm\IBM Cognos Controller Local Client\ccr.exe.config in notepad.
Change the value

<add key=”CASUrl” value=”C:\Program Files (x86)\IBM\IBM Cognos Controller\”/>

to

<add key=”CASUrl” value=”C:\Program Files\ibm\IBM Cognos Controller Local Client\”/>

Save the file and try again.
Check also that <add key=”HelpUrl” value=”http://www.ibm.com/support/knowledgecenter“/>  point to the correct web address.

Example of the ccr.exe.config file:

<?xml version=”1.0″ encoding=”utf-8″?>
<!–
IBM SOURCE CODE HEADER START
# =====================================================================
# IBM Confidential
#
# OCO Source Materials
#
# IBM Cognos Products: ccr
#
# (C) Copyright IBM Corp. 2004, 2014
#
# The source code for this program is not published or otherwise
# divested of its trade secrets, irrespective of what has been
# deposited with the U.S. Copyright Office.
# =====================================================================
# IBM SOURCE CODE HEADER END
–>
<configuration>

<configSections>
<sectionGroup name=”profile”>
<section name=”Settings” type=”System.Configuration.NameValueSectionHandler, System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, Custom=null”/>
</sectionGroup>
<section name=”log4net” type=”log4net.Config.Log4NetConfigurationSectionHandler, log4net” requirePermission=”false”/>
</configSections>
<profile>
<Settings>
<add key=”SelectDb” value=”true”/>
<add key=”Language” value=”2057″/>
<add key=”CASUrl” value=”C:\Program Files\IBM\IBM Cognos Controller Local Client\”/>
<add key=”WSSUrl” value=”http://servername/ibmcognos/controllerserver”/>
<add key=”HelpUrl” value=”http://www.ibm.com/support/knowledgecenter”/>
<add key=”InstallExcelLink” value=”false”/>
<add key=”CacheDir” value=””/>
</Settings>
</profile>
<system.web>
<webServices>
<soapExtensionTypes>
<add type=”ClientExtension, ControllerExtension” priority=”0″ group=”0″/>
</soapExtensionTypes>
</webServices>
</system.web>

<log4net>
<root>
<level value=”ERROR”/>
<appender-ref ref=”CCRClient”/>
</root>
<appender name=”CCRClient” type=”log4net.Appender.FileAppender”>
<staticLogFileName value=”false”/>
<file type=”log4net.Util.PatternString”>
<conversionPattern value=”${LOCALAPPDATA}\CCRClientLogs\%date{MM_dd_yyyy}.txt”/>
</file>
<appendToFile value=”true”/>
<layout type=”log4net.Layout.PatternLayout”>
<conversionPattern value=”%date %-5level %logger – %message%newline”/>
</layout>
</appender>
</log4net>

</configuration>
Then in the users profile, check the same values are correct, in the file /appdata/roaming/cognos/ccr/ccr.config.

Product:
Cognos Planning Analytics Workspace version 30
Microsoft Windows 2016 Server

Problem:
In a Planning Analytics (TM1) environment where native security is used, you get a error when you try to add content to workspace from the PA databases on left side of screen.

Error Message:
unable to fetch data for content tree. Session can not be established for server: BUDGET 401 (Unauthorized) (“errorMessage”.””.”query”.”https://…..

Possible Solution:
Log out from Workspace
Go into TM1 Architect.
Set a password for all users, do not use blank (empty) as a password. That will not work for workspace. Also ensure that the ADMIN account have a password like apple.

After the user have a password set, exit TM1 Architect and surf to Planning Analytics Workspace again.

Product:
Planning Analytics 2.0.4 on Microsoft Windows 2012 server
Planning Analytics Workspace 30 on Linux server
Cognos Analytics 11.0.9 on Microsoft Windows 2012 server

Issue:
https://www.ibm.com/communities/analytics/cognos-analytics-blog/cognos-analytics-and-planning-analytics-integration-walkthrough-part-2/
Have setup PA with SSO to CA11 as above link, but when a user surf from Internet Explorer to PAW at address http://pawservername.domain.com/ –  the user end up logged into the CA11 portal (cognos connection) instead of the PAW page.

Solution:
Start PUTTY and login to the Linux server
Enter sudo -su to a root user.
Go to the ../paw folder.
Go to the /paw/config folder.
Enter more paw.env  to see the settings used in Planning Analytics Administration Tool listed on screen. They are saved to this file paw.env
Enter nano paw.env  to be able to edit the file.
Change the IBM Cognos BI Gateway URI and IBM Cognos BI Dispatcher URI fields, to both end with /bi/v1/disp

pawsso

Two lines in paw.env should look like this;
export IBMCognosGatewayURL=”http://caservername.domain.com:80/ibmcognos/bi/v1/disp”
export IBMCognosServlet=”http://caservername.domain.com:9300/bi/v1/disp”

Press CTRL+X to exit the NANO editor in linux.
Press Y to save the changes to paw.env file.

In the paw/scripts folder enter ./paw.sh down  to stop the PAW services.
In the paw/scripts folder enter ./paw.sh to load the PAW services again.
In the paw/scripts folder enter ./paw.sh start  to start the PAW services.
Wait 10 minutes.
Surf to http://pawservername.domain.com  to test if it works.

This change can also be done in the Planning Analytics Administration Tool, but then you first need to turn off SSO in IIS and change to security mode 1 in tm1s.cfg file.

More Information:
https://www.ibm.com/communities/analytics/cognos-analytics-blog/cognosanalytics-and-planninganalytics-integration-walkthrough-part-3/

Product:
Planning Analytics Workspace 2.0.4
Microsoft Windows 2016 server

Issue:
When starting the PAW administration tool you get a error when updating settings.

Error Message:
Failed to fetch the status. Ensure the Administration tool is running.

If you from a power shell prompt test the installation by running the command ./paw.ps1 ( from folder d:\install\paw\scripts\) you get this error:

Error: for pa-gateway Cannot start service pa-gateway: failed to create endpoint pa-gateway on network NAT. HNS failed with error: The object already exist.
Encountered errors while bringing up the project.
Execution failed with exit code 1.

Troubleshoot:
Use the scripts/paw.ps1 script instead of Administration tool from power shell prompt.
Enter scripts/paw.ps1 to ensure all services are running and up-to-date.
Enter scripts/paw.ps1 ps to see status of all services.

Above may show that you have a pa-gateway already running.
Check that no other application is using port 80 and 443.
Start IE on the server and surf to http://localhost/ – what does that give?

Stop all PAW with scripts/paw.ps1 down
Then start it again with scripts/paw.ps1

Did it help?

Enter docker ps -a to see all running containers. Any duplicates?
Then to remove a container enter docker stop <container-id> ; then docker rm <container-id>.

Check the log files in folder D:\install\paw\log\pa-gateway\error.log
If you see this; AH00558: httpd.exe: Could not reliably determine the server’s fully qualified domain name, using fe80::5db7:f898:8a1:858c. Set the ‘ServerName’ directive globally to suppress this message. Then that is nothing to be concerned about.

To remove installation of PAW on Microsoft Windows 2016 do this steps in paw folder:
scripts/paw.ps1 stop
scripts/paw.ps1 rm -v
docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
…after that you can install again with ./Start.ps1

You can recreate the docker network with below commands (try this first):
Stop the docker service: stop-service docker
Make sure the hns service is running: start-service hns
Now run this PowerShell command: get-containernetwork | remove-containernetwork
Start the docker service again: start-service docker

If it still doesn’t work, you can also try the same steps except with get-netnat | remove-netnat:

Stop the docker service: stop-service docker
Make sure the hns service is running: start-service hns
Now run this PowerShell command: get-netnat | remove-netnat
Start the docker service again: start-service docker

After that is done, go to the d:\install\paw\scripts folder in power shell.
Start the PAW with ./paw.ps1 start.

Check the file D:\install\paw\config\paw.ps1 contain the values you have set in the administration tool before. Should look similar to this;
# paw.ps1 file generated by the Administration Tool
$env:TM1Location=”https://labwin2012ca.lab.local:5898″
$env:TM1ApplicationsLocation=”http://labwin2012ca.lab.local:9510″
$env:PAAuthMode=”tm1basic”
$env:TM1LoginServerURL=”https://labwin2012ca.lab.local:8010″

Surf to servername to see if paw is working e.g.  http://labwin2012ca.lab.local/

To get more detail debug info on screen,
stop the docker service.
Run the Docker daemon in debug mode:
C:\Program Files\Docker\dockerd -D

More Information:

https://github.com/MicrosoftDocs/Virtualization-Documentation/issues/529#issuecomment-310236487

https://docs.docker.com/v17.09/engine/userguide/networking/

https://docs.docker.com/config/daemon/

https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_parametersinthetm1s.cfgfile_n1503fe.html

 

Product:
Cognos Analytics 11.0.10
Microsoft Windows 2016 Server

Issue:
When you try to install the ExternalDiskCache_amd64_en-US.msi you get a error.

Error Message:
IIS version 7.0 or greater is required to install Microsoft External Cache Version 1 for IIS 7

Workaround:
You can resolve this problem by modifying registry.

Open run dialog and enter regedit, to open the Registry Editor.
Find MajorVersion in the path: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\InetStp and HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W3SVC\Parameters.
Open the value MajorVersion and select Decimal radiobutton.
Change Its value from 10 to 9.
Click OK.

After finishing the steps above, you can install External Disk Cache and Microsoft Web Farm Framework successfully.

You can also try download a new version from here
https://blogs.iis.net/iisoobs

More Information
https://docs.microsoft.com/en-us/iis/extensions/installing-application-request-routing-arr/install-application-request-routing-version-2
http://www-01.ibm.com/support/docview.wss?uid=swg22000097