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

Product:
Planning Analytics 2.0.4
Planning Analytics Workspace 30
Microsoft Windows 2016 Server

Issue:
You have installed docker, but before you install PAW, you realize that you do not have the needed 50 GB of free space on C drive. How do I tell docker to create the images on the D drive?

Solution:
Create a folder d:\docker\images
Stop the docker service
Open Notepad and enter this
{
“data-root”: “d:\\docker\\images”
}
save the file as c:\programdata\docker\config\daemon.json

docker1 docker2
Start the docker service

Any previous created images in C:\ProgramData\docker\containers\ are not moved.

How Install Docker on Windows 2016 – Get Docker EE for Windows Server
Docker EE for Windows Server 2016 is simple to install.
1. Installation

Open a PowerShell command prompt, and type the following commands:

Install-Module DockerProvider -Force
Install-Package Docker -ProviderName DockerProvider -Force

2. Test your Docker EE Installation
Test your Docker EE installation by running the hello-world container:

PS> docker container run hello-world:nanoserver

Unable to find image ‘hello-world:nanoserver’ locally
nanoserver: Pulling from library/hello-world
bce2fbc256ea: Pull complete
3ac17e2e6106: Pull complete
8cac44e17f16: Pull complete
5e160e4d8db3: Pull complete
Digest: sha256:25eac12ba40f7591969085ab3fb9772e8a4307553c14ea72d0e6f98b2c8ced9d
Status: Downloaded newer image for hello-world:nanoserver

Hello from Docker!
This message shows that your installation appears to be working correctly.

Download a working docker-compose-Windows-x86_64.exe file;

Invoke-WebRequest "https://github.com/docker/compose/releases/download/1.21.0/docker-compose-Windows-x86_64.exe" -UseBasicParsing -OutFile $Env:ProgramFiles\docker\docker-compose.exe

Rename it to docker-compose.exe and copy it to the c:\program files\docker folder.

Then after a reboot of the Windows 2016 server, turn off your Anti-Virus software and start your PAW installation from a administrative powershell prompt with the command ./Start.ps1

More about docker:
https://blog.devmatter.com/docker-on-windows-server-2016-the-journey-begins/
https://sysinfo.io/ubuntu-16-04-move-docker-root/

https://docs.docker.com/compose/install/#install-compose

Product:
Planning Analytics 2.0.4
Planning Analytics Workspace 2.0.4
Microsoft Windows 2016 Server

Issue:
When you run Start.bat under Windows 2016 to install PAW you get a error.

Error message:
ERROR: The system was unable to find the specified registry key or value.
Install Docker Toolbox for Windows and try again.

Possible Solution:
You have follow this instructions to install Docker for Windows 2016.
https://docs.docker.com/install/windows/docker-ee/#install-docker-ee
But you have downloaded the wrong PAW file that is for Windows 2012 and try to install that.
Here how setup Windows 2012 with docker
https://docs.docker.com/docker-for-windows/install/
If you have the correct PAW file for Windows 2016 you should start a powershell file called Start.ps1.
Download the correct fileĀ ipa_workspace_local_win_2.0.30.228.6.zip from below link
http://www-01.ibm.com/support/docview.wss?uid=swg27049597

and from a powershell prompt enter ./Start.ps1 to install PAW.

Product:
Planning Analytics 2.0.4
Planning Analytics Workspace 2.0.4
Microsoft Windows 2016 Server

Issue:
When you in powershell run ./Start.ps1 from paw_2.0.4_win16_ml folder you get a error.

Error message:
unable to invoke ‘docker-compose’. Ensure docker-compose is installed and is on the PATH

Possible solution:
Check that the file docker-compose.exe exist in folder c:\program files\docker
Enter PATH at a DOS prompt to check that c:\program files\docker is part of your path string.
In a DOS prompt enter DOCKER-COMPOSE VERSION, do you get a message that
‘docker-compose’ is not a recognized as an internal or external command, operable program or batch file?
Go to the docker folder with command cd \program files\docker and try the DOCKER-COMPOSE again.
Same error, try enter DOCKER-COMPOSE.EXE. Does that work?
If you get a list of possible docker commands, it works.
But the DOCKER-COMPOSE.EXE file can be corrupt.
Erase the DOCKER-COMPOSE.EXE file and copy a new file to the docker folder.
Rename the new DOCKER-COMPOSE-Windows-x86_64.exe file to DOCKER-COMPOSE.EXE and try again to enter only DOCKER-COMPOSE.
If that works, and you get a list of commands, then the file was corrupt.
Please try ./Start.ps1 again from your powershell session.

