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:
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.

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

Issue:
When user inside Cognos TM1 Applications (contributor) are reporting there numbers. Then they click on X to close the window, they get a error message: 54: ObjectNameInvalid, when they press OK the application exits as it should.

Only when you use CAM authentication.

Suggested Solution:
You are using Internet Explorer in wrong emulation mode.

Press F12.
Select Emulation.
Change Document mode to Edge or 10, from 11.
Go into the node again and test.

To get to TM1 Applications you surf to http://paservername.domain.com:9510/pmpsvc

This error can also be found if the name of the TM1 application is to long, so the total length of the temp files BLB is more than 255 characters on the Windows server. During start of the Contributor session a blb file is created with the user name as filename in the datafiles folder, if this file is not created (due to its name is to long), when you exit your Planning Analytics Contributor application you get above error, because TM1 can not find the file and erase it.  All work, but you get a irritating error.

Solution is to have TM1 instances installed with short names like d:\tm1server\112\datafiles or similar.

You can also find in the tm1server.log error like this NAME INVALID error and that causes TM1.Blob FileCreateOpenDelete.

Product:
Planning Analytics 2.0.3
Planning Analytics Workspace  (ipa_workspace_local_2.0.29.1080.2.zip)
Microsoft Windows 2016 server
Red Hat Linux server

Problem:
When inside PAW, and you try to expand a node of a TM1 instance, you get a error message.

Error:
Session can not be established for server proven_techniques 500 (internal server error) “code” “explorer” “refID” “message” .”Failed to get children for server cubes”. “cause”.”java.net.NoRouteToHostException: No route to host”.

Solution:
In one case this is because of DNS and routing problems in network. The PAW server and PA server have both two network cards, and can only communication on one of them.
You must in TM1S.CFG tell Tm1 instance what network card it should use.

Add the line
IPAddressV4=”10.200.30.40″
in TM1S.CFG and restart the TM1 instance.

Replace the ip number with the correct ip address of your Planning Analytics server.
Important that the IP address are inside ” double quotation mark.

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

Problem:
When user surf to the PAW, they are not administrator and can not add other users.
Surf to http://pawservername.domain.com
Click on the user — and see there is not a option for Administration.
This is a new PAW setup with CAM authentications.

Solution:
The first users that you add in a TM1 instance as ADMIN will be admin in paw when you login to paw. Therefor you must add CAM users to a native TM1 instance first.

Open up a Tm1 application in Native mode. Like Proven_Techniques.
Open C:\Program Files\ibm\cognos\tm1_64\samples\tm1\Proven_Techniques\tm1s.cfg in notepad++.
Add the lines;
IntegratedSecurityMode=2
ServerCAMURI=http://caservername.domain.com:9300/p2pd/servlet/dispatch
ClientCAMURI=http://caservername.domain.com:80/ibmcognos/bi/v1/disp
Close TM1 architect.
Update the C:\Users\%username%\AppData\Roaming\Applix\tm1\tm1p.ini file with
AllowImportCAMClients = T
CognosGatewayURI = http://caservername.domain.com:80/ibmcognos/bi/v1/disp

Start PAW administration console and surf to http://pawservername.domain.com:8888
Setup like this (change to your servers name);
TM1 Admin Server URI: https://paservername.domain.com:5898
TM1 Application Server Gateway URI: http://paservername.domain.com:9510
Authentication Mode: TM1
TM1 Login Server URI: https://paservername.domain.com:5011
Click validate and update.

(This TM1 instance you point out with the HTTPport number is the instance that will define the first ADMIN in paw, even if you use security mode 5).

Start TM1 Architect and login to Proven_Techniques as Admin.
Go to Security – Client/Groups. From menu Clients select Add New Client.
Add your CAM user from your AD domain, that you want to be ADMIN in paw.
Mark the user to be ADMIN in TM1 Architect. Click OK.
Exit Tm1 Architect.

Open C:\Program Files\ibm\cognos\tm1_64\samples\tm1\Proven_Techniques\tm1s.cfg in notepad++.
Change; IntegratedSecurityMode=5
Save the file and restart the TM1 instance.
Now TM1 instance is using CAM authentication.

