by ·Comments Off on Install Mirantis on air-gapped computer

Product:
Planning Analytics Workspace 74
Microsoft Windows 2019 server

Issue:
To install PAW74 or later on Windows 2019 server, you need to first install the docker runtime.

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=ipawl-install-planning-analytics-workspace-local-windows-server-2019

Solution:

From a workstation with internet connection.
Create a folder like c:\install\docker

Go to the folder in powershell as administrator

Enter this command to get the installation script

Invoke-WebRequest -Uri https://get.mirantis.com/install.ps1 -o install.ps1

Enter this command to download the media only

.\install.ps1 -DownloadOnly

Then copy this files over to the server, and place them in some folder like d:\install\docker

On the new server start powershell as administrator and go to the folder to start installation with command

.\install.ps1 -Offline

When installation is done, it is common to change the drive for docker. Update the file c:\ProgramData\docker\config\daemon.json

The value data-root point to where you want all the docker images for PAW. In windows you must enter the path with double slash. Save the file.

To start the docker service enter:

Start-Service docker

If you get error;

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

then you have missed the \\ in the file.

To check version of docker enter:

docker version

Should give response: Client: Mirantis Container Runtime

Version: 20.10.11

API version: 1.41

More information:

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

https://store.mirantis.com/product/basic-for-mirantis-container-runtime-formerly-docker-engine-enterprise-for-compatible-linux-and-windows-server/

 

https://techcrunch.com/2022/02/09/mirantis-on-run-rate-over-100m-two-years-after-buying-docker-enterprise-assets/

by ·Comments Off on Invalid database version

Product:
Cognos Controller 10.4.2
Microsoft Windows 2019 server

Issue:
After upgrade of Cognos Controller to a new version, the users get a error message when they start Cognos Controller Client program.

“The version of Controller requires database version 992.”

Solution:

Wait for the IT department to upgrade the Cognos Controller Client installation on the Citrix server you are using. Cognos Controller 10.4.2 use database version 1010.

More Information:

https://www.ibm.com/support/pages/ibm-cognos-controller-builds-ccr-name-and-database-version

https://www.ibm.com/support/pages/how-install-controller-local-client

by ·Comments Off on How much disk space does PAW need?

Product:
Planning Analytics Workspace 74

TM1_version=TM1-AW64-ML-RTM-11.0.912.9-0
TM1_name=IBM Cognos TM1

Microsoft Windows 2019 server

Issue:

How much disk space do i need for PAW on my new server?

Solution:

The install folder (where you downloaded the software) takes around 15 GB.

The PAW folder (where log files are) takes 10 GB.

The DOCKER folder (where the images are) takes around 52 GB.

The program folder for planning analytics takes 7 GB.

The folder for your TM1 instance – is very depending on your solution and how much data you have in TM1.

The Windows folder take around 18 GB.

Normally you have windows on C: and all the rest on your D: drive.

Recommendation is to have above 100 GB free on the C: and D: drive before you start.

 

More information:

https://static1.squarespace.com/static/5268c662e4b0269256614e9a/t/5ccb9e48ea82dc000156eadc/1556848201313/TM1+Planning+Analytics+-+Cheat+Sheet+-+2019-05.pdf

https://na.eventscloud.com/file_uploads/b16ad176a58e3a9a360d66f1a4009c4e_Plan_IBMPlanningAnalyticsLocal_SoufianeAzizi.pdf

by ·Comments Off on Could not find a part of the path

Product:
Cognos Controller 10.4.2
Microsoft Windows 2019 server

Issue:
When you login to cognos controller client, you get a error message of this kind;

Number: 76
Source: mscorlib
Description: Could not find a part of the path ‘C:\Users\nnnnn\AppData\Roaming\Cognos\CCR\ADMdb_cognoscontroller.local,1433CognosControllerdatabase’.
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc)

Suggested Solution:

Click OK to get past the error message, and still login to Cognos Controller Client program.

Clear the local cache by going to Maintain – Special Utilities – Clear Local Cache.

Close Cognos Controller program and try to login again. Did the error go away?

Can be garbage in the cache of files in folder C:\Users\nnnn\AppData\Roaming\Cognos\ccr, that are cleared by this action.

More Information:

https://www.ibm.com/support/pages/standard-error-76-could-not-find-part-path-when-launching-controller

by ·Comments Off on ERROR: java.lang.NullPointerException

Product:
Cognos Controller 10.4.2
Microsoft Windows 2019 server

Issue:
When open FAP.UDL file with DBCONV.exe program to upgrade the database you get a error.

ERROR: java.lang.NullPointerException

Possible solution:

The UDL file does not contain a password.

Copy the fap.uld file to folder D:\Program files\ibm\cognos\ccr_64\Data

Open the file in Cognos Controller configuration and add a password.

Click on test connection icon.

Click on arrow to start the Database conversion program.

Select FAP DB.