Product:
Planning Analytics 2.0.4
Planning Analytics Workspace 30
Microsoft Windows 2016 Server

Issue:
When you validate settings in PA Workspace Administration Tool page you get a error for TM1 Application Server Gateway URI:

Error Message:
Error: getaddrinfo ENOTFOUND servername servername:9510

Possible Solution:
Port 9510 is not open in the local Windows Firewall on the server.
Go to Control Panel
Go to Windows Firewall
Go to Advanced Settings
Click on Inbound Rules
Click on New Rule
Select Port and click Next
At Specific local ports enter 80,443,9510,5495,5498,8888, 12345,12354,53333,5011,12346,8010 and click Next. The last port numbers depend on what you have set in your tm1s.cfg file.
Click Next at Allow the connection
Click Next when the rule apply for all (Domain, Private, Public)
Enter a name like Cognos TM1 and click Finish
Check the validate again.

Product:
Planning Analytics 2.0.4
Planning Analytics Workspace 30
Microsoft Windows 2016 Server

Issue:
When you in PA Workspace Administration Tool click on validate you get a error for TM1 Admin Server URI.

Error Message:
Error: connect ECONNREFUSED 127.0.0.1 443

Possible Solution:
The text you have entered in the field for TM1 Admin Server URI is not correct.
You have installed PA and PAW on a Windows server you have named DonaldDuck.
In the field you have entered:
https:/donaldduck.domain.com:5898

Note that you have missed one / at the https:/ point where it should be https://

Enter https://donaldduck.domain.com:5898 and test again.

Product:
Cognos Controller 10.3.1
Microsoft Windows 2016 Server
Cognos Analytics 11.0.9

Issue:
Standard reports in Cognos Controller does not work.

Possible solution:
You have to manually change the database connection string from SQLOLEDB to Native SQL.

Surf to Cognos Connection.
Go to old Administration page.
Go to Data Source.
Go to Set Properties for the connection.
Change the value and save it.

The Cognos Datasource connection string that is automatic created from Cognos Controller Configuration repair button creates non-supported data connections in CA11.
ca11 databas kopplingar

Above is the supported data sources in Cognos Analytics 11.

Product:
Cognos Controller 10.3.1
Microsoft Windows 2008 R2 server
Microsoft SQL database
Cognos Analytics 11.0.8

Issue:
When logging in to Cognos Controller 10.3.1 after a new setup some users get a error.
This setup is with 3 citrix servers and 3 controller application servers, where the controller functions is scaled out over the different controller application servers. On each citrix server the ccr.exe.config file point one of the controller application servers – to allow some kind of load balance to the controller applications server layer.
This is setup from this instructions:
http://www-01.ibm.com/support/docview.wss?uid=swg21677206

Error message:
Error occured at 3/22/2018 8:18:10 AM in IBM Cognos Controller, Error No=5, Source=FrangoDirect.ConnectionDirect.SetSelectDb#System.Web.Services, Description=System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.Net.WebException: The request failed with HTTP status 404: Not Found.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at CCRRemoteServerProxy.Proxy.FrServerB.WSFrServerB.ConnectionBusiness_SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
at FrServerB.RemoteConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
at FrServerB.ConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)

Possible solution:
The web.config file have not a correct servername for the ccrRemoteServer value, it can be a extra special character or something that make the “http” string not work. Test the string in Internet Explorer from the slave server – can it surf to the master server?

Enter this to get a response:
http://masterserver/ibmcognos/controllerserver/ccrws.asmx

If above does not solve it – check that you can from the client and server surf to;
http://masterserver/ibmcognos
http://caservername/ibmcognos

If you have CA11 on the same server as your cognos controller installation, then the caservername and masterserver is the same address.

The key setup point for more controller application servers is this;

On the Slave server:

  • Browse to the ‘ControllerProxyServer’ folder (by default, this is located here: C:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer)
  • Open the file ‘web.config’ inside Notepad.exe
  • Locate the section ‘<appSettings>’
  • Add the following entry, inside that section:
        <add key=”ccrRemoteServer” value=”