Update PAW admin console by surf to http://pawservername.domain.com:8888
TM1 Admin Server URI: https://paservername.domain.com:5898
TM1 Application Server Gateway URI: http://paservername.domain.com:9510
Change to Authentication Mode: CAM
Set IBM Cognos BI Gateway URI: http://caservername.domain.com:80/ibmcognos
Set IBM Cognos BI Dispatcher URI: http://caservername.domain.com:9300/p2pd/servlet/dispatch
Set IBM Cognos BI Authentication Namespace ID: AD
Click Validate and update.
Click on status tab – wait until CPU usage is below 1%.

Surf to http://pawservername.domain.com
Login as the CAM user you have given ADMIN rights in Proven_Techniques.
This user should now have a ADMINISTRATOR option under its name.

The list will only show name for people who have already try to login.

More Information:
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_paw_administration_top_level.html

Product:
Cognos Tm1 10.2.2 Fix pack 7 (10.2.5270.108)
Microsoft Windows 2008 R2 server

Issue:
When click save in TM1 Cognos Configuration you get a error message that you can not save, but can save in plain text.
The Cognos TM1 Application Web is using the value Environment – group properties – Gateway uri as default values in http://localhost:9510/pmpsvc setup.
If localhost is used in Cognos Configuration, the BI services (if it exist) on the local server is used as key for the creation of the crypto files.

Error details:
[Cryptography]
[ ERROR ] CAM-CRP-1132 An error occurred while attempting to request a certificate from the Certificate Authority service. Unable to connect to the Certificate Authority service. Ensure that the Content Manager computer is configured and that the IBM Cognos services on it are currently running. The HTTP result code ‘500’ was returned from the server.

but first you may get
:java.lang.nullpointerexception
when you try to save Cognos Configuration.

Possible workaround:
In Cognos Configuration, select Local Configuration, click the and then click Add.

Type StandaloneCertificateAuthority in the Name box.
Type True in the Value box.
Click OK.

This will make the TM1 cognos configuration not use the BI values to create the crypto keys.

Check also that you have not installed a fix pack over a TM1 installation that uses custom key certs.
Check that you have access to the Cognos BI server by in IE surf to http://cognosbiservername:80/ibmcognos/cgi-bin/cognosisapi.dll
Check that the Cognos Controller FAP or Cognos TM1 admin services is stopped when you update Cognos Configuration.
Check that you do not have doublets of the Cognos TM1 admin services.

More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21655725&myns=swgimgmt&mynp=OCSS9RXT&mync=R
http://www-01.ibm.com/support/docview.wss?uid=swg21902547
https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_inst.10.2.2.3.doc/t_config_tm1_cont.html

Product:
Planning Analytics 2.0.2
Planning analytics workspace 2.0.25
Microsoft Windows 2016 standard server
Problem:
How install PAW with Microsoft 2016 Docker files?
Solution:
When using the Microsoft 2016 server with Docker EE, there is no need to have a Virtualize active in VMWARE, therefor is this a better solution. (If you not use Linux OS). Docker EE also does not cost anything extra, as it is part of the Microsoft 2016 licenses.
But to make this work you must:
– The Microsoft Windows 2016 server must be connected to Internet to download the Docker EE.
– Update Microsoft Windows 2016 standard server to the latest fix pack.
– You must use FQDN to access all servers.
– You must have 70 GB free disk space on the Microsoft Windows 2016 server.
– Turn off the Antivirus program on the Windows 2016 server where PAW is installed.
– After you start PAW you must always wait 10 minutes before you try to access it.
– Recommend that you only have ONE network card on the Microsoft Windows 2016 server for PAW.

Above only for your test server, on your laptop.
There is possible to download Docker EE and move it to a different server, according to this page,
https://docs.docker.com/engine/installation/windows/docker-ee/
I copy some of the information here:
Use the following steps when you want to install manually, script automated installs, or install on air-gapped systems.

