page-brochureware.php
IBM Planning Analytics 101
Planning Analytics Our support team maintains articles to assist users with product information, support policies, and common issues. This page contains a searchable list of all Planning Analytics technical notes.

This list of technical support articles was updated on August 07, 2025.
Last Updated Title Abstract
2025-08-06 Planning Analytics app_maintenance.bat Script Fails to Perform Application Deactivation Users are encountering the following error when attempting to deactivate the application using the app_maintenance.bat script:"An exception occurred during operation execute: java.net.SocketException: Connection or outbound has closed exitCode=200"Command used:C: \Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\tools>app_maintenance.bat -serviceurl https://tm1application url:9510/pmpsvc -username <user name> -pwd <password> -op deactivate -app <Application ID>Error foun
2025-07-29 IBM Planning Analytics 2.0 Fix Lists A comprehensive list of defect corrections for all Planning Analytics components. Planning Analytics Workspace, Planning Analytics for Microsoft® Excel and Planning Analytics Spreadsheet Services Release updates are released independently on a short cadence (SC) cycle of typically once per month. IBM® Planning Analytics updates are released on a long cadence (LC) cycle, typically once per 3 months.
2025-07-28 IBM Planning Analytics 2.1 Fix Lists A comprehensive list of defect corrections for all Planning Analytics components. Planning Analytics Workspace, Planning Analytics for Microsoft® Excel and Planning Analytics Spreadsheet Services Release updates are released independently on a short cadence (SC) cycle of typically once per month. IBM® Planning Analytics updates are released on a long cadence (LC) cycle, typically once per 3 months.
2025-07-09 Timeline Reference for IBM Planning Analytics 2.1 Releases List of IBM Planning Analytics component releases as of the end of each month.
2025-07-09 Timeline Reference for IBM Planning Analytics Releases List of IBM Planning Analytics component releases as of the end of each month.
2025-06-17 Must Gather – Troubleshoot Planning Analytics Database Engine A problem has been encountered with a Planning Analytics database
2025-06-16 Rule based cells that are not fed, are not included in FILTER results In Planning Analytics Version 12, no results are returned to a FILTER expression if the cells included in the FILTER are not fed.
2025-06-13 TM1 Web and TM1 Applications Utilizing a Load Balancing Appliance When deploying IBM Cognos TM1 Web where high-availability is required, it may be beneficial to implement load balancing on the IBM Cognos TM1 Web Server. Load balancing this portion of IBM Cognos TM1 can also provide fail-over capabilities should one of the IBM Cognos TM1 Web Servers experience a hardware or system failure. In the event of a server failure using this technique, the user(s) with active sessions on the server that failed would need to refresh their browser.
2025-06-10 How to setup TM1 Web and TM1 Applications for CAM authentication This Technote provides detailed steps to configure the TM1 Server, TM1Web, TM1 Applications (pmpsvc), and pmhub web appliction for CAM authentication. This Technote supplements the following TM1 10.2.2 and Planning Analytics 2.0 Local documentation. TM1 10.2.2 – https://www.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_inst.10.2.2.3.doc/c_tm1op_cogaccman.html#tm1op_cogaccman Planning Analytics 2.0 Local – https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cogno
2025-06-03 The Universal Report does not work when a custom certificate is used on the Data Tier When try to create any Universal Report in Planning Analytics for Excel the error is generated.The problem is happening only with instances where in tm1s.cfg is set UseSSL=T.
2025-05-27 Planning Analytics for Excel – in excel on right click PAfE menu missing In Excel when use Planning Analytics for Excel on right click extension menu is missing
2025-05-21 Planning Analytics Workpace install fails with "Execution failed with exit code 1" Attempts to install Planning Analytics Workspace fail after running start.ps1
2025-05-21 How to determine the version of the Secure Gateway client for Planning analytics on cloud clients? How to check the version installed to see whether you require an upgrade or not?
2025-05-21 How to use GSKit (gsk8capicmd_64.exe) in order to create a PFX keystore file? (PKCS#12 format) How to use GSKit (gsk8capicmd_64.exe) in order to create a PFX keystore file? (PKCS#12 format)
2025-05-21 DB2 select script (run inside TI process) does not show all expected values (missing blank/null value entries), caused by incorrect SQL syntax relating to DB2 script 'SELECT' (run in Turbo Integrator TI script) Customer wants to read some information from the 'main' Controller database, via Planning Analytics (TM1). For example, they want to read from the table XDB19To achieve this, they read the data via a DB2 script, running inside TM1 Turbo Integrator (TI)However, the results do not include all expected rows Specifically, the script cannot find rows where the select answers are set to blank / empty / null
2025-05-21 Providing HTTP ARchive (HAR) format files to IBM Support for troubleshooting HTTP ARchive format (HAR) files may contain confidential information which you should be aware of.
2025-05-19 IBM Planning Analytics Spreadsheet Services after update/fresh install of version  2.0.99 or newer, cannot list database instances when using custom SSL IBM Planning Analytics Spreadsheet Services after update/fresh install of version 2.0.99 or newer, cannot list database instances when using custom SSL
2025-05-15 Understanding Planning Analytics as a Service Database Memory Usage The purpose of this document is to highlight the tools available to help with understanding the memory usage of a Planning Analytics as a Service database
2025-05-09 Elements inserted via tm1web cannot be read back in tm1web Element attributes not being shown in active form (in tm1 web) after adding an element. In Excel it works properly. New elements are being added by using an action button in a report. By selecting a reference element, all attributes but alias are being copied from the reference to the new one. After starting the process, the new element (and the attributes) is being shown in Excel and Architect but not in TM1 web.
2025-05-09 How to run a TM1 TI Process from Cognos Command Center with a parameter Steps to pass a parameter to a Planning Analytics TM1 process
2025-05-09 How to capture TM1 server crash dump files with WER This Technote provides alternative steps to using ADPlus to capture crash dump files during a TM1 server crash.The advantages of Windows Error Reporting over ADPlus are as follows:1 – No additional software needs to be installed. WER is included with Windows Server (since Windows Server 2008).2 – No process to start before the TM1 Server crash.3 – A user does not need to remain logged into the system running TM1.
2025-05-09 "Error with CAM Passport" trying to log into TM1 "Server Explorer" 11.0.0.918 after Controller client was used User launches Controller client. User logs in. User then launches TM1 Perspectives. User launches 'Server Explorer' and double-clicks on TM1 (to logon). User tries to logon, but receives an error.
2025-05-09 No default Boot2Docker ISO found locally Insatlled Docker Toolbox on Windows to install Planning Analytics Workspace 2.0 (PAW). The installation of PAW stops with an error message and the reffered log file indicate the folloing error message: Running pre-create checks… (paw) No default Boot2Docker ISO found locally, downloading the latest release… Error with pre-create check: "Get https://api.github.com/repos/boot2docker/boot2docker/releases/latest: dial tcp 192.30.253.116:443: connectex: A connection attempt failed because the connected party
2025-05-09 We can't load the visualization, because its associated data set 'undefined' isn't available – Changing Exploration View to a visualization In Planning Analytics Workspace, when changing a particular Exploration View to a visualization (synonyms: graph, or chart)The following error is displayed:We can't load the visualization, because its associated data set 'undefined' isn't available
2025-05-09 IBM Planning Analytics Missing from Excel Ribbon After installing Planning Analytics for Microsoft Excel the IBM Planning Analytics tab is missing from the ribbon. The add-in can be enabled manually by enabling the following COM Add-in named IBM Framework for Office.
2025-05-09 How to Troubleshoot a Planning Analytics TM1 Server Crash Planning Analytics TM1 Server crash
2025-05-09 Planning Analytics Workspace validation error on the IBM Cognos BI Dispatcher URI While attempting to validate the CAM configuration in the IBM Planning Analytics Workspace Administration Tool an error is encountered for the IBM Cognos BI Dispatcher URI. The error message contains the following: Error: Server responded with status code 599 CAMNamespace Client CM-REQ-4342 An error occurred with the client. error caf CM-REQ-4159 Content Manager returned an error in the response header. The error "cmAuthenticateFailed CM-CAM-4005 Unable to authenticate. Check your security directory ser
2025-05-09 Unable to fetch data for content tree Error while expanding the Tm1 Server database within Planning Analytics Workspace :"Unable to fetch data for content treeSession can not be established for server : <Server Name>500 (Internal Server Error) {"code":"Explorer","refID":"message":Failed to get children for Server cubes","cause":"java.net.SickerException:Connection reset"}"
2025-05-09 Load denied by X-Frame-Options TM1Web is configured with HTTP but some of the custom applications where Websheets are embedded in iFrame are configured with HTTPs.Users get this error while trying to access the Websheets from these applications :"Load denied by X-Frame-Options: http://localhost:9510/tm1web/UrlApi.jsp#Action=Open&Type=WebSheet&Workbook=Applications/Planning Sample/Management Reporting/Actual v Budget&AdminHost=localhost&TM1Server=Planning Sample does not permit cross-origin framing"
2025-05-09 Planning Analytics Workspace: Indefinite Loading bar when accessing a TM1 server Unable to connect to a TM1 server from Planning Analytics Workspace (PAW) for modelling as a loading bar appears indefinitely below the TM1 server. A connection could not be established from PAW however the same model was accessible via Architect.
2025-05-09 After upgrading Planning Analytics Administration Agent version: "Agent unreachable" and "Cannot display resource information" errors in the web interface After the Planning Analytics Administration Agent (PAAA) has been updated with a newer version, the "Databases" tab of the Planning Analytics Workspace Administration page displays"Agent unreachable" error at the topand"Cannot display resource information" error for each TM1 server.The messages.log (in C:\Program Files\ibm\cognos\tm1_64\paa_agent\wlp\usr\servers\kate-agent\logs) contains errors of that type:0000003c com.ibm.pa.kate.agent.service.PAKateAgentService
2025-05-09 "The action has been terminated because it exceeds the configured maximum memory limit" error is received while opening a Planning Analytics Workspace Book. Planning Analytics Workspace books fail to render embedded web sheets with the following error:"The action has been terminated because it exceeds the configured maximum memory limit error"
2025-05-09 Index was out of range error when running Turbo Integrator Process (via Action Button) in Planning Analytics for Excel User is getting "Index was out of range" error when running a Turbo Integrator Process (via Action Button) in Planning Analytics for Excel
2025-05-09 Unable to Start Planning Analytics Workspace Administration Tool on Windows – Execution failed with exit code 125 After an install of Planning Analytics Workspace on Windows, the Administration Tool does not start.
2025-05-09 How to find the user who has opened books in a Planning Analytics Workspace How to find the user who has opened books in a Planning Analytics workspace
2025-05-09 Include Navigation Pane for selected user not working in tm1web NavTreeHidden functionality is not working when the TM1 Web navigation settings are changed for a selected non-admin user. 1.Clients/Groups in Architect, > Settings > Un-tick the Show Navigation box. 2. Client Settings > Apply to Selected Clients But when the relevant user logs into tm1web, the navigation is still there.
2025-05-09 Not able to export from TM1Web Not able to export from TM1Web (Slice/Snapshot/PDF). It stucks on "Curently publishing…" message and no reports gets generated. Same behavior with all the TM1 Servers including the sample TM1 Servers.
2025-05-09 Script error when opening Subset Editor in Planning Analytics for Excel In Planning Analytics for Excel, when double-clicking a cell having a SUBNM formula, the Subset Editor opens as a blank window with a script error in it : "." expected http:///prism/js/dashboardAuthoring.js
2025-05-09 An alias which duplicates another alias or a primary name was found. Do you want to stay in the attributes editor and correct the problem manually ? Error occurs while defining an Alias in the Architect :"An alias which duplicates another alias or a primary name was found.Do you want to stay in the attributes editor and correct the problem manually ?"
2025-05-09 How to Configure TM1 Application Web to connect to TM1 Web since 2.0.9.2 ? (IBM Planning Analytics Spreadsheet Services) Since Planning Analytics 2.0.9.2, the TM1 Web component has been removed from the TM1 Application Server ("IBM Cognos TM1" service, using Websphere Liberty Profile). Now TM1 Web installation has to be done separately, by downloading "IBM Planning Analytics Spreadsheet Services" (IBM PASS) from IBM Fix Central web site ( https://www.ibm.com/support/fixcentral ), and installing it either separately or on the same machine as an existing Planning Analytics installation. IBM Planning Analytics Spreadsheet Ser
2025-05-09 A blank white page is rendered while opening Websheets within Planning Analytics Workspace. Planning Analytics Workspace returns a blank white page while rendering an embedded web-sheet or rendering a web-sheet from Planning Analytics Workspace database tree.
2025-05-09 The Logon Box Appears Blank in Planning Analytics For Excel and Prevents User From Logging In User is unable to log in to Planning Analytics For Excel as the Logon Box appears blank.The username and password option boxes to enter credentials are not available.
2025-05-09 Cannot add IBM Framework for Office COM Add-in IBM Planning Analytics ribbon does not appear in Excel. Excel Add-ins are showing properly however COM Add-ins are not showing "IBM Framework for Office" Add-in.Checking the registry entries for CognosOffice12.Connection are showing values set to 3. Adding the COM add-in (cognosofficeshim12.dll) manually does nothing as it is still not visible in the COM add-ins window.
2025-05-09 How to Troubleshoot a Planning Analytics Web Tier Hang Planning Analytics Web Tier hang (TM1 Application Server, TM1 Web, Spreadsheet Service)
2025-05-09 Configure Planning Analytics 2.0 TM1 Server with SSL Cognos BI Dispatcher This Technote explains the process to configure Planning Analytics 2.0 Local TM1 Server for CAM Authentication when using a Cognos BI Dispatcher with SSL enabled. To configure TM1 Server 10.2.2 and lower to work with a Cognos BI Dispatcher using SSL please see: http://www-01.ibm.com/support/docview.wss?uid=swg21980367. The process to configure CAM Authentication with a SSL enabled Cognos BI Dispatcher has changed in Planning Analytics 2.0 as the CAMSSLCertificate and SkipSSLCAMHostCheck parameters in the
2025-05-09 How to configure Planning Analytics Spreadsheet Services Starting with Planning Analytics 2.0.9.2, TM1 Web is no longer packaged with the PA installation. With the change of TM1 Web to the new Planning Analytics Spreadsheet Services (PASS), the options for configuration changed slightly. For example, you can no longer use the "Cognos Configuration" application in order to set the available memory for the Java process. However, this and other parameters are still configurable in a new location.
2025-05-09 Visualizations loose labels when using "Fit to page" Visualizations loose labels when using "Fit to page"
2025-05-09 TM1 Web error: "Export prevented. Cubeview export is too large" whatever the value of MaximumSheetsForExport Trying to export "Slice to Excel", "Snapshot to Excel", or "Export to PDF" fails with error:"Export preventedThe Cubeview export is too large. Reduce the size of your export by selecting fewer dimensions on rows or columns, or smaller subsets of data."This error occurs whatever the value of MaximumSheetsForExport in tm1web_config.xml (in C:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\WEB-INF\configuration)
2025-05-09 Planning Analytics Workspace installation FAQ Are you new to IBM Planning Analytics Workspace? Before you begin your Workspace installation, please read this FAQ: What additional software is required when installing IBM Planning Analytics Workspace? As of version 2.0.46, all software required for installing IBM Planning Analytics Workspace is bundled with the installation package when installing on Microsoft Windows or RHEL. Are there any additional steps when installing on IBM Planning Analytics Workspace on CentOS
2025-05-09 Unable to stop TM1 Admin Server using IBM Cognos Configuration tool Unable to stop TM1 Admin Server using IBM Cognos Configuration tool
2025-05-09 Unable to view the status of Planning Analytics databases post upgrading to Planning Analytics Agent version 52(2.0.52.1270) Planning Analytics databases display "Cannot display resource information" and the agent shows up as "unreachable" post upgrade to Workspace 52 from an older version.
2025-05-09 Using "Edit Set" or "Open Viewer" displays a blank pop-up window In Planning Analytics for Excel, when using "Edit Set" menu to open the Set Editor, or "Open Viewer" menu to get the cube Viewer, an empty pop-up window appears instead of showing the Set Editor or the Viewer.This happens whatever default supported browser that is set on the client machine: Edge, Firefox, Chrome.
2025-05-09 Errors CWWKG0014E or CWPKI0819I when starting TM1 Web after setting up custom SSL/TLS After configuring Planning Analytics Spreadsheet Services (TM1 Web) with custom SSL / TLS / HTTPS, the "IBM Planning Analytics Spreadsheet Services" service is started but is not listening (by default, javaw.exe is listening on port 9510)One of these errors can occur:In tm1_messages.log:CWPKI0819I: The default keystore is not created because there is no password in the <keyStore id="defaultKeyStore"/> element, and the 'keystore_password' environment variable is not set. In console.log:CWWKG0014E: The
2025-05-09 Bad gateway 502 error in Planning Analytics for Excel when a custom certificate is used in a Planning Analytic Workspace When try to connect to any TM1 instance the error Bad gateway 502 error is displayed in Planning Analytics for Excel when a custom certificate is used in TM1 Data tier
2025-05-09 PA-GATEWAY Error: An unexpected error has occurred. See the server logs for more information When attempting to log in to Planning Analytics Workspace, the following error is thrown:PA-GATEWAY Error: An unexpected error has occurredSee the server logs for more information
2025-05-09 Planning Analytics Administration (Workspace) Fails to Communicate With Admin Agent Upon opening of Planning Analytics Administration (Workspace), the status of the agent is Unavailable. The agent is also unable to provide TM1 Server metrics.
2025-05-09 How to restrict cipher suites in Planning Analytics Spreadsheet Services Vulnerability scan identified weak SSL/TLS key exchange in Planning Analytics Spreadsheet Services. To mitigate potential risks, restrict Planning Analytics Spreadsheet Services to only use secure cipher suites. This is a supplement to the technote for WebSphere Application Server & Liberty to better illustrate syntax that works for Planning Analytics Spreadsheet Services. https://community.ibm.com/community/user/wasdevops/blogs/alaine-demyers/2021/08/18/customer-cipher-suites-on-traditional-webspher
2025-05-09 How to Configure Planning Analytics Timeout Settings The following page contains a consolidated view of the various timeout settings available to Planning Analytics. Please take in to consideration that timeouts allow the cleanup of inactive sessions, freeing up resources (memory) from various services to be used by active users. Timeouts set too high may have a negative impact on your environment.
2025-05-09 TM1Web Fails to Start if JVM Max Heap Size is More Than 32 GB Although the steps in this document are correct, it is NOT recommended to have a Java Heap set to larger than 24GB for Planning Analytics 2.0.5 and lower (which uses JRE 7). As of Planning Analytics 2.0.6 and higher (JRE 8), the limit may be increased but not recommend to be set larger than 56GB. The max Java Heap allowed while also maintaining -Xcompressedrefs is 24GB (2.0.5 and lower) or 56GB (2.0.6 and higher).Disabling -Xcompressedrefs (by using -Xnocompressedrefs) results in additional memo
2025-05-09 Unable to negotiate authorization – Single sign-on stops working in Workspace after upgrading Planning Analytics to 2.0.9.1 A working environment has been updated to Planning Analytics 2.0.9.1.This environment includes a TM1 Server configured for SSO, using Integrated Windows Authentication (IWA).The tm1s.cfg of the TM1 Server contains these parameters to achieve this:SecurityPackageName=kerberosIntegratedSecurityMode=3Since this upgrade, it is not possible to connect to Planning Analytics Workspace.
2025-05-09 Spread Data menu is deactivated on specific element There are some elements that Spread Data menu is deactivated.Some elements are leaf and some elements are consolidation.
2025-05-09 How to force the reinstallation of the docker version provided by Workspace, without losing existing databases and images? When the docker installation gets broken for unknown reason, or when a too old docker version is already installed and needs an update, we might want to let Planning Analytics Workspace installing docker for us (from the "<PAW>/software" directory). However, by default, Planning Analytics Workspace does not install or update docker if a version of docker is already installed. How to force the reinstallation of the docker version provided by Workspace, without losing existing databases and images?
2025-05-09 In Planning Analytics for Excel with SSO (Kerberos/SPNEGO) clicking a SUBNM displays either the connection page or a blank IE window A Planning Analytics installation is configured for SSO, based on Kerberos / SPNEGO.In Planning Analytics for Excel, the first connection with single sign-on is working correctly.However, when we click a SUBNM formula, either the Internet Explorer login page is displayed again or a blank page is displayed.The connection is falling into a loop.
2025-05-09 Unable to Publish Cognos Insight Workspace to IBM Cognos Analytics You are unable to Publish your Cognos Insight Workspace to IBM Cognos Analytics
2025-05-09 Planning Analytics Workspace: Docker Service not starting in Services Docker is a pre-requisite for Planning Analytics Workspace. If the Docker service does not start, you will not be able to start Planning Analytics Workspace. This issue talks about the Docker service being unable to start through Services (services.msc).
2025-05-09 Proxy error when accessing Planning Analytics Workspace When users are trying to access Planning Analytics Workspace, they are receiving an error message similar to this one:Proxy Error The proxy server received an invalid response from an upstream serverThe proxy server could not handle the request GET Reason: DNS lookup failure for: wa-proxy
2025-05-09 How to Troubleshoot a Planning Analytics TM1 Server Hang Planning Analytics TM1 Data Server hang
2025-05-09 Unable to refresh or create Dynamic Reports IBM Planning Analytics for Microsoft Excel is unable to refresh or create Dynamic Reports.
2025-05-09 PAW error message: Unable to fetch data for content tree … 401 Unauthorized In try to open a cube in the "Data" section in PAW result in an error message. This happen not to all of the TM1 cubes. Error message: Unable to fetch data for content tree. Session can not be established for server: &lt;servername&gt; 401 (Unauthorized) {"errorMessage"."","query","/api/v1/Model/Cubes%28%29?$count=true","httpStatusC…."
2025-05-09 Configure TM1 CAM Authentication using Cognos Analytics 11.0 with SSO This Technote explains steps required to configure TM1 for CAM authentication when Cognos Analytics 11.0 is configured with single sign on (SSO). The solution provided in this Technote applies to both TM1 10.2.2 and the TM1 component provided with Planning Analytics 2.0 Local. This configurion has been tested with Cognos Analytics 11.0.4, 11.0.5, and 11.0.6.
2025-05-09 In Chrome, "Login failed" error in TM1 Web with Windows Authentication (IWA, Kerberos/SPNEGO) A previously working TM1 Web environment is not working anymore: users are receiving "Authentication error -Login failed" errors in Chrome (and Edge) when trying to connect to a TM1 Server by using Integrated Windows Authentication (SSO, Kerberos, SPNEGO).Errors in tm1server.log:TM1.Login Login attempt by client: ***TM1.Login Login Error: SystemServerClientConnectFailedErrors in tm1_messages.log on the TM1 Web side:[5/9/22 9:43:48:361 CEST] 00000cfa SystemErr R com.ibm.security.krb5.KrbException, status cod
2025-05-09 Script error when accessing Oracle Web ADI after installing Planning Analytics for Microsoft Excel After installing Planning Analytics for Microsoft Excel, users may see a 'Member not found' script error message and references to specific .js files when accessing Oracle Web ADI.
2025-05-09 Access failed to Planning Analytics Workspace Administration tool The administration tool can web page cannot be accessed after install Planning Analytics Workspace. When attempting to access to administration tool URL, 'This page can't be displayed' is displayed. Executing the 'Docker ps' command returns only following containters. 0.0.0.0:8888->8888/tcp admintool pa-login 1338/tcp social share-app share-proxy 3333/tcp user-admin glass welcome
2025-05-09 Planning Analytics Administration Agent is unreachable Planning Analytics Administration Agent is unreachable
2025-05-09 Planning Analytics For Excel: the "IBM Framework for Office" COM add-in is disabled each time Excel restarts – Or other abnormal behaviours on some client machines only Each time Excel is restarted, Planning Analytics For Excel is deactivated.It is always necessary to go to File / Options / Add-ins, go to manage the "COM add-ins" and check the "IBM Framework for Office" option again.Even a simple uninstallation of Planning Analytics For Excel followed by a reinstallation does not solve the problem.(This document can also be applied when encountering other abnormal behaviours, not related to data, that occurs only for some particular users or client machines)
2025-05-09 How to manually capture a java core dump for IBM Planning Analytics Spreadsheet Service (TM1Web) and TM1 application service (PMPVC) How to manually capture a java core dump for IBM Planning Analytics Spreadsheet Service (TM1Web) and TM1 application service (PMPSVC)
2025-05-09 Some Icons Do Not Appear In PA for Excel Cube Viewer or Subset Editor When using the Cube Viewer or Subset Editor Window in PA for Excel, some icons are not visible.
2025-05-09 Login window does not appear in Planning Analytics For Excel Planning Analytics servers are configured with IntegratedSecurityMode 5 to use Cognos Analytics authentication (CAM Authentication)When Users try to access the Planning Analytics For Excel (PAx) Cognos Analytics login window does not appear.Instead Users see the blank window.
2025-05-09 Planning Analytics Workspace: ConnectTimeoutException when connecting to a TM1 server model Unable to connect to a TM1 server from Planning Analytics Workspace (PAW) and the error message "ConnectTimeoutException" appears.
2025-05-09 Planning Analytics For Excel: Error in Exploration View: "httpStatusCode":500 PROBLEMWorking within an Exploration Report of Planning Analytics For Excel, the following error occurs when editing a dimension subsetWhen the error occurs, one no longer can work within the subset editor and must close the editor.
2025-05-09 What to do if capturing a Planning Analytics "tm1sd.exe" crash dump file has failed? In the case of a TM1 server process crash, you may want to understand why this happened so that it can be avoided in the future. For IBM support to find a guaranteed answer, you must provide a crash dump file. The recommended method for enabling crash dump capturing is using the Windows Error Reporting (WER) tool built into Windows. This can be enabled for the TM1 process by following this document: https://www.ibm.com/support/pages/how-capture-tm1-server-crash-dump-files-werSometimes, even after setting th
2025-05-09 Proxy error displayed while attempting to login to Planning Analytics Workspace. Proxy error is received while attempting to log in to Planning Analytics Workspace, refer detailed error message below.The proxy server received an invalid response from an upstream server. The proxy server could not handle the requestReason: Error reading from remote server.
2025-05-09 How to check the exact version of PAAA (Planning Analytics Administration Agent) How to check the exact version of PAAA (Planning Analytics Administration Agent)
2025-05-09 Operations Console prompt for CAM authentication with SSO enabled Cognos Analytics environment Operations Console prompt for CAM authentication with SSO enabled Cognos Analytics environment
2025-05-09 Planning Analytics Workspace social container in restarting state. After restarting machine on which Planning Analytics Workspace is installed accessing Workspace from browser displays "Planning Analytics Workspace is unavailable. Try again in a few minutes.".
2025-05-09 Using new log4j2.properties to trace user login and activities, cube views, workbooks, worksheets, memory, in TM1 Web 2.0.70 and higher Since Planning Analytics Spreadsheet Services (TM1 Web) version 2.0.70, the old log4j.properties is replaced by a new log4j2.properties in C:\Program Files\ibm\cognos\tm1web\webapps\tm1web\WEB-INF\configuration\ . This new logging method is describe in the official documentation: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=utwl-configuring-enabling-tm1-web-logging-versions-2070-later How to use new "log4j2.properties" to trace user login and activities, cube views, workbooks, worksheet
2025-05-09 StringCellUpdateError committing data in PA for Excel An error occurs committing data in PA for Excel.
2025-05-09 User user is not authorized to access Planning Analytics. Please contact the system administrator for support. Login again as another user A user gets the following error when attempts to log in to Planning Analytics Workspace for the first time.
2025-05-09 Unable to perform security functions: TM1 Server "Security", "Clients/Groups" menu option is grayed out or missing This issue occurs despite the connected user being part of the ADMIN group.In TM1 Architect or TM1 Perspectives Server Explorer, Server 'Security', 'Clients/Groups' menu option is missing.It is not possible to edit or create any objects (cube, dimension, process, rule, and so on)
2025-05-09 Planning Analytics Workspace not Accessible from Client Systems This Technote applies only to Planning Analytics Workspace (PAW) in Windows environments. In Windows environments Docker utilized Oracle VirtualBox to run the PAW image. This Technote explains how VirtualBox Network Address Translation (NAT) must be configured so that web browsers on client systems are able to access PAW. PAW can be accessed from a browser on the server running PAW using the IP 192.168.40.10, and the PAW Administration Tool at 192.168.40.10:8888. VirtualBox and NAT are not used when D
2025-05-09 Unable to log in to Planning Analytics / TM1Web using SSO / SPNEGO – 403 Error Users are unable to log in to Planning Analytics / TM1Web when the server had been configured for SSO / SPNEGO authentication. Users received a 403 error in the browser.
2025-05-09 Unable to assign assets while creating Applications and Plans in Planning Analytics Workspace Unable to assign assets while creating Applications and Plans in Planning Analytics Workspace
2025-05-09 Cannot start service pa-gateway: failed to create endpoint pa-gateway on network nat: hns failed with error: the object already exists Workspace pa-gateway service does not start:Cannot start service pa-gateway: failed to create endpoint pa-gateway on network nat: hns failed with error: the object already exists
2025-05-09 How to connect to TM1 Server through REST API by using Postman? How to connect to TM1 Server through REST API by using Postman?
2025-05-09 COI-ERR-2025 IBM Planning Analytics for Excel was unable to find an installed Microsoft Edge WebView2 runtime This problem happens with the 64-bit version of Planning Analytics for Excel.There is an error when trying to connect with Edge WebView2 configured ("r74_EnableWebView2ForAuth" is set to "true" in tm1features.json):COI-ERR-2025 IBM Planning Analytics for Excel was unable to find an installed Microsoft Edge WebView2 runtime. Please download and install the Microsoft Edge WebView2 runtime in accordance with your local IT policies.Yet, Edge WebView2 version 64-bit appears to be installed:-The Edge WebView2 ins
2025-05-09 How to capture book specification in Planning Analytics Workspace How can I get book structure in Planning Analytics Workspace?
2025-05-09 TM1 10.2.2 installations that were using the certificate version 2 (tm1ca_v2, 2048-bit) are not working anymore as the certificate has expired on 25 August 2022 This document is for TM1 10.2.2 only. For Planning Analytics 2.0.x follow this other document:TM1 Server v2 SSL Certificate Expiry on 25 August 2022 Since the 25 August 2022, the TM1 Server and TM1 Admin Server certificates version 2 (using 2048-bit key) have expired.These certificates are signed by an IBM Cognos proprietary root certificate authority named "TM1 CA V2" ("tm1ca_v2.pem" in "/tm1_64/bin64/ssl" folder) that has also expired since the 25 August 2022.
2025-05-09 Planning Analytics Workspace is unavailable. Try again in a few minutes The following message is displayed in a web browser when any user is trying to connect to Planning Analytics Workspace:"Planning Analytics Workspace is unavailable. Try again in a few minutes"
2025-05-09 TM1 breakback: Hold & Spread does not work The breakback of the consolidated element does not work if the user holds consolidated elements and wants to make changes to elements directly below the C element. If there’s another C element above the one with the hold, then the breakback works. It won’t work if the hold cell is a consolidated element above the element which cell should be updated. If the same hold and spread is done on the N element of the breakback dimension, the data spread works correctly.
2025-05-09 TM1 servers from an unknown IP seen registered with the Admin Host In Cognos Configuration only 3 TM1 servers were registered however in Architect 5 TM1 servers were seenClicking on the 2 unknown TM1 servers caused a hang.
2025-05-09 How to Regenerate Cryptographic Keys for Planning Analytics Starting the Planning Analytics service gives cryptographic errors of type CAM-CRP. In addition, you might receive an error message: The Cryptographic information cannot be encrypted. Do you want to save the configuration in plain text?
2025-05-09 TM1Web Custom SSL Configuration Not Working as Expected – javax.net.ssl.SSLHandshakeException: no cipher suites in common After attempting to configure TM1Web to use custom certificates, users can not access the website and see a connection refused message.
2025-05-09 How to restart TM1 Admin Server service after a crash or a hang without impacting running TM1 Servers ? For some reasons it might happen that the TM1 Admin Server either crashes or hangs.In such a situation, if we try to restart the "IBM Cognos TM1 Admin Server x64" service through the Windows Services tool (services.msc), we get two annoying behaviours:-&gt; If the TM1 Admin Server has crashed, we get the following error message when trying to restart it : "The IBM Cognos TM1 Admin Server x64 service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other
2025-05-09 After executing TM1User() function, the performance of next Refresh Data or Rebuild degrades In Planning Analytics for Excel, once the TM1User() function is executed through some VBA macro, the performance degrades: the next Refresh Sheet or Rebuild Sheet or Rebuild Book is slow.The time taken can goes from several seconds to several minutes.
2025-05-09 Unable to connect to TM1 Server with a non local TM1 Admin Server TM1 Server can support multiple TM1 Admin Servers .However not able to connect to TM1 Server through TM1 Clients such as Architect if only non-local TM1 Admin Server is running.
2025-05-09 Protecting a Quick Report in IBM Planning Analytics for Microsoft Excel You may want to protect your Quick Report in IBM Planning Analytics for Microsoft Excel. This document shows you how you can protect your Quick Reports.
2025-05-09 Getting "Forbidden" error when logging into TM1Web using CAM security After entering log in credentials, getting a "Forbidden" error.
2025-05-09 How to Enable Garbage Collection (GC) Logging on the TM1 Application Server There may be times where Garbage Collection logging is required to diagnose a specific problem with the TM1 Application Server. This document outlines the steps required to enable Garbage Collection logging for the bundled Websphere Liberty Application Server.
2025-05-09 After an upgrade of Cognos Analytics, none of the Planning Analytics components can log in anymore with CAM security: blank page or HTTP 404 error After IBM Cognos Analytics was upgraded, the IBM Planning Analytics components cannot connect to CAM security anymore.The web browser shows either a blank page or an HTTP 404 error (page not found)
2025-05-09 SQL Statement failed on Azure Synapse – Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint An ODBC data source was created to access an Azure Synapse database.The "SQL Statement failed" error appears when we click the "Preview" button in Architect, in the TI process creation dialog.If we try to run the process, the following error appears in tm1server.log:SQLState: 37000 SQLMsg: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint.
2025-05-09 Planning Analytics Workspace Administration shows "Processing" instead of "Started" for server status When accessing Planning Analytics Servers from Planning Analytics Workspace Administration page, the Planning Analytics Server status is displayed as "Processing".
2025-05-09 Planning Analytics Server Logging for ODATA\Planning Analytics Workspace This Technote provides steps to enable REST API debug logging for the TM1 Server. This logging is essential to understand how Planning Analytics Workspace interacts with a TM1 model.
2025-05-09 Planning Analytics Workspace forecasting feature performance issue Planning Analytics Workspace forecasting feature is slow: forecasting on 100000 lines takes several hours.
2025-05-09 Cannot install Docker on some machines: "WARNING: Cannot verify the file SHA256. Deleting the file." IBM Planning Analytics Workspace (PAW) relies on Docker, which is a non-IBM software.Docker can be installed on Windows Server 2016 by simply running these two commands in Powershell :Install-Module DockerMsftProvider -ForceInstall-Package Docker -ProviderName DockerMsftProvider -ForceBut sometimes, on some machines, the Install-Package command may terminate with this error :WARNING: Cannot verify the file SHA256. Deleting the file.Sometimes it can be worked around by installing a specific version of Docker
2025-05-09 How to check the version of Java that Planning Analytics is using. How to check the version of Java that Planning Analytics is using.
2025-05-09 TM1Web URL to Login to a Specific Planning Analytics Model This Technote explains how to create a URL that can be used to bypass the options for selecting the Planning Analytics admin host and model name on the TM1Web login page without setting an admin host or model name in the tm1web_config.xml file. This technique may be useful in cases where there are multiple Planning Analytics models but only a single instance of TM1Web.
2025-05-09 MTFeeders Exception Message in tm1server.log file The following exception message is seen in the tm1server.log file: 12345 [] INFO 2018-01-01 09:09:09.099 TM1.Server TM1CubeImpl::ProcessFeeders: Exception, done computing feeders for base cube 'ANY CUBE'.This message might be presented when starting the Planning Analytics model or when saving rules.
2025-05-09 Error: can only create exec sessions on running containers: container state improper Unable to launch admintool after a restart on Redhat8.X while using Podman.
2025-05-09 AuditLogMaxQueryMemory too small using Rest API to retrieve auditlog entries. AuditLogMaxQueryMemory too small using Rest API to retrieve auditlog entries.
2025-05-09 Ribbon and button texts are not rendering correctly in Planning Analytics for Excel Strange texts are displayed for Planning Analytics for Excel
2025-05-09 Attribute }TM1_DefaultDisplayValue is not update when user name was changed in LDAP Attribute }TM1_DefaultDisplayValue is not update when user name was changed in LDAPExample scenario: Change the name of the user in the connected LDAP The CAMID of the user does not change, the name of the cognos user is updated correctly The same user in tm1 still has the same ID, which is understandable since the CAMID has not changed either The attribute }TM1_DefaultDisplayValue still has the old name as value for the user After the value is deleted manually and the user logs in again, the attribute disp
2025-05-09 ViewZeroOut on a cube which uses UNDEFVALS does not set values to the UNDEFVALS state If you have a cube which has UNDEFVALS enabled in the rule of the cube, the ViewZeroOut function sets the cells in the cube to 0 and not the state of an undefined value.
2025-05-09 Error "TOMCAT'S SERVER.XML FILE DOES NOT EXIST" When launching Cognos Configuration For PA Local on Linux OS Receive the below error message when launching the Cognos configuration on the Linux operating system. Does this impact Planning analytics Local installation on Linux OS?See below the error message received.Using /usr/lib/jvm/java-ibm/bin/java -bash-4.2$ 07/02/2020,15:13:39,Dbg,Use Customized settings for font and color. 07/02/2020,15:13:40,Err,Tomcat's server.xml file does not exist at the following path: /&lt;PA_Install_Dir&gt;/wlp/usr/servers/cognosserver/server.xml 07/02/2020,15:13:40,Err,org.dom4j
2025-05-09 Sandbox dimension is missing in reports generated from the Cube Viewer Users can use sandbox dimensions in the Cube Viewer, however, if users generate a report from the Cube Viewer, the sandbox dimension will not be present in the generated report.
2025-05-09 When Attempting to Add New Users or Groups (using CAM Security) via Architect, the Popup Window is Blank When using Architect to add new users or groups to your TM1 Server (via Client/Groups window), the popup window that should load the Cognos Security page is blank.
2025-05-09 Unable to Create Quick Report in Planning Analytics for Excel – "Microsoft is waiting for another application to complete an OLE action" In Planning Analytics for Excel, no users can create a quick report. The following error is returned:"Microsoft is waiting for another application to complete an OLE action"
2025-05-09 Performance Consideration With Multi (Parallel) TI Process Techniques When using multiple TI processes in parallel (TM1RunTI / RunProcess), there are a number of factors that could hinder or improve performance of your overall runtime.
2025-05-09 How to configure TM1 data tier back to the default SSL/TLS in case of issue with the current custom SSL/TLS configuration? This document applies to cases when TM1 data tier (TM1 Admin Server and TM1 Server) suddenly stops working with custom SSL/TLS, in a situation where getting the application back online within a short delay is imperative. Such issues might have multiple causes: -Planning Analytics was upgraded, and some defect or product change is causing the certificate chain to be rejected. For example, since Planning Analytics 2.0.9.5, security was hardened: the chain of trust must conform to RFC-5280 standards (see ht
2025-05-09 Planning Analytics IBM Cognos Configuration Crashes on Startup When launching IBM Cognos Configuration from the Start Menu, it crashes after a couple of seconds.
2025-05-09 PAfE does not expand aggregated element in TM1RPTROW when it is integrating a SUBNM from another cell. PAfE does not expand aggregated element in TM1RPTROW when it is integrating a SUBNM from another cell.
2025-05-09 Troubleshooting IBM Planning Analytics For Excel add-in Various client issues may occur with Planning Analytics for Excel (PAfE), like:- Nothing happens after trying to connect to Planning Analytics Workspace- Connection is failing- The right pane that should contain TM1 server objects is empty or does not even appear- SUBNM formulas are showing #NAME! error and DBRW formulas contain #VALUE! error, even after running "Refresh Sheet", "Refresh Book", or "Recreate Workbook"- Some buttons may not work- Some weird behaviour or error messages may happen (VBA errors,
2025-05-09 How to implement encryption at REST over CAM authenticated Planning Analytics Server. This document is a real example that goes through the configuration of Planning Analytics Encryption at REST using a sample server. The intent of this document is to allow you to follow along, implementing the necessary changes for the environment you are configuring. The official production documentation should still be reviewed and used, and can be found here: https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_modelencryption.html
2025-05-09 How are regional settings (locales and languages) used by Planning Analytics tools on Windows ? How are regional settings (locales and languages) used by Planning Analytics tools on Windows ?
2025-05-09 Planning Analytics Workspace 2.0.22 and 2.0.23 for Windows Server 2016 Removed From Fix Central Planning Analytics Workspace 2.0.22 and 2.0.23 for Windows Server 2016 have been removed from from the IBM Fix Central. The only currently available version of Planning Analytics Workspace available for Windows Server 2016 is 2.0.21.
2025-05-09 How to restart an unresponsive TM1 Admin Server without restarting all TM1 Servers that depend on it ? When the list of running TM1 Servers is not displayed in Architect, Perspectives, TM1 Web, or Planning Analytics Workspace, this may be caused by a TM1 Admin Server that has crashed or that is not responding despite it is "running". This kind of error may also be found in the Event Viewer : " cannot connect to admin server at host and port 5498 " Restarting the "IBM Cognos TM1 Admin Server x64" service is usually sufficient to solve the problem, but we can encounter two problems: Case 1) If the TM1
2025-05-09 Error response from daemon when running admintool.ps1 or answering Yes to "Start the Administration Tool?" question PAW has been correctly installed and the images have been loaded by Start.ps1 (or underlying /scripts/build.ps1) ; the admintool image is listed when running "docker images" or "docker image ls" command.Despite this, the administration tool container cannot be run. The message is as follows :Starting IBM planning Analytics Workspace Administration Tool, please wait… Error response from daemon: {"message":"no such image:……}
2025-05-09 Configure Planning Analytics Workspace on Windows Server 2016 Core (no GUI) When launching the Planning Analytics Workspace Administration Tool on a Windows install without a GUI, you will receive the following error:Exception occurred:This command cannot be run due to the error: Class not registered.
2025-05-09 Planning Analytics Workspace on Linux is unaccessible although all containers are running correctly Planning Analytics Workspace is running on Linux.The "./scripts/paw.sh ps" command shows that all containers are "Up", except for "bss-init" and "couchdb-init", which is the expected behavior.From a remote machine, no web browser is able to access the login page. The page is not found.From Edge:Hmmm… can't reach this page&lt;servername&gt; took too long to respondERR_CONNECTION_TIMED_OUTFrom Chrome:This site can't be reached&lt;servername&gt; took too long to respondERR_CONNECTION_TIMED_OUTFrom Firefox:Hmm.
2025-05-09 User encounters an exception after disconnecting and refreshing a workbook IBM Planning Analytics for Microsoft Excel (version 2.0.29) users with a workbook containing Exploration Views, Quick Reports, Dynamic Reports, or Custom Reports can encounter a "Cognos.Office.Framework.DialogOpenException" type exception if the user disconnects from their Planning Analytics (version 2.0.30) connection and then refreshes the workbook using Refresh Workbook.
2025-05-09 How to Manually Generate a Process Dump using Process Explorer There may be times where a process dump file (or files) are required to troubleshoot a specific problem. The steps in this document walk through the process of generating a dump file using Process Explorer for IBM Support analysis. While the example used covers the tm1sd.exe process, the same steps can be followed for any process on the operating system. NOTE: You may follow a very similar approach using only Windows Task Manager, however Windows Task Manager will not allow you to choose a dump file loc
2025-05-09 Some containers are stuck in Restarting state on Linux On Linux, the result of the "&lt;PAW&gt;/scripts/paw.sh ps" command shows some containers are stuck in "Restarting" state.
2025-05-09 Agent unreachable – Cannot display resource information – In the Databases tab of the Planning Analytics Workspace administration page In the Databases tab of the Planning Analytics Workspace administration page, an "Agent unreachable" error is displayed at the top, and a "Cannot display resource information" error is displayed for each monitored TM1 Server database.
2025-05-09 The "Rights" tab is not displayed with the same language as the rest of Performance Modeler interface IBM TM1 Performance Modeler interface language is not consistent: it seems that the "Rights" tab is not using the same locale.
2025-05-09 What port is used between Planning Analytics Workspace and Planning Analytics Agent? What port is used between Planning Analytics Workspace (PAW) and Planning Analytics Agent (PAA)?
2025-05-09 Unable to modify Host information in Quick reports In an existing Planning Analytics for Excel (PAfE) report, it is not possible to edit the "Host information" field so that to point to another Planning Analytics Workspace server machine. The field is not editable.
2025-05-09 Large Number of Threads Created on TM1 Server When Running Large Planning Analytics for Excel Report When monitoring TM1Top/PAA, administrators observe moments where tens or hundreds of threads are opened on the TM1 Server in a short time span.
2025-05-09 How to Troubleshoot Performance with Cognos Analytics Reports Using Planning Analytics as a Datasource You are encountering performance concerns with Cognos Analytics Reports that use Planning Analytics as a datasource, however do not know where to start. The objective of this document is to help you better understand the components involved with reporting on data from Planning Analytics using Cognos Analytics, and the areas of the product that require focus.
2025-05-09 Small Excel report fails in TM1 Web with: "Limits exceeded", "exceeds maximum cell count", "exceeds the configured maximum memory limit" Although WorkbookMaxCellCount parameter was set to a high value (for example 2,000,000), a small report with far less data cells is throwing this error in TM1 Web or Planning Analytics Spreadsheet Services:Limits exceededThe action has been terminated because it exceeds the configured maximum memory limit.tm1web.log contains this kind of message:2021-10-15 17:53:51,726 [Default Executor-thread-6954] ERROR () com.ibm.cognos.tm1.publish.Workbook – [] Workbook TM1://appli/blob/PUBLIC/.\}externals\TM19246.xlsx_
2025-05-09 Microsoft Excel crashes immediately upon clicking the Planning Analytics tab in the Excel menu Microsoft Excel crashes immediately upon clicking the Planning Analytics tab in the Excel menu
2025-05-09 Troubleshooting issues related to docker network- HNS failed with error – or PA Workspace not accessible from outside the NAT Error when trying to start Planning Analytics Workspace:Cannot start service pa-gateway: failed to create endpoint pa-gateway on network nat: HNS failed with error : Unspecified errorExecution failed with exit code 1OrPlanning Analytics Workspace containers are correctly started up, but Planning Analytics Workspace cannot be reached through the web browser. One possible message is "An unknown error has occurred", or a classic HTTP 404 error might occur when the docker network is not accessible at all.
2025-05-09 Modify the subset by collapsing and expanding consolidation show all member belong to consolidation Open the view with named subset after collapse the consolidation then expand it shows all members, which include eliminated member.Is this an expected behavior?
2025-05-09 Planning Analytics Administration (PAA) unable to display status of TM1 databases. The agent status is reflected as "unreachable" within PAA console. Planning Analytics Administration (PAA) unable to display status of TM1 databases. The agent status is reflected as "unreachable" within PAA console.
2025-05-09 TM1 Server may not be able to shut down if you are using Java extensions with Java 8 on Linux The JVM in Java version 8 does not release the correct signal back to the TM1 Server, thus preventing it from shutting down.
2025-05-09 401 error when opening the set editor in IBM Planning Analytics for Microsoft Excel Users may encounter a 401 error when opening the set editor in IBM Planning Analytics for Microsoft Excel. This is the result of the user exceeding the maximum number of client service connections when using the set editor. This issue may be resolved by increasing the maximum number of client service connections by a user to '10'.
2025-05-09 DataLimitExceededException when trying to open a big Excel report with millions of cells Error in Planning Analytics for Excel when trying to open a big Excel report that contains millions of cells:IBM Framework for Office:Cognos.Office.Tm1.Connections.DataLimitExceededException
2025-05-09 Failed to start container – failed to create endpoint share-proxy on network nat – the file local-kv.db.lock is being used by another process Errors when Planning Analytics Workspace is restarted automatically after rebooting the Windows server machine:Failed to start container eaa8604bfe35f171577395d85b463f0abaa96c1b080cf03c786a261460511556:failed to create endpoint share-proxy on network nat:failed to save endpoint 3a7b3bb to store:failed to update store for object type *windows.hnsEndpoint:open F:\DockerData/network/files/local-kv.db.lock:The process cannot access the file because it is being used by another process.","1",,"0","2","0",,"360287
2025-05-09 How to Configure Planning Analytics to Connect to an SSL Secured Cognos Dispatcher If you intend to use CAM Security (IntegratedSecurityMode=5) for your Planning Analytics authentication and your Cognos Dispatcher is secured with SSL, you must perform additional steps to ensure that the Cognos Dispatcher certificate authorities are trusted by the Planning Analytics keystore.
2025-05-09 TM1 Server is hanging, not responding, and tm1server.log is full of TM1.Event mt_WaitForSingleObject: Timed out on event 0x0x2788d60 TM1 Server is hanging, not responding, and tm1server.log is full of these messages:TM1.Event mt_WaitForSingleObject: Timed out on event 0x0x2788d60
2025-05-09 How to restrict cipher suites in Planning Analytics Administration Agent It is possible to restrict Planning Analytics Administration Agent to use specific cipher suites. This technote is a supplement to the following post for WebSphere Application Server & Liberty, which the Planning Analytics Administration Agent runs on: https://community.ibm.com/community/user/wasdevops/blogs/alaine-demyers/2021/08/18/customer-cipher-suites-on-traditional-websphere-an
2025-05-09 How to prevent unauthorized users from connecting to TM1 Web ? How to prevent unauthorized users from connecting to a TM1 Server through TM1 Web ?
2025-05-09 How to Configure Planning Analytics Spreadsheet Service for KERBEROS/SPNEGO (SSO) This document is a real example which goes through the setup and configuration of KERBEROS/SPNEGO using a sample server. The intent of this document is to allow you to follow along, implementing the necessary changes for the environment you are configuring. The official production documentation should still be reviewed and used, and can be found here: https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_tm1_ug_configuring_sso_with_spnego.html  Please n
2025-05-09 TM1 Databases stuck at loading in Planning Analytics Workspace Server tree Planning Analytics Workspace is unable to connect to TM1 Server. The server is stuck on the loading icon in the server tree.
2025-05-09 Since Planning Analytics for Excel 2.0.65 (XLL), no default Excel workbook is opened at startup Since Planning Analytics for Excel 2.0.65, we just need to double-click an XLL file to open the add-in: no installation is needed anymore.However, in previous versions, a default workbook was automatically opened: in newer versions, no default workbook is displayed anymore at startup.
2025-05-09 Relative proportional spread fail with error SpreadConsolidationRulesFailed Try to perform relative proportional spread, it failed with error SpreadConsolidationRulesFailed.
2025-05-09 Line Chart, Stack Chart, Column Chart, Area Chart, Bar Chart, are showing one color only In Planning Analytics Workspace: Line Chart, Stack Chart, Column Chart, Area Chart, Bar Chart, are showing one color only.There are missing lines, or stacks, or columns, or areas, or bars.For example, this Exploration View:Is displayed as follows when changed into a Column Chart:Instead of showing distinct colors for Europe and North America, the nested levels are concatenated and placed into the x-axis.
2025-05-09 Using GSKit on Linux generates error "version gsk8 not defined in file libgsk8cms_64.so with link time reference" The GSKit 8 tool which is included with Planning Analytics on Linux is used for many procedures such as configuring SSL and adding certificates to the TM1 keystores, which is needed for certain integrations such as Git.When using this tool, you might encounter an error such as the following:/tm1/cognos/tm1_64/bin64/gsk8capicmd_64: symbol _ZTV20GSKPasswordEncryptor, version gsk8 not defined in file libgsk8cms_64.so with link time reference
2025-05-09 Planning Analytics for Excel: Publish Failed. Please make sure you have the correct permissions to publish The user encounters an error message when publishing a workbook in Planning Analytics for Excel (PAfE): "Publish Failed. Please make sure you have the correct permissions to publish"The user had admin rights on TM1 server and the issue occurs whether the user is publishing the workbook as private or public.
2025-05-09 Applications folder and templates' security reset after TM1 Server restart Applications folder security reset after TM1 Server restart. All users are able to access all Applications folder and templates which were secured based on security groups
2025-05-09 "Cannot create container for service admintool: Invalid bind mount spec" error while starting admintool Installing Planning Analytics 2.0 on windows. All prerequisites ok. Starting vm and starting admintool. A browser opens and says the page cannot be displayed
2025-05-09 Receive path too long error when extracting the IBM Planning Analytics Workspace installation kit for Microsoft Windows Server 2016 When you extract the installation kit ipa_workspace_local_win_.zip, you get an error message saying that the path is too long. The error occurs in ipa_workspace_local_win_2.0.24.x.y.zip or earlier.
2025-05-09 org.xml.sax.SAXException: Bad envelope tag: html is received while validating application over TM1 Performance Modeler. org.xml.sax.SAXException: Bad envelope tag: html is received while validating application over TM1 Performance Modeler.
2025-05-09 How to change the default port (9012) used by Planning Analytics Administration Agent ? The Planning Analytics Administration Agent (PAAA or PAA Agent) is run through a Windows service named "IBM Planning Analytics Administration Agent" which is a based on Websphere Liberty Profile (WLP). This java-based service is listening on port 9012 by default. Planning Analytics Workspace communicates with this service when the "Administration" menu is activated from the Welcome page of Planning Analytics Workspace. The container that communicates with PAA Agent is the "monitor" container, which expe
2025-05-09 IBM Planning Analytics for Microsoft Excel not responding as expected after being launched Users may experience IBM Planning Analytics for Microsoft Excel (v2.0.3) not responding as expected after launching the application or after logging in.
2025-05-09 In Planning Analytics Workspace Administration, why are the "Last started" and the "Start time" empty for some TM1 Servers ? In Planning Analytics Workspace Administration, why are the "Last started" and the "Start time" empty for some TM1 Servers ?
2025-05-09 Bad performance caused by Refresh Sheet recalculating the whole Excel workbook rather than the active one only In Planning Analytics for Excel, the Refresh Sheet menu recalculates all the sheets in the workbook, rather than the active one only.This leads to poor performance.
2025-05-09 Must gather: Use PAWDockerWinChecker tool on Windows to gather information for IBM Support For any kind of issues experienced with Planning Analytics Workspace, often numerous information is needed to investigate and find the cause. Gathering all the required information can require many various requests and communication between system administrators, network administrators, application administrators, and IBM support. It can lead to delays in providing a solution.
2025-05-09 "Duplicate Aliases are not allowed" occur when adding new alias When add new alias, "Duplicate Aliases are not allowed" error occur while there are no same alias.
2025-05-09 503 Server Unavailable Errors with Various PA Workspace and PA Excel Actions Various actions such as updating user roles in PA Workspace Administration, or publishing a book in PA for Excel result in 503 Server Unavailable errors.
2025-05-09 Docker error when running paw.sh: Cannot start service <container_name>: oci runtime error: container with id exists: {container_id} Docker is unable to start containers on Linux:Cannot start service &lt;container_name&gt;: oci runtime error: container with id exists: {container_id}For example:ERROR: for share-app Cannot start service share-app: oci runtime error: container with id exists: 30dcc8af9b9dc112ff1db6cac13f1e29e6b113892582ae07bc562b9b8efaf554 Starting bss … error
2025-05-09 How to verify if TM1 server has loaded completely up post restart using Rest API. How to verify if TM1 server has loaded completely up post restart using Rest API.
2025-05-09 TM1 Web service is unable to restart after a reboot or when it was stopped by using a script A previously working "IBM Planning Analytics Spreadsheet Services" service cannot be started after the server machine was rebooted, or after the service was stopped by script, for example by using this Windows command: NET STOP tm1web Or by using this Powershell command: Stop-Service -force tm1web The tm1web-stdout.YYY-MM-DD.log contains the following error:"Failed to start tm1web server"
2025-05-09 Planning Analytics Access Manager Component The installer for Planning Analytics 2.0.x Local includes an Access Manager component as part of the web tier component.
2025-05-09 Can not access to TM1 Applications Portal I could not access to TM1 Applications Portal after enter account and password.
2025-05-09 How to Login to Planning Analytics Server with CAM Authentication using Planning Analytics for Excel API This document provides an as-is example of how to use the Planning Analytics for Excel API to log in to a Planning Analytics Server that is secured using CAM Authentication
2025-05-09 Backing up Planning Analytics Workspace on a Microsoft Windows OS How to Back up your Planning Analytics Workspace on a Microsoft Windows OS
2025-05-09 New Reports created in Planning Analytics for Excel are showing #Value New install of Planning Analytics for Excel. Any newly created report in Planning Analytics for Excel shows #VALUE
2025-05-09 Size of Planning Analytics for Excel menu/fonts changes (shrinks) when change screen settings (for example plug in docking station) When using Planning Analytics for Excel, user docks/undocks their laptop. By doing this, this triggers the PA for Excel screen to change font size (and scaling) which makes it unreadable.
2025-05-09 Error Connecting to Planning Analytics Server in Planning Analytics for Excel – PublicKeyToken not Serializable Error After logging in to a TM1 server instance, the following error occurs: "Type 'Cognos.Office.Tm1.Connections.Tm1WebException' in Assembly 'TM1.Common, Version=11.0.50.5, Culture=neutral, PublicKeyToken=d6e6d7d808b7e5b7' is not marked as serializable"
2025-05-09 How to use Free-Form UI to run MDX Queries in Planning Analytics for Excel This document shows how to use the free-form query UI to create hand-tuned queries to be used instead of the queries generated by the client (PA for Excel) if you have a deeper awareness of the model-cost relationship
2025-05-09 Planning Analytics Administration not generating email alerts while stopping TM1 services Planning Analytics Administration Alerts not getting generated while stopping TM1 services
2025-05-09 How to Troubleshoot a Planning Analytics Web Tier Crash Planning Analytics Web Tier crash (TM1 Application Server, TM1 Web, Spreadsheet Service)
2025-05-09 IBM Planning Analytics Spreadsheet Services: Invalid paths in server configuration files When installing IBM Planning Analytics Spreadsheet Services using the short-cadence (SC) installer version 59 or earlier, invalid paths could be created in the WebSphere liberty server configuration files. These paths must be corrected in order to run the service, and before upgrading the service.
2025-05-09 Set Editor is blank in Planning Analytics for Excel Set Editor is blank in Planning Analytics for Excel
2025-05-09 Use IKeyMan to Configure Custom SSL Certificates for TM1Web This Technote provides steps to enable SSL/HTTP for TM1Web, pmpsvc, and pmhub web applications for TM1 10.2.2 and Planning Analytics 2.0 Local using the IBM Java IKeyMan tool. To configure custom SSL certificiates without the use of IKeyMan please see: http://www-01.ibm.com/support/docview.wss?uid=swg21998395
2025-05-09 use command line for tm1runti.exe gets error message SystemServerClientNotFound use command line for tm1runti.exe gets error message SystemServerClientNotFound Server connection failed
2025-05-09 Unable to Log in to Planning Analytics for Excel – The operation has timed out Users are unable to log in to Planning Analytics for Excel
2025-05-09 In PA for Excel, RefreshAllData does nothing if run from VBA or VBS In Planning Analytics for Excel (PAX), trying to refresh data through VBA macro or VBS script does not work : nothing happens or Excel may hang/freeze.
2025-05-09 How to enable both HTTP and HTTPS simultaneously on Planning Analytics Spreadsheet Services (TM1Web) Starting with Planning Analytics 2.0.9.2, TM1Web is no longer packaged with the PA install. With the change of TM1Web to the new Planning Analytics Spreadsheet Services (PASS), now web can be set up for both HTTP and HTTPS access at the same time. This is not recommended for production use, as typically you will want to restrict usage to HTTPS only, but can be useful for testing situations.
2025-05-09 How to check the exact version of Planning Analytics Workspace How to check the exact version of Planning Analytics Workspace New Experience (NE)
2025-05-09 "Unable to connect to the planning service" when Performance Modeler connects to a specific TM1 server When trying to connect to a specific TM1 server by using Performance Modeler, it is failing with this error message:Could not connect to planning serviceUnable to connect to the planning serviceThe present document covers only the case when this error occurs for one specific TM1 Server.If this error happens for any TM1 servers, then contact IBM Support and provide the fpmsvc_config.xml file from "C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\fpmsvc_config.xml" and the cogstartup.xm
2025-05-09 Admin Server not starting The TM1 Admin Server is not starting from Windows Services or Cognos Configuration. The TM1 Admin Server Logs contain the following errors:8944 ERROR 2020-02-24 15:27:37,197 TM1.Comm.SSL gsk_environment_init failed. Error: 4088944 ERROR 2020-02-24 15:27:37,197 TM1.TM1AdmSvr GSK environment initialization failed
2025-05-09 Quick or Universal Reports Displaying Blank Values in TM1Web Quick or Universal Reports Displaying Blank Values in TM1Web:
2025-05-09 Evaluating DBRW formulas in IBM Planning Analytics for Microsoft Excel returns #VALUE error Users may experience IBM Planning Analytics for Microsoft Excel returning #VALUE errors when evaluating DBRW formulas. This may be due to conflicting 'Lotus compatibility Settings' in Microsoft Excel.
2025-05-09 How to determine the version of IBM Planning Analytics Spreadsheet Services installed The following options are available to identify the version of IBM Planning Analytics Spreadsheet Services deployed.
2025-05-09 Pre-configuring the size/position of the Display Properties Window in the Architect/Perspectives subset editor Pre-configuring the size/position of the Display Properties Window in the Architect/Perspectives subset editor
2025-05-09 Planning Analytics Spreadsheet Services Silent Uninstall You would like to uninstall Planning Analytics Spreadsheet Services silently, without a user interface.
2025-05-09 How to Troubleshoot Planning Analytics Administration Agent The purpose of this document is to provide guidance with troubleshooting the Planning Analytics Administration Agent.
2025-05-09 Planning Analytics Agent: message.log: Email configuration properties missing After setup the e-mail notification for the Planning Analytics Agent in make the changes in the bootstrap.properties file the following message will occur in the Planning Analytics Agent message log file:0000007e com.ibm.pa.kate.agent.util.PAKateNotificationEmailUtil E Email configuration properties missing
2025-05-09 Users experiencing issues when performing Microsoft Excel data filtering in IBM Planning Analytics for Microsoft Excel Users can experience issues when performing Microsoft Excel data filtering in Exploration Views, list views, and Dynamic Reports.
2025-05-09 Planning Analytics Workspace is not accessible after some time After some time Planning Analytics Workspace isn't accessible anymore. The mongo and neo-provision container are stopped, which results into the problem in not able to access Planning Analytics Workspace anymore.
2025-05-09 TM1.Server E15) Server unable to listen on port 5001 Not able to start more than one Planning Analytics server. 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 "
2025-05-09 COR-ERR-2012 Exploration can not be converted when converting view to a dynamic or custom report Trying to open cube in viewer to convert Exploration to Dynamic or Custom report, the following error pops up "COR-ERR-2012 Exploration can not be converted".
2025-05-09 Planning Analytics for Excel: The file format and extension of 'IBM_PAfE_xxx_x.x.xx.x.xll' don't match. The file could be corrupted or unsafe. Opening the PAfE Xll file downloaded from IBM Fix Central displays the error message "The file format and extension of 'IBM_PAfE_xxx_x.x.xx.x.xll' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?":
2025-05-09 Missing user interface elements in IBM Planning Analytics for Microsoft Excel Users with high DPI displays may notice that some user interface elements in IBM Planning Analytics for Microsoft Excel are not rendering properly.
2025-05-09 Planning Analytics Workspace not starting on Windows Server 2016 – ActivateLayer failed in Win32 You have installed Planning Analytics Workspace on Windows Server 2016. When starting the application, you face the following error for one or more containers:ActivateLayer failed in Win32: The process cannot access the file because it is being used by another process.
2025-05-09 Planning Analytics Administration Agent: "Agent unreachable" – In the Databases tab of the Planning Analytics Workspace administration page In the Databases tab of the Planning Analytics Workspace administration page, an "Agent unreachable" error is displayed at the top, and a "Cannot display resource information" error is displayed for each monitored TM1 Server database.
2025-05-09 Share/Export report from Planning Analytics Workspace does not generate PDF filer properly if Book contain Image Generate PDF file using Share/Export from Planning Analytics Workspace does not contain any chart if book contains image.
2025-05-09 Available TM1 Servers not listed in IBM Planning Analytics Spreadsheet Services or TM1 Web (in non-SSL/TLS/HTTPS configuration) In an installation that is not configured with SSL/TLS/HTTPS, when connecting to IBM Planning Analytics Spreadsheet Services or TM1 Web, the list of available TM1 Servers is not displayed whereas the specified Admin Host has been correctly set, and Architect is able to see the TM1 Servers (even from the TM1 Web server machine itself)The tm1web.log in "\ibm\cognos\tm1web\webapps\tm1web\WEB-INF\logs" or "\ibm\cognos\tm1_64\webapps\tm1web\WEB-INF\logs" contains these errors:[TM1WebFileWatcher] ERROR () com.ibm
2025-05-09 Internal Error 500 occurs when exporting from Planning Analytics Workspace to Excel Internal Error 500 occurs when exporting from Planning Analytics Workspace to Excel
2025-05-09 Planning Analytics TM1 Web /Planning Analytics Spreadsheet Services after upgrade to version 2.0.97 or newer throw error "Unsupported protocolSSL_TLSv2" Planning Analytics TM1 Web /Planning Analytics Spreadsheet Services after upgrade to version 2.0.97 or newer throw error "Unsupported protocolSSL_TLSv2"
2025-05-09 Unable to Start TM1 Web Tier Components with Planning Analytics After installing the TM1 Web Tier components for Planning Analytics, the IBM Cognos TM1 service does not function / can not be used.
2025-05-09 SUBNM, TM1PRIMARYDBNAME, DBRW, DBSS, etc. suppressed by exploit protection SUBNM, TM1PRIMARYDBNAME, DBRW, DBSS, etc. do not work, they do not execute
2025-05-09 Empty Server List or Unable to Connect to the TM1 Server Error When Attempting to Connect to TM1 Server via Performance Modeler Empty Server List or Unable to Connect to the TM1 Server Error When Attempting to Connect to TM1 Server via Performance Modeler
2025-05-09 All data are set to zero in Exploration View when a hierarchy by attribute is used in either rows, columns, or context In Planning Analytics Workspace, all data are set to zero in Exploration View when a "Hierarchy by Attribute" is present as either rows, columns, or context.
2025-05-09 Creating an Active Form: Run-time error '1004' Method 'Calculation' of object '_Application' failed Error in TM1 Perspectives while trying to create a new Active Form:Run-time error '1004'Method 'Calculation' of object '_Application' failed
2025-05-09 How to Change Core File Location for Planning Analytics Web If/when Planning Analytics Web encounters a situation where a Core file must be written, the default location where the Core (DMP) files are written is in the <tm1_Install_dir>\bin64\ folder. The steps in this document will allow you to redirect the Core files to a different location.
2025-05-09 Errors in Internet Explorer 11 since Planning Analytics Workspace 2.0.57 : unable to load requested view, unable to get property 'LearningPanel' Since Planning Analytics Workspace was migrated to version 2.0.57 or higher, Internet Explorer 11 is not working anymore.Errors:Unable to load requested viewUnable to get property 'LearningPanel' of undefined or null reference
2025-05-09 Planning Analytics Workspace becomes inaccessible frequently. Planning Analytics Workspace becomes inaccessible frequently.
2025-05-09 How to check if the data in Planning Analytics is encrypted Customer is using Planning Analytics (PA) local. They would like to check whether their data/model is encrypted or not. How can they do this?
2025-05-09 Docker unresponsive after few minutes. Stopping Planning Analytics Workspace hangs. Containers are stuck in Restarting state. On a previously working Planning Analytics Workspace environment, Docker is getting unresponsive after few minutes (usually about 30 minutes) whereas all containers are still shown as "Up" (except for bss-init, which normally shuts down itself shortly after Planning Analytics Workspace started up).When we try to stop containers through Powershell, the whole shutdown process hangs eventually.Even basic Docker commands are not responding.After a forced restart of Docker service, the "/scripts/paw.ps1 ps" comm
2025-05-09 (TM1 API Error) TM1PATHEnvVarNotFound when running tm1runti.exe on Linux When trying to execute a TM1 TI process using the tm1runti.exe tool, this error occurs:(TM1 API Error) TM1PATHEnvVarNotFound Server connection failed
2025-05-09 "An unexpected error occurred" when connecting to Planning Analytics Workspace (Linux) after editing paw.env Web browser displays "An unexpected error occurred" when trying to connect to a Planning Analytics Workspace that is installed on Linux.This error happens after modifying the paw.env configuration file by using some text editor outside the Linux machine.
2025-05-09 Since version 2.0.9.5, with custom SSL, TM1 Admin Server appears as started but does not work Since Planning Analytics 2.0.9.5, a custom SSL/TLS chain of certificates that was previously working, is not working anymore with TM1 Admin Server.Despite "IBM Cognos TM1 Admin Server x64" service seems to be "Running", no TM1 Server is able to register against it.In the tm1admsrv*.log files, the following error appears:TM1.TM1AdmSvr Failed to start Admin serverAfter we set DEBUG in tm1admsrv-log.properties, we are getting more information:TM1.Comm.SSL.Cert Unrecognized cert data typ
2025-05-09 The remote server returned an error: (404) Not Found Users get this error while login to Planning Analytics For Excel :"The remote server returned an error: (404) Not Found"Validate action on Planning Analytics Workspace Admin tool returns the following error for TM1 Application Server Gateway URI :"Error:Server responded with status code 404"TM1 Admin Server URI and TM1 login Server URI validate successfully
2025-05-09 Planning Analytics Workspace Administration Tool Not Working The installation of Planning Analytics Workspace looks to have gone well, however the last step is not launching the Planning Analytics Administration Tool, and the URL is not accessible.
2025-05-09 'TM1.ClientMessage Could not read message header.' is logged in tm1server.log What causes this error in tm1server.log?TM1.ClientMessage Could not read message header.
2025-05-09 Intermittently, regularly, all containers are in 'Exit' state and they have to be manually restarted Intermittently, regularly, all Planning Analytics Workspace containers seem to stop by themselves.The "/scripts/paw.ps1 ps" (Windows) command or "/scripts/paw.sh ps" (Linux) command shows all containers in 'Exit' state.None of the containers is running ('Up').Nevertheless, they can be manually restarted with no problem by running one of these commands:/scripts/paw.ps1 start (Windows)/scripts/paw.sh start (Linux)or/scripts/paw.ps1 (Windows)/scripts/paw.sh (Linux)Which means the containers don't have any issu
2025-05-09 "IBM Cognos TM1" service is started but TM1 Web is not responding – This page can't be displayed (HTTP 404) – No java.exe listens on port 9510 "IBM Cognos TM1" service is started but is not responding:Error: "This page can't be displayed" (HTTP 404)In Resmon.exe, in "Listening ports", there is no process listening on port 9510.In Task Manager there is no "\tm1_64\jre\bin\java.exe" process running.
2025-05-09 Planning Analytics For Excel: Exploration View : Error Occurs When Selecting Elements Within Dimension When working with an Exploration View in Planning Analytics For Excel, the following error occurs when making a selection within the subset editorThe issue is user specific not all users are affected.
2025-05-09 Planning Analytics for Excel: System.ObjectDisposedException: Cannot access a disposed object Users are receiving this error message while connecting or while working in Planning Analytics for Excel:System.ObjectDisposedException: Cannot access a disposed object. Object name: 'Tm1AuthBrowser'.at System.Windows.Forms.Control.CreateHandle() at System.Windows.Forms.Form.CreateHandle() at System.Windows.Forms.Control.get_Handle() at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Cognos.Office.Framework.SingleDialog.ShowDialog(Form form, IWin32Window owner)at Cognos.Office.Tm1.Security.UILog
2025-05-09 Unable to Access Planning Analytics Workspace Administration Tool – Page can't be displayed Unable to access Planning Analytics Workspace Administration tool. Page can't be displayed.
2025-05-09 Planning Analytics for Excel – Can't login with CAM authentication after PAW upgrade After Planning Analytics Workspace (PAW) upgrade, users are not able to log in to PAfE with CAM authentication. They receive the following error:"The PMHub service parameter was not specified or is not one of the configured locations"
2025-05-09 "Error with CAM passport" in Perspectives or Architect for roaming users only Some users get this error message when trying to connect to a CAM-secured TM1 Server (IntegratedSecurityMode=5) through either Perspectives or Architect:"Error with CAM passport"The C8ITK.log in C:\Program Files\ibm\cognos\tm1_64\Logs contains this kind of error:20201107 18:31:12.125 (v10.3.1.5)[1838:1088][ITKMMF.cpp L506] CryptProtectData failedUsers who do not have a roaming profile do not get that problem.[ Read this Microsoft© document to know more about roaming profiles: https://docs.microsoft.com/en-u
2025-05-09 How to log websheets and cube views that are opened by users in TM1 Web ? This document explains how to log the names of websheets and cube views that are accessed in TM1 Web or Planning Analytics Spreadsheet Services.This logging can also help to determine which users were logged in TM1 Web as the user names are displayed in the tm1web.log file.This logging can help determining whether TM1 Web performance issues or JVM memory utilization issues are caused by one or several particular websheets or cube views. The heap memory usage is included in the log.The present document is va
2025-05-09 Turning on zero suppression inside the Planning Analytics TI process results in the data being ordered by when the element was added to the dimension, instead of the subset order, or the default dimension order. This technote documents the current limitation of TM1 Server related to turning on Zero suppression inside the Planning Analytics TI process, which results in the data being ordered by when the element was added to the dimension, instead of the subset order, or the default dimension order.When the TI process is created with the parameter pSuppressZero = 0 (suppress zero is turned off), it shows data for the dimension in descending alphabetical order, as expected.When the TI process is created with
2025-05-09 How to open a drill through report (either a cube view or an ODBC data source) by using Planning Analytics Workspace URL API? How to open a drill through report (either a cube view or an ODBC data source) by using Planning Analytics Workspace URL API?
2025-05-09 Error Occurs Clicking Action Button in Planning Analytics for Excel – Tm1p.xla not loaded Attempting to click an action button in Planning Analytics for Excel results in the following error: Tm1p.xla not loaded
2025-05-09 Currency symbol other than $ is not displayed in TM1 Web when formatting is done by TEXT formula in Excel The currency symbol that is defined through a TEXT formula is correctly rendered in Excel:TEXT(1234,"$#,##0.00") ==&gt; $1,234.00TEXT(1234,"€#,##0.00") ==&gt; €1,234.00TEXT(1234,"£#,##0.00") ==&gt; £1,234.00But only the dollar $ sign is appearing in TM1 Web, whatever the regional settings and browser content language that are used for either creating the Excel file or opening TM1 web:TEXT(1234,"$#,##0.00") ==&gt; $1,234.00TEXT(1234,"€#,##0.00") ==&gt; 1,234.00TEXT(1234,"£#,##0.00") ==&gt; 1,234.00
2025-05-09 How to change the IP configuration of Planning Analytics Workspace Local on Linux Instructions on how to change the default IP address that Planning Analytics Local on Linux uses.
2025-05-09 No TM1 Server visible in the databases list in Workspace when creating or updating a book In Planning Analytics Workspace,in "Reports and Analysis""Create" –&gt; "Book" menu"Databases" buttonThe "Data" frame is empty/blank ; there is no TM1 server displayed/listed, no TM1 Server is visible/available.
2025-05-09 "An unexpected error has occurred" error message shows up when a new user attempts to access Planning Analytics Workspace "An unexpected error has occurred" error message shows up when a new user attempts to access Planning Analytics Workspace.
2025-05-09 pa-gateway goes from "Up" to "Restarting" state after few seconds when Planning Analytics Workspace configured with custom SSL/TLS Once PA Workspace is configured with custom SSL/TLS certificates, the pa-gateway container goes from "Up" state to "Restarting" state after few seconds.The "docker logs pa-gateway" command in Powershell displays this error only:httpd.exe: Could not reliably determine the server's fully qualified domain name, using &lt;IPv6 address&gt; for ServerName
2025-05-09 Configure an Oracle ODBC data source for TM1 on UNIX and Linux This Technote provides guidelines for configuring Oracle as an ODBC data source on UNIX and Linux system running TM1.
2025-05-09 PAW returns error "Unable to Fetch Data ….. "httpStatusCode" 401,"Authenticate" " when clicking on Report Tabs PAW returns error "Unable to Fetch Data ….. "httpStatusCode" 401,"Authenticate" " when clicking on Report Tabs OR Unable to Compose your request ….. "httpStatusCode" 401,"Authenticate" "
2025-05-09 Start.ps1 cannot be loaded. A required certificate is not within its validity period Certificate error when trying to run Start.ps1 :./Start.ps1 : File C:\IBM\\PAW\Start.ps1 cannot be loaded. A required certificate is not within its validity period when verifying against the current system clock or the timestamp in the signed file. At line:1 char:1 + ./Start.ps1 + ~~~~~~~~~~~ + CategoryInfo : SecurityError: (:) [], PSSecurityException + FullyQualifiedErrorId : UnauthorizedAccess"
2025-05-09 Unable to start IBM Planning Analytics Spreadsheet Services and IBM Cognos TM1 service on same host server Unable to start IBM Planning Analytics Spreadsheet Services and IBM Cognos TM1 service in parallel on the same host server.
2025-05-09 TI was not terminated after ProcessExitSeriousError() A Turbo Integrator process (TI) is not immediately terminated after running a TI (with ExecuteProcess()) which results in a ProcessExitSeriousError() being returned.
2025-05-09 Planning Analytics Workspace with CAM security: either HTTP 404 or blank page or PMHUB errors Planning Analytics Workspace is configured with Cognos Analytics security (CAM).When we try to access Workspace, a blank page is displayed, sometimes with just "error, see logs" at the upper-left, or some pmhub errors occur.When we try to connect through Planning Analytics for Excel, an HTTP 404 "page not found" error occurs.This message can also appear:"PMHub service parameter was not specified"When we trace by using either Fiddler or generating a HAR file (by using the developer's mode of the web browser)
2025-05-09 What are the port numbers used by IBM Planning Analytics products ? What are the port numbers used by IBM Planning Analytics products?
2025-05-09 Planning Analytics Workspace Administration – Agent is Unreachable In Planning Analytics Workspace Administration, the status of the Agent is 'Unreachable'. Users cannot perform administrative tasks on the TM1 server.
2025-05-09 Planning Analytics Workspace Administration Tool – Can not start: Execution failed with exit code 125 Unable to start Planning Analytics Workspace Administration tool. When run ./Start.ps1 and type: "y" for starting "admintool" it returns error: "Execution failed with exit code 125: docker\\windowsfilter… "
2025-05-09 TM1Web/ IBM PA Spreadsheet Service SameSite Cookie Handling TM1Web components can no longer be set up on a different domain and work within an external application or custom html page which is using components sourced from TM1Web via iFrame using the TM1Web URL API. Rather than rendering the TM1Web content the iFrame displays a "session timed out" error message.
2025-05-09 Receiving "JCE cannot authenticate the provider BC" error when installing or configuring Planning Analytics on Linux Receiving "JCE cannot authenticate the provider BC" error when installing or configuring Planning Analytics on Linux. This error is most commonly seen when trying to save changes in the Cognos Configuration application. This is due to the JRE missing files that are needed for BouncyCastle, which is a security provider that normally comes packaged with the tool.
2025-05-09 How to turn off/disable Port 80/ http in Planning Analytics Workspace ( PAW ) When configured for HTTPS, PAW only uses the HTTP port to respond with a redirect to use HTTPS. When in PAW HTTPS is enabled with EnableSSL=true the plain HTTP access is technically disabled. The port itself remains open to redirect users to https. There is no way to modify PAW configuration file to achieve block port used by HTTP. If we want to simply no response on port 80 this can be done in several ways. One of which is to firewall port 80 on the host.
2025-05-09 Planning Analytics Workspace validation error 401 on Cognos BI Gateway A 401 error is returned for the IBM Cognos BI Gateway URI when attempting to validate in the IBM Planning Analytics Workspace Administration Tool.
2025-05-09 IRR() Excel formula shows #NUM! when the result is negative on TM1 Web The IRR formula in Excel returns #NUM! in a websheet in TM1 Web when the result is negative.
2025-05-09 Planning Analytics Spreadsheet Services/TM1web: Percentages behaviour In Planning Analytics Spreadsheet Services (PASS)/TM1web, entering a whole value (that is, 5) into a cell formatted to percentage, results in 500% instead of 5%. This is the expected and intended behaviour of PASS/TM1web. To get the expected result, instead of just entering a whole number, enter "5%" or "0.05" into the cell instead, which will result in 5% instead of 500%. Also, when you try to edit a cell that already contains a percentage, it will automatically add a percent (%) sign for you at the
2025-05-09 Planning Analytics Spreadsheet Services (TM1 Web) is crashing with java.lang.OutOfMemoryError exception "IBM Planning Analytics Spreadsheet Services" service (PASS, TM1 Web) is crashing.Each crash generates a core*.dmp file and a javacore*.txt file in the \tm1web\bin64 directory.In the javacore file or in the console.log file (\ibm\cognos\tm1web\wlp\usr\servers\tm1web\logs), the following exception appears:java.lang.OutOfMemoryError: java heap size
2025-05-09 PAW Oracle VM 'Aborted' when user logs off of host machine The PAW web server is installed on Windows. If the user of this host machine logs off, the PAW VM installed under Docker goes into an 'aborted' state. Subsequent attempts to restart the PAW VM may fail and the VM needs reinstalling to resume it.
2025-05-09 Opening IBM Planning Analytics Cube View using TM1 Web URL API parameters throws error "Request to the server has been blocked by an extension." when using Google Chrome Opening IBM Planning Analytics Cube View using TM1 Web URL API parameters throws error "Request to the server has been blocked by an extension." when using Google Chrome. This works fine in Internet Explorer. Impacting if using Mode 5 (CAM Security). HAR trace from Chrome Browser shows: main.js:37 [Deprecation] Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check https://xhr.spec.whatwg.org/. n @ main.js:37
2025-05-09 Understanding Delay in TM1 Server Start Time Most of the TM1Server.log file is quite useful toward understanding what is happening during the TM1 Server startup, however there is a gap in the logging details available during one of the last phases of the TM1 Server startup. This document will help you understand what is happening during that time.
2025-05-09 Unable to view cancel processing of a thread window in TM1 Top. Unable to view cancel processing of a thread window in TM1 Top.
2025-05-09 IBM Planning Analytics for Excel throws an error when the dimensional structure has changed for a referenced element An exploration report run in IBM Planning Analytics for Excel errors out because an element has been moved from one parent to another. The dimensional structure has changed.
2025-05-09 Enable Garbage Collection Logging for TM1Web, PMPSVC, PMHUB in Planning Analytics 2.0 This Technote provides steps to enable verbose garbage collection logging for WebSphere Liberty Profile (WLP). This logging is very useful for associating activity seen in other log files with high memory or JVM heap exhaustion problems.
2025-05-09 TM1 servers not visible over Architect/Perspectives post configuring custom SSL over Planning Analytics data tier. TM1 servers not visible over Architect/Perspectives post configuring custom SSL over Planning Analytics data tier.
2025-05-09 How to Troubleshoot Planning Analytics Administration Alerts You have configured Planning Analytics Administration Alerts however the alerts are not working as expected.
2025-05-09 Write to cube perfromance become significantly slow Upgare from TM1 9.5.2 to Planning Analytics Local, Turbo Integrator run very slow. i.e.) One of process which execute ViewZeroOut, it run within 1 second at TM1 9.5.2 became more than 30 minuts on Planning Analyics Local.
2025-05-09 Planning Analytics Administration Database page fails to update After a recent Windows Server update, the Planning Analytics Administrations database page no longer updates. The TM1 database tiles show no information about memory and CPU utilization, or the current information about resource utilization is not updated.This problem has been caused by a Windows update that changed the output of the following fsutil command.C:\Users\user&gt;fsutil volume diskfree C:Total # of free bytes : 12238098432Total # of bytes &nb
2025-05-09 A blank page is displayed for some users who connect to Planning Analytics Workspace (duplicate user issue) In Planning Analytics Workspace, some of the existing users are now getting a blank page just after logging in.
2025-05-09 TM1 Server list not available in Architect/Perspectives for non-admin users after applying custom SSL/TLS Custom SSL/TLS certificate has been installed on the TM1 Data Tier as described in this document:https://www.ibm.com/support/pages/how-configure-ssl-planning-analytics-data-tier-using-gskit-new-certificate-signing-requestSince then, when running Architect or Perspectives, the list of available TM1 Servers is empty, unless the connected user is a member of the local Administrators group on Windows.
2025-05-09 Unable to access a data source from a TI process when the data source is located on a shared or other non-local drive When creating TI processes, you will often use data sources for reading, inputting, or exporting data. Often, you might want to host these files on another machine than the TM1 server itself, and have the TI process work over the network. The TI process can sometimes throw an error such as:Error: Prolog procedure line (0): Unable to open data sourceThis problem might occur even if you can view the "preview" section of the TI process correctly.
2025-05-09 IBM Planning Analytics For Excel (PAfE) – script errors while connect When try to connect PAfE, with usage of PAW-URL, following script error appears in Excel:"An error has occurred in the script on this page: http://enviroment_name/cdn/pa-glass/1.02021120202/js/pa-glass.js"After click "Yes", next script error appears:"http://enviroment_name/?b_action=xts.run&amp;ui.compid=ps&amp;m=portal/close.xts&amp;h_CAM_Action=loginAs"Then, after next click "Yes", blue circle appears, it hangs and nothing happens anymore.
2025-05-09 How to enable Planning Analytics for Excel Addin for all users using script Planning Analytics for Excel is installed and successfully registered for the Admin account that was used to install it However other users do not see the Addin by default and need to add it every time they launch Excel Need a script to activate the Planning Analytics Excel for ALL users that log in to the machine.
2025-05-09 The term 'docker-compose' is not recognized … when trying to start containers with /scripts/paw.ps1 Error when trying to run containers by using &lt;PAW_path&gt;/scripts/paw.ps1Invoke-Expression : The term 'docker-compose' is not recognized as the name of a cmdlet, function, script file, oroperable program. Check the spelling of the name, or if a path was included, verify that the path is correct and tryagain.At C:\ibm\PAW\scripts\paw.ps1:82 char:28+ … sh = exec { Invoke-Expression "docker-compose ${COMPOSE_FILES} -p paw …+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +
2025-05-09 Unable to fetch data for content tree, when expanding TM1 Server in PAW In PAW, when trying to expand one particular TM1 Server on the left frame, this error shows up :Unable to fetch data for content tree.Session cannot be established for server:&lt;TM1ServerName&gt;500 (internal error) …Json parse exception: Invalid UTF -8 middle byte 0x74\n at source …
2025-05-09 Unable to Fetch Data Error Accessing a TM1 Server with PAW When trying to expand the list of objects in the TM1 Server in PAW the following error may be displyed. Error Unable to fetch data for content tree. Session can not be established for server: Server Name.
2025-05-09 Performance Modeler Error "com.ibm.cognos.tm1.TM1Exception: APIFunctionFailed" Unable to save any changes in TM1 Performance Modeler
2025-05-09 Error connecting to Planning Analytics from PA for Excel An error message is displayed in Planning Analytics for Excel after the environment to connect to is chosen, and before the login prompt comes up.
2025-05-09 How to view unlimited rows in Planning Analytics for Excel Reports created/used in Planning Analytics for Excel are not displaying all rows expected.
2025-05-09 Planning Analytics for Excel Errors "<Filename>" can not be found in collection of type 'Entry' Planning Analytics for Excel Errors "&lt;Filename&gt;" can not be found in collection of type 'Entry'
2025-05-09 Planning Analytics Administration Agent version number is not updated in the Workspace interface Although IBM Planning Analytics Administration Agent was updated, the old version number is still displayed in Planning Analytics Workspace administration interface.
2025-05-09 TM1 error "server" 'servername' on which this object resides is not responding. Refresh server explorer display?" while working in Planning Analytics Architect/Perspectives An error "server 'server name' on which this object resides is not responding. Refresh server explorer display?" pops up while working in TM1 Architect and TM1 Perspectives
2025-05-09 How to automatically save entered data (in either normal cells or picklists) in TM1 Web when another tab is selected? In TM1 Web (IBM Planning Analytics Spreadsheet Services, PASS), some data were updated and either the "Enter" key was pressed or another cell was clicked after each cell edition. However, if a user doesn't use the "Recalculate" button and directly click another tab, this warning message appears: <TM1WebServer>:9510 says Changes you made to '<ViewName>' have not been saved. Press OK to continue, or Cancel to stay on the current object. How to automatically save the data that were entered (in either
2025-05-09 Same user shows twice in TM1 Database The same user shows twice in TM1 Database. One shows with regular name and second shows with regular name + CAM ID. Why this happens? How to fix that?
2025-05-09 Failed to open the target workbook. Please make sure that the file has not been renamed or deleted Following error while exporting or opening any workbook in TM1 Web : " Failed to open the target workbook. Please make sure that the file has not been renamed or deleted "
2025-05-09 How to troubleshoot TM1 Application Server not starting on Windows You may encounter a situation where you are unable to start your TM1 Application Server successfully.
2025-05-09 Unable to log in to Planning Analytics for Excel – System.Runtime.Serialization.SerializationException Users are unable to log in to Planning Analytics for Excel
2025-05-09 Status tab in admin tool shows no services in the list When running the admintool in Internet Explorer, none of the PAW services are listed in the Status tab. This is working in Firefox or Chrome.
2025-05-09 How to Start Planning Analytics Workspace during Windows Server Startup Planning Analytics Workspace on Windows by default, requires Docker Toolbox for Windows. By default, Docker Toolbox for Windows comes bundled with Oracle VirtualBox. This technote describes one way that Oracle VirtualBox can be configured to run automatically upon Windows Server Startup.
2025-05-09 Variables are not getting migrated correctly while migrating TurboIntegrator processes using TM1 REST API The Variable contents erroneously change to "Ignore" in target environment while migrating TurboIntegrator processes using TM1 REST API.
2025-05-09 Planning Analytics for Excel task pane is empty and grayed-out when connecting to CAM-secured TM1 Server Planning Analytics for Excel task panel is empty and greyed-out after the connection to TM1 Server is made.The TM1 Server is using Cognos Analytics security (CAM) and single sign-on (SSO) is configured.Although the panel is disabled, the tool is able to open existing reports and get data.This issue does not occur when connected to a sample TM1 server that is using native TM1 security.
2025-05-09 Execution failed with exit code 1 or Windows named pipe error when trying to start containers by using /scripts/paw.ps1 One of these errors occurs when containers are started by using /scripts/paw.ps1 script:Execution failed with exit code 1:At C:\ibm\PAW\scripts\init.ps1:78 char:13+ throw "Execution failed with exit code ${LASTEXITCODE}: $ …+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : OperationStopped: (Execution failed with exit code 1: :String) [], RuntimeException + FullyQualifiedErrorId : Execution failed with exit code 1: ERROR:
2025-05-09 How to install Performance Modeler on a remote client machine Detailed troubleshooting steps to install Performance Modeler on a remote machine
2025-05-09 TM1 Admin server unable to communicate with TM1 server. Recurring "Notifying the Admin Server" message gets logged within tm1server.log TM1 Admin server unable to communicate with TM1 server. Recurring "Notifying the Admin Server" message gets logged within tm1server.log
2025-05-09 Planning Analytics for Excel returns “Unable to connect to the remote server” error when hovering on info icon in options menu When users hover over the info icon in the Options menu on an air-gapped machine (where internet access is blocked), Planning Analytics for Excel displays the error: “Unable to connect to the remote server”. However, some info icons still display text-based information about the settings.
2025-05-09 Architect hangs when user tries to open the rules editor for one particular cube Architect hangs when user tries to open the rules editor for one particular cube.All other rules file for the same TM1 server open up without a problem
2025-05-09 Container is marked for removal and cannot be started – Driver "windowsfilter" failed to remove root filesystem: hcsshim::GetComputerSystems When Planning Analytics Workspace containers are starting up , the following errors occur:Error: for &lt;container_name&gt; Cannot start service monitor: container is marked for removal and cannot be started.OrException occurred:Execution failed with exit code 1:ERROR: for &lt;container_name&gt; &lt;GUID&gt;:driver "windowsfilter" failed to remove root filesystem:hcsshim::GetComputerSystems: The requested compute system operation is not valid in the current state.Encountered errors while bringing up t
2025-05-09 How to manually re-create "IBM Planning Analytics Administration Agent" service? How to manually stop, unregister, register, start again the "IBM Planning Analytics Administration Agent" service?
2025-05-09 TM1 instances/servers do not appear in Architect/Perspectives if you don't open as an administrator Running TM1 instances do not appear in the list of available servers in Architect/Perspectives if you don't open them as an administrator
2025-05-09 How to Configure Custom SSL Certificates for Planning Analytics 2.0 and 2.0.1 This Technote provdies guidelines for configuring custom SSL certificates for the TM1 Server and TM1 Admin Server components for Planning Analytics 2.0 and 2.0.1. These steps are specific to Planning Analytics 2.0 and 2.0.1 only. To configure custom SSL certificates for the TM1 Admin Server and TM1 Server in version 10.2.2 and lower please see: http://www-01.ibm.com/support/docview.wss?uid=swg21998260.
2025-05-09 Server Principal Name (SPN) or the security context of the destination server could not be established error message is received when encryption type "RC4-HMAC-MD5" is disabled in Active Directory Attempting to login to a Planning Analytics Server configured with integrated login results in error "Server Principal Name (SPN) or the security context of the destination server could not be established" when encryption type "RC4-HMAC-MD5" is disabled in Active Directory
2025-05-09 Unable to open TM1web (Planning Analytics Spreadsheet Service) – HTTP ERROR 500 TM1Web not working – Error 500
2025-05-09 How to set persistent IP for Planning Analytics Workspace (PAW) administration tool on Linux How to set persistent IP for Planning Analytics Workspace (PAW) administration tool on Linux
2025-05-09 The IBM Cognos TM1 service is not created after running the Planning Analytics Local TM1 Installation After installing the TM1 Application Server / TM1 Web components, the 'IBM Cognos TM1' service does not appear under the 'IBM Cognos TM1 Services' list within Cognos Configuration.
2025-05-09 Unable to start workspace docker image:Error creating machine: Error in driver during machine creation Workspace docker image startup script fails.
2025-05-09 Users are unable to login to TM1 Web or Planning Analytics Spreadsheet Services on Windows 10 or Windows 11 using Kerberos Single Sign On when Credential Guard is enabled Users cannot login to TM1 Web or Planning Analytics Spreadsheet Services on Windows 10 or Windows 11 using Kerberos Single Sign On (SSO) when Credential Guard is enabled. Windows 11 22H2 enables Credential Guard by default.
2025-05-09 OLE message from Microsoft Excel due to slow server responses from IBM Planning Analytics You can receive an Object Linking and Embedding (OLE) message if the network latency is too high for the IBM Planning Analytics server. If this is the case, contact your system administrator to attempt to lower the network latency.
2025-05-09 Performance issue when navigating from cell to cell in an IBM Planning Analytics for Excel workbook When using the arrow keys to move from cell to cell in a IBM Planning Analytics for Excel workbook, the performance is sluggish/slow.
2025-05-09 How to enable TM1Top logging using the tm1top.ini file Generating a TM1Top log file is useful to detect lock contention, and provide general information on what processes were being executed on the server at a certain time. This is an example configuration to correctly set up the tm1top.ini before running tm1top.exe.
2025-05-09 How to Configure Planning Analytics TM1 Web for KERBEROS/SPNEGO (SSO) This document is a real example which goes through the setup and configuration of SPNEGO/TM1Web using a sample server. The intent of this document is to allow you to follow along, implementing the necessary changes for the environment you are configuring. The official production documentation should still be reviewed and used, and can be found here: https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_tm1_ug_configuring_sso_with_spnego.html  Please not
2025-05-09 TM1runTI with CAM security gives (TM1 API Error) SystemServerClientNotFound Trying to execute a process through TM1runTI.exe, on a TM1 Server that is using CAM security (IntegratedSecurityMode=5), the following error occurs:(TM1 API Error)SystemServerClientNotFoundServer connection failed
2025-05-09 How to configure and run unattended TM1 Web installations on Windows or Linux? How to configure and run unattended (or silent) installations of TM1 Web (Planning Analytics Spreadsheet Services) on Windows or Linux?
2025-05-09 Login prompt does not appear when connecting to TM1 server in Architect/Perspectives. TM1 Architect/Perspectives displays the TM1 Server(s) from a client machine. After clicking on the server name to connect nothing happens.
2025-05-09 Why is TM1 Server configuration file (tm1s.cfg) updated with EventLogging, EventThreshold.ThreadRunningTime, and EventThreshold.ThreadWaitingTime parameters? Something is randomly and automatically updating the tm1s.cfg file of some TM1 servers.These parameters suddenly appear in that file:EventLogging=T EventThreshold.ThreadRunningTime=1500 EventThreshold.ThreadWaitingTime=300What is causing this change, and why?
2025-05-09 How to activate or disable Performance Monitor on a TM1 server through a TI process or some external code ? The Performance Monitor can be enabled or disabled manually in Architect by right-clicking the server name and selecting "Start Performance Monitor" or "Stop Performance Monitor". But How to automate this ? How to activate or disable Performance Monitor on a TM1 server through a TI process or some external code ?
2025-05-09 All containers are in "Restarting" state on Linux, and logs are empty On Linux, all containers are in "Restarting" state:The &lt;PAW&gt;/log directory contains either empty subfolders, or there are no new log files created for some time.The result of "docker logs &lt;container_name&gt;" command might display this error:/bin/bash: error while loading shared libraries: libtinfo.so.6: cannot open shared object file: Permission deniedThe result of "journalctl -u docker.service" command might show no entries
2025-05-09 Planning Analytics for Excel requires Login with every action Or Blank Screen when trying to open a view Or ' Cognos.Office.Tm1.Connections.RedirectException' when creating an Exploration. Scenario1: User keeps getting login prompt when Opening a view or subset editor without exceeding the timeout settings.Scenario2: User can access all views using Planning Analytics Workspace via browser but not from Planning Analytics for Excel, It is showing Blank Window.Scenario3: The user experience the following error when attempting to create an Exploration.System.AggregateException: One or more errors occurred. —&gt; Cognos.Office.Tm1.Connections.RedirectException: Exception of type 'Cognos.Office.T
2025-05-09 re-exec error : exit status 1 cloning the parent utility VM image failed error message is received while installing Planning Analytics Workspace on Windows 2016 server re-exec error : exit status 1 cloning the parent utility VM image failed error message (refer complete error message in screen-print below) is received while installing Planning Analytics Workspace on Windows 2016 server.
2025-05-09 String Data Lost If Element Is Changed From N to C (consolidation) If a N level string element contains a value and that N level element becomes a C level element (consolidation), the value at the N level is lost.
2025-05-09 Planning Analytics Workspace Subset Editor – CCL Runtime Error: Operation is not supported User receives "CCL Runtime Error: Operation is not supported" in Planning Analytics Workspace (PAW) when attempting to open the subset editor for cubes and dimension. The problem is due to mixing an old version of TM1/PA server (2.0.2) with a recent version of PAW (2.0.61).The user had admin/write access to the dimension they were trying to edit in the subset editor.Steps the user followed to reproduce the error message:1. Create new PAW book.2. Connect to a TM1 server, add a cube as a view.3. Select one of
2025-05-09 Planning Analytics For Excel: COI-ERR-2021 Connection failed. Unknown exception. All users encounter the error "COI-ERR-2021 Connection failed. Unknown exception. Exception of type 'Cognos.Office.Framework.DataSource.HttpForbiddenException' was thrown." when testing or connecting to a Planning Analytics Workspace (PAW) URL from Planning Analytics for Excel (PAfE) when SSL is enabled for PAW.
2025-05-09 Release version combination of Planning Analytics Local What Planning Analytics Local version was released together with what Planning Analytics Workspace and Planning Analytics for Excel version?
2025-05-09 Dynamic Report in PA for MS-Excel shows #NAME? instead of values Dynamic Report in PA for MS-Excel shows #NAME? instead of values.Excel throws an error on the top stating Product Activation Failed
2025-05-09 ERROR: Network "paw_default" needs to be re-created When starting Planning Analytics Workspace ERROR: Network "paw_default" needs to be re-created – IPAM option "driver" has changed when you start the Planning Analytics Workspace on Linux servers
2025-05-08 Reports in integrated Planning Analytics/Cognos Controller cloud environment do not work If you are working in an IBM Cognos Controller on Cloud environment that is integrated with your IBM Planning Analytics on Cloud environment, the following standard reports in the Cognos Controller Client application do not work: Maintain > Configuration > Reports > General Configuration Transfer > External Data > Reports Transfer > External Structures > Reports
2025-05-01 Working with IBM BA Support: Severity 1 Expectations for Cognos Analytics and Planning Analytics #importantFont {font-family: Arial, Helvetica, sans-serif!important;font-size: 12px!important;letter-spacing: .5px!important;word-spacing: .5px!important;color: #A04858!important;font-weight: 800!important;text-decoration: none!important;font-style: oblique!important;font-variant: normal!important;text-transform: none!important;}table.grayTableMain { border: 1px solid #1C6EA4 !important; background-color: #EAEAEA!important; width: 90%!important; text-align: left!important; border-collapse: collapse!imp
2025-05-01 Troubleshooting the CA PA (TMR) data provider issues This document describes how to troubleshoot the performance and data integrity problems with the Cognos Analytics (CA) TM1 REST (TMR) data provider. TMR provider is a data provider for the Planning Analytics (PA) data sources in CA.
2025-04-30 How to modify time-out settings in Microsoft IIS when required by Cognos products ? Various timeout errors can occur in various IBM Cognos products. This document explains how to change various timeout settings in Microsoft IIS. This document applies only to issues that are not related to IBM Cognos products timeout settings.
2025-04-24 Planning Analytics for Excel (PAFE): Task Pane does not open In PAFE, when the Task Pane button is clicked, nothing happens. The Task Pane does not render.
2025-04-04 How to Install and Configure the IBM Satellite Connector as a Windows Service for IBM Planning Analytics on Cloud The following document outlines the steps required to install and configure the IBM Satellite Connector as a Microsoft Windows service that can be used by an IBM Planning Analytics on Cloud subscription to access an on-premises database.
2025-04-01 How to add CAM user using Planning Analytics Workspace If you want to add user manually before first login attempt. In Planning Analytic 2.0.9.x you could add user using Architect , this is not option in Planning Analytics 2.1.
2025-03-20 How to create the }CubeProperties control cube in a new Planning Analytics/TM1 instance How to create the }CubeProperties control cube in a new Planning Analytics/TM1 instance as in some cases this control cube has not been created when a new PA instance is created using Planning Analytics Workspace Administration?
2025-03-11 How to Download and Run the Satellite Connector on Docker This document contains the steps required to download and run the Satellite docker agent on GNU/Linux.
2025-03-11 MustGather for Planning Analytics Satellite Connector on Docker The Planning Analytics Satellite Connector, Connector Agent, or Endpoint are not working as expected.
2025-03-10 Satellite Endpoints do not support SQL named instances UI/fields which are available when creating the Satellite Endpoint do not include/allow to specify the SQL Server Instance name.
2025-03-04 Websheet Fails to Load in Planning Analytics as a Service – Failed to open the target workbook An error is encountered opening a websheet in Planning Analytics as a Service: "Failed to open the target workbook"
2025-03-03 Must Gather – Troubleshoot Planning Analytics ODBC Connector (ODBCIS) A problem has been encountered while using the Planning Analytics ODBC Connector (ODBCIS)
2025-02-25 How to Configure IBM Planning Analytics Spreadsheet Service with Custom SSL (using Existing Keystore) The steps in the document guide you toward securing IBM Planning Analytics Spreadsheet Service, by using a keystore provided to you in PFX/PKCS12 format. In this document you replace the keystore used by the IBM Planning Analytics Spreadsheet Services, with your own.
2025-02-24 How to Configure SSL on Planning Analytics Web Tier using GSKit (Using Existing Signed Certificate) The steps in the document will guide you in using the IBM Global Security Kit (GSKit) to secure your Planning Analytics Web Tier in 2.0.9.x, using a certificate that has already been signed.
2025-01-24 How to use ExecuteCommand for Windows commands The ExecuteCommand function usage to run Windows commands.
2025-01-16 How to increase Java heap size for Ti process How to increase Java heap size for Ti process When you try to run Ti process you might experience errors like TM1.Process [com.ibm.cognos.tm1.jos.ti.TIExecuteJavaHandler] – Exception caught during executeJavaN java.lang.reflect.InvocationTargetException … …. Caused by java.lang.OutOfMemoryError Java heap space The problem is caused by Java heap memory size (default value e is 512 MB ) The Tm1 server is running fine , just the Ti process fail To resolve the problem you can increase a
2025-01-13 The remote server returned an error: (502) Bad Gateway when attempting to login to tm1 server in Planning Analytics for Excel When trying to connect to the Planning Analytics TM1 Server using Planning Analytics for Excel, the following error is displayed: This issue only affects login to the server in Planning Analytics for Excel. Planning Analytics workspace works with no issue.
2024-12-13 Unable to install PA 2.1.x after uninstalling PA 2.0 Unable to install PA 2.1.x after uninstalling PA 2.0User is experiencing the following message when attempting to install PA 2.1 after uninstall 2.0 and restarting the server.All IBM Planning Analytics Services must be stopped and Planning Analytics Local 2.0 must be uninstalled before installation of Planning Analytics Local 2.1.
2024-12-11 400 Bad Request error thrown when launching Planning Analytics Workspace (PAW) in a browser. When launching PAW in browser, an http 400 Bad Request error is thrown
2024-12-10 Planning Analytics for Excel (PAfE) addin does not appear in Excel ribbon after installing the addin even as Administrator Why Planning Analytics for Excel (PAfE) addin does not appear in Excel ribbon after installing the addin even as Administrator?
2024-12-04 Troubleshoot Planning Analytics ODBC Connector Connections and SSL Certificates The purpose of this document is to assist with troubleshooting connection or certificate related issues one might encounter when using the IBM Planning Analytics ODBC Data Connector.
2024-12-04 How to Validate Planning Analytics ODBC Data Connector (ODBCIS) Connection via API The steps in this document assist you in validating your connections to a running Planning Analytics ODBC Data Connector (ODBCIS) service, using the API
2024-12-02 Rolling update of Satellite agents If multiple Satellite agents are running, can each be upgraded individually, leaving the others running to handle the work load?
2024-11-28 How do I create a noninteractive account in Planning Analytics as a Service? How do I create a noninteractive account in Planning Analytics as a Service?
2024-11-10 How to enable Drive Explorer in Planning Analytics on Cloud non-prod environments By default Drive Explorer is not enabled in non-prod environments. Here are the steps to follow to enable Drive Explorer.
2024-10-25 How to Configure IBM Planning Analytics Workspace with Custom SSL (using Existing Keystore) The steps in the document guide you toward securing Planning Analytics Workspace, by using a keystore provided to you in PFX/PKCS12 format. In this document, you replace the keystore used by Planning Analytics Workspace, with your own.
2024-10-01 How to Enable and Disable Debug Logging on Planning Analytics Engine Using REST API This document provides an example of using REST API to enable and disable debug logging on a Planning Analytics as a Service database.
2024-09-20 IBM Satellite Connector: Failed to get configuration from API – insufficient privilege After installation of a satellite connector agent, the windows service starts successfully but the agent fails to get the configuration from the APIkey due to insufficient privilege
2024-09-20 IBM Satellite Connector: Failed to get configuration from API After installation of a satellite connector agent, the windows service starts successfully but a tunnel cannot be established.
2024-09-09 How to Retrieve and Cancel Jobs Running on a Planning Analytics as a Service Database Using REST API This document provides an example of using REST API to retrieve and cancel jobs running on a Planning Analytics as a Service database.
2024-09-03 TM1 Architect freeze when adding CAM security groups When opening the security/group menu in architect and right-clicking on add user/groups menu the application freezes and stop application is the only solution to resolve freeze issue.
2024-08-23 IBM Satellite Connector for Planning Analytics on Cloud – Frequently Asked Questions Q – How many connectors can each customer create?A – Each customer can create 1 connector, which will visible on all environments. Endpoints will only show in the environment that they are created.Q – How many agents can I have?A – Each connector can have 6 agentsQ – How many endpoints (data source) can I create in total?A – Spread across all environments, the maximum is 35.Q – Are there any exceptions to the maximum of 35 endpoints?A – Yes. Additional connectors can be purchased. Please contact your Sales
2024-08-14 Planning Analytics Spreadsheet Services/TM1web: Excel sheets with a dot in the name cannot be exported In Planning Analytics Spreadsheet Services/TM1web, attempting to export an Excel sheet(s) that contains a dot (".") in its name, will become stuck or load indefinitely.
2024-07-29 Exporting databases and books from Planning Analytics on Demand The end-of-life for Planning Analytics on Demand has been announced. In anticipation of migration to either Planning Analytics Local or Planning Analytics as a Service, Planning Analytics on Demand customers can use this procedure to export and download their data.
2024-07-16 How to Upload Files to Planning Analytics as a Service Database using REST API The following document provides steps to uploads files to a Planning Analytics as a Service database using the REST API
2024-06-27 Must Gather – Troubleshoot Planning Analytics Engine Database Migration Utility A problem has been encountered while using the Planning Analytics Engine Database Migration Utility
2024-06-19 Planning Analytics Model Appears To Have More Fed Cells Than Expected You have encountered a situation where you believe that your feeders have been written correctly however the }StatsByCube cube is reporting that you have more Fed cells than you are expecting.
2024-06-18 How to Connect to Planning Analytics as a Service Database using REST API with PA API Key This document outlines the steps to connect to a Planning Analytics as a Service Database, using the REST API with PA API Key
2024-05-31 How to Enable Web Browsers for Kerberos to Planning Analytics When Planning Analytics is configured for Kerberos, web browsers must be configured correctly for the authentication process to work as expected.
2024-05-21 How to Troubleshoot Planning Analytics Turbo Integrator (TI) Process that is Not Working as Expected You are encountering a problem with a Planning Analytics TI Process, however do not know where to start. The objective of this document is to help you better understand the steps you can take to better understand the underlying issue.
2024-05-16 Understanding Planning Analytics as a Service Instance Quota The Planning Analytics as a Service Instance Quota tile provides details that do not appear to match the usage of the databases in Planning Analytics Database Administration.
2024-04-23 Synchronization and Single Cell Widgets Can single cell widgets be synchronized to selector widgets and books?
2024-04-16 Planning Analytics Engine REST API Does Not Return Expected ServerName Value REST API responses from Planning Analytics as a Service databases which include the ServerName, do not return the expected server name (database name)
2024-04-15 AsciiOutput Behaviour Inconsistent When Threads Write to Same File in Parallel When using AsciiOutput to write to the same file in parallel, the behaviour is not consistent
2024-04-12 Suppress zero in Planning Analytics 2.0.9.19 and later versions don't work as expected when ViewConsolidationOptimization is set to F Suppress zero in Planning Analytics 2.0.9.19 and later versions don't work as expected when ViewConsolidationOptimization is set to F
2024-04-04 Resolving CAM-CRP-1093 Keystore Error while Generating Planning Analytics Cryptographic Information CAM-CRP-1093 Unable to read the contents of the keystore error occurs while saving Cognos Configuration for Planning Analytics
2024-03-30 Does deprecating 3rd Party Cookies impact Planning Analytics component functionality in Chrome? Google announced about deprecating 3rd Party Cookies in Chrome. Does that impact Planning Analytics component functionality in Chrome?https://blog.google/products/chrome/privacy-sandbox-tracking-protection/
2024-03-18 User with WRITE permission to Dimension (i.e. DIM1) and ElementAttributes cube, unable to edit element attribute for the same dimension User with WRITE permission to Dimension (i.e. DIM1) and ElementAttributes_DIM1 cube, unable to edit element attribute for the same dimensionError: SystemServerReadOnlyUsercannotWrite
2024-03-13 REST API query returns error code 278 When running a REST API query against a Planning Analytics server, an error is thrown stating the object does not exist
2024-03-11 Dimension could not be Compiled – Blank element found in dimension Unable to migration Planning Analytics Database. Errors occur: Dimension could not be Compiled – Blank element found in dimension
2024-03-08 Deprecation notices for IBM Planning Analytics 2.0 This document provides information about capabilities, components, or platforms, that apply to IBM Planning Analytics 2.0.8 and later.
2024-03-06 Planning Analytics Database Not Releasing Memory After Load Testing When performing a load test on a Planning Analytics Database, memory does not appear to be returned or released as expected
2024-03-01 Excel sheets with a dot in the name do not render properly in TM1Web Excel sheets with a dot in the name do not render properly in TM1Web
2024-03-01 TM1 Git failed. Reason: Authentication failed Unable to connect to Git repository from Planning Analytics. TM1 Git failed. Reason: Authentication failed.
2024-02-28 Understanding Planning Analytics Engine Database Backup Contents The purpose of this document is to help one understand the contents of a Planning Analytics Engine database backup file.
2024-02-28 Planning Analytics Database Migration Tool Error: _mt11t12_.exe: cannot execute binary file: Exec format error When running the Planning Analytics Database Migration Tool to convert a v11 model to v12 the following error is thrown and the migration fails:$ ./migrate_tm1.sh –input "C:\TM1_Model" –output "file://localhost/c:/TM1_Output/model.tar.gz"./migrate_tm1.sh: line 234: ./_mt11t12_.exe: cannot execute binary file: Exec format error
2024-02-09 How to View Planning Analytics Database User Sessions The purpose of this document is to provide steps one can follow to understand which users are active in a Planning Analytics database.
2024-01-24 Must Gather – Troubleshooting IBM Planning Analytics Connector for SAP A problem has been encountered while using the IBM Planning Analytics Connector for SAP
2024-01-16 Planning Analytics as a Service Timeouts The purpose of this page is to provide details regarding timeouts that users of Planning Analytics as a Service should be aware of.
2024-01-16 Errors Refreshing Formula-Based Report In Planning Analytics for Excel – #NUM! #VALUE! When refreshing a Planning Analytics for Excel formula-based report (custom report or dynamic report), the following error is displayed in the cells:Dynamic Report – #NUM!Customer Report – #VALUE!
2024-01-11 How to increase Planning Analytics Database disk size This document outlines the steps required to increase the size of disk allocated to a specific Planning Analytics Database
2024-01-10 How to Update PA Engine TI Process File Datasource to Location URL Within Process You have a TI Process using a File type data source and would like to point it to a Location (URL) instead
2023-12-28 Exploration Report Error Occurs When Opening The Set editor On The Row Dimension : The current set is not loaded successfully On an existing Exploration Report of Planning Analytics For Excel, the following error occurs when opening the Set Editor on the row dimensionAs a workaround, you can move the dimension to the context section and then back to the row. No error will occur following the move.However, when the report is opened again the error persists.
2023-12-20 RDP applications such as Architect and Perspectives are slow to render modelling objects after a TM1 sign-in A user might experience performance issues after signing into Architect or Perspectives within a remote session.For example, the user is likely to notice that it takes anywhere between 3-5 minutes for objects (cubes, dimensions, processes) to finally appear.
2023-12-20 Users may be unable to export to Excel from Planning Analytics Workspace on Chromium-based browsers Users might notice that they're unable to download files from Planning Analytics Workspace through the Microsoft Edge and the Google Chrome browser.
2023-12-20 Selections in the Planning Analytics Workspace set editor displays the MDX statement instead of the member name A user might notice that their member selection panel to the right within the set editor is displayed differently than usual.
2023-12-12 TI Process Error – Unable to open data source – Failed to send HTTP POST request An error is encountered attempting to Preview or Execute a Planning Analytics TI Process that uses the Planning Analytics ODBC Connector (ODBCIS) as a data source. Unable to open data source – Failed to send HTTP POST request
2023-12-12 Software Environments for IBM Planning Analytics The information and links in this document identify the software environments supported by IBM Planning Analytics and associated components.
2023-12-11 Unable to update cell(s). SystemServerReadOnlyUserCannotWrite Error while updating a Dimension Attribute Non-Admin user receives the following error while updating the dimension attribute:Unable to update cell(s). SystemServerReadOnlyUserCannotWrite
2023-12-11 How do you add an extra row/column to a Universal Report in Planning Analytics for Excel? The objective is to add a new column or a row to an existing Universal report.
2023-12-07 IBM Planning Analytics For Excel: How To Add A Blank Row or Column In A Univeral Report How To Add A Blank Row or Column In A Univeral Report
2023-11-29 Must Gather – Troubleshoot Planning Analytics – Secure Gateway A problem has been encountered while using the Planning Analytics Secure Gateway
2023-11-09 Planning Analytics for Excel: "Object reference not set to an instance of an object" when generating a report or exploration from a cube view. In Planning Analytics for Excel (PAfE) converting a cube view into a: Exploration Quick Report Dynamic Report Custom ReportFails and displays the error message: "Object reference not set to an instance of an object."
2023-11-01 Object reference not set to an instance of an object after logging into Planning Analytics for Excel (PAFE) After logging into Planning Analytics for Excel, the following error is thrown: Object reference not set to an instance of an object.
2023-10-10 Turbo Integrator (TI) process using a Microsoft SQL Server data source appears to hang A TI process that worked in a previous version of IBM Planning Analytics appears to hang on the call to the underlying data source.
2023-10-10 How to Upgrade Planning Analytics Database (as a service) This document outlines the steps to connect to and upgrade a Planning Analytics as a Service Database, using the REST API
2023-10-03 How to Manually Repack Planning Analytics Database Backup File for Planning Analytics as a Service The steps in the document cover how to build an archive that can be used to restore a Planning Analytics as a Service database
2023-09-27 How to Encrypt Password in Planning Analytics WLP Server.xml File Depending on your configuration, you may have a need to connect to a password secured resource configured by the server.xml file in a Websphere Liberty Application server. In this example, the Planning Analytics Web Tier / TM1Web is being secured to use KERBEROS security – which requires an LDAP password be provided.
2023-09-26 Must Gather – Troubleshoot Planning Analytics for Excel A problem has been encountered while using Planning Analytics for Excel
2023-09-26 Must Gather – Troubleshoot Planning Analytics Workspace A problem has been encountered while using Planning Analytics Workspace
2023-09-26 Must Gather – Troubleshoot Planning Analytics Websheets in Planning Analytics Workspace A problem has been encountered with a Planning Analytics Websheet opened in Planning Analytics Workspace
2023-08-16 Samples Required for IBM Planning Analytics forecasting tutorial This page contains sample data files that you use to complete the lessons in the IBM Planning Analytics forecasting tutorial.
2023-08-11 TM1 Application – Could not connect to the TM1 Server When users try to load TM1 Application with TM1 Application portal under http://&lt;Webserver&gt;:9511/pmpsvc , receives error message as following:"Could not connect to the TM1 Server"This same error can be noticed when try log in to Performance Modeler.
2023-08-10 Planning Analytics on Cloud – SMTP (send email) process using Powershell script A Planning Analytics administrator would like to send email notifications by using a TM1 Turbo Integrator process.
2023-08-10 Unable to import /list certificates using gsk8capicmd_64 tool in Linux OS Unable to import /list certificates using gsk8capicmd_64 tool in Linux OS
2023-08-10 PAA agent doesn't show instance information, unable to upload csv file from PAW. PAA agent doesn't show instance information, unable to upload csv file from PAW.
2023-08-10 Sandbox file size Why is the .cub_delta file size, sometimes, as large as the .cub file? And what can be done to reduce its size?
2023-08-03 Long waiting times when refreshing a Custom Report in IBM Planning Analytics for Excel Some users might experience long waiting times when they refresh their Custom Reports in IBM Planning Analytics for Microsoft Excel.
2023-08-01 Unable to access the Learn panel server The Learn panel is unable to connect to the Learn panel server.
2023-07-20 After enable IBM Planning Analytics Spreadsheet Service with Custom SSL unable to see any instances , Authentication error Login failed After enable IBM Planning Analytics Spreadsheet Service with Custom SSL unable to see any instances
2023-07-19 Cognos Command Center Remote agent not found Cognos Command Center triggers are failing and requests to port 443 aren't working.The error message is "Remote agent not found at &lt;environmentName&gt;.planning-analytics.ibmcloud.com port 443 (https://&lt;environmentName&gt;.planning-analytics.ibmcloud.com:443/ccagent/). Unable to connect to the remote server."
2023-07-04 On The RDP Server For Planning Analytics on Cloud: A Network Error Occurs When Accessing The File Share Location \\data\s On the RDP Server (Rich Tier) For Planning Analytics on Cloud environment, the following network error occurs when accessing the shared folder (S:\) using \\data\s
2023-07-04 Planning Analytics for Excel: Where To Retrieve The Macro Automation Files For Cognos Office Written In Microsoft Visual Basic For Applications (VBA) For API Calls Where to retrieve the Macro Automation files to import into Microsoft Visual Basic For Applications (VBA) For API Calls in Planning Analytics For ExcelMacro Files:CognosOfficeAutomationExample.basCognosOfficeMessageSuppressor.cls
2023-07-04 Logging Into Planning Analytics For Excel A Windows Security Error Occurs: Select A Certificate From The Following List To Authenticate Logging into Planning Analytics For Excel, the following Windows Security error will occur
2023-07-04 The Planning Analytics For Excel Task Pane Does Not Appear And The Excel Option Of Optimize for Compatibility is Enabled. The Planning Analytics For Excel Task Pane Does Not Appear and The Excel Option Of Optimize for Compatibility is Enabled.
2023-06-29 How to change the day that the Calendar Picker starts with This requirement depends on the browser, which overrides the OS region setting. If you want the Calendar Picker to start on a Sunday, then set the browser Language to English (US). And if you want the Calendar Picker to start on a Monday, then set the browser Language to English (UK). So pick the browser language to suit your preference.
2023-06-22 How to avoid updating all TI processes when password changes for ODBC source ? Many TurboIntegrator processes are using the same ODBC data source. Each time the username and password is modified, all TurboIntegrator processes have to be updated one by one. How to avoid this?
2023-06-16 TM1 Web 2.0.85 – Labels on the X-axis in waterfall charts are not wrapping In IBM TM1 Web 2.0.85, labels on the X-axis in waterfall charts do not wrap and appear truncated. This issue is due to an issue with a third-party library.
2023-05-17 Unable to Log in to Planning Analytics for Excel – Script Error – Expected ';' User is unable to log in to Planning Analytics for Excel. A script error is encountered, indicating an expected character of ';'.
2023-04-13 How to resend an invitation for Planning Analytics with Watson How can an invitation for a subscription be resent to a user?
2023-04-06 Failed to create document when publishing a workbook via Planning Analytics for Excel Unable to publish a workbook via Planning Analytics for Excel
2023-04-02 Addressing Cross Hierarchy Attributes in Rules In a dimension with six alternate hierarchies, I'd like to synchronize in a rule a "Code-Name" alias for C level elements, which are the same thing hierarchy to hierarchy.For example, in the main Hierarchy, Code "M1000" is a parent that has dozens of children.M1000-M1000.01-M1000.02-etc…The Code is "M1000" and the Name is "Fred", therefore the Code-Name alias is "M1000 – Fred".In the nonmain hierarchy, I'd like to write a rule that says:['Code-Name', in AltHierarchyX or all Alt Hierarchies ] =C:
2023-04-02 Planning Analytics Workspace User and Group Security Permissions For group permission changes in Planning Analytics Workspace, such as adding and removing users, why must the user sign out of their current Planning Analytics Workspace session and sign back in for changes to take effect?
2023-03-31 How to find the Planning Analytics server version on Cloud How can I determine what version of server is running on Planning Analytics with Watson?
2023-03-27 Multi Factor Authentication (MFA) for every login How can I turn on MFA for every login regardless of application?
2023-03-21 Planning Analytics on Cloud – ODBC connection to SQL Server fails due to lack of cursor support in SQL Server Planning Analytics on Cloud – ODBC connection to SQL Server fails due to lack of cursor support in SQL Server
2023-03-01 Security Scan Scope and Process – Planning Analytics To provide timely and effective responses for clients when they run security scans, we provide the following guidelines to help to reduce the noise and to allow support teams to better focus on the highest priority results for our clients.This process provides guidelines for clients and sets expectations for how Support will process these sorts of requests when logged as cases.The IBM Cognos and Planning Analytics (CAPA) organization follows the IBM Security and Privacy by Design (SPbD) process, which
2023-02-23 Planning Analytics Websheets – Formatted values can be displayed differently when compared with Explorations and Planning Analytics for Excel reports Different Planning Analytics clients seem to exhibit different rounding behavior when they display the same value.For example, when the display format is set to show the value 2097152.125 to two decimal places: A Planning Analytics Workspace exploration, and a Planning Analytics for Excel custom report, both round the displayed value up to: 2,097,152.13. A Planning Analytics Workspace websheet, and a TM1 Web websheet, both round the displayed value down to: 2,097,152.12.However, all four clients displa
2023-02-06 How to use REST API and Postman to return threads in a table format How can a user view active threads on a server without launching Planning Analytics Administration?
2023-01-19 After each reboot, some Planning Analytics Workspace containers are failing to start Planning Analytics Workspace is working correctly until the Windows Server is rebooted.Each time the Windows Server is restarted, some of the containers fail to start ("Exit" state instead of "Up" state).Some temporary containers might also appear, like:bf16f3c7faa2_couchdb32784fd3b06d_share-app78fd50cfc238_pa-gatewayEach time it happens, a manual operation is necessary to get all the containers up again, which is not acceptable on a production environment.
2023-01-19 TI Process Errors When Sourcing An Azure Synapse Datasource: Error Executing SQL Statement TI Process errors when sourcing an Azure Synapse datasourceThe SQL query works fine in Sql Server Management Studio
2023-01-18 Azure Synapse Datasource Errors On Test Connection Within The Secure Gateway Datasource Connection Using Correct Credentials: Connection failed due to invalid credentials An Azure Synapse datasource connection fails when testing the datasource connection with correct username and password credentials within the Secure Gateway datasource connection of Planning Analytics Administration on Cloud environment.When using the same credentials within SQL Server Management Studio, the credentials work successfully.
2023-01-17 Cursor support is not an implemented feature for SQL Server Parallel DataWarehousing TDS endpoint error when executing a SQL query in Planning Analytics This happens when MSSQL is on Azure. Within Planning Analytics, when you execute a simple query, it errors saying: Error executing SQL query.
2023-01-17 Static subset in Planning Analytics Workspace does not show the list of elements defined Static subset in Planning Analytics Workspace does not show the list of elements defined. It shows an MDX that references itself.
2023-01-11 Must gather: PA_SSL_Checker tool on Windows to gather SSL/TLS information for IBM Support The attached Powershell script is to be used for any kind of issues involving custom SSL/TLS on one of these components: TM1 Server TM1 Admin Server TM1 Web TM1 Application Web (pmpsvc) Planning Analytics Spreadsheet Services Planning Analytics Workspace
2023-01-10 Planning Analytics Quick Report Errors "One or more axes are missing from the current quick report" Planning Analytics Quick Report stops working
2023-01-09 Try to connect to Planning Analytics Workspace result into a "Proxy Error" in the browser window Planning Analytics Workspace is up and running. It's possible to start and open the Planning Analytics Workspace Administration Tool. Validation is fine and the status shows all containers up and running. But when users try to access Planning Analytics Workspace in a web browser, the following error message occurs:Proxy ErrorReason: DNS lookup failure for wa-proxy
2022-12-28 A Planning Analytics TI Process Sourcing An ODBC SQL Data Source When Run Is Very Time Consuming To Complete A TI process that uses an ODBC data source to execute a SQL Query takes over 5 minutes to complete. The SQL Statement when run directly in SQL Server Management Studio takes only 5 seconds to complete.
2022-12-28 Planning Analytics Workspace Lifecycle Management Export Snapshot Does Not Complete Within Planning Analytics Workspace Lifecycle Management, the snapshot of assets is created successfully, however, the export of the snapshot does not complete. The issue is specific to books that are very large in size with over 20 sheets within the one book.The message box appears with message:Export snapshot.Please wait while the request is executedThe progress bar quickly disappears but there is no confirmation that the export completedThe *.gz file does not appearThe log file only sho
2022-12-28 Can Planning Analytics Workspace TI Data Source Preview feature be used to identify issues in the source CSV file? Can Planning Analytics Workspace TI Data Source Preview feature be used to identify issues in the source CSV file?
2022-12-28 How is data formatting applied in TM1 – Planning Analytics? How is data formatting applied in TM1 – Planning Analytics?What are the priority rules?
2022-12-28 The Rollback Feature Is Disabled in Planning Analytics Workspace In a Planning Analytics Workbook, the rollback feature is disabled and any cell value changes cannot be rolled back to the original value
2022-12-28 How To Determine The Version Of IBM Secure Gateway Installed How To Determine The Version Of IBM Secure Gateway Installed
2022-12-28 Copy and Paste slow when you have the Planning Analytics for Excel add-in enabled in Excel When you attempt to copy and paste non TM1 formulas between excel tabs, you notice a performance lag when the add-in is enabled. Without the add-in enabled, no lag is noticed.
2022-12-27 Error Occurs When Opening A TM1Web Report: The Action Has Been Terminated Because It Exceeds The Configured Maximum Memory Limit Error occurs when opening a TM1Web report
2022-12-16 How to determine the version of TM1Web/PASS for Cloud-based Planning Analytics customers? How to determine the version of TM1Web/PASS for Cloud based Planning Analytics customers?
2022-12-16 Differentiating between subset icons in Planning Analytics Workspace The screen capture has three highlighted subsets, each with a different icon.What does each icon represent?Figure 1. Subsets
2022-12-14 How to setup non SSL enabled Planning Analytics Workspace with SSL enabled load balancers When you only have SSL enabled on the load balancer URL for Planning Analytics Workspace and not on Planning Analytics Workspace itself, so you are actually proxying paw that is not TLS enabled while the proxy is TLS enabled. This will result in the following error message: " The information you are about to submit is not secure"
2022-12-13 "Failed to create element" error occurs when attempting to add an element to a hierarchy, when the element name (added to hierarchy) exists as an Alias for an element in a dimension "Failed to create element" error occurs when attempting to add an element to a hierarchy, when the element name (added to hierarchy) exists as an Alias for an element in a dimension.
2022-12-12 The file format and extension of IBM_PAfE_x64_2.0.xx.xll don’t match. The file could be corrupted or unsafe. when installing Planning Analytics for Excel. After loading the Planning Analytics for Excel Add-in, a prompt with the following message pops up."The file format and extension of IBM_PAfE_x64_2.0.82.5.xll don’t match. The file could be corrupted or unsafe."When click "yes" to proceed, Excel shows "This Program cannot be run in DOS mode".
2022-12-11 Attribute based hierarchy when created for a text attribute in PA Workspace, why hierarchy is created but leaf level elements are not added to the hierarchy? Attribute based hierarchy when created for a text attribute in PA Workspace, why hierarchy is created but leaf level elements are not added to the hierarchy?
2022-12-07 How to drag an element to the right side in the Carbon Design Subset Editor in Planning Analytics for Excel? How to drag an element to the right side in the Carbon Design Subset Editor in Planning Analytics for Excel?
2022-12-07 Excel crashing when launching Planning Analytics for Excel Launching Excel with the Planning Analytics for Excel add-in enabled crashes Excel.
2022-12-06 How to roll back a Planning Analytics upgrade to an earlier build In some situations it may be beneficial to roll back an upgrade and return to a previously installed version. This can be done by simply uninstalling the new version and installing the old one back, but a quicker method that does not remove configuration files is also available. Note that this only works to roll back to versions which the machine previously had installed, and an upgrade was applied on top. When an upgrade is applied, a backup of the previous version is automatically created in the "tm1_6
2022-12-05 Planning Analytics on Cloud – Backup process using PowerShell script A Planning Analytics administrator would like to perform their own backup of the Planning Analytics Data folder by using a Planning Analytics Turbo Integrator process. For security reasons, third-party utilities (for example 7-zip) cannot be installed on the Cloud.
2022-12-05 SFTP SSH key In order to setup SFTP with a 3rd party tool, an SSH key is needed. How can the key be found?
2022-12-02 Users unable to copy and paste elements to subset editor in Planning Analytics for Excel Users unable to copy and paste elements in subset editor.
2022-11-21 Unable to authenticate successfully when creating an Azure connection with Secure Gateway A valid Azure connection, created by using Secure Gateway, fails to test successfully.
2022-11-17 How to change format of data in a visualization How to change the format of data in a visualization in Planning Analytics Workspace new experience?
2022-11-15 How to delete an Application in Planning Analytics Workspace How to delete an Application in IBM Planning Analytics Workspace
2022-10-25 How to determine if Planning Analytics is affected by a security vulnerability If you run a security scan and it is reported that the Planning Analytics server is affected by a vulnerability, it might cause concern. In order to verify if the application is truly affected by this vulnerability, and to determine what steps can be taken to protect the server, the following steps can be used.
2022-10-25 Authentication to TM1 Web is taking longer than previously expected After an upgrade, restart, or configuration changes, you might notice a difference in performance. If the performance difference is specific to login duration taking over 10 seconds, there can be an issue with the authentication server. There may be a blank background page shown while attempting to connect that does not progress further or takes much longer than expected.
2022-10-25 TM1 Servers not appearing in the server list on TM1 Web after configuring HTTPS The server is visible in Architect and login goes through successfully, but while accessing TM1 Web, no servers are appearing in the list.There might be an error in the "webapps/tm1web/WEB-INF/logs/tm1web.log" file indicating that it was unable to find parameter "batchID".
2022-10-18 Numeric Calculations in TM1 This document explains the numeric calculation behavior of the TM1 database.
2022-09-20 Planning Analytics Administration Agent is unreachable When the user tries to check the agent status, it shows as unreachable.
2022-09-12 PA-GATEWAY Error: An unexpected error has occurred Planning Analytics Workspace was working for a while. When try to connect to PAW the following message occurred in the browser:PA-GATEWAY Error: An unexpected error has occurred
2022-09-01 Quick reports that are opened on a new book are missing right-click options Important: This issue is fixed in IBM Planning Analytics for Microsoft Excel 2.0.80.Quick Reports that are created and opened on a new book from the IBM task pane in Planning Analytics for Microsoft Excel, are missing right-click menu options.
2022-08-31 Planning Analytics On Cloud: How To Install the Secure Gateway Client On A Proxy Server The following steps detail how to set up the Secure Gateway Client with a proxy configuration in place and avoid any failed installations with npm or certificate errors when connecting to the Secure Gateway Servers. The Secure Gateway Client does support a proxy configuration with the following rules: Secure Gateway does support a proxy configuration with implicit authentication (proxy process runs under specific user + password service account). Secure Gateway client proxy does not support a configura
2022-08-09 Powershell back up script fails with unauthorized access error A Powershell script that creates a back up a folder structure fails with an unauthorized access error
2022-08-03 Can the '–NONE –' value be removed from a picklist in IBM Planning Analytics Workspace? Can the '–NONE –' value be removed from a picklist in IBM Planning Analytics Workspace?
2022-07-25 How to clear cell data in TM1 Web using action buttons on a websheet In some cases, users might work with websheets in TM1 Web that are either filled by a TI process or filled manually to complete a form. In case they want to submit this form multiple times for different data, it can be inconvenient to remove data from many cells to clear the form for work on a new submission. One method is to simply reopen the form from scratch, but this can take several seconds for each submission. Instead, it is possible to create an action button with the purpose of clearing data from th
2022-07-25 Request Functional Enhancement (RFE) for Planning Analytics How do we submit an enhancement request for Planning Analytics?
2022-07-25 Configuring PA Components for SSL and CAM Security after enabling SSL on Cognos Analytics and Planning Analytics After Cognos Analytics is enabled for SSL some changes in Configuration have to be done. In all Config Files for PA on the BI Server the links redirecting to PA have to be changed to https In all Config Files for CA on the PA Server entries have to be changed to https Each Component from Planning Analytics has to trust the certificates on Cognos Analytics
2022-07-12 IBM Secure Gateway client version How can I determine what version of IBM Secure Gateway client I have installed on Microsoft Windows?
2022-07-11 How to install or uninstall the IBM Cloud Secure Gateway manually The software media of IBM Cloud Secure Gateway will uninstall or install Windows service as required. Sometimes, it is necessary to run these steps manually
2022-06-30 User is a Planning Analytics (PA/TM1) Administrator but isn't able to see Dimensions and Cubes in Architect User is a Planning Analytics (PA/TM1) Administrator but isn't able to see Dimensions and Cubes in Architect as:
2022-06-29 How to use TM1RunTI on Cloud Specific account and steps need to be performed in order to use TM1RunTI on IBM Planning Analytics on Cloud. This document described these steps.
2022-06-29 How to Configure SSL on Planning Analytics Data Tier using GSKit (New Certificate Signing Request) The steps in the document guide you in using the IBM Global Security Kit (GSKit) to secure your Planning Analytics Data Tier (Admin Host and TM1 Server), by creating a new Certificate Signing Request, and having the certificate signed by your Certificate Authority.
2022-06-28 How to Delete Old Log and Model Upload Files in Planning Analytics This technote describes how to automate the deletion of old log and model upload files.
2022-06-21 How To Create a Dynamic Asymmetric Selection in a Planning Analytics Workspace Exploration The aim is to create an exploration that has an asymmetric selection in columns, where a Version dimension is nested with the Year dimension. The member of the Version dimension that is displayed for each Year member is determined by a value in an assumption cube. When the value in the assumption cube changes, the exploration automatically updates. This technote details how to write an MDX view statement that fulfills this requirement.
2022-06-17 Unable to install Planning Analytics Workspace, prism-platform container stuck at restarting state Unable to install Planning Analytics Workspace due to prism-platform container getting stuck at restarting state
2022-06-07 Troubleshooting TM1 data encryption with the TM1Crypt tool Data encryption is an optional feature in TM1 that can help protect data. Using encryption, even if the data files themselves are taken, they cannot be read without the proper encryption key. This process can be done by following the configuration instructions here:https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=encryption-run-tm1crypt-utilityIt is recommended to test all of the following processes before implementing this in a production environment:- Encrypting the data- Backing up the encrypte
2022-06-07 Configuring SSL for TM1 Web with LDAP authentication In some cases you might want to configure SSL communication for TM1 Web, as well as LDAP authentication for user login. Both of these processes make changes to some of the same configuration files, so you must take care to follow the order of instructions so that no errors arise. The first recommendation is to follow the SSL setup for TM1 Web starting from a fresh installation. This process can be done with the following process that uses your existing certificates: https://www.ibm.com/docs/en/planni
2022-06-07 Embedding Planning Analytics Workspace (PAW) assets in external pages Some users might want to export PAW assets for use in other external tools, such as Cognos Analytics reporting, or other third party reporting tools. The PAW configuration file allows for some options to help facilitate compatibility, here is our list of available parameters, which must be matched with your reporting tool's requirements for embedded items: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=local-configure-parameters Beyond this, we also have the PAW API that provides a number
2022-06-03 "Session timed out" error in TM1 Web Users are receiving this message after few minutes in TM1 Web or Planning Analytics Spreadsheet Services:&lt;IP_address&gt;:9510 saysSession timed out
2022-05-30 Planning Analytics for Excel in dynamic reports don't suppress columns. Planning Analytics for Excel in dynamic reports doesn't suppress columns.
2022-05-26 Win32 access denied errors while installing Planning Analytics for Excel on non-system drive Win32 Access Denied errors when Planning Analytics Workspace is installed on non-system drive or when attempting to start one of the containers.
2022-05-25 How to delete a string comment within an Exploration in Planning Analytics for Excel? How to delete a string comment within an Exploration in Planning Analytics for Excel?
2022-05-23 How to use the ExecuteFunction process within Planning Analytics? The EXECUTEPROCESS function is used to call and run a TurboIntegrator (TI) process from within another TurboIntegrator process.
2022-05-20 Create Cube option missing in the New Experience of Planning Analytics Workspace When you attempt to create a new cube under Reports and Analysis by right-clicking cubes, the option is missing.
2022-05-19 Resolution scaling issues with remote desktop applications The desktop icons on the modeler remote system are large, and the row height sizes within a TM1 cube view are truncated, resulting in the data being illegible.
2022-05-19 Configure Microsoft Excel as a Secure Gateway data source The distinct steps needed to configure and also test Microsoft Excel as a Secure Gateway data source.
2022-05-18 Change the MDX solve order used when calculating variance percentages The solve order is determined by the last created calculation — the last calculation is the expected logical result.
2022-05-18 A dash used to represent zero values in a format expression displays an error in Planning Analytics Workspace Using a dash to represent zero values in a format expression displays as error in Planning Analytics Workspace.
2022-05-17 Unable to delete the old Add-ins (CognosOfficeBI and CognosOfficeTM1) within Planning Analytics for Excel (PAFE) Unable to delete the old Add-ins (CognosOfficeBI.xll and CognosOfficeTM1.xll) within Planning Analytics for Excel
2022-05-11 How to use the ExecuteFunction API to call Turbo Integrator processes in Planning Analytics for Excel? Use the ExecuteFunction to call Ti processes within Planning Analytics for Excel.
2022-05-10 Error code 289: TM1 Git failed to connect to remote. Reason: TM1 Git network connection failed. Error while running the GitInit command (through REST API) to initialize Git Integration:Error code 289:TM1 Git failed to connect to remote. Reason: TM1 Git network connection failed.
2022-05-04 IBM Planning Analytics Custom SSL – Quick Start and Troubleshooting The purpose of this document is to compliment the existing product documentation and provide extra guidance to those implementing custom SSL with IBM Planning Analytics Local.
2022-05-04 How to Configure IBM Planning Analytics Performance Modeler with Custom SSL (using Existing Keystore) The steps in this document guide you toward configuring your IBM Planning Analytics Performance Modeler to allow connections to a TM1 Server and Planning Service that has been secured by using custom certificates. In this document you replace the default ibmtm1 certificate keystore with your own.
2022-05-02 Deprecation notices for IBM Planning Analytics 2.0.7 and earlier This document describes the history of deprecated capabilities, components, or platforms in IBM Planning Analytics releases from version 2.0.0 to 2.0.7 inclusive.
2022-05-02 Revocation information for the security certificate for this site is not available – When connecting to a custom SSL/TLS secured environment When custom SSL/TLS is set, a security alert might appear when we try to connect to TM1 from various tools (Architect, Perspectives, Performance Modeler, TM1 Web, …)This message happens either in a Planning Analytics environment that is secured with custom SSL/TLS, or that is accessing a Cognos Analytics environment that is using custom SSL/TLS.This occurs when a web browser is involved in the connection process.The error message is the following:Security alertRevocation information for the security certi
2022-04-28 Planning Analytics for Excel Menu/Toolbar language How-to change the Planning Analytics for Excel menu and toolbar language setting without altering the Windows display language.
2022-04-22 Large Planning Analytics Workspace and Planning Analytics for Excel Requests Fail – Entity Too Large (HTTP 413) Large requests in Planning Analytics Workspace and Planning Analytics for Excel fail with entity too large errors
2022-04-21 How to Configure IBM Planning Analytics Application Web (TM1 Contributor/PMPSVC) with Custom SSL (using Existing Keystore) The steps in the document guide you toward securing Planning Analytics Application Web (TM1 Contributor/PMPSVC), by using a keystore provided to you in PFX/PKCS12 format. In this document, you replace the keystore used by Planning Analytics Application Web, with your own.
2022-04-21 How to Configure Planning Analytics Data Tier with Custom SSL (using Existing Keystore) The steps in the document guide you toward securing the Planning Analytics Data Tier (Admin Host and TM1 Server), by using a keystore provided to you in PFX/PKCS12 format. In this document you replace the default ibmtm1 certificate keystore with your own.
2022-04-21 How to Configure IBM Planning Analytics Administration Agent with Custom SSL (using Existing Keystore) The steps in the document guide you toward securing Planning Analytics Administration, by using a keystore provided to you in PFX/PKCS12 format. In this document you will be replacing the keystore used by Planning Analytics Administration, with your own.
2022-04-13 Unable to upgrade Action button in Planning Analytics for Excel. Client is upgrading Action button in Perspectives sheets but the Total number of files upgraded shows Zero.
2022-04-13 How to create a line chart with multiple dimensions in Planning Analytics Workspace New Experience How can I create a line chart with multiple dimensions in Planning Analytics Workspace New Experience? Only one line is appeared when I select a line visualization.
2022-03-31 Workspace error: User does not have read access (rte 34) when trying to add a child in a hierarchy Planning Analytics Workspace error when trying to add a child in a hierarchy (same problem for both admin and non-admin users):SELECT: User does not have read access (rte 34)
2022-03-28 Planning Analytics on Cloud – How to Renew a Secure Gateway (SG) security token Planning Analytics on Cloud is not able to connect to on-prem datasource via Secure Gateway client because security token is expired. This document lists the steps to renew the security token and to add the new token to on-prem SG client installation.
2022-03-25 "Select datasource" window takes minutes to appear after authentication in IBM Planning Analytics for Microsoft Excel (PAfE) 2.0.68 A user opens a worksheet in PAfE, clicks connect, chooses a connection to their environment. After authentication, a window is presented with active Planning Analytics data sources requiring the user to select one. With a particular workbook, this window takes upwards of 4 minutes to appear.
2022-03-23 SUBNM formulas do not work in TM1Web A workbook with multiple SUBNM formulas works without issue in IBM Planning Analytics for Excel but when published to TM1web, the formulas are "dead"
2022-03-20 tm1s-log.properties file reappears after deletion or its content changes unexpectedly This issue can present itself two ways: The tm1s-log.properties file reappears after deletion The contents of the tm1s-log.properties file changes unexpectedly
2022-03-18 Passing URL (ECHOHEADERS.JWS?METHOD=LIST) in TM1 Web displays TM1 server hostname In IBM Planning Analytics TM1 Web (Planning Analytics for Spreadsheet Services), passing the following URL displays the hostname of the TM1 server during error handling: https://&lt;tm1_server_name&gt;/tm1web/tm1web/EchoHeaders.jws?method=list
2022-03-17 Why some users run into the following error message when using PA Workspace workbook: "Sorry, Invalid cell update. Your view session has expired. Please refresh your view and try your action again." Why some users run into the following error message when using PA Workspace workbook:"Sorry, Invalid cell update. Your view session has expired. Please refresh your view and try your action again."
2022-02-25 User unable to see any content in Planning Analytics Workspace – You don't currently have any assets Users attempting to access assets (Books, Views, and more) in Planning Analytics Workspace see a message that states: "You don't currently have any assets"
2022-02-16 Script Error Occurs Logging in to TM1 Perspectives When Using Cognos Security When logging in to a TM1 Server secured with CAM Authentication in Perspectives, a script error occurs.
2022-02-08 Error possible when upgrading Perspectives report with Action Buttons and Backup option in IBM Planning Analytics for Excel If you selected the Backup option when upgrading a Perspectives report with Action Buttons in IBM Planning Analytics for Excel, you might see the following error:No Workbooks found. Please make sure you have permission to upgrade.
2022-01-13 Something went wrong in step "Installing/Updating IBM Planning Analytics Docker images" When trying to upgrade Planning Analytics Workspace, users get the following message and there is no Start.log created in the admintool log directory:Looks like something went wrong in step "Installing/Updating IBM Planning Analytics Docker images"… Check the log file /data/ipa_workspace_win_2.0.xx/log/admintool/start_xxxx_xx_xx.log… Press Enter to continue…
2022-01-11 Custom Report does not refresh correctly in IBM Planning Analytics for Excel In certain cases, the Custom Report is not refreshing correctly and does not return any values.
2022-01-10 Browser Search (Ctrl+F) does not find elements in TM1Web Using a browser search (Ctrl+F) for a specific element on a Websheet only works if the user scrolls to a point where the value is displayed. In older versions of the product, the value is found immediately.
2022-01-03 Display issue in Subscriber & Subscription Management Not able to see the headers in Subscriber &amp; Subscription Management (administrator, entitled users etc).
2021-12-31 How To Determine The Version Of The IBM Secure Gateway Client Installed and Latest Available Versions and Fix Lists How to determine the version of the Secure Gateway Client installedAndWhat are the latest available versions to install and their corresponding fix lists
2021-12-29 How to Export A List Of All Users Who Have Not Accepted The IBM Planning Analytics On Cloud Invitation How to export a list of all users who have not accepted the IBM Planning Analytics On Cloud Invitation
2021-12-23 Instructions on how to defederate individual IBMid accounts for Planning Analytics on Cloud and Cognos Analytics on Cloud users The following steps are required to defederate individual IBMid account for Planning Analytics on Cloud and Cognos Analytics on Cloud users
2021-12-21 Planning Analytics Administration: Long Running Thread With The Function GET /api/v1/MessageLog() In Planning Analytics Administration for a TM1 Server, there is a long running thread that will not cancel and displays with the function – GET /api/v1/MessageLog()
2021-12-21 Planning Analytics For Excel: In Exploration Report, All Data Cells Appear As <#1234#> In Planning Analytics For Excel, within an Exploration report, all cells contain the entry &lt;#1234#&gt;
2021-12-21 Using correct password but get 'Connection failed due to invalid credentials' error when testing DSN in IBM Cognos Secure Gateway Unable to connect to the DB2 datasource from IBM Cognos Secure Gateway (SG)
2021-12-21 How to fully uninstall and clean up a corrupted Planning Analytics for Excel installation ? How to fully uninstall and clean up a corrupted Planning Analytics for Excel installation ? If a classic uninstallation and reinstallation is not sufficient to resolve some odd or unexplained issues, then use this document to uninstall and reinstall the product.
2021-12-20 Planning Analytics On Cloud: RDP Server: Script Error Occurs When Logging Into Tm1 Server For Architect and Perspectives A script error occurs when logging in to any Tm1 server instance for both Architect and Perspectives on the Planning Analytics On Cloud RDP Server (Rich Tier)
2021-12-20 Planning Analytics On Cloud – Modeler User Logs Into RDP Server And The Screen Appears Blank and No Desktop Icons Appears On a Planning Analytics on Cloud RDP server (Rich Tier) environment, a specific modeler logs on and the screen appears blank and no destop icons appear. The issue is specific to one modeler account only, other modeler accounts are successful in logging on.
2021-12-13 When creating a new calculation column in a Planning Analytics Workspace view, not all of the cells are being displayed as expected (some are left blank) When users create an arithmetic calculation in workspace , not all cells calculate. Select 2 elements displayed in the column, then right click to select Create Calculation, then select the Arithmetic option to subtract one element from the other. Some cells calculate, others are blank.
2021-12-05 CSIAQ0287E Error received when logging into Planning Analytics on Cloud User receives the following error when attempting to log into Planning Analytics on Cloud:CSIAQ0287E The system cannot process your request because the transaction has been idle for too long.
2021-12-03 Error code ssl_error_no_cypher_overlap in Performance Modeler when configuring rights The following error is seen when configuring rights in Performance Modeler:An error occurred during a connection to server.domain.comCannot communicate securely with peer. No common encryption algorithm(s). (Error code ssl_error_no_cypher_overlap)
2021-11-25 How to Troubleshoot CAM Authentication from Planning Analytics TM1 Server This document covers troubleshooting techniques that can be used to identify and resolve configuration issues or authentication problems when using CAM security with the TM1 Server.
2021-11-19 MSG_Ribbon seen with the IBM Planning Analytics tab after upgrading to Planning Analytics for Excel (PAFE) version 68 MSG_RIB_DESIGNMODE_OFF and MSG_RIB-FORMULA_WB_MODE seen in the IBM Planning Analytics ribbon after upgrading to PAfE 68. It should display as "Design Mode" and "Writeback Mode".
2021-11-17 Users are unable to commit data in Application Web (Contributor) Users are unable to commit data in Application Web (Contributor). Data remains in blue color even after clicking on commit.
2021-11-16 Some containers are in "Exit" or "Restarting" state: pa-content, async-service, neo-idviz, wa-proxy – (logs: ENOENT on db_secret.key) The following containers are in "Exit" or "Restarting" state shortly after restarting Planning Analytics Workspace:pa-contentasync-serviceneo-idvizwa-proxy
2021-11-15 Running a Chore within Planning Analytics Workspace (PAW) fails with Chore Execution failed , error code : 278 Running a Chore within Planning Analytics Workspace (PAW) fails with Chore Execution failed, error code: 278. You will not see this message in either Architect/Perspectives. However, if you check the tm1server.log file, you will see the Chore executed successfully.
2021-11-09 Users see a 502 Proxy error when attempting to log into Planning Analytics Workspace (PAW) Error seen when attempting to log in to workspaceUnable to retrieve the capabilities for server : server name followed by Session cannot be established for server : server name 502 (Proxy error)
2021-11-05 The specified file is not a valid application export file when attempting to import an application zip file into TM1 Application Web or Contributor When attempting to import an application, you see an error saying the specified file is not a valid application export file.
2021-11-05 #NAME seen when you open Dynamic or Custom Reports in Planning Analytics for Excel When attempting to open a formula report in Planning Analytics for Excel, you notice #NAME on all the formulas like SUBNM or DBRW. All other report types work fine (Exploration, Quick).
2021-11-05 Security hardening for Planning Analytics How to harden security on Planning Analytics ?
2021-10-26 Unable to install Planning Analytics for Excel add-in due to error While attempting to install the new single file Planning Analytics for Excel add-in, an error is thrown and the installation fails.
2021-10-26 From some client machines: either the Task Pane is not visible, or user gets The remote server returned an error: (404) Not Found From some client machines: either the Task Pane is not visible, or user gets this error:IBM Framework for Microsoft OfficeThe remote server returned an error: (404) Not FoundCognos.Office.Tm1.Connections.Tm1WebException: The remote server returned an error: (404) Not Found —&gt; System.Net.WebException: The remote server returned an error: (404) Not Found at System.Net.HttpWebRequest.GetResponse() at Cognos.Office.Tm1.Connections.Tm1Request.GetResponse()…
2021-10-25 IBM CloudPak for Data Platform Integration fails – Connection test failed! Please check all values and try again. When creating and testing IBM CloudPak for Data Platform Integration in Planning Analytics Workspace, the test fails with the following error: IBM CloudPak for Data Platform Integration fails – Connection test failed! Please check all values and try again.
2021-10-17 A blank white page is displayed while opening a node in TM1 Contributor (PMPSVC) A blank white page is displayed while opening a node in TM1 Contributor (PMPSVC)
2021-10-14 Uninitialized strings causes incorrect names to display in the IBM Planning Analytics for Excel ribbon Incorrect names are displayed for buttons in the IBM Planning Analytics for Excel ribbon.
2021-10-13 The requested path does not exist error is received while attempting to log in to TM1 Contributor The requested path does not exist error is received while attempting to log in to TM1 Contributor
2021-10-11 TM1 Perspectives times out every 15 minutes Troubleshooting Problem Symptom TM1 Perspectives times out every 15 minutes without warning and the user must log in and provide credentials. Cause -Default value for ClientPingCAMPassport in tm1.cfg is 900 (seconds).  Resolving The Problem -Modify the…
2021-10-11 Log in to CAM authenticated TM1 Server fails with message 'Error, see logs' Log in to CAM authenticated TM1 Server fails with message 'Error, see logs'
2021-10-07 How to use the Core Dump Packager for TM1 Server The TM1 Core Dump Packager has been designed to remove unnecessary data from the core dump files, allowing for the file size to be reduced in size. This is useful when IBM Support requests a core dump file to diagnose a crash or hang issue. The TM1 Core Dump Packager tool is provided with IBM Planning Analytics Local 2.0.9.1.
2021-09-27 Setting ENABLE_USER_IMPORT to "false" does not prevent new users to connect to Workspace through Planning Analytics for Excel Setting ENABLE_USER_IMPORT parameter to "false" in /config/paw.ps1 does not prevent new users to connect to Planning Analytics Workspace through Planning Analytics for Excel.
2021-09-27 Log in Failed : SystemServerClientNotFound error is received while attempting to log on to a CAM authenticated TM1 Server. Log in Failed: SystemServerClientNotFound error is received attempting to logon to a CAM authenticated TM1 Server with Architect and Perspective.
2021-09-27 Unable to start IBM Planning Analytics Spreadsheet Service on Windows Unable to start IBM Planning Analytics Spreadsheet Service on Windows.
2021-09-24 With some particular locales, the Viewer of Planning Analytics for Excel does not use correct format (decimal separator and thousand separator) With some particular locales, for example "English (Belgium)", Planning Analytics for Excel is able to display correct decimal and thousand characters [respectively comma and point for "English (Belgium)"] as long as this is in the Excel sheet.But when opening a view in the Viewer (by using right-click "Open Viewer"), the decimal and thousand separators are not correct anymore.
2021-09-21 Moving a member alias requires feeders to be reprocessed After moving an alias value from one member to another some cells are not fed. Unfed cells may cause consolidated cells to incorrectly display zero values and impact zero suppression.
2021-09-20 Planning Analytics for Excel (PAfE) shows #NAME on refresh – check that the add-in is enabled The data content and cell values in PAfE show #NAME on refresh.
2021-09-20 Planning Analytics Workspace shows rows as blank PAW doesn't show rows correctly on a view. When scrolling down only some rows are visible. Page down shows more rows than scrolling. However, when scrolling up again, the rows disappear.
2021-09-20 Secure Gateway client connection shows Disconnected in Planning Analytics Secure Gateway- Secure gateway error SELF_SIGNED_CERT_IN_CHAIN Unable to get a Secure Gateway connection successful in Planning Analytics on Cloud. Looking closely at the Planning Analytics Administration and it shows the Secure Gateway client connection status as "Disconnected".
2021-09-20 User name in the TM1 security on Planning Analytics Cloud appears as Planning Analytics/<mail address> On Planning Analytics Cloud, user name on TM1 Clients/Groups dialog appears as "Planning Analytics/&lt;mail address&gt;" instead of "Planning Analytics/&lt;First name&gt; &lt;Last name&gt;". How can I change user name?
2021-09-20 Unexpected uncommitted data appears in TM1 Application Web for specific user A user in TM1 Application Web sees unexpected data in blue text, as if changes have been made and are uncommitted. When in this state, the user is unable to add new data.
2021-09-20 Can "Last Modified" date in IBM Planning Analytics Administration be used for auditing user sign on? Can the "Last Modified" date that is displayed for Users in IBM Planning Analytics Administration (PAA) be used to audit user sign on?
2021-09-20 Planning Analytics Secure Gateway every 2nd connection attempt to the database fails Using the Secure Gateway Client to connect from your cloud Planning Analytics environment to an on-premise database, you will see every 2nd connection attempt to the database fails.
2021-09-20 What is the procedure to get a backup of a TM1 Server instance restored on the Cloud? What is the procedure to get a backup of a TM1 Server instance restored on the Cloud?
2021-09-20 Compatibility issues between Memory Optimized Tables and ODBC Driver 13 for SQL Server Executing a SELECT statement to query/retrieve data from a memory optimized table may result in an error due to compatibility issues with ODBC Driver 13 for SQL Server.
2021-09-20 TM1 Server Will Not Shutdown / Stop in Planning Analytics Administration on Cloud: How To End Process on the Server In a Planning Analytics on Cloud environment, one attempts to stop a TM1 Server in Planning Analytics Administration but it will not stop during the normal expected time.The database process is unresponsive.If a database enters an unresponsive or deadlocked state, one can end the database process.
2021-09-20 Troubleshooting Planning Analytics for Excel – issues like Grayed out connection, 400 Error Tips for troubleshooting the Planning Analytics for Excel (PAfE) add-in
2021-09-20 Planning Analytics Administration: Selecting Manage User Accounts Results in Error: 500: Internal server error In Planning Analytics Administration Users tab, when one selects Manage User Accounts, the following error will occur.
2021-09-20 Absolute path of shared folder in batch file I'm trying to copy files in shared folder using batch file, but below command in batch file doesn't work.COPY \\data\s\server\*.cub \\data\s\tm1\encrypted files
2021-09-20 Planning Analytics Spreadsheet transformation utility (beta) The IBM Planning Analytics Spreadsheet transformation utility is in beta, and we are working constantly to improve it. If you have spreadsheets that the utility is unable to process, we would like to see them so we can understand any issues, and fix them.
2021-09-20 Planning Analytics Workspace: Error Occurs When User Opens An Existing Cube View Or Creates A Cube New View: User Does Not Have Read Access (rte 34) In Planning Analytics Workspace, the following error occurs for a non-administrator user when opening an existing cube view or creating a cube new view.If the user has DataAdmin role, the cube view opens fine.
2021-09-20 How to improve transfer performance when using SFTP on PA on Cloud environment SSH2 protocol uses a low buffer size for transport and it can be improved with two options.
2021-09-20 Unable to export Dynamic Report as snapshot to Excel in tm1 web Unable to export specific dynamic report as a snapshot to excel, slice to excel or PDF. This was tried in tm1 web and Planning Analytics Workspace. The report was published using Planning Analytics for Excel.
2021-09-20 User Is Unable To RDP To Planning Analytics On Cloud Rich Tier: ERROR: Your Computer Can't Connect to the Remote Desktop Gateway Server One user errors when attempting to Remote Desktop (RDP) into the Planning Analytics Cloud Rich Tier.The issue is specific to user's Windows 10 machine.Other users on Windows 10 machines work fine.
2021-09-20 CLOUD — Steps to allow the FileShare account to have perpetual connection to the S:\ drive. Steps to allow the FileShare account to have perpetual connection to the S:\ drive.
2021-09-20 How to change the language of PAW (Planning Analytics Workspace) User would like to change the language of the user interface of PAW (Planning Analytics Workspace). How can they do this?
2021-09-20 When using the Print Report function in Perspectives, the action fails and displays a yellow exclamation mark When using the Perspectives Print Report function, the print action fails and a yellow exclamation mark is shown:
2021-09-20 No servers are listed under Connections PA for Excel When users open Excel and try to connect to Planning Analytics on Cloud, no servers are listed under Connection.
2021-09-20 PA on Cloud: Removing Cognos Analytics (CA) from Planning Analytics Cognos groups When Cognos Analytics entitlement is removed from a Planning Analytics subscription, customers and/or their business partners should ensure their user group management has been transferred from Cognos Analytics to Planning Analytics. Groups created in the Cognos namespace will be removed and no longer usable.
2021-09-20 Error 404: java.io.FileNotFoundException: SRVE0190E: File not found: /cgi-bin/cognos.cgi when accessing Cognos Analytics from Planning Analytics landing page When clicking the "Reports" tab on the Planning Analytics (PA) homepage to access Cognos Analytics (CA), the following error is thrown:Error 404: java.io.FileNotFoundException: SRVE0190E: File not found: /cgi-bin/cognos.cgi
2021-09-20 Missing / different choices available (inside 'Change visualisation') for PAW charts User has an existing chart in PAW. User clicks on the 'Change visualisation' button, which brings up a new screen where they can choose what type of chart/graph they want to display their date with.User notices that some chart selections are not there (not available to select/choose). Why are some charts missing?
2021-09-20 How to check the Cognos Command Center repository connection details After CCC client has been installed, it is not possible to check or change the connection details. How can this be checked?
2021-09-20 Customise personalisation of tm1web for branding purposes logo style- FAQ Collected information on how to customise tm1web / Planning Analytics Web
2021-09-20 Hostname format is not correct When creating a Data Source for IBM Secure Gateway, on Planning Analytics Administration, the above message is reported.
2021-09-20 Blank Cube Viewer and Dimension Editor popup windows A pre-existing user is unable to use Dimension 'Set Editor' and/or Cube Viewer in Planning Analytics for Microsoft Excel. Before now, this was working without any issues.
2021-09-20 "CSIAH0302E The configuration for the basic LDAP user authentication mechanism is missing or invalid" error trying to log on to Planning Analytics server that uses 'Admin' native user User logs on to the rich tier server. User launches TM1 Architect, and tries to log on to their instance. They do this using a 'Native' (non-IBMID) user (for example 'Admin').An error appears.
2021-09-20 PA on Cloud: Turbo Integrator syntax for Powershell script How to execute a powershell script from within a turbo integrator process, specifically, on Planning Analytics on Cloud environment.
2021-09-20 "Unable to create the content of this widget. The dimension or hierarchy may have been removed or is inaccessible" error – PAW Customer has assigned a user the role of 'Modeler' (in PA Workspace). In the }DimensionSecurity cube, customer has granted the Group (associated with the 'bad' user) both Write and Admin privileges on the Dimension.User right-clicks on the Dimension and selects 'Edit Dimension'. An error appears.
2021-09-20 Error Running TI Process When Importing CSV File. Error: Prolog Procedure Line (0): Unable To Open Data Source Error occurs when running a TI process that imports a csv file.Preview displays the correct data.
2021-09-20 FTPS – Failed to retrieve directory listing User is able to connect to the FTPS site, however the below error message is displayed, in the FTP client, after making the connection
2021-09-20 "Unable to paste cell(s) … Invalid numeric value 'xyz' specified" error when trying to paste cells across different levels in a hierarchy, caused by APAR PH06217 User selects several cells, across 2 (or more) levels in a hierarchy. User presses CTRL-C to copy them into their clipboard.User selects a different cell, and presses 'CTRL-V' to paste. An error appears.
2021-09-20 Cannot publish to Applications from Planning analytics for Excel. You will see the following error message:"Publish Failed. Please make sure you have the correct permissions to publish"
2021-09-20 How to check the version of Planning Analytics (PA) on IBM Cloud that you are using Customer is using Planning Analytics (PA) on IBM Cloud. They would like to check the version of Planning Analytics (PA) that they have installed. How can they do this?
2021-09-20 IBM Bluemix Secure Gateway fails to install properly – Installation folder exists but the service does not appear. Secure Gateway Client has been downloaded and installed. However the expected IBM Bluemix Secure Gateway service does not appear in Services.
2021-09-20 'Memory Usage' value inside Planning Analytics Administration (PAA) website seems too high (caused by misunderstanding what this value actually measures) User launches Planning Analytics Administration (PAA) website. User clicks on the 'Administration' button. User clicks on the tab 'Databases'.The dashboard shows all the PA instances running (in that environment). User looks at one of the PA instances, and sees that the 'Memory Usage' is higher than they expect.Why is the memory usage so high?
2021-09-20 Unable to log in to Planning Analytics Cloud – An error has occurred – FBTSML242E Authentication failed at the identity provider. Upon logging in to Planning Analytics Cloud, users receive the following error: An error has occurred FBTSML242E Authentication failed at the identity provider
2021-09-20 Non admin users cannot enter data in Planning analytics cube view – Cells appears to be locked. Non ADMIN users should have write access to the dimension elements they are trying to update in the view but Only ADMIN users can enter data at this point.
2021-09-20 IBM Planning Analytics on Cloud – tm1web content has lost its formatting and colours. Possible cause: Full S (share) Drive. From one day to the next, tm1web content in Cloud has lost formatting.
2021-09-20 Are you truly running Hubless in PA for Excel? After following these instructions to update your Planning Analytics for Excel Datasource so that you are not using Performance Management Hub, you open or refresh an existing exploration or quick report and your Datesource reverts to IBM Planning Analytics (PMhub).
2021-09-20 Cannot connect to Oracle ODBC data source "DataSourceName" S1000[Oracle][ODBC][Ora]ORA-12547: TNS:lost contact Ti process is failing due to unable to open connection to database when using an Oracle ODBC datasource.The user is also seeing an error when testing the DSN for the data source in question in the secure gateway portal within Planning Analytics Administration. Once entering the username and password, and click Test DSN, you will see the following error message:"An Error has occurred while testing DSN".In addition to the above, you will see the following errors in the tm1 server log file:ERROR &nb
2021-09-20 How to check the version of Planning Analytics Workspace (PAW) that you are using Customer would like to check the version of Planning Analytics Workspace (PAW) that they have installed. How can they do this?
2021-09-20 After updating/installing Planning Analytics for Excel , error: The input is not a valid Base-64 string as it contains a non-base 64 character error After updating/installing Planning Analytics for Excel users are updating/refreshing certain Books.They get the error: The input is not a valid Base-64 string as it contains a non-base 64 character
2021-09-20 Intermittent "Unable to fetch data" errors when opening views (inside Books) in PAW, caused by APAR PH07697 User launches PAW, opens a book and tries to view reports. An error appears.The problem may be intermittent.
2021-09-20 "Idle timer expired" message when using rich tier of Planning Analytics on Cloud, if user does not press keyboard or mouse for over 30 minutes User connects to the Remote Desktop Gateway (by using their RDP file). This launches Planning Analytics rich tier (on IBM cloud).User performs work on their PA rich tier, for example: run the hosted desktop applications and/or manage files in the shared folder.After a while, the user takes a break (for example, goes to lunch). User returns to their PC. A message is on the screen.
2021-09-20 How to decode a SAML response when it is encoded When federated users have issues logging in, we require a SAML trace to determine if the assertion has the exact required attributes: firstName, lastName, country and emailAddress. Sometimes when a SAML trace is taken, the response is encoded. This must be decoded before the investigation can proceed.
2021-09-20 PAW – Lifecycle Management – Backup, Restore and Migrate Assets stopped working, solved by clearing cache After a PAW on Cloud short cycle version update, Migrate Assets stopped working.
2021-09-20 Quick method for changing hierarchies in a Planning Analytics Workspace view When working with a hierarchy view in Planning Analytics Workspace, the hierarchy can be switched quickly without using the navigation pane, all within the view itself.
2021-09-20 Folder Permissions in Planning Analytics Workspace (PAW) This Technote provides an overview of how Planning Analytics Workspace (PAW), and the folder permissions work.
2021-09-20 How to configure system threshold settings for Disk Usage in Planning Analytics Administration In order to monitor Disk Storage, a Planning Analytics Administrator should define the system thresholds for disk usage.
2021-09-20 Planning Analytics on Cloud – Connection to IBM iSeries with Secure Gateway When setting up a DB2 i Series ODBC connection in Planning Analytics on Cloud, additional configuration is required prior to completing your connection and should be requested through a support case. If you attempt to create a data source by selecting 'IBM DB2 ODBC DRIVER – IBMDBCL1' or 'iSeries Access ODBC Driver' ODBC drivers prior to requesting this configuration, you will receive a message to say "DSN could not be created. Please contact IBM support".
2021-09-20 One user gets "FBTSTS313E The required SAML attribute [country] is missing or not valid" when trying to logon to PA (via federation) Customer has federated their logons. In other words, users logon to Planning Analytics on Cloud (PAoC) via SAML authentication.User launches PAoC and tries to logon. User receives error.Problem only affects one user.
2021-09-20 Cannot hide PAW folder from users – user can see folders despite not having any rights (for example 'View') Customer wants to create a shared folder where: User #1 can see the folder (and its contents) User #2 cannot see the folder (and therefore cannot open it, or see its contents).However, after User#1 creates the folder, User#2 can see it (despite not being given any permissions). Why was User#2 able to see/view a folder, when they do not have any permissions on that folder?
2021-09-20 One user can see TI chores in 'Architect' but not in 'PAW' (despite having READ access) – error 'The chore may have been removed or is inaccessible' Customer would like a user to be able to: View/run chores Not be able to create/edit chores.User can successfully see the chores inside TM1 ArchitectHowever, if he tries the same task inside PAW content tree (by browsing/expanding the PA instance/database) the user can only see 'Applications' and 'Cubes' Specifically, the user cannot see 'Dimensions' or 'Processes' or 'Chores'If the user tries to use a workbook which uses that chore, he gets an error ("…The chore may have been removed or is inaccessible")
2021-09-20 Planning Analytics on Cloud federated logon – An error has occurred FBTSML225E Token exchange failed A PA Cloud customer is onboarding new users. On accepting their email invitation, instead of being able to log in they get an error.The issue may be affecting some users and not others.
2021-09-20 "System.Exception: SpreadTotalZero (191)" error when typing value into consolidated cell, caused by setting ProportionSpreadToZeroCells to be False Users types in a value to a consolidated cell (C: element), which was 0 (zero) originally.User expects that (instead of the default proportional spread) the engine automatically should use the 'Equal Spread to Leaves' option. Therefore users could simply type in a value to a C: element, and the even spread would be done automatically This is the behaviour of older versions of TM1/PA However, this is not what happens in this Technote's scenario. Instead, if a user tries to type in a value to a C: elemen
2021-09-20 How to generate a HAR file to troubleshoot issues with Planning Analytics (PA / PAW) Customer is using an IBM Cognos Planning Analytics. They are encountering an issue when using a component (for example PAW) which runs inside a web browser. How can they generate a HAR file to troubleshoot web-browser-based issues with Planning Analytics?
2021-09-20 "Insufficient permissions to view subscriptions" status for 'Subscription', when click on user's User profile in PAA Administrative user (user#1) launches Planning Analytics website, and clicks 'Administration' (to launch PAA).Administrative user clicks 'Users' tab, and clicks on a different user (user#2). In the 'Subscription' section, it says: Insufficient permissions to view subscriptions
2021-09-20 Data not automatically appearing (after performing actions that change the structure of the view) caused by not ticking/enabling "Grid refresh – After each context change" Inside PAW, user makes a change to the view. The data-related change is not immediately (automatically) visible. User has to manually press 'Refresh' to see the changed data.Problem may only affect some users.Example:User opens workbook. User clicks on a view. User makes a selection inside the 'Set Editor'.- However, the data is not refreshed automatically in the view.
2021-09-20 Performance Modeler 'not responding' when adding an Approval Hierarchy to an Application Performance Modeler hangs when adding an Approval Hierarchy to an Application and must be force-closed.
2021-09-20 Unable to download log files in Planning Analytics Administration (PAA) When a user clicks on the download log files icon to retrieve logs from a TM1 database/server, the following error is thrown: Something went wrong! There is an internal error with this database. Please try again in a few minutes.
2021-09-20 Required information to request ODBC set up of IBM DB2 Warehouse (DashDB) on Cloud ODBC Driver on Planning Analytics on Cloud Connecting IBM DB2 Warehouse (DashDB) on Cloud does not use secure gateway as on premise database require. Planning Analytics on Cloud can directly connect to IBM DB2 Warehouse (DashDB) on Cloud.
2021-09-20 Subscription Administrators given TM1 admin rights All PAoC (Planning Analytics on Cloud) users with the role of Subscription Administrators automatically become TM1 administrators. If this is manually updated/removed in TM1 security, admin rights will automatically revert.
2021-09-20 How to move data from TM1 on Cloud environment to a Planning Analytics on Cloud environment TM1 on Cloud and Planning Analytics on Cloud environments are in different VLANs and as a result, private IPs provided in the Welcome Kit to map drives do not render.
2021-09-20 How to delete user(s) on IBM Planning Analytics on Cloud Customer wishes to delete a user from their Planning Analytics on Cloud.
2021-09-20 After a Planning Analytics version update, Planning Analytics for Excel (PAfE) throws a script error on login After a PA on Cloud upgrade to newer version, a script error is thrown when user logs into Planning Analytics for Excel. Sometimes it prevents login, sometimes repeatedly clicking past the error allow a login.
2021-09-20 Planning Analytics on Cloud: Who am I when accessing client interface on the Rich Tier When a user logs into the Rich Tier, using a modeler account, then log into user interface (Architect or Perspectives); the wrong login is used.
2021-09-20 How to publish customer images and PDF files into Planning Analytics Workspace (PAW) using Dropbox While PAW accepts links to jpg and PDF files (for images and web pages respectively), they fail to render if published as a public link from Dropbox.
2021-09-20 Task pane doesn't open in Planning Analytics for Excel User is trying to work in Planning Analytics for Excel however the task pane doesn't open after signing in successfully to the PA instance.
2021-09-20 Planning Analytics for Microsoft Excel Blank Cubeviewer Planning Analytics for Microsoft Excel cube viewer or subset editor displays a blank page. Furthermore, Planning Analytics Workspace will also display a blank page when using Internet Explorer.
2021-09-20 How to gather a SAML trace for federation issues with Planning Analytics on Cloud When a customer reports an issue with Federation, our Internal Identity Team (ibmidfd@us.ibm.com) requires a SAML trace to troubleshoot the issue
2021-09-20 Cognos Command Center – Create a new Computing Resource Troubleshooting Error with code 3 and Error with code 12 When adding the Endpoint URI, user name and password to test a new Computing Resource, getting an error.
2021-09-20 Unable to Remote Desktop to Planning Analytics Cloud Rich Tier from Windows 7 Computer Users are unable to connect to the IBM Planning Analytics Cloud Rich Tier
2021-09-16 Clarifications about old IPaddress parameter and new IPaddressV4 parameter in Planning Analytics IPaddress parameter in tm1s.cfg is deprecated since moving from TM1 to Planning Analytics.It is replaced by IPaddressV4 (and IPaddressV6)However, it is observed that IPaddress could still have some effect on Planning Analytics servers.Why is it so ? Is IPaddress still supported although it is not documented anymore ? Can we still use it ?
2021-09-16 MSG_ PRECEDING THE UI LABELS IN PLANNING ANALYTICS FOR EXCEL MSG_ PRECEDING THE UI LABELS IN PLANNING ANALYTICS FOR EXCEL
2021-09-08 Menu in Planning Analytics for Excel ribbon does not show properly After installation Planning Analytics for Excel, menu in Planning Analytics ribbon headed by MSG as follows.
2021-09-02 Low disk space alert is displayed by the operating system where IBM Planning Analytics is installed Low disk space alert is displayed by the operating system where IBM Planning Analytics is installed.
2021-08-26 Federated users from the United Kingdom (UK) are unable to sign into IBM Planning Analytics with Watson Federated users from the UK are unable to authenticate to IBM Planning Analytics with Watson
2021-08-20 Write TM1 Server Debug Logging to an Alternate File It is possible to write TM1 Server logging to a file other than tm1server.log. Debug logging options can be configured by modifying the tm1s-log.properties file. The tm1s-log.properties file should exist in the same directory as the TM1 Servers tm1s.cfg file. If the tm1s-log.properties file is not present, default logging options are applied. A restart of the TM1 Server is required after modifying the tm1s-log.properties file. Debug options in the tm1s-log.properties file
2021-08-19 Batch file run via ExecuteCommand stopped executing A batch file that is called from a Turbo Integrator (TI) process that uses ExecuteCommand stopped working.
2021-07-26 TM1.SQLAPI 01000[Microsoft][ODBC Driver Manager] Cursor library not used. Load failed The following error appears in tm1server.log:TM1.SQLAPI 01000[Microsoft][ODBC Driver Manager] Cursor library not used. Load failed
2021-07-15 TM1PRIMARYDBNAME() does not return a value in IBM Planning Analytics for Excel The function TM1PRIMARYDBNAME() returns #‌NAME when used in a workbook
2021-07-08 Unable to create report by right-clicking a view in Task Pane In IBM Planning Analytics for Microsoft Excel (PAfE), user is unable to create any type of report off any view because the menu is blank. They are able to open a Cube Viewer only.
2021-06-29 Execute TI process from Action button in websheet on Planning Analytics Workspace,"an error occur" occur. If TI process takes more than 2 minutes to run, execute this process from Action button on a websheet in Planning Analytics Workspace generate "An error occur" while process itself work properly. Execute this Action button from Planning Analytics Workspace book, error does not occur.
2021-06-28 IBM Secure Gateway unable to connect due to error "unhandled critical extension" IBM Secure Gateway failing to connect with "unhandled critical extension" error
2021-06-28 SUBNM formulas show up blank within Planning Analytics for Excel Dynamic and Custom Reports. SUBNM formulas show up as blank within Planning Analytics for Excel Dynamic and Custom Reports resulting in data not getting retrieved.
2021-06-28 TM1MDVUtil._getFeatureValue error 'TM1MDVUtil._getFeatureValue error — required feature "cubeName" not found' error occurs while accessing objects in Planning Analytics for Excel
2021-06-24 Use of the word 'Name' for objects in Planning Analytics Workspace (such as dimension attribute) caused unexpected results Using the word 'Name' for objects in Planning Analytics Workspace can cause unexpected results.
2021-06-10 'TM1APIException':com.ibm.cognos.tm1.TM1Exception: Could not load C API due to /usr/lib64/libstdc++.so.6:version'GLIBCXX_3.4.21' not found When you open the pmpsvc application portal (http://&lt;hostname&gt;:9510/pmpsvc/), the following error is displayed:
2021-06-10 Custom Dashboard Palette Does Not Migrate With Planning Analytics Workspace Lifecycle Manager Planning Analytics Workspace Lifecycle Manager does not migrate custom dashboard palettes between environments.
2021-05-12 Unable to launch IBM Cognos Perspectives – Run-time Error '48' User is unable to launch Perspectives from a shortcut on their desktop
2021-04-27 How to Troubleshoot Planning Analytics for Excel or Planning Analytics Workspace Performance You are encountering performance concerns with Planning Analytics for Excel or Planning Analytics Workspace, however do not know where to start. The objective of this document is to help you better understand the components involved with Planning Analytics for Excel / Workspace and the areas of the product that require focus.
2021-04-26 BUTTON TEXT ALIGNS TO BOTTOM WHEN UPGRADING TO NEW EXPERIENCE When converting a book from Classic Experience, the text of all buttons vertically align to the bottom instead of centering.
2021-04-22 Unable to delete file using IBM Cognos Command Center (CCC) process Unable to delete a file from an IBM Planning Analytics on Cloud system using a CCC process
2021-04-20 Change in Kerberos Windows Authentication Registry Settings for Chrome and Edge SSO Mode 3 Windows Authentication with SSO is not working in new versions of Chrome and Edge Chromium. When users click "Login", they see a "Login failed" error message
2021-04-15 Planning Analytics Spreadsheet Service (TM1Web) session timeout error after connecting to PMPSVC The client logins to TM1web then logins to PMPSVC using same browser. If the user go back to TM1web, the user will get "session timeout".This only occurs If TM1web and PMPSVC are installed on same machine.
2021-04-07 Incorrect User Logged into Planning Analytics Web Applications with SSO Enabled When logging in to one of the Planning Analytics Web Applications (TM1Web, Workspace), with SSO enabled, the wrong user is logged in.
2021-04-06 Title information missing from TM1web worksheet when columns are grouped A simple Quick report displays correctly in IBM Planning Analytics for Excel but when published to TM1web, the title information is missing.
2021-03-29 Can Multi Factor Authentication (MFA) be enabled for IBM Planning Analytics on Cloud? Can Multi Factor Authentication (MFA) be enabled for IBM Planning Analytics on Cloud?
2021-03-24 IBM Secure Gateway unable to connect due to error UNABLE_TO_VERIFY_LEAF_SIGNATURE IBM Secure Gateway has been installed and configured. Gateway ID and Security Token are valid but the SG client will not start up successfully.
2021-03-23 IBM Secure Gateway unable to connect IBM Secure Gateway configuration file, securegw_service.config, has 7 Gateway IDs and 7 security tokens listed. All of these are valid but the Secure Gateway for 5 of the Gateway IDs will not start up successfully.
2021-03-22 Unable to access Planning Analytics Workspace Administration Tool "504 Gateway Timeout" User(s) receive "504 Gateway Timeout" error when accessing the Planning Analytics Workspace Administration Tool (admintool).
2021-03-19 HTTP 404 error "Not Found" during Validation in Admin Tool whereas TM1 Application Server seems to work properly In Planning Analytics Workspace Admin Tool, the Validation displays an error when testing TM1 Application Server Gateway URI :Error: Server responded with status code 404 : Not found
2021-03-09 Script error when signing into IBM Planning Analytics for Excel When signing into IBM Planning Analytics for Excel, the user is presented with a script error. Clicking OK, allows the user to continue signing on successfully.
2021-03-03 Error "Cannot access a disposed object" when trying to connect to a server via IBM Planning Analytics for Excel A previously working connection in IBM Planning Analytics for Excel is no longer working after a Planning Analytics (PA) server upgrade
2021-03-02 Planning Analytics Workspace Admin Tool Fails to Start – Error response from daemon: Container XXXX is not running. Attempting to start the Planning Analytics Workspace Administration Tool on Linux fails with the following error:Error response from daemon: Container XXXX is not running.
2021-03-02 Intermittent Connection Errors in PA Workspace or PA for Excel when MaximumPorts for user is set too low Users in PA for Excel or PA Workspace may experience intermittent connection related errors if their connections to the TM1 Server have been limited via the MaximumPorts setting.
2021-02-23 Unable to successfully SFTP to IBM Planning Analytics Cloud When trying to establish a connection to the SFTP server on IBM Planning Analytics Cloud, a PuTTY or WinSCP session fails. The same connection from Filezilla works without issue.
2021-02-01 Planning Analytics Administration Agent displays "Invalid Date" or nothing in "Start Time" field of a TM1 Server – Cannot create PyString with non-byte value In Planning Analytics WorkspaceIn Planning Analytics AdministrationIn Databases tabFor all TM1 Servers, the "Start Time" field is either empty or contains "Invalid Date"This kind of error message may be found in messages.log file: File "kateagent/scripts\status.py", line 2, in &lt;module&gt; import logging File "C:\Program Files\ibm\cognos\tm1_64\paa_agent\wlp\usr\servers\kate-agent\apps\expanded\PA_KATE_AGENT.war\WEB-INF\lib\jython-standalone-2.7.1.jar\Lib\logging\__init__.py", line 26, in &lt;module&gt; j
2021-01-25 TI Process has rolled back due to lock contention even using synchronized() Customer execute same process by several user at a time. Then process has rolled back due to lock contention even they using synchronized() to serialize processes.
2021-01-25 Even using same version of Planning Analytics for Excel, some user's cube viewer title and context dimension name are different. Even using same version of Planning Analytics for Excel, some user observed different fonts are used in cube viewer title and context dimension name.
2021-01-12 Subset runtime error when selecting a single member In IBM Planning Analytics for Excel, a runtime error is thrown when a member is selected via the subset editor.
2020-11-20 Type initialize exception is thrown and IBM Planning Analytics is missing from Excel ribbon When I start Excel, following error occurs and IBM Planning Analytics is missing from Excel ribbon.The type initializer for 'Cognos.Office.Framework.Service' threw an exception.
2020-11-18 Refresh does not work on Planning Analytics for Microsoft Excel Quick Report On Planning Analytics for Microsoft Excel quick report, refresh doesn't work. If I clear values in cells and click Refresh icon, value doesn't get back to cells.
2020-11-18 Cannnot resize Threads table in Planning Analytics Administration After I upgraded to Planning Analytics Workspace new experience, I cannot resize databaser threads table column width in Planning Analytics Administration. The column is too narrow to show the user name to the end.
2020-11-16 How to set up Weight on Planning Analytics Workspace? I can set up Weight for elements on Architect. How can I do it on Planning Analytics Workspace?
2020-11-11 Unusual Process Names in tm1server.log Unusual process names are appearing in the tm1server.log. They appear to be a type of key rather than a name, for example: Process "{36b2588f-cdee-4984-8e4f-985431d9ef02}". Where do these come from?
2020-11-10 Are TM1 Perspectives Dimension and Rule Worksheets Supported in Planning Analytics ? Are TM1 Perspectives Dimension and Rule Worksheets Supported in Planning Analytics ?
2020-11-04 Sample spreadsheets for the IBM Planning Analytics Spreadsheet transformation utility (Beta) Download sample spreadsheets to see examples of spreadsheets that can be transformed by the IBM Planning Analytics Spreadsheet transformation utility (Beta).
2020-10-28 Incorrect values are shown in Planning Analytics Workspace Administrtaion Databases The values for the TM1 Databases in Planning Analytics Administration Databases are incorrect. They do not show the correct values of resources the TM1 databases are using at this time.
2020-10-27 Planning Analytics Workspace Administration page shows error message: An unexpected error has occurred Try again later With Planning Analytics Workspace 2.0.57When try to access the Planning Analytics Workspace Administration Database page the following error message will happen in the browser window:An unexpected error has occurred. Try again laterThe background page of Planning Analytics Workspace is still showing and you are able to still work with Planning Analytics Workspace exempt the access to the Administration section.
2020-10-07 User unable to perform edit in contributor nodes After upgrading from 10.2.2 to PA 2.0.x, User unable to edit his node. The user has to release and retake the ownership to perform edits.
2020-09-29 Using Mix mode authentication, Workspace retain previous windows authentication account when using Internet Explore Using Mix mode authentication, logon as TM1 Native account after logon as Windows Authentication, Planning Analytics Workspace still retain Windows account.
2020-09-18 After installing or upgrading Planning Analytics to 2.0.9.2 or greater opening all applications in Planning Analytics Workspace load empty views with no error message After installing or upgrading Planning Analytics to 2.0.9.2 or greater, opening all applications in Planning Analytics Workspace load empty views with no error message
2020-09-10 Error when trying to set Threshold Alerts of Database Settings in Planning Analytics Workspace Administration "Could not load data. Please try again later. For assistance contact IBM support" Error when trying to set Threshold Alerts of Databbase Settings in Planning Analytics Workspace Administration "Could not load data. Please try again later. For assistance contact IBM support"
2020-08-11 Planning Analytics Workspace do not behave on iPad (Safari) on touch gesture like expected When using Planning Analytics Workspace on an iPad the touch gesture like a single quick click or a long hold are not behave like they should or expected to work like in other web applications.
2020-07-31 About the )async directory in TM1 Planning Analytics server What is the }async directory in TM1 Planning Analytics server ?
2020-07-31 How to create a dimension Attributes Cube in Planning Analytics TM1 When creating a Map Visualization in Planning Analytics Workspace one of the first steps is to locate and edit the }DimensionAttributes cube But in new TM1 models the }DimensionAttributes cube doesn't exist and there are no instructions on how it should be created
2020-07-10 Application Log Files Not Rolling Over as Expected (example, TM1Server.log) TM1Server.log file is not rolling over when the file reaches the maximum file size as defined in the tm1s-log.properties file.NOTE: This can impact more than just the TM1Server.log file, and could apply to any application log file.
2020-07-09 TM1 Server Log – TM1.Server Error retrieving product information from swidtag file For Planning Analytics Local server installs that are flagged as non-production in the installation wizard, the server log file reports the following error each time the server is started:5052 [] INFO 2017-11-13 14:46:03.455 TM1.Server Error retrieving product information from swidtag file: The swidtag folder "&lt;C:\Program Files\ibm\cognos\tm1_64\bin64\..\swidtag\&gt;" does not contain a software id tag file for product "IBM TM1".
2020-07-07 IBM Planning Analytics for Excel installation failing; files missing from installation location Installation of IBM Planning Analytics for Excel fails on step 6. Many files/folders are missing from the installation location.
2020-07-07 How can I enter single and double quotation in string as default value of button parameter? Customer sometime want to use single and double quotation as part of text data in button parameter as default value.
2020-07-03 Planning Analytics Administration Agent didn't work – Error: Exception java.lang.NullPointerException After an upgrade of the Planning Analytics Administration Agent (PA Agent) it's not possible to see the TM1 Databases in Planning Analytics Workspace Administration anymore.The "messages.txt" log file of the Planning Analytics Administration Agent in "../tm1_64/paa_agent/wlp/usr/servers/kate-agent/logs" include a bulk of error messages:…0000003c com.ibm.pa.kate.agent.service.PAKateAgentService E Exception java.lang.NullPointerException at com.fasterxml.jackson.databind.deser.SettableBeanProperty.getName(S
2020-06-26 Is Office 365 supported for IBM Planning Analytics for Microsoft Excel or TM1 Perspectives? Does IBM Planning Analytics for Microsoft Excel or TM1 Perspectives support Microsoft Office 365?
2020-06-22 How to Configure TM1Web Application Server to Allow SSL LDAP when using KERBEROS Authentication In a recent update from Microsoft, customers have been enabling/forcing SSL for LDAP connections to Active Directory. The enabling/forcing of SSL is described in the following Microsoft document: https://support.microsoft.com/en-us/help/4520412/2020-ldap-channel-binding-and-ldap-signing-requirements-for-windowsThis document outlines the steps required to allow your TM1Web Application Server to communicate with the Active Directory LDAP using SSL.
2020-06-16 Change the cube or datasource used by an exploration User would like to use an Exploration report (created on Planning Analytics for MSExcel) from one PA instance into another. The instance doesn't have the same name. However the cube on the new instance is replica of the source cube/instance.User is referencing this IBM documentation to try and achieve this: Change the cube or data source used by an exploration.
2020-06-11 Unable to start TM1 Admin Server – Service starts and immediately stops TM1 Admin server fails to start. The service starts and immediately stops again.
2020-06-11 Dynamic report cannot be generated due to the set expression exceeding 32767 characters When customer tries to use PAfE to create a dynamic report he gets the following error.
2020-06-04 Websheet subset editor window do NOT close When you open a websheet subset editor window (by clicking the icon in the corner of the drop down of a SUBNM in a websheet in IBM Planning Analytics Workspace/tm1web), you can change the selected member from the dimension, and click "OK", but the set editor window does not close; However the SUBNM value changes to the desired value. The only way to close the set editor window is by clicking the "X" in the top right corner of the window. This issue occurs in all browsers (so not a browser sp
2020-05-26 TM1 Perspective presenting windows logon screen while attempting to login to a SSO enabled CAM authenticated server using Excel VBA Users getting prompted to enter username and password when attempting to login to a SSO enabled CAM authenticated server using Excel VBA.This results in login failure over Planning Analytics server as manually entered credentials are not accepted considering Cognos Analytics is configured to use SSO.
2020-05-26 Planning Analytics scheduled chores erroneously execute twice. Planning Analytics scheduled chores execute twice instead of executing once as per their defined schedule.
2020-05-08 View Set editor scroll bar goes in reverse by itself and without scrolling View set editor scroll bar keeps scrolling in reverse order for some time even if you stop scrolling using the mouse. This occurs in any scroll bar view in Planning Analytics workspace. This usually happens when using Chrome browser in specific.
2020-05-08 Can not login to TM1 server from Perspectives, (N33) Connection Failed occur. Since accessing TM1 server through VPN, some user encounter (N33) Connection Failed error when connect.This is intermittent issue.
2020-04-30 IBM Planning Analytics – PA Workspace and PA for Microsoft Excel Fix List A comprehensive list of defect corrections for Planning Analytics Workspace and Planning Analytics for MS Excel components in Planning Analytics 2.0. PA Workspace and PA for Microsoft Excel are released independently from the rest of IBM Planning Analytics to provide defect corrections and enhancements more quickly.
2020-04-16 TM1 Server Does Not Zero Suppression Calculated Rows and Columns The zero suppression feature of TM1 Server does not apply to MDX calculated rows and columns. This behaviour impacts add-hoc calculation created using the cubeviewer widget in Planning Analytics Workspace, Planning Analytics for Excel reports, and Cognos Analytics reports.
2020-04-10 IBM Bluemix Secure Gateway Service not created While installing the IBM Secure Gateway Client, the service is not created.
2020-04-07 Unable to expand/collapse on TM1RPTRow in a Dynamic Report (shows the mail to icon) In an update of Microsoft Office 365, Microsoft upgraded Excel's formula language to support dynamic arrays. Part of this upgrade adds the `@` symbol in front of certain formula types. In general, this upgrade should not cause any problems in IBM Planning Analytics for Microsoft Excel, however if the Internet and network paths with hyperlinks setting is also enabled, this upgrade will impact certain TM1 functions in Planning Analytics for Microsoft Excel. For more information about Microsoft's upgrade to Ex
2020-04-07 Error 500:java.lang.nullpointerexception in the PMPSVC application portal When you open the pmpsvc application portal – http://&lt;hostname&gt;:9510/pmpsvc/You receive the following error message – Error 500:java.lang.nullpointerexception
2020-04-06 Planning Analytics Workspace Administration – Databases error message: Something went wrong! Please try again in a few minutes When opening the Planning Analytics Workspace Administration page to check the database you will receive the following error message after some time:"Something went wrong! Please try again in a few minutes"A retry after some minutes didn't change the behaviour. The same error message will occur or a cube with a spinning wheel is shown.The connection and display of the databases in Planning Analytics Workspace worked fine the last time you checked this page.
2020-04-02 Dynamic report works in IBM Planning Analytics for Excel but returns no data when published to IBM TM1Web A dynamic report, that returns data in Planning Analytics for Excel, does not return any data in TM1Web
2020-02-05 Cannot select IBM Framework for office COM Add-in and IBM Planning Analytics tab is not showing up in Excel IBM Planning Analytics for Excel ribbon is not appearing in Excel. You navigate to Excel options to manage the available COM Add-ins then notice that you are not able to check off the "IBM Framework for Office" COM Add-in to make it available.
2020-02-03 Truncated element names in an Exploration view causing "member not found (rte 433)" error Planning Analytics for Excel user is trying to edit an exploration dimension to choose an element; However the action is triggering an error message that indicates the element does NOT exist. The error message is showing the element with the first and last characters truncated.For instance, if the user selects an element called "Testing" the error will indicate "estin": member not found (rte 433).
2020-01-29 Custom Report is causing CPU high spikes when editing specific view data Editing few cells in custom report (leaf level) is causing high CPU spikes ( close to 100% usage) then Excel will not be usable and system will be slow. No major threads will show up in Planning Analytics Server side. The Excel process is what seems to be taking most of the CPU percentage on the user machine.
2020-01-23 PA for MS Excel formulas have a '@' added to the front New Installation of Planning Analytics for Microsoft Excel and/or Microsoft OfficeWorkbook/sheet that contains PA for MSExcel formulas have a 'at sign' (@) added to their forefront.
2020-01-14 IBM Planning Analytics 2.0.9 Long Term Support Release IBM Planning Analytics 2.0.9 is designated as a long-term support release.
2020-01-03 TM1 Contributor (PMPSVC) – This application has been updated by the administrator. Your view will now be refreshed. When attempting to open a TM1 Contributor application, users receive the following error (on loop) and are unable to open the application successfully:This application has been updated by the administrator. Your view will now be refreshed.
2019-12-30 Planning Analytics on Cloud: Java extensions support in TurboIntegrator Does IBM Planning Analytics on Cloud support Java™ as a scripting language to create and run TurboIntegrator processes?
2019-12-18 Cube View Does Not Open in PA Workspace – Unable to create the content of this widget. The cube may have been removed or is inaccessible. Some or all non-admin users are unable to open Cube Views in Planning Analytics Workspace. They are presented with the following error: Unable to create the content of this widget. The cube may have been removed or is inaccessible. Please contact your administrator to ensure you have sufficient rights to view this widget.
2019-12-18 TM1 Perspectives / Excel Crashing – Application Error 1000 – Faulting module name: tm1api.dll When attempting to refresh/recalculate a view, Excel/Perspectives is crashing. The view in question is one that never had experienced any problems before, and no changes to the model or environment were made.
2019-12-17 Planning Analytics and virus scan software What TM1/Planning Analytics for Excel/Planning Analytics Workspace files/directories should virus scan software be set to avoid scanning?
2019-12-11 How to Zoom In and Out in the Planning Analytics for Excel Cube Viewer Some users may want a zoomed in (or out) view of the Cube Viewer in PA for Excel. This document explains how.
2019-12-10 Troubleshooting Macro/VBA Based Perspectives Report – TM1 Tab Does Not Display In Ribbon Users attempting to work with a Macro/VBA based book do not always see the TM1 Ribbon.
2019-12-09 HOLD function in Planning Analytics Workspace Are HOLDs in Planning Analytics Workspace persistent or do they expire?
2019-12-07 Rename and/or redirect core dumps on Linux On Linux operating systems, core files are, by default, named "core" and are located in the working directory of the application which faulted. In the case of TM1, this is usually the tm1/bin64 directory. To add information to the filename such as timestamps, or to redirect core files to a specific directory, the core_pattern kernel setting can be modified using the steps below.
2019-12-06 Error Expanding Subsets in Planning Analytics for Excel – (500) Internal Server Error Users encounter the following error expanding subsets in Planning Analytics:The remote server returned an error: (500) Internal Server Error.Cognos.Office.Tm1.Connections.Tm1WebException: The remote server returned an error: (500) Internal Server Error.
2019-12-04 How to enable MDX Debug logging on the TM1 Server This document is applicable to anyone who wants to better understand performance for specific MDX queries on the TM1 Server.
2019-12-04 Unable to test Planning Analytics Datasource in Cognos Analytics – XTR-ERR-0005 A request to the TM1 resulted in error: "[403] Forbidden". When attempting to create and test a Planning Analytics datasource in Cognos Analytics, the following error is encountered:XTR-ERR-0005 A request to the TM1 resulted in error: "[403] Forbidden".
2019-12-04 Planning Analytics Workspace error message: Unable to login using the provided CAM ID credential When try to login to Planning Analytics Workspace with the CAM user ID the following message occur in the browser: Unable to login using the provided CAM ID credential
2019-12-03 How to Monitor Planning Analytics Workspace Availability As an Administrator, you want to monitor the availability of your Planning Analytics Workspace application.
2019-11-25 File name under <data folder>/}Externals is not same as report name when report is published on Planning Analytics for Microsoft Excel When report is created on Planning Analytics for Microsoft Excel and pulished, name of the file created under <data folder>/}Externals is not same as name of report. How can I make it same?
2019-11-18 How to determine what version of Planning Analytics for Microsoft Excel is installed This explains how to see what version of Planning Analytics for Microsoft Excel you have installed.
2019-11-12 Missing metrics visualizations in Planning Analytics Workspace for none admin user Using the Planning Analytics sample server Go_Scorecards, the admin user has access in PAWorkspace to the following metrics visualizations:Impacts, History, Go Process, Go Region, Go Strategy Map.But none admin users only able to see/select the metric visualizations:Impacts and History.
2019-10-25 How to sort element by Alias in Planning Analytics Wokspace and Planning Analytics for Excel using MDX TM1Web sorted element based on the alias in use in the active form, while Planning Analytics for Excel sorts based on the principal element name using TM1SORT command in the MDX.
2019-10-23 Cannot start service admintool: Insufficient system resources exist to complete the requested service It's not possible to start Planning Analytics Workspace or the PAW Admin Tool.A reboot of the host Windows server do not solve the issue.The start of PAW results into an error message with the following content: "… Insufficient system resources exist to complete the requested service. …"
2019-10-21 Detailed procedure for upgrading your PAW installation Detailed procedure for upgrading your PAW installation
2019-10-21 Unable to access to IBM Planning Analytics Workspace Customer was unable to access to Planning Analytics Workspace. To investigate the issue they also executed <Planning Analytics Workspace installation dir>scripts\Start.ps1 command to start IBM Planning Analytics Workspace Administration tool page. However, the command interrupted with following exception message in Power shell. "Exception occurred: Execution failed with exit code 1 Stopping IBM Planning Analytics Workspace Administration Tool… Exited." There are also following messages in s
2019-10-21 After updated Planning Analytics Workspace, PA for Excel and Planning Analytics Local, PA for Excel connection is disconnected within the duration set for MaxInactivityTimeout in PMHUB admin PA for Excel disconnected even within the time set at http://localhost:9510/pmhub/pm/admin , Configurations &gt; PMHub Session with MaxInactivityTimeout while it is idle.The connection remained until the time set for MaxInactivityTimeout before upgrade PAW, PA for Excel and PAL.
2019-10-18 In Planning Analytics for Excel, where are stored the connection informations ? In Planning Analytics for Excel, a new connection to Planning Analytics Workspace can be created using "Connect" button in the ribbon, then "New connection" dialog. But where are stored these connections information ?
2019-10-08 Cannot Start service <service-name>: Container is marked for removal and cannot be started When trying to start PAW containers using ./scripts/paw.ps1 the following error occurs for one or several containers :Cannot Start service &lt;service-name&gt;: Container is marked for removal and cannot be startedIn addition to this error, when diplaying the list of containers using "./scripts/paw.ps1 ps" command, it shows some temporary containers, looking like this :bf16f3c7faa2_couchdb32784fd3b06d_share-app78fd50cfc238_pa-gateway
2019-10-04 Login error using CAM authentication from TM1Web with Firefox ESR 68 – SRVE0190E: FILE NOT FOUND: /TM1/WEB/TM1WEB.HTML FireFox ESR 68 users encounter an error when logging in to TM1Web using CAM Security.
2019-09-25 How to increase writeback performance via Secure Gateway for Planning Analytics on Cloud implementation When writing back to an on premise database via a Secure Gateway connection, performance is poor as this is a row by row INSERT INTO.
2019-09-19 How to implement an email notification in Planning Analytics on Cloud using a Powershell script (TLS 1.2 compliant) This document describes how an email notification can be generated from a TI process in Planning Analytics on Cloud using a Powershell script.
2019-09-10 Planning Analytics (and TM1) DO Connector – Run Optimization Process Errors When attempting to use the Planning Analytics (and TM1) Decision Optimization (DO) Connector, the Run Optimization TI Process throws errors in the &lt;DO-TM1_Connector&gt;\connector.log file
2019-09-05 Unable to install Workspace – Network Gateway IP for NAT network is not assigned to Host vNic Unable to install Workspace on Windows 2016 via Start.ps1. Following error is encountered:Network Gateway IP for NAT network is not assigned to Host vNic
2019-08-26 Data Spread failed Error in Architect/Perspective while spreading on the leaf cell :"Data Spread failed"Error in logs :"95872 [186] DEBUG TM1.Cube.Spreading Error : dbsprViewDataSpread() errorcode = 143"
2019-08-23 How to add a new admin user to a Planning Analytics server on Cloud A new server has been created on an environment on Cloud and you need to add an admin user.
2019-08-23 How to Troubleshoot TM1 Server Lock Contention It is possible that you may experience a situation in your environment, where the TM1 Server appears to be hung/unresponsive. For example, you may be unable to log in… or open a view… or a TI process is running much longer than expected.
2019-08-19 Namespace drop-down appears blank in Cognos Analytics/Cognos BI Login Page while attempting to login to Planning Analytics CAM authenticated server via Perspectives Attempts to login to CAM authenticated Planning Analytics server over Perspectives is not successful as the Cognos Namespace drop-down appears blank, not allowing users to select the namespace and login to Cognos Analytics/Cognos BI.
2019-08-19 SystemServerConnectWithCAMNamespace takes more and more time and may end with request timeout error TM1 Server is configured with CAM security ( IntegratedSecurityMode=5 )A lot of TI processes are executed through TM1RunTI tool within a scheduled batch. This generates a lot of connection requests onto Cognos Analytics Content Manager.TM1Top shows that SystemServerConnectWithCAMNamespace operation is taking more and more time ; connecting to the CAM namespace can then take from few seconds to several minutes.
2019-08-15 How to Convert CAFE Reports to Planning Analytics for Excel Reports / How to Update Report Connections from one server to another The steps in the document will guide you in converting your CAFE reports to Planning Analytics for Excel reports using the inbuilt "Update Connection Utility" functionality. The same steps may also be used to update a connection in a report from using one server, to using a different server.
2019-08-13 Unable to slice to Excel or export to Excel in TM1 Web in Planning Analytics 2.0.8 If you upgrade to Planning Analytics 2.0.8, you might not be able to slice to Excel or export to Excel from TM1 Web. This problem occurs on TM1 Web running in a Firefox or Chrome browser.
2019-08-12 Thin borders sometimes do not appear in TM1 Web dynamic reports If a user adds a thin border on the top of the row in the format row of a dynamic report, it appears in report rows in Microsoft Excel and TM1 Perspectives. However, no borders are shown in report rows in TM1 Web.
2019-08-09 Planning Analytics SSL Configuration on TM1Web (or any Web Tier components) does not work as expected After having completed the SSL Configuration for the Planning Analytics Web Tier components, the sites do not work. The certificates appear valid in the keystore, and all steps had been followed correctly.
2019-08-09 TM1 Web formatting differences in Planning Analytics 2.0 Formatting of cells, reports, borders, and other elements of websheets in TM1 Web might differ if you are migrating from Cognos TM1 and TM1 Perspectives to IBM Planning Analytics 2.0 and TM1 Web or Planning Analytics for Microsoft Excel.Some of these inconsistencies are designed to be part of TM1 Web websheets in Planning Analytics 2.0. Some of these inconsistencies can be addressed by applying workarounds.
2019-08-08 Planning Analytics for Excel connections are not available (not saved) after closing and reopening Planning Analytics for Excel After a connection has been added to Planning Analytics for Excel, the connection is lost/removed when PA for Excel is closed and reopened.
2019-07-31 Planning Analytics Administration Database Configuration Fails to Return Database List Planning Analytics Administration Database Configuration Fails to Return Database List
2019-07-31 Unable to FetchData Prolog Procedure error (98) unable to register subset when attempting drillthrough to source data User is unable to perform a turbointegrator process (any TI, including drill-through). The below error is recorded on the tm1server.log
2019-07-31 HTTP ERRPOR 404 on hitting Tm1Web URL Following error on hitting Tm1Web URI configured with CAM security :"HTTP ERRPOR 404This page can't be foundNo webpage was found for the web address :http://&lt;FQDN name&gt;/ibmcognos/tm1/web/tm1web/applications.jsp"
2019-07-15 Unable to import data in Planning Analytics Workspace using drag and drop method User is attempting to import data into Planning Analytics Workspace (PAW) by dragging a .csv file onto an existing cube.
2019-06-30 Non-admin users intermittently receive "Unable to fetch data … can not be found in collection of type 'Cellset'" errors when opening views (inside Books) in PAW, caused by APAR PH12306 User refreshes a book. Intermittently, an error appears.Problem only affects non-admin users.
2019-06-25 How to Manage your TM1 Application Server (JAVA) Memory The purpose of this document is to help with understanding and managing the memory utilization of the TM1 Application Server.
2019-06-24 ODBCOUTPUT using variable with numeric values User is wanting to post values from Planning Analytics to a relational database and use the SQLStmInsertODBC statement while using a variable, as oppose to hard coding them.Example:vVAR = 'CellGETN(dimension)';SQLStmInsertODBC= 'insert into dbo.Table_One (code) values ( '''|vVAR|''' )';odbcoutput ('SQL Test', SQLStmInsertODBC);This works well unless the value in question is numeric. The below error is encountered when attempting to post a numeric value by way of a variable on that statement.
2019-06-20 TM1Web Export of Active Form does not render correctly After exporting an Active Form from TM1Web, the output when opened in Excel does not render correctly.
2019-06-19 Each login from Planning Analytics for Excel 2.0.42 generate ServerError*.log file Login from Planning Analytics for Excel 2.0.42 to Planning Analytics 2.0.6 or less generate ServerError*.log file.File contained following error message. Is it a ignorable or not?Path: http://hostname/pmhub/pm/tm1/server(Planning%20Sample)/api/v1/%2524metadata?Method: GETAccepts: text/xmlError: Internal Server ErrorResponse: {}
2019-06-13 cannot launch admin tool due to Windows image version incompatibility Cannot launch administration tool
2019-06-11 MustGather: Troubleshooting TM1 Application Tier Crashes This MustGather Technote lists the information that must be collected to troubleshoot TM1 Application Tier Crash where WebSphere Liberty Profile (WLP) is part of the environment.
2019-06-11 MustGather: Troubleshooting TM1 Application Tier Performance Issues If your TM1 Web application experiences a perceived hang, or performance issues, there are a number of diagnostic data files that are useful for diagnosing the problem. This MustGather document describes the steps and settings that are required to be in place in order to generate those diagnostic data files.Collecting DataTo troubleshoot TM1 Web Application Tier performance issues prepare to gather the following information – either by supplying existing files or enabling additional logging – that should th
2019-06-11 Values of distributed leaf cells are different the second time a spread operation is performed (triggered by leaf cell's original values being zero) – relating to ProportionSpreadToZeroCells Customer has a 'consolidated' cell (at the top), with several 'leaf' cells below it.User types in a value inside the consolidated call, and presses &lt;return&gt;. This causes values to be 'spread' to the leaf (child / daughter') cells below.User then repeats the exact same task (typing in the same value inside the same consolidated call, and presses &lt;return&gt;. This causes different values to be spread to the leaf cells.
2019-06-04 Empty cells cause incorrect top borders on heading rows in TM1 Web 2.0.7 and later You will notice that the same report appears differently in TM1 Web version 2.0.6 and earlier (including TM1 Web 10.2.2) and TM1 Web version 2.0.7 and later. In TM1 Web 2.0.7 or later, observe that there is no top border on the heading cells below cells with empty values. Open the same report in TM1 Web 10.2.2, and you will see the correct/expected format. The following image shows the incorrect border formatting of cells in TM1 Web 2.0.7.
2019-05-30 How to Configure SSL on Planning Analytics Web Tier using GSKit (New Certificate Signing Request) The steps in the document will guide you in using the IBM Global Security Kit (GSKit) to secure your Planning Analytics Web Tier.
2019-05-27 How to Configure Planning Analytics 2.0.6 and later TM1 Web for KERBEROS/SPNEGO (SSO) This document is a real example which goes through the setup and configuration of SPNEGO/TM1Web using a sample server. The intent of this document is to allow you to follow along, implementing the necessary changes for the environment you are configuring. The official production documentation should still be reviewed and used, and can be found here: https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_tm1_ug_configuring_sso_with_spnego.html Please note t
2019-05-22 Cell formatting extends beyond some cells in TM1 Web Report formatting in TM1 Web does not reflect the same report format as seen in TM1 Perspectives. In some cases where cells are dynamically merged, formatting expands beyond cells and into the next cell.
2019-05-22 Borders are missing on some column headers in TM1 Web Report formatting in TM1 Web does not reflect the same report format as seen in TM1 Perspectives. In some cases, a border is missing on specific cells in the websheet where there are hidden rows.
2019-05-21 TM1 server fails to start 8300 [] ERROR 2019-05-20 16:19:36.028 TM1.Server E15) Server unable to listen on port 12366. Please check the log file for further details.8300 [] INFO 2019-05-20 16:19:36.030 TM1.Server The server is coming down…8300 [] INFO 2019-05-20 16:19:36.034 TM1.Server Server shutdown, elapsed time 0.00 seconds11128 [] ERROR 2019-05-20 16:19:36.051 TM1.Server Error generating session keys11128 [] ERROR 2019-05-20 16:19:36.051 TM1.Server CreateSvrKeys failed
2019-05-17 Formatting of borders above a freeze pane is not correct in TM1 Web Report formatting in TM1 Web does not reflect the same report format as seen in TM1 Perspectives. In some cases, borders above a freeze pane line do not match the same border appearance in TM1 Web as they do in Microsoft Excel and TM1 Perspectives.
2019-05-17 Action buttons in TM1 Web do not look the same as in TM1 Perspectives Action buttons in TM1 Web do not look the same as seen in TM1 Perspectives. The formatting of action buttons is different and text of some buttons may appear different.
2019-05-14 Creating a Wildcard Certificate for Tm1 Application Tier with Open SSL Creating a Wildcard Certificate for Tm1 Application Tier with OpenSSL
2019-05-14 Creating a Private Key and a Certificate Request for PAW SSL Configuration You might use openSSL if you do not get a Privatekey from your IT department and/or they demand for an Certificate Request
2019-05-09 Unable to open databases tab in Planning Analytics Administration – Something went wrong! Please try again in a few minutes. Users are unable to open the Databases tab in Planning Analytics Administration.
2019-05-04 How to stop and start Planning Analytics Workspace from the command line The document describe in how to start and stop Planning Analytics Workspace (PAW) from the command line.
2019-04-26 "Unable to fetch data for content tree … ObjectSecurityNoWriteRights" error when users open public views (in PAW) if they have READ access to cube – caused by APAR PH04253 User launches Planning Analytics Workspace (PAW). User has READ only permission on the cube.User tries to open a view. An error appears.Problem only affects public views. Private views work OK.
2019-04-23 Configuring TM1 Server to trust the SSL certificate on CA Side If Cognos Analytics is configured to use SSL TM1 Server must trust the certificate to be able to connect to CAM Security. If not any TM1 Client will throw an error and is not able to connect.
2019-04-22 Unable to open node in TM1 Application Contributor (PMPSVC) – Page is blank When attempting to open a node in TM1 Application Contributor (PMPSVC), the user is presented with a blank page.
2019-04-22 Troubleshooting Planning Analytics Workspace Related Docker Issues Docker is one of the chief prerequisites for the installation and configuration of IBM Planning Analytics Workspace (PAW). Every so often, it is possible that customers may run into docker-related issues which might prevent functioning of PAW. This technote aims to help you through some commonly faced docker issues. For the purposes of this technote, all Powershell commands mentioned should be run from an elevated Powershell session. Given below is a workflow diagram of the
2019-04-16 TM1 Architect not defaulting on dimension pick list when users don't have access to the pick list cube When a cube contains two pick lists (a pick list cube and pick list dimension), and the user does not have access to the pick list cube, it is expected to default to the pick list dimension and allow the user to choose from that list. However, this results in having no pick list at all i.e. an empty element.
2019-04-15 Planning Analytics Workspace Content Store is not refreshing content in Planning Analytics for Microsoft Excel Planning Analytics for Microsoft Excel users may notice that content from the Planning Analytics Workspace Content Store is not refreshing.
2019-04-04 How to Resolve a Browser Certificate Warning – This site is missing a valid, trusted certificate When you access an SSL Secured web page, you may be prompted with a warning that the website is missing a valid, trusted certificate. The steps in this document guide you towards verifying the certificate used and importing the certificates so that the browser warning does not occur.
2019-04-02 How to disable port 9080 in Planning Analytics When you configure the Planning Analytics Application Server (Web Tier), for SSL – port 9080 is still in use by HTTP.
2019-03-29 ICIS new option to see the MDX statements generated in ICIS for SAP IN order to see which MDX statements are generated from ICIS when importing from SAP, a new optional function was implemented in ICIS. Thats a huge help when analysing why some imports may fail or if the result of the outcome is unexpected.
2019-03-21 No Permission to perform operation "No Permission to perform operation" on a white page is received when a IBM Planning Analytics application link is called from IBM Cognos Analytics, 3rd party application or static webpage.
2019-03-20 Security Reports: PAW used cipher suits are weak Tools may flag the ciphers offered by PAW for different reasons. Most recently ciphers not suitable for Perfect Forward Security (PFS) get flagged as well. This will include all ciphers based on static key exchange like TLS_RSA_WITH_AES_128_CBC_SHA TLS_RSA_WITH_AES_256_CBC_SHA TLS_RSA_WITH_CAMELLIA_128_CBC_SHA TLS_RSA_WITH_CAMELLIA_256_CBC_SHATLS 1.2 ciphers: TLS_RSA_WITH_AES_128_CBC_SHA TLS_RSA_WITH_AES_128_CBC_SHA256 TLS_RSA_WITH_AES_128_GCM_SHA256 TLS_RSA_WITH_AES_256_CBC_SHA TLS_RSA_WITH_AES
2019-03-12 Perspective Add-In title disappears from the Menu bar while its menu items are seen with no titles Perspective Add-In title disappears from the Menu bar while its menu items are seen with no titles. This is a random behavior with no pattern.After you close and open Excel (several times ) the addin and all its menu items are back as normal
2019-03-12 Usage of port 5495 and 5498 in Planning Analytics Which of the ports 5495 and 5498 are used in Planning Analytics ?
2019-03-08 Cannot run a Turbo Integrator process from an action button Running a Turbo Integrator (TI) process from an action button will fail if you are using IBM Planning Analytics for Microsoft Excel 2.0.40 with IBM Planning Analytics 2.0.4 or older.
2019-03-08 "Error getting active sandbox – no ad-hoc sandbox capability has been granted" error on TI execution TI run by Non- Admin users fail with error"Error getting active sandbox – no ad-hoc sandbox capability has been granted"Same TI works for Admin users.
2019-02-20 How to Provide a Testcase to Planning Analytics Support Depending on the type of problem you are encountering, providing a testcase to Planning Analytics Support can be useful in expediting a resolution. Providing a testcase that demonstrates the problem you are encountering will allow for greater flexibility in the testing/debugging process, and also allow for the testing of possible solutions. If you have reason to believe the problem you encountering is a product defect, such a testcase may be required by the Planning Analytics Development team in
2019-02-08 After a restart of the TM1 server, TM1RunTI executes processes in serial on first run but executes them in parallel on all subsequent runs After a restart of the TM1 server, TM1RunTI executes processes in serial on first run but executes them in parallel on all subsequent runs.
2019-02-07 Exception computing feeders for base cube 'CUBE_NAME': IX locking is prohibited in nested transactions Saving a rule is taking a long timeUser reviews the tm1server.log and finds the information described in 'Symptom' section of this document.
2019-01-18 Decision Optimizer (DO-TM1) Connector works, however crashes using larger datasets When using the Decision Optimizer (DO-TM1) Connector, it works without when using smaller datasets. When using larger datasets, the Connector crashes.
2019-01-11 Unable to Start Multiple TM1 Servers at Once From Cognos Configuration, user can start only one server at any given point in time. If a second server is started, it errors out with the following message: errorlevel1 exit 1The IBM Cognos TM1 Server – &lt;ServerName&gt; Service could not be startedA system error has occurred. System error 1067 has occurred. The process terminated unexpectedly.
2019-01-11 Running paw.ps1 script fails to bring up one or more Planning Analytics Workspace services When ./scripts/paw.ps1 is run from an elevated PowerShell session, one or more containers fail to come up with the following error message: Cannot start service &lt;service-Name&gt;: failed to create endpoint &lt;service-name&gt; on network nat: HNS failed with error: The object already exists.
2019-01-09 Error occurs logging out of TM1 Web – DPR-ERR-2079 Firewall Security Rejection When logging out of TM1 Web, the following error is encountered:IBM Cognos An error has occurred. DPR-ERR-2079 Firewall Security Rejection. Your request was rejected by the security firewall. CAF rejection details are available in the log. Please contact your administrator.
2019-01-08 "Unable to fetch data. ObjectSecurityNoAdminRights" error when trying to drill through (in PAW and PA for Excel) if not an administrator, caused by defect User launches PAW (or PA for Excel) and logs on as a standard (non admin) user. User tries to drill through. An error appears.- If the same 'bad' user launches Architect, then they can successfully drill through (no error). Problem only affects non-ADMIN users.
2019-01-03 TM1 Perspectives causing Excel to Crash when used through Citrix When using TM1 Perspectives through Citrix, Excel randomly crashes.
2018-12-19 ODBC Drill Through Based on Element Attributes in Planning Analytics Workspace This Technote explains a known limitation of ODBC drill through in Planning Analytics Workspace.
2018-12-11 TM1 Web returns error "This Page isn't working" After Server restart TM1 Web , Operations Console ,Planning Analytics For Workspace (PAW) and PAx stopped working.No issue with Architect and Perspectives .After restart PAW was able to work.TM1 Web returns error "This Page isn't working"PAx when attempt to connect to the server returns this error:"Cognos.Office.Tm1.Connections.Tm1WebException: The remote server returned an error: (503) Server Unavailable. —&gt; System.Net.WebException: The remote server returned an error: (503) Server Unavailable."Found
2018-11-26 Planning Analytics TI Process using Microsoft SQL Server – Unable to open connection to database Planning Analytics Turbo Integrator processes utilizing Microsoft SQL Server as a data source fail with "Unable to open connection to database"
2018-10-12 Unable to Import content from previous version of IBM Cognos Command Center Cognos Command Center content was exported from one version and imported to another. Import failed.
2018-10-01 Data updated cell does not toggle the color to blue Normally data updated cell toggle the font color to blue. However, my worksheet stay in black.How can I revert to toggle the color?
2018-09-07 Critical usage notes for IBM Planning Analytics This document describes late-breaking critical usage issues for IBM Planning Analytics and associated components. IBM Cognos TM1 10.3 is currently available only as part of the IBM Planning Analytics release on the cloud. We recommend that you do not use the 10.3 documentation with previous versions of Cognos TM1.
2018-08-28 Unable to get task pane to render in Planning Analytics for Excel – Error "Specified restriction conflicts with the current dock position" When a user launches Excel and signs into Planning Analytics (PA) for Excel, they are unable to get the task pane to display.
2018-08-17 Critical installation, configuration, and usage issues in IBM Planning Analytics 2.0 This document describes late-breaking issues for IBM® Planning Analytics 2.0.
2018-07-30 Planning Analytics Applications prompt for CAM authentication with SSO enabled Cognos Analytics environment Planning Analytics Applications prompt for CAM authentication with Single-Sign-On (SSO) enabled Cognos Analytics environment.
2018-07-18 Security Bulletins – IBM Planning Analytics, Cognos TM1 and Cognos Insight IBM Planning Analytics and Cognos TM1 Security Bulletins and Alerts.
2018-07-11 Error "FBTSML225E Token exchange failed" occurs when authenticating When trying to authenticate in Planning Analytics on Cloud, user gets the following error: An error has occurred FBTSML225E Token exchange failed. Error details: FBTSTS001E The given SAML assertion is not valid yet
2018-07-09 Why users can't see TM1 cube processes in Planning Analytics Workspace Users who login to Planning Analytics Workspace can't see the processes in the TM1 cubes. In other tools liek TM1 Architect the same user is able to see and edit processes.
2018-07-05 Move menu at child element does not activate in Set Editor when expand the consolidate element. Please let me know is following behavior a expected or not.Using set editor in Planning Analytics Workspace or Planning Analytics for Microsoft Excel. Insert consolidation item to 'Current set'. Expand consolidation item in 'Current set'. Right click child element and following menu are gray out. 'Move to top','Move up','Move down' and 'Move to bottom'If insert consolidation and child which already expanded in available members, those move menu
2018-06-17 Upgrade to Planning Analytics Workspace Local 2.0.29 Linux fails After upgrading from some older versions of Planning Analytics Workspace Local to version 2.0.29, Planning Analytics Workspace fails to start. This occurs only when applying an upgrade on a Linux system.
2018-06-17 Documentation correction – The documentation for configuring Cognos TM1 Web to use Cognos security incorrectly identifies the destination diretory for the tm1web.html fileConfiguring Cognos TM1 Web to use Cognos security
2018-06-17 Critical installation, configuration, and usage issues in IBM Planning Analytics 2.0.3 This document describes late-breaking issues for IBM® Planning Analytics 2.0.3.
2018-06-17 IBM Planning Analytics 2.0.3 release notes These release notes provide a list of topics and links relevant to IBM® Planning Analytics 2.0.3.
2018-06-17 Critical installation, configuration, and usage issues in IBM Planning Analytics 2.0.2 This document describes late-breaking issues for IBM® Planning Analytics 2.0.2.
2018-06-17 IBM Planning Analytics 2.0.2 release notes These release notes provide a list of topics and links relevant to IBM® Planning Analytics 2.0.2.
2018-06-17 Activating your IBM Planning Analytics account and inviting other users This document describes how to activate your IBM Planning Analytics account and issues that you ned to be aware of when inviting other users to Planning Analytics.
2018-06-16 Unable to open Planning analytics BI report URL in Excel Unable to insert PA BI reports urls as hyperlinks in Excel.
2018-06-15 Additional TI logging for }tp TI processes How to enable additional logging for }tp TIs associated with TM1 Applications?
2018-06-15 How to change docker images and containers location with Windows 2016 Server? In many occasions, your C drive is typically small and/or you wish to install docker (images) off the C drive.
2018-06-15 Cognos Analytics for Microsoft Excel: Unable to expand a model in Task Pane After connecting to Cognos Analytics for Microsfot Excel, the user uses the Task Pane to access the model (they have multiple models (TM1 Servers)). Clicking on the folder to show the cubes and dimensions of this model, does nothing.
2018-06-15 UNICODE: Dimension element alias deleted on startup After upgrading to Planning analytics from TM1, some dimension elements (unicode) alias are removed from the dimension. The attribute on the dimension (alias) is blank. The rest of other attributes are intact. The tm1server.log records the following warning (see below).
2018-06-15 New Hierarchy Level Behavior in Planning Analytics Set Editor What's new with Hierarchy Level Behavior in Planning Analytics Set Editor?
2018-06-15 Error message: "SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol" Click validate button on Planning Analytics Workspace Administration Tool shows error TM1 Login Server URI Error: write EPROTO 139647280936768:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol:,./deps/openssl/openssl/ssl/s23_clnt.c:794
2018-06-15 TM1 web error "Failed to open the target workbook. Make sure that the file has not been renamed or deleted." occurs to all websheets Open any websheet from TM1 web gets error "Failed to open the target workbook. Make sure that the file has not been renamed or deleted." TM1web.log shows following error 2017-11-23 15:02:37,340 [Default Executor-thread-27730] ERROR () com.ibm.cognos.tm1.web.services.WorkbookService – [] Exception Error: null Stack Trace: java.lang.reflect.InvocationTargetException … Caused by: java.lang.NoSuchMethodError: com/aspose/cells/Workbook.getDataConnections()Lcom/aspose/cells/ExternalConnectionCollection; ….
2018-06-15 Grid service error in PAW when trying to open TM1 model What is wrong in the PAW administration configuration although validation displays everything as OK and the same model opens fine in TM1 web
2018-06-15 How to connect remotely from Windows to the Planning Analytics Workspace admin tool on Linux Unable to connect from Windows to the Planning Analytics (PA) Workspace Administration Tool that is installed and launched on Linux (through either Start.sh or admintool.sh). If PA Workspace is installed on Windows, there is no problem as the admin tool can be reached through the following URL: http://:8888 However, this does not work when PA Workspace is installed on Linux.
2018-06-15 Decimal places missing in spreading dialog in TM1 Web in Planning Analytics 2.0.3 The behavior of the spreading dialog has changed for whole numbers. Whole numbers no longer appear with decimal places.
2018-06-15 How to Obtain the Planning Analytics / TM1 Server Certificate If you have an application which must connect to your Planning Analytics / TM1 Server, you will need to import the SSL Certificate used to secure your server in to the application you are configuring. These steps will help you obtain the details you need to connect as well as extract the certificate from the Planning Analytics / TM1 Server.
2018-06-15 Installation issues with PAW on Windows 2016 when Symantec Antivirus is running During the installation process on Windows 2016, trying to run this kind of command may lead to this error : Command : Install-Package -Name docker -ProviderName DockerMsftProvider -Force Error : Install-Package : Cannot rename because item at 'C:\Program Files\dummyName' does not exist. At line:1 char:1 + Install-Package -Name docker -ProviderName DockerMsftProvider -Verbos … + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (Microsof
2018-06-15 Planning Analytics for Excel results in HTTP 404 error When trying to log on to a TM1 server in Planning Analytics for Excel a HTTP 404 error appears.
2018-06-15 PA flickers and then reloads after logon After logging into PAW, the website constantly refreshes automatically, so, I can login, but after login, I can't do anything as the website is continiously refreshing. I have tried with Internet Explorer, Google Chrome and Mozilla Firefox, but in all three browsers, the behaviour is the same.
2018-06-15 Error when using an Action Button to navigate to a worksheet whose name includes GB 18030 characters In Planning Analytics for Microsoft Excel and TM1 Web, clicking an Action Button to open another worksheet results in a worksheet that contains no data.
2018-06-15 Still getting java.lang.OutOfMemoryError whatever the value of 'Maximum Memory in MB' TM1 Web or TM1 Application Web are getting unresponsive and Planning Analytics logs contain some errors java.lang.OutOfMemoryError. In Cognos Configuration, the parameter /Environment /TM1 Applications /Maximum Memory in MB has been increased a lot, but Java Out Of Memory errors are still happening the same way, with no improvement at all.
2018-06-15 No tm1 server instances in the tm1web drop down when trying to log in A new installation of TM1 results in all aspects workling OK except for tm1web.
2018-06-15 Planning Analytics Workspace: Unable To Expand Tree Hierarchy: Tree Item Not Found: TM1 When expanding the tree hierarchy of the TM1 server in Planning Analytics Workspace, the following error occurs:
2018-06-15 Cognos Analysis For Excel (CAFE): Error Occurs When Selecting The Option To Create A Crosstab The following error occurs in CAFE when selecting the option tab to create a crosstab report. The error occurs for one machine only
2018-06-15 Commit Option On TM1Web Portal Is Greyed Out. Users Cannot Commit Their Node. Commit option on TM1Web portal is greyed out. Users Cannot Commit Their Node.
2018-06-15 Error Logging Into TM1 Instance In Architect: Failed To Establish A Backside Connection Error occurs after entering logon credentials for TM1 instance for the first time in Architect Same error occurs in Perspectives, Performance Modeler and Cognos Connection after entering logon credentials for tm1 instance for the first time.
2018-06-15 CAFE Error When Creating A Crosstab: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX) The following error occurs in CAFE when selecting the tab to create a crosstab
2018-06-15 Error Logging Into Planning Analytics Workspace For The First Time: An Unexpected Authorization Error Has Occurred Error Logging Into Planning Analytics Workspace For the First Time
2018-06-15 Error Logging Into Watson Analytics From Planing Analytics Workspace: Problem Accessing External Website Error occurs when launching Watson Analytics from Planning Analytics Workspace
2018-06-15 Cannot edit a crosstab in Cognos Analysis for Microsoft Excel With earlier versions of Microsoft Excel 2013, when you create a crosstab or list with User Columns in Cognos Analysis for Microsoft Excel, you cannot edit subsequent crosstabs, lists, or flex views created in Excel. NOTE: IBM Cognos Analysis for Microsoft Excel 10.3 is currently available only as part of the IBM Planning Analytics release on the cloud. We recommend that you do not use the 10.3 documentation with previous versions of Cognos Analysis for Microsoft Excel.
2018-06-15 Cannot log in to the PMHub admin page When you try to log in to the IBM Cognos Performance Management Hub (PMHub) admin page, the page continues to show that you are not logged in. NOTE: IBM Cognos TM1 10.3 is currently available only as part of the IBM Planning Analytics release on the cloud. We recommend that you do not use the 10.3 documentation with previous versions of Cognos TM1.

“IBM prides itself on delivering world class software support with highly skilled, customer-focused people. ”


Return to 101 home
Contact Support Find your regional support contact

Back to top