http://MASTERSERVER/ibmcognos/controllerserver

      ” />

Naturally, modify the value ‘MASTERSERVER’ with the name of your ‘master’ application server.

https://www.ibm.com/support/knowledgecenter/SS9S6B_10.3.1/com.ibm.swg.ba.cognos.ctrl_inst.10.3.1.doc/t_ctrl_loadballacing.html

Product:
Cognos Controller 10.3.1
Microsoft Windows 2008 R2 Server
Cognos Analytics 11.0.8

Issue:
After installation of a interim fix on top of a Cognos Controller 10.3 installation, some of the Cognos Controller windows services are missing.

Solution:
Here instructions on how to install a upgrade, on top of Cognos Controller.
http://www-01.ibm.com/support/docview.wss?uid=swg22001683

After the installation check that all Cognos windows services are in place.
ctrl1

If your are missing IBM Cognos Controller Java Proxy you should run this line from cmd:
sc create “IBM Cognos Controller Java Proxy” binpath= “d:\Program Files\ibm\cognos\ccr_64\server\CCRProxy.exe” DisplayName= “IBM Cognos Controller Java Proxy” depend= RpcSs start= demand

if you are missing IBM Cognos Controller User Manager you should run this line from cmd:
sc create frLicServer binpath= “d:\Program Files\ibm\cognos\ccr_64\server\FrLicServer.exe” DisplayName= “IBM Cognos Controller User Manager” depend= RpcSs start= auto

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg21680801
http://www-01.ibm.com/support/docview.wss?uid=swg21680788

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

Product:
Planning Analytics 2.0.3
IBM Cognos TM1 Applications
Microsoft Windows 2016 server

Issue:
When publishing a updated TM1 application in Performance Modeler to the TM1 Applications web (contributor web portal), the application is deleted.

Error can be:
[DeployApplicationThread:9b649fa9-1cf1-46f7-9bae-5f2fde393121] ERROR () com.ibm.cognos.pmpsvc.PMPService – deployApplication Throwable
com.ibm.cognos.pmpsvc.PMPSVCException: An exception occurred on the server. Please contact your system administrator. :com.ibm.cognos.pmpsvc.handler.PMPTM1Exception: TI_NODE_NOT_EXIST[CAMID(“CDS:u:uid=roger,ou=people,ou=eu”) | }tp_modify_application_attribute | }ElementAttributes_}tp_applications, BounceMode ] :EXCEPTION

Solution:
There is a chance that there are “left-overs” from a old application with similar name in the portal, therefor the application is deleted before a new is created. The first time you publish a TM1 application to a new PMPSVC (contributor) web server, you need to ensure there is not a old application there since a previous crash.

Before republishing a old TM1 10.2.2 application to a new PA 2.0.3 server do this;
— stop the TM1 instance windows service.
— erase the log folder for the tm1 instance.
— copy a new fresh data folder from the TM1 10.2.2 application.
— surf to http://paservername.domain.com:9510/pmpsvc and remove the old application with the same name from the list of applications. You do this from the TM1 applications configuration page. You must be ADMIN in the TM1 instance you try to remove.
Check in the file TM1InstallRoot\webapps\pmpsvc\WEB-INF\configuration\fpmsvc_config.xml that the application is not listed any more.
— stop the IBM Cognos TM1 windows service (tm1web and pmpsvc service).
— surf to Cognos Analytics http://caservername.domain.com/ibmcognos and go to Team Content – IBM Cognos TM1 Applications – My Applications. Remove the link to your published application. PM can not publish a application if there already exist on with the same name.
— start the IBM Cognos TM1 Windows service (pmpsvc service).
— start the TM1 instance, that you had issues with.
— Surf to http://paservername.domain.com:9510/pmpsvc and add the TM1 instance to the portal, and make it a application you can work with from PM tool.
— Log into Performance Modeler as a ADMIN in your TM1 application. Open up and see the application you have built before, validate the application first. Then try to publish it again.

If you have a working TM1 instance, then above should solve the issue, because you start from a fresh working data folder. There should not be any corrupt files you need to delete. Surf to http://paservername.domain.com:9510/pmpsvc to see if it worked.

More Information:
https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_inst.10.2.2.doc/c_tm1_inst_contrib_strtlnk.html

If you Run the }tp_admin_delete_all process from Architect, then all applications can be erased, and you may have to recreate them.