• PS> Expand-Archive docker.zip -DestinationPath $Env:ProgramFiles
• # Extract the archive.
• Copy the zip file to the machine where you want to install Docker. In a PowerShell command prompt, use the following commands to extract the archive, register, and start the Docker service.
• https://download.docker.com/components/engine/windows-server/17.06/docker-17.06.2-ee-4.zip
• PS> invoke-webrequest -UseBasicparsing -Outfile docker.zip
• # On an online machine, download the zip file.
• In a PowerShell command prompt, download the installer archive on a machine that has a connection.
• # Clean up the zip file.
• PS> Remove-Item -Force docker.zip

• # Install Docker. This will require rebooting.
• $null = Install-WindowsFeature containers

• # Add Docker to the path for the current session.
• PS> $env:path += “;$env:ProgramFiles\docker”

• # Optionally, modify PATH to persist across sessions.
• PS> $newPath = “$env:ProgramFiles\docker;” +
• [Environment]::GetEnvironmentVariable(“PATH”,
• [EnvironmentVariableTarget]::Machine)

• PS> [Environment]::SetEnvironmentVariable(“PATH”, $newPath,
• [EnvironmentVariableTarget]::Machine)

• # Register the Docker daemon as a service.
• PS> dockerd –register-service

• PS> Start-Service docker
• # Start the Docker service.

• Test your Docker EE installation by running the hello-world container.
• PS> docker container run hello-world:nanoserver

But for this installation, we will have the Microsoft Windows 2016 server connected to Internet.

Download the latest PA Workspace file (ipa) from IBM Fix Central
http://www-01.ibm.com/support/docview.wss?uid=swg27049597

In these instructions we use the version 25. Note; take the WIN version, the other is for Linux (or Windows 2012).

• ipa_workspace_local_win_2.0.25.46.1.zip (6.27 GB)

Unzip the file and place it on the Microsoft Windows 2016 server in a folder, e.g. \install\paw

The Start.ps1 file indicate that you have downloaded the correct program for Windows 2016.

Check that Microsoft Windows 2016 is update in control panel

You can go to settings from Server Manager or enter Settings in the search box.

By the way, we have IE Enhanced Security Configuration and DEP off during the installation. Turn off the Windows firewall during installation and first testing. Start up the firewall later.

After the update you need to reboot your Microsoft Windows 2016 server.

How install Docker EE

https://github.com/docker/labs/blob/master/windows/windows-containers/Setup-Server2016.md

PowerShell Package Provider (recommended)

Microsoft maintains a PowerShell package provider that lets easily install Docker on Windows Server 2016.
Run the following in an Administrative PowerShell prompt:

Install-Module -Name DockerMsftProvider -Force
Install-Package -Name docker -ProviderName DockerMsftProvider -Force
Restart-Computer -Force

So, ensure the server is connected to internet, and right click on start, and select Windows PowerShell (Admin).

Enter the below commands:

Install-Module DockerProvider -Force

Install-Package Docker -ProviderName DockerProvider -Force

For the questions about update the NUTGET, press Yes.

Then the download is done as shown in above picture.

Restart the Microsoft Windows server

Above error comes when you run Start.ps1 and you have not downloaded docker compose.

Download docker compose from here https://github.com/docker/compose/releases/tag/1.16.1

Copy to the file to \program files\docker folder and rename the file to docker-compose.exe.

Install IBM Planning Analytics Workspace

The Microsoft Windows 2016 server will need at least

• 13308 MB of memory
• 4 CPUs
• 70,000 MB (70 GB) of storage

Here the official instructions
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/t_paw_install.html

Then go to the powershell admin and run ./start.ps1

Click Y to start the admin tool

Accept the licenses

You must accept both the license tabs

Click OK and you are into the setup dialog.

If you want CAM security (then you need to fill in all above)

But for our test we will use Native TM1 security, then we only need to fill in above values.

The HTTPPortNumber is found in the TM1S.CFG file for the TM1 application that you will use as Authority to the PAW program. Above we use the Planning Sample application.

