Category: TM1

Information about Cognos TM1

paw dashboard is blank

April 12, 2022 by Roger·Comments Off

Product:
Planning Analytics Workspace 74

Microsoft Windows 2019 server

Issue:

After migrate reports from old PAW to new PAW; some workspace does not show, they are blank instead of showing the table or graph.

Possible solution:

Ensure that inside Planning Analytics Workspace Administration, that the URL for TM1 Application Server Gateway URI point to your TM1WEB server and port.

http://paservername.domain.com:9510

This settings are also found in file d:\IBM\PAW74\config\paw.ps1

PAW uses the TM1WEB to render the websheets, so this must point to correct port.

If it point to the pmpsvc instead, you will get a blank page, where there should be a websheet in the dashboard.

You migrate the books and reports with the PAW lifecycle function from old PAW to new PAW; but the web sheets are migrated with the TM1 data folder.

If there is only the websheet that are blank in the PAW book, then it can be the IBM Cognos BI Gateway URI that point wrong, it should point to the IIS weburl in case when you use SSO in your Tm1 application. It should match the settings in the TM1S.CFG file. Try by change it to:

http://cognosservername.domain.com:80/ibmcognos/bi/v1/disp

from the old value;

http://cognosservername.domain.com:9300/bi/v1/disp

The IBM Cognos BI Dispatcher URI should always be;

http://cognosservername.domain.com:9300/p2pd/servlet/dispatch

The other valus in the IBM Planning Analytics Workspace Administration Tool ( http://172.31.201.196:8888/ ) should be:

The TM1 Admin Server URI

https://tm1servername.domain.com:5898

TM1 Application Server Gateway URI (port depending on setup as listed above)

http://tm1webservername.domain.com:9511

More information:

https://blog.octanesolutions.com.au/backup-and-restoration-paw

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=snapshots-import-snapshot

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=classic-limitations

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=classic-manage-snapshots

https://www.tm1forum.com/viewtopic.php?t=15452

https://www.ibm.com/support/pages/blank-white-page-rendered-while-opening-websheets-within-planning-analytics-workspace

Websheet is blank in PAW

Can not expand tm1 instance in PAW

April 12, 2022 by Roger·Comments Off

Product:
Planning Analytics Workspace 74
Microsoft Windows 2019 Server

Issue:

Can not expand proven_techniques in databases under modeling tools in Planning Analytics Workspace.

Other TM1 instance work.

Possible solution:

The TM1 instance HTTPportnumber is not open in the firewall.

PAW uses REST API, HTTPportnumber, to communicate with the TM1 instances.

Change to a port you now the firewall let trough, by edit the tm1s.cfg file.

PortNumber=12301
HTTPPortNumber=12302
AdminHost=

Save the TM1S.CFG file and try again.

PAW have access to the TM1 Admin service, therefor the TM1 instance is listed in the tree.

More information:

https://ibm.github.io/planninganalyticsapi/#introduction

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=cloud-tm1-rest-api

How move users between PAW servers

April 12, 2022 by Roger·Comments Off

Product:

Planning Analytics Workspace 74

Microsoft Windows 2019 server

Issue:

How move user from on PAW installation to a other PAW installation?

Suggested solution:

Browse to the from PAW server and login as administrator.

Click on Administration icon.

Click on Users tab.

Click on Export Users. (this will export all users to a csv file)

The file will be in you download folder, on your computer.

Close the web browser and logout from the old PAW server.

Open the all-users.csv file in notepad++ and add names to all blank columns. There is not allowed to be blank columns in the csv file when loading it up to the PAW.

Start the web browser and go to the new PAW, where the users should be inserted.

Click on Administration icon.

Click on Users and Groups.

Click on upload users from csv file icon.

Drag the all-users.csv file to the drop zone.

Done, if you not have blank columns, then you get a error.

But the rows with correct information is loaded to PAW.

More Information:

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=users-add-local-only

invalid character ‘P’ in string escape code

April 12, 2022 by Roger·Comments Off

Product:

Planning Analytics Workspace 74

Microsoft Windows 2019 server

Issue:

When starting docker first time after installation with command start-service docker you get an error.

Error message in windows event log:

fatal: unable to configure the Docker daemon with file C:\ProgramData\docker\config\daemon.json: invalid character ‘P’ in string escape code

Solution:

Open the daemon.json file in notepad++

Ensure the path for data-root is using double backslash \\

Save the file.

Start docker with command: start-service docker

More information:

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

https://www.mirantis.com/blog/getting-started-with-mirantis-container-runtime-on-windows-server/

https://www.ibm.com/support/pages/troubleshooting-planning-analytics-workspace-related-docker-issues

Could not logon to TM1 com.ibm.cognos.tm1.TM1Exception

March 23, 2022 by Roger·Comments Off

Product:
Planning Analytics TM1_version=TM1-AW64-ML-RTM-11.0.5.1008-0

Cognos Analytics Product_version=11.1 R7 (LTS)

Cognos Controller CONTRL_UPDATE_version=CCR-AW64-ML-RTM-10.4.2000.1098-0

Microsoft Windows 2019 server

Issue:

IBM Cognos Controller FAP service does not login to the TM1 server for a FAP IP.

In D:\Program Files\ibm\cognos\ccr_64\Server\FAP\lib you have the SQLJDBC42.JAR file.

In Control Panel you have installed Microsoft SQL server 2012 Native client version 11.4.7001.0 (as a older version gave other problems)

In REGEDIT only TLS 1.2 is activated with key;

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]
“SchUseStrongCrypto”=dword:00000001