Click Connect.

Check if the numbers are different, then you need to click on Upgrade button.

Close the program.

Remove the fap.udl file from the \ibm\cognos\ccr_64\Data folder.

Also, ensure the SQLJDBC42.JAR file is in the folder D:\Program files\ibm\cognos\ccr_64

More Information:

https://www.ibm.com/support/pages/javalangunsupportedoperationexception-jre-version-16-error-when-using-database-conversion-utility-dbconv

https://www.ibm.com/support/pages/could-not-create-view-could-not-create-controller-type-failed-launch-javalangnullpointerexception-launching-java-related-functionality-caused-invalid-ccrjavahome-variable

by ·Comments Off on Language in PAW

Product:
Planning Analytics Workspace 73
Microsoft Windows 2016 server

Issue:
When user browse to PAW portal, some of the text is in other language than English.

The edit fields are controlled by the settings in your web browser.

How change language in Chrome:

Go to Settings

Expand Advanced

Click on Languages – expand the dialog

Add the language you want the text in PAW toolbar to be the chosen language for your browser.

 

You create translated values by adding a caption attribute, and then by assigning caption values for every language that you want to make available. You add caption attributes and caption values by creating TurboIntegrator processes.

Planning Analytics Workspace uses the browser language setting to determine which language to display, so a user can view cubes, views, dimensions, and so on, in their own language without needing any additional configuration.

If you enabled the display of translated names on your TM1 server, then cubes, dimensions, elements, and attributes display in your local language as determined by the language setting of your Web browser. If translation is not enabled, object names appear as they were originally created on the TM1 server. In websheets, only elements that are returned by SUBNM or TM1RptRow functions are translated. All other element and object names in websheets display as originally created.

https://www.ibm.com/support/pages/how-use-alias-values-captions-planning-analytics-connection

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=data-attributes-localization

More information:

https://www.ibm.com/support/pages/ibm-planning-analytics-20-fix-lists

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=workspace-translate-model

https://www.ibm.com/support/pages/how-change-language-paw-planning-analytics-workspace

https://cubewise.com/blog/attributes-in-pa/

IBM Planning Analytics Tips & Tricks: Captions

by ·Comments Off on Could not run TI process: FAPMonthlyCompanyDetails_TextImportData

Product:
Cognos Controller 10.4.2 if8 CONTRL_UPDATE_version=CCR-AW64-ML-RTM-10.4.2000.1064-0
Microsoft Windows 2016 server
Planning Analytics 2.0.9.11  TM1-AW64-ML-RTM-11.0.911.20-0

Issue:
After upgrade of TM1 (Planning Analytics) to a newer version than 2.0.9.4 then the Cognos Controller FAP does not work.
The FAP IP stop with a error.

The TM1ProcessError can be:

Cannot convert field number 17, value “123456” to a real number

Error: Data procedure line (0): 01004[Microsoft][ODBC SQL Server Driver]String data, right truncation

Solution:

Upgrade Cognos Controller software to a later version.

https://www.ibm.com/support/pages/download-ibm-cognos-controller-1042-if17

  1. Install Controller 10.4.2 IF 17
  2. Stop the Windows service of the TM1 server that is connected to FAP.
  3. Stop the Windows service IBM Cognos FAP Service.
  4. Manually delete the existing <…>MonthlyCompanyDetails_TextImportData TI process from inside TM1 Architect.
  5. Start the Windows service of the TM1 server that is connected to FAP.
  6. Start the Windows service IBM Cognos FAP Service.
  7. Do a full FAP IP.

 

More information:

https://www.ibm.com/support/pages/cannot-run-ti-process-monthlycompanydetailstextimportdata

These errors occur because Planning Analytics 2.0.9.4 and later does not support FAP jobs with comments containing more than 2047 characters.  The existing <…>MonthlyCompanyDetails_TextImportData TI process that you upgraded from your previous TM1 environment does not adhere to this new limitation.

If you upgrade Planning Analytics 2.0.9, you must upgrade Cognos Controller 10.4.2 to a later version.

https://www.ibm.com/support/pages/how-upgrade-controller-1042x-later-interim-fix-if-fix-pack-patch-level

https://www.ibm.com/support/pages/ibm-planning-analytics-20-fix-lists

https://www.ibm.com/support/pages/node/6519826

https://www.ibm.com/support/pages/ibm-cognos-controller-builds-ccr-name-and-database-version

by ·Comments Off on Do i need to upgrade the cognos controller client?

Product:
Cognos Controller 10.4.2
Microsoft Windows 2016 server

Issue:

We need to install a fix pack/interim fix to cognos controller – do we also need to upgrade the cognos controller client?

Suggested solution:

Do a test upgrade in your test environment, and see if the client works without upgrade the Cognos Controller client.

When you do a installation of a new version, you must upgrade the cognos controller client. But if you only install a Interim fix then the client installed can be used without upgrading.