All users that will use the PAW program must be part of that application, so the users must in most cases be part of TWO TM1 instances, the “login” TM1 instance and the “Application” instance – where they should work on their Budget solution.

Fill in the server name and port number and click on Validate.

If you get above error, this can be a DNS or Network problem, change to use FQDN, even do the ping to the server is working.

Now you see the HTTP ports number the different TM1 instances are using on your server.

Click on UPDATE to start the services.

Go to the Antivirus software, in above dialog it is Microsoft Defender, and click on Settings to turn it off.

Turn off Real-time protection.

Start Internet explorer and surf to you server to test the installation of PAW , surf to your IP address of your Windows server.

http://192.168.254.24/login/form

Login with the user and password for the planning sample application. Now you need to test the installation by creating a workbook.

https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_prism_books_views.html

To check the version of docker enter: docker version

Enter Docker stats to see what memory is used by the services

Press CTRL+C to exit the session.

How to backup the PAW database

To take a backup of the databases inside PAW, recommend to run every week the ./Backup.ps1 script from the scripts folder. This will stop and start the services, making the backup possible.

The backup files are placed in the backup folder.

How stop PAW in a secure way:

Start a powershell prompt in administrator mode and enter ./paw.ps1 stop

When that is finish – then you can shut down the Microsoft Windows 2016 server.

Docker stats should show an empty page, if all services are closed.

You can start the PAW from the PowerShell prompt with commando ./paw.ps1 start

How upgrade PAW to later version:

Depending on the version of PAW the steps are different, but in general for version 25.

You must first backup your existing PAW data by use of the backup_for_upgrade.ps1

Copy the zip backup files to a save location.

Procedure from IBM site;

Copy the <paw_install_location>/config/paw.env file from your current installation to the new installation location.

Copy the <paw_install_location>/config/certs directory from your current installation to the new installation location.

Perform Installing of new Planning Analytics Workspace.

Reply “y” when you are prompted to install the Docker images. Reply “y” when you are prompted to open the administration tool.

In the Planning Analytics Workspace administration tool, restart all the services.

After you got all up and running, run the new Restore.ps1 script, and point to your saved files to read that data into the PAWs databases.

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

How do i see PAW

Docker is running as a service in Windows 2016, and you have the PAW solution inside the docker service. Check Windows Task Managers details, to see if the PAW parts are running.

In new version of PAW you can set security better than in older versions, more information here
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_paw_administration_top_level.html

In new version of PAW you can share a view, here more information on how
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/t_prism_sharing.html

Note that version 25 of PAW does not support Single Sign On (SSO). That maybe will be accessible in a future version.

You cannot install more than one PAW on a server, due to network configuration issues.

All TM1 applications use SSL for communications between the programs, using their default certificates.

If you get error:

Unable to invoke ‘docker’. Ensure docker is installed and is on the PATH.

Then you have not reboot the server, after docker installation.

If you get error:

This error (HTTP 404 Not Found) means that Internet Explorer was able to connect to the website, but the page you wanted was not found. It’s possible that the webpage is temporarily unavailable. Alternatively, the website might have changed or removed the webpage.

For more information about HTTP errors, see Help.

Then the PAW is not started completely.

Above error show that the PAW underlying services are stopped. Check in Task Manager.

PAX (Planning Analysis for Excel) setup, is not covered in this article.

In the task manager you can see the processes that make up the Docker solution, under the details section;

MONGO database is running here.

REDIS database is running here.

The COUCH database is running here.

When all the services inside docker are stopped, there is no CPU activate or memory used.

More Information:

How setup SSO

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

How setup PAX

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

The latest functions in the different PAW versions

https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_new_features_paw.html

Please note; that the PA 2.0 LOCAL PAW is released a few months later than the PA on cloud. Local is around 3 versions after.

Product:
Planning Analytics 2.0.2
Centos Linux to install PAW (ipa_workspace_local_2.0.22.832.2)
Microsoft Windows 2012 R2 server for the TM1 main install.
Docker version docker-1.12.6-32.git88a4867.el7.centos.x86_64
Operating System: CentOS Linux 7 (Core).