Error in D:\Program Files\ibm\cognos\ccr_64\Server\FAP\error.log file:

ERROR [fap.service.schedule.Scheduler] [schedulerThread], Could not logon to TM1
com.ibm.cognos.tm1.TM1Exception: SystemServerClientNotFound
at com.ibm.cognos.tm1.API.logonCAMNamespace(Native Method)
at com.ibm.cognos.fap.common.persistence.tm1.TM1Context.login(TM1Context.java:124)
at com.ibm.cognos.fap.service.schedule.Scheduler.updateDatamarts(Scheduler.java:591)
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:261)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:166)
at java.lang.Thread.run(Thread.java:825)

Solution:

Check that you can login to CA11 with the account that you enter inside FAP client program.

Check the TM1S.CFG file for this url

ServerCAMURI=http://servername.domain.com:9300/p2pd/servlet/dispatch
ClientCAMURI=http://servername.domain.com:80/ibmcognos/bi/v1/disp

Copy http://servername.domain.com:9300/p2pd/servlet/dispatch to your web-browser and try to login with the same username and password as you have entered in FAP DATA MART TM1 Connection.

Can you not login? Ensure that this user is part of the Cognos System administrator group inside Cognos Connection.

Go to Administration Console

Click on Security tab – click on cognos

Go to System Administrators – click on more

Click on Set Members

Add you user by click on Add… and type.

Enter the name domain/username and click on arrow, and click OK.

Now you should test if you can login with that user to CA11 from your web browser.

Create a jvm.options file in folder D:\Program Files\ibm\cognos\ccr_64\Server\FAP to make FAP use TLS1.2

-Dcom.ibm.jsse2.overrideDefaultTLS=true
-Dcom.ibm.jsse2.overrideDefaultProtocol=TLSv12

Also ensure that the Windows account running the Cognos Analytics service is part of the local administrator group.

More information:

https://www.ibm.com/support/pages/how-configure-force-controller-use-tls-12

https://www.ibm.com/support/pages/troubleshooting-could-not-login-tm1-systemserverclientnotfound-error-when-publishing-controller-data-tm1-fap

https://www.ibm.com/support/pages/troubleshooting-could-not-login-tm1-systemserverclientnotfound-error-when-attempting-run-initial-publish

https://www.ibm.com/support/pages/automatic-tm1-cam-user-creation-when-using-cam-bi-non-native-security

bolt.Close(): funlock error: The handle is invalid

March 8, 2022 by Roger·Comments Off

Product:
Planning Analytics Workspace 73

Microsoft Windows 2016 server

Issue:

After upgrade of PAW, the system does not start all containers.
In the c:\programdata\docker\panic.log file you may have this error:

bolt.Close(): funlock error: The handle is invalid

When try to start the PAW with the command ./paw.ps1 we get error similar to “No connection could be made because the target machine actively refused it” and “failed to update store for object type *windows.hnsEndpoint: open C:\ProgramData\docker/network/files/local-kv.db.lock: Access is denied.”

In powershell enter: ./paw.ps1 ps to get a better view of the running containers.

If PAW73 is working, it should look like above.

In powershell enter: docker logs mongo to see the log file for that container.

In powershell enter: docker version to see the version you have installed.

Possible solution:

Cause could be a to old version of Docker or too few resources in the Windows server.

If you have a old version of docker-compose, like 1.23, then you need to update it with this commands:

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

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

Ensure you have a backup of PAW before you run any scripts.

If the docker version is 17.06.2-ee-14 you need to upgrade it with this script, paste the code in a text file, and save it in the same folder as you have your Start.ps1 file (for example d:\ibm\paw73).