Any fixes that are in the client side, like help – content issues, will not be solved.

Recommendation is to always upgrade the cognos controller client too.

Before installation we had in the client this version:

IBM Cognos Controller Version 10.4.2000.293
Integration Version 10.4.2000.145
Installer/Updater Kit Version 10.4.2000.1064

after installation we had this in cognos controller client – help – system info:

IBM Cognos Controller Version 10.4.2000.293
Integration Version 10.4.2000.145
Installer/Updater Kit Version 10.4.2000.1111

The client looks like it is working, but not any bugfixes that are in the Cognos Controller client code is not part of the solution.

Supported is to have both cognos controller client and cognos controller server at the same version.

You can check the version of cognos installed in the cmplst.txt file, often found in folder D:\Program Files\ibm\cognos\ccr_64

CONTRL_UPDATE_version=CCR-AW64-ML-RTM-10.4.2000.1111-0
CONTRL_UPDATE_name=IBM Cognos Controller Update
[Main Applications]

When doing a upgrade of cognos controller to a interimfix it is important that you;

Note down cognos controller configuration for report server URL.

Specifically, stop the following Windows services:

  • IBM Cognos
  • IBM Cognos Controller Batch Service
  • IBM Cognos Controller Consolidation
  • IBM Cognos Controller Java Proxy
  • IBM Cognos Controller Reports
  • IBM Cognos Controller Web
  • IBM Cognos Controller Web Spreadsheet Service
  • IBM Cognos Controller Web UI
  • IBM Cognos FAP Service
  • WWW service

Stop COM+ object for Cognos Controller.

Backup the controller web folder

D:\Program Files\ibm\cognos\ccr_64\fcmweb and D:\Program Files\ibm\cognos\ccr_64\frontend

Check that no JAVA processes is running, before you start the upgrade.

After upgrade, Cognos Controller Web need to be reconfigured.

More information:

https://www.ibm.com/support/pages/how-upgrade-controller-1042x-later-interim-fix-if-fix-pack-patch-level

https://www.ibm.com/support/pages/ibm-cognos-controller-builds-ccr-name-and-database-version

Currently Supported Versions of Controller (incl. Interim Fixes):

Updater Kit Build CCR Version DB Version Comment
10.4.2000.1111 10.4.2000.311 10.4.2 IF17 1010 Generally available (FixCentral)
10.4.2000.1108 10.4.2000.300 10.4.2 IF16 1010 Generally available (FixCentral)
10.4.2000.1098 10.4.2000.300 10.4.2 IF15 1010 Generally available (FixCentral)
10.4.2000.1079 10.4.2000.300 10.4.2 IF14 1010
10.4.2000.1078 10.4.2000.300 10.4.2 IF13 1010
10.4.2000.1076 10.4.2000.300 10.4.2 IF12 1010
10.4.2000.1073 10.4.2000.300 10.4.2 IF11GA 1010 Generally available (FixCentral)
10.4.2000.1070 10.4.2000.296 10.4.2 IF10 1010
10.4.2000.1067 10.4.2000.296 10.4.2 IF9 1010
10.4.2000.1064 10.4.2000.293 10.4.2 IF8 1010
10.4.2000.1063 10.4.2000.292 10.4.2 IF7GA 1010 Generally available (FixCentral)
10.4.2000.1018 10.4.2000.270 10.4.2 IF3 1010  
10.4.2000.1013 10.4.2000.267 10.4.2 IF2 1010  
10.4.2000.1002 10.4.2000.259 10.4.2 IF1GA 1010 Generally available (FixCentral)
10.4.2000.185 10.4.2000.252 10.4.2 RTM 1010 Available via Passport Adv. (full install)

 

https://www.ibm.com/support/pages/download-ibm-cognos-controller-1042-if17

https://www.ibm.com/support/pages/how-installupgrade-controller-serverclient

https://www.ibm.com/support/pages/how-install-controller-web

by ·Comments Off on Nothing happens after select database at login to Cognos Controller

Product:

Cognos Controller 10.4.2

Microsoft Windows 2019 server

Issue:

At new installation, i after selection of database, in cognos controller client, are then stuck.

No more information.

Solution:

The cognos controller client uses port 80 to talk to the cognos controller server, but after the selection of database, it will if SSO is active, connect to Cognos BI to validate the user.

This happens on the port listed in Cognos Controller Configuration as Report Server.

If this is port 9300, then port 9300 need to be open in firewall between server and client. This is not the normal case.

You should instead change the Cognos Controller Configuration for Report server to use port 80.

Wrong line at report server:

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

Correct line at report server:

http://caservername.domain.com/ibmcognos/bi/v1/disp

More information:

https://www.ibm.com/support/pages/controller-logon-window-does-not-appear-or-webpage-cannot-be-found-appears-after-selecting-database-caused-incorrect-report-server-settings

by ·Comments Off on paw dashboard is blank

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