Problem:
How install Planning Analytics Workplace on Linux?

Solution:
This is a suggestion on how to do it in your lab – please follow official documentation in first place. You must have a Linux expert with you when you do the installation at a company production site.

Download products;
IBM Planning Analytics Workspace 2.0.22
with file ipa_workspace_local_2.0.22.832.2.zip (2.06 GB)
from here
https://www-945.ibm.com/support/fixcentral/swg/downloadFixes?parent=Cognos&product=ibm/Information+Management/IBM+Planning+Analytics+Local&release=All&platform=All&function=fixId&fixids=BA-PAWL-2.0.22&includeRequisites=1&includeSupersedes=0&downloadMethod=http&login=true

Download Linux Centos file CentOS-7-x86_64-DVD-1611.iso from here
http://isoredirect.centos.org/centos/7/isos/x86_64/CentOS-7-x86_64-DVD-1611.iso

Different versions of Linux and Docker can give you other issues.
Download PUTTY from here https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html
Download WINSCP from here https://winscp.net/eng/download.php

For TEST purpose you can setup a VMWARE image on your laptop, select New Virtual Machine Wizard. Point to your ISO file at Installer disc image file (iso) and click next.
Select Linux (version: Red Hat Enterprise Linux 7 64-bit) at Guest Operating System and click next.

Enter a name like CentOS and point to a empty folder on your harddisk and click next.
Set maximum disk size to 200 GB and mark “Store virtual disk as a single file” and click next.

Click on Customize hardware and set memory to 10088 MB, set Number of cores per processor to 2, Remove USB and Sound Card and Printer.
Leave network at NAT. Click close and Finish.

Click on “power on this virtual machine” in WMware Workstation.
Click in the black area with your mouse to get the focus inside the VMware session, go with arrow up to select Install CentOS Linux 7 and press ENTER.

This acpi error is nothing to be concern about – let the installation start.

Let English be your choice and click Continue.
Fill in date and time and keyboard for your country.


Then scroll down and click on Network.


Change the HOST name to something better – like centospaw.lab.domain and activate the network to see what ip you get from the DHCP. Enter the host name in small letters.

Note down the IP address, and click on the Configure button at lower right corner. Click on IPv4 Settings tab and select Method to Manual (you must use manual ip on your PAW server) and click on Add button to fill in the IP values.

Enter the ip address you had on the screen before.
address 192.168.254.11
Netmask 255.255.255.0
Gateway 192.168.254.2
Click Save and then click Done in the top left corner.

Click on Begin installation.
Click on ROOT Password to set it to Cognos17 (or something better)
Using this weak password will demand that you click on Done twice to move forward.


Click on USER Creator and enter your name. Mark “make this user administrator” (this will make it possible for him to use SUDO command in linux)
and set password to Cognos17 (or something better)
click Done twice.
Click on Finish Configuration.

Wait until it is complete installed and click on Reboot button.

Enter your name and your password, as you set it up before.
Now you are inside your Linux OS.

Linux is case sensitive – so enter all commands in lower case. They are only shown in capitals letters in this text to stand out.
Best is to add a text editor, so because this is CENTOS you need to enter YUM SEARCH NANO to see if the text editor NANO exist for installing. If this had been Ubuntu you have to enter APT-GET

Install NANO

http://ubuntu-for-humans.blogspot.se/2009/11/installing-and-using-terminal-editor.html

Enter SUDO YUM INSTALL NANO to install the editor. You need to provide your password for it to act on the command.

First it will list what it will download, so you must click Y to allow it to download and install your selected program.

Enter Y to other warnings.

Now the program is installed.

Now you have setup the VMWARE to have 10 GB of ram and 200 GB of hard disk and installed Linux CentOS version. You have also tested to install a program into Linux. This may require that you have access to Internet from your Linux machine.

Install DOCKER
Enter SUDO YUM INSTALL DOCKER to install docker into your machine.

Enter Y to install the DOCKER program.