IF ((Get-Service -Name docker).status -ne 'Running') { Start-Service docker }
IF (Test-Path ./Start.ps1){
Powershell './scripts/paw.ps1 stop'
docker stop admintool
docker rm $(docker ps -a -q)
Copy-Item -Path 'C:\Program Files\docker\docker-compose.exe' -Destination "$env:TEMP"
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
Install-PackageProvider -Name NuGet
Install-Module DockerMsftProvider -Force
Install-Package -Name docker -ProviderName DockerMsftProvider -verbose -RequiredVersion 20.10 -Update -Force
Move-Item -Path "$env:TEMP/docker-compose.exe" -Destination 'C:\Program Files\docker\'
docker network rm $(docker network ls -q)
Stop-Service docker
Get-ContainerNetwork | Remove-ContainerNetwork -force
Get-VMSwitch | Remove-VMSwitch -force   
Get-NetNatStaticMapping | Remove-NetNatStaticMapping -Confirm:$false
Get-NetNat | Remove-NetNat -Confirm:$false
Restart-Service HNS
Start-Service docker
Restart-Service docker
Powershell '.\scripts\paw.ps1'
Powershell '.\scripts\paw.ps1 ps'
}

Above script will clean all containers and networks in docker, and upgrade to a later version of Docker.

Run the above .ps1 script in PowerShell as administrator.

If you get the blue screen with “Planning Analytics Workspace is unavailable. Try again in a few minutes.” message, then wait at least 10 minutes, before you try accessing again. PAW can be only starting up all it’s containers, and that take a long time. Check in TASK MANAGER, if all CPU are 100%, then docker is still loading.

(If you do not have a anti-virus program running, that can interfere with docker startup.)

Also, always test in a other web browser, when there are issues in PAW.

More information:

https://www.ibm.com/support/pages/failed-start-container-failed-create-endpoint-share-proxy-network-nat-file-local-kvdblock-being-used-another-process

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=web-install-configure-tm1-microsoft-windows

https://www.ibm.com/support/pages/troubleshooting-planning-analytics-workspace-related-docker-issues

https://www.ibm.com/support/pages/container-marked-removal-and-cannot-be-started-driver-windowsfilter-failed-remove-root-filesystem-hcsshimgetcomputersystems

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=local-prerequisites

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=wnipaw-2073-whats-new-february-10-2022

Server unable to listen on port 5001

February 20, 2022 by Roger·Comments Off

Product:

Planning Analytics 2.0.9.11
Microsoft Windows 2019 Server

Issue:

Newly installed TM1, when start the TM1 application, the first starts, but the second application does not start.

Following error in tm1server.log while starting the second Planning Analytics server : ” TM1.Server E15) Server unable to listen on port 5001. Please check the log file for further details ”

Possible solution:

The Tm1 instance can not read the tm1s.cfg file, and therefor defaults to the standard value of HTTPPortNumber; that is port 5001.

The first starts, the second tm1 instance try to use same port and crash.

Can be that you have missed to include HTTPPortNumber in the tm1s.cfg file.

Add HTTPPortNumber to every tm1s.cfg file with a unique number.

Can be that you inside the tm1s.cfg file you have “Configuration Directory” set to the data folder, but the tm1s.cfg file is in a different folder.

Remove “Configuration Directory” from the tm1s.cfg file.

Let only the path for the Tm1 instance in cognos configuration point out where the tm1s.cfg file is located.

More Information:

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=tcf-parameters-in-tm1scfg-file

https://pmsquare.com/analytics-blog/2020/6/7/planning-analytics-configuration-file-breakdown

https://www.ibm.com/support/pages/tm1server-e15-server-unable-listen-port-5001

TM1/PA REST API Part 1: Introduction – Getting it Right

Incorrect function.

February 17, 2022 by Roger·Comments Off

Product:
Planning Analytics 2.0.9.11
TM1_version=TM1-AW64-ML-RTM-11.0.911.20-0
Microsoft Windows 2019 server

Issue:
Can not start IBM Planning Analytics Spreadsheet Services service (tm1web).

Error in windows event log:

The IBM Planning Analytics Spreadsheet Services service terminated with the following service-specific error:

Incorrect function.

Suggested solution:

Change the user account that run the windows service to local system and try if that works.

Can be that a windows service account – do not have full access to files or memory.

Check the log files in folder D:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\tm1web\logs

More information:

Planning Analytics 2.0.9.11 – December 21, 2021
IBM Planning Analytics Local version 2.0.9.11 and the cloud release of IBM Planning Analytics with Watson version 2.0.9.11 includes updates for IBM TM1 Server version 11.8.9.

Failed to open the target workbook. Make sure that the file has not been renamed or deleted

January 16, 2022 by Roger·Comments Off

Product:
Planning Analytics 2.x

Microsoft Windows 2016 Server

Issue:
User have removed some sheet in a excel workbook and publish it again to TM1WEB.

But can now not open the application view in TM1WEB. User gets a error “Failed to open the target workbook. Make sure that the file has not been renamed or deleted”.