Enter SUDO YUM UPDATE to update the Linux OS to latest fix pack.
(Note that Linux is case sensitive, you must enter program commands in lowercase).

After the installation it is best to reboot the Linux server, enter SUDO INIT 6 or REBOOT NOW.

Install Docker-Compose
Before you install Docker-Compose you need to create a folder to store it in.
Enter PWD  (in lower case) to see what folder you are in.
pwd

The Linux disk is build up of several folders, recommendation is to install all cognos to folder OPT. Change to folder with commando CD /OPT (the / tell it to start from the top).

Enter LS to see if there are any files in the folder.
Enter SUDO MKDIR COMP to create the folder comp.
Enter LS to see the folder now (in blue text).

Enter CD COMP
Enter LS
This is a new folder so it should not have any content.
Enter CD .. to go up one folder in the file structure.
Enter LS -L COMP to see the rights on the folder.
Enter SUDO CHMOD A+X COMP to set full rights for all users on folder COMP.

https://ss64.com/bash/syntax-permissions.html
https://help.ubuntu.com/community/FilePermissions

Now you need to enter this line to download Docker-Compose.
curl -L “https://github.com/docker/compose/releases/download/1.9.0/docker-compose -$(uname -s) -$(uname -m)” -o /opt/comp/docker-compose

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

Enter SUDO CHMOD A+X DOCKER-COMPOSE to make the file executable.

Sometimes the download of Docker-Compose only give you the HTML page — you can check your download by open it in your text editor, in our case NANO.

If it show readable text, you have not downloaded the program.  Remove your download with the RM DOCKER-COMPOSE command.

Then you should try this URL instead;
curl -L “https://github.com/docker/compose/releases/download/1.9.0/docker-compose-Linux-x86_64cd” -o /opt/comp/docker-compose

Note the size of the received bytes, if to small then you did not download the correct file.

Now you need on your Windows laptop, install below program to access the Linux virtual machine
Install PUTTY
http://support.real-time.com/windows/web/putty.html
Install WINSCP
http://support.real-time.com/open-source/winscp/#installation

Install PAW
Create the folder /opt/apps/ibm/paw to store it in.
Enter SUDO MKDIR APPS APPS/IBM APPS/IBM/PAW

Enter CD APPS/IBM
Enter SUDO CHOWN ROGER: PAW to set owner on the folder paw

install unzip in your linux OS
Enter SUDO YUM INSTALL UNZIP

Enter Y to download and install the unzip program.

To check that you have access to Linux server from you laptop open a CMD prompt and enter PING 192.168.254.11, this should give a good reply.
Copy the PAW files to your linux server, start the WINSCP program.
Click New Site
Enter the Host name to the ip address and enter the user name to your name in linux and the password you have set there.

Click save and login

Click Yes to the question about adding the host key.
Navigate on the left side to the folder on your laptop where you have the ipa file you have downloaded.

Navigate on the right side on the linux box to your new created folder /opt/apps/ibm/paw.
Drag the ipa file from the left windows to the right window, and the copy starts. You can also click on UPLOAD.

When done exit WINSCP program.
In CentOS linux go to the /opt/apps/ibm/paw folder.
Enter CD /OPT/APPS/IBM/PAW
Enter SUDO UNZIP ipa_workspace_local_2.0.22.832.2.zip


Remove the large ipa file with commando SUDO RM -F filename

Start Notepad++ and enter below in a new file.
###### begin of file ##########
#!/bin/bash

# This script exports required environment variables needed
# set to autostart docker program with linux os
systemctl enable docker

# set ip address – change to address of your server
export ADMINTOOL_IP=192.168.254.11

# set area to path where docker-compose is
export PATH=$PATH:/opt/comp

# create docker group
groupadd docker
usermod -a -G docker roger
usermod -a -G docker root

#create folder
mkdir /root/bin

# set rights on the folder to be able to run files
chmod -R a+x /root/bin

# map (link) docker to the a root area
ln -s /opt/comp/docker-compose /root/bin/docker-compose

# lower security
setenforce permissive

# open port in firewall
firewall-cmd –add-port=8888/tcp
firewall-cmd –add-port=8888/tcp –permanent

###### end of file #######
Save the file as startbeforepaw.sh on your laptop.
Use WINSCP to copy the file to your linux paw folder.

Start putty on you laptop.
Enter the ip address at Host Name, and enter a name at Saved Sessions and click on Save.

Click on Open to connect.

Click on Yes to add the server key to your local machine.
Enter your username and password
Enter PWD to see where you are.
Enter CD /opt/apps/ibm/paw to change to the paw folder.

Change so you can run the files in the paw folder by enter SUDO CHMOD A+X *

Enter SUDO ./startbeforepaw.sh to run the startbeforepaw.sh script
Run it as Root will work best.

Let your Linux expert validate your steps before you run them.

Above when you run the script without correct user permissions.

Set execute rights on the script files with command SUDO CHMOD A+X *

If the script does not work, then you have to enter this values manually before you run the Start.sh script.

Or better is to add this lines to start of the Start.sh script;
#!/bin/bash
export ADMINTOOL_IP=192.168.254.11
export PATH=$PATH:/opt/comp

..then when start.sh is run this is executed as the correct user.

Check if they are set with command ENV.

Above when the folder where docker-compose file is not part of the PATH.

Run paw
Go to the paw folder on your CentOS linux server
Enter SUDO ./Start.sh
(Note that linux are case sensitive, you must enter Start.sh)

Press Y

The second run will ask if you want to update the images.

DOCKER PS -A will list the running services. Here only the admintool.

Start a Internet Explorer and surf to http://192.168.254.11:8888

Scroll down and press Accept

Press OK, and select the other tab

Scroll down and press Accept and OK.

Change the servername to point to your TM1 server.

In our example we use the IP address of the TM1 server.

The TM1 Login Server URI port number is to the TM1 instance that will control the access to the PAW (in native mode).

The port number is found in the TM1S.CFG file.

Press validate – this will also show the TM1 applications on that server.
Click on Update button to start the PAW services.

Click on Status tab to see the process start. Press Refresh to get a update of the status. When the CPU% is low the PAW is started. Then you should be able to browse to it on address http://192.168.254.11:80

Enter Admin and apple to login to your sample application.

If you have a terminal to the linux server, you can there enter DOCKER PS -A to see a similar list of status on how the PAW all services are working.

Now you are in PAW. If you are missing options in PAW, please try a different browser – like Chrome instead.
https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_paw_modeling.html

Command to see the running docker images;

DOCKER PS  -A

Command to see list of installed images;

DOCKER IMAGES

Command to see content of file;

MORE ADMINTOOL/UP.LOG

If you enter ctrl-c here, you only stop the AdminTool – the paw will still run.

How run a backup of the instance

From a terminal windows – check that the process are running by enter DOCKER PS -A

Then move to the script folder of your PAW start folder.

CD /opt/apps/ibm/paw/script

Here you can run the SUDO ./backup.sh command to create the backup of the databases in folder /opt/apps/ibm/paw/backup

Backup.sh will stop the services, take a backup and start the services again. Recommended to run this every week at least.

Please check the other scripts files in Notepad++ to learn more.

Error

/opt/comp/docker-compose: line 1: syntax error near unexpected token `newline’
/opt/comp/docker-compose: line 1: `<!DOCTYPE html>’

Solution
Download Docker-Compose again, you did not get the right file.

Error
ERROR: for admintool  Cannot start service admintool: driver failed programming external connectivity on endpoint admintool (81344b5025415739036ed6be09366f4f76076d1ce835733547889d727cc77a5c): exec: “docker-proxy”: executable file not found in $PATH
Encountered errors while bringing up the project.

Solution
The docker file does not exist, in this version of docker it have a different name. Make a link in the folder from the new name to the old name, so the program can find the file. Enter a command like this:

ln -s docker-proxy-current docker-proxy

Error
ERROR: for admintool  Cannot start service admintool: driver failed programming external connectivity on endpoint admintool (52dcfb86a67c6f953074c223aefe27e5a85aca9b250df6e5c5d2fa34acb4ce7f): Bind for 192.168.254.11:8888 failed: port is already allocated

Solution
Restart the server, the last try made the ports to be allocated, but no service started.

To ensure you get a new log file, you can erase the old log file with the commando;

rm admintool/up.log

Error
Error response from daemon: Container 81344b5025415739036ed6be09366f4f76076d1ce835733547889d727cc77a5c is not running.

The user that run the service (root) does not have docker files in its path.

Solution
Make symbolic links to the folder for all files, from the USR/BIN folder, that normally is in the ROOTs path.
cd /usr/bin
ln -s /usr/libexec/docker/* .

More info about setup of CAM with PAW:

#CognosAnalytics and #PlanningAnalytics Integration – Walkthrough – Part 3

More Information about PAW versions:
https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_new_features_paw.html

How to install DOCKER CE for Centos on a RED HAT Linux

https://stackoverflow.com/questions/42981114/install-docker-ce-17-03-on-rhel7

Recommendation is to only use supported environments.
https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/osForProduct?deliverableId=6745CB200D5411E69DCADF455C6AF151

Product:
Cognos TM1 10.2.2 Fix Pack 7 (or Planning Analytics 2.0.2)
TM1_version=TM1-AW64-ML-RTM-11.0.0.612-0
TM1_name=IBM Cognos TM1
Microsoft Windows 2012 R2 server

Problem:
How write and debug TI code more easy?

Solution:
Use the free TI debugger tool.
You download it from here
https://www.ibm.com/developerworks/community/groups/service/html/communityview?communityUuid=51f0ea6b-1c8b-4e4d-9042-74d69ad84fe3#fullpageWidgetId=W8f78e5b97b1c_4f90_8fcb_de8eb32c26ad&file=f78f0f40-bbe8-48a7-acfc-2e6c68c1e8ce

On your TM1 server create a empty folder c:\debugger
Save the 20161214_TurboDebugger [v6].zip file in that folder.
Unzip it in this folder so you get 3 files.
Open TurboDebugger.bat file in notepad.
Add the path to your java folder to the first line, then it can look like this;
start “TM1 Turbo Integrator Debugger” “C:\Program Files\ibm\cognos\tm1_64\bin64\jre\7.0\bin\javaw.exe” -Djavax.net.ssl.keyStore=cacerts -Djavax.net.ssl.trustStore=cacerts -jar TurboDebugger.jar
Save the file.
Create a Shortcut on the desktop to your TurboDebugger.bat file.

In your TM1S.CFG file you need to add EnableTIDebugging=True and then restart the TM1 instance.
For Planning Sample you find the file in folder C:\Program Files\ibm\cognos\tm1_64\samples\tm1\PlanSamp.
# TM1 Server HTTP Port
# Sets the server port number for HTTP access. Like PortNumber above, it is used to distinguish between multiple servers running on the same computer. When multiple TM1 servers are installed on a single computer, each server must use unique values for port number and HTTP port number.
# Type: Optional, Static
# When you install a TM1 server, the default HTTP port number is 12354. Valid port values are between 5000 and 49151
#
# If the Tm1s.cfg file does not contain the HTTPPortNumber parameter, then you can not use the OData v4 Compliant REST API.
HTTPPortNumber=12354
EnableTIDebugging=True

Click on the bat file in Windows explorer to start the debugger.
At the login enter the TM1 windows server name and the HTTPportnumber for the application you want to connect to.
You find the HTTPS port number in the TM1S.CFG file for your TM1 application.
https://localhost:12354/api/v1/

Enter the username and password to connect to your TM1 application.

This give you a improved TI editor.
You can search and replace text, and more easy update the TI processes.
On the right side you will see the TM1 variables values when you step though the TI process.

Changes you make to the code can be save with the save button on the top right side.

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg27049516
http://ecapitaladvisors.com/blog/ibm-planning-analytics-turbointegrator-debugger-tool-is-now-available/