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 September 13, 2024.
Last Updated Title Abstract
2024-09-12 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.
2024-09-06 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"
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-30 Timeline Reference for IBM Planning Analytics 2.1 Releases List of IBM Planning Analytics component releases as of the end of each month.
2024-08-30 Timeline Reference for IBM Planning Analytics Releases List of IBM Planning Analytics component releases as of the end of each month.
2024-08-29 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.
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-31 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
2024-07-25 Relative proportional spread fail with error SpreadConsolidationRulesFailed Try to perform relative proportional spread, it failed with error SpreadConsolidationRulesFailed.
2024-07-19 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.
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-26 Quick or Universal Reports Displaying Blank Values in TM1Web Quick or Universal Reports Displaying Blank Values in TM1Web:
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-05-31 Must Gather – Troubleshoot Planning Analytics ODBC Connector (ODBCIS) A problem has been encountered while using the Planning Analytics ODBC Connector (ODBCIS)
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 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-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-04-02 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.
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-06 Must Gather – Troubleshoot Planning Analytics Database Engine A problem has been encountered with a Planning Analytics database
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-12 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-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 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?
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-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-10-18 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".
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-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-27 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"
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-09-21 Planning Analytics for ExcelではTM1RPTROWが他のセルにあるSUBNMを参照すると集約が展開されない Planning Analytics for ExcelではTM1RPTROWが他のセルにあるSUBNMを参照すると集約が展開されません。
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://<Webserver>: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 <environmentName>.planning-analytics.ibmcloud.com port 443 (https://<environmentName>.planning-analytics.ibmcloud.com:443/ccagent/). Unable to connect to the remote server."
2023-07-07 AuditLogMaxQueryMemory too small using Rest API to retrieve auditlog entries. AuditLogMaxQueryMemory too small using Rest API to retrieve auditlog entries.
2023-07-07 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.
2023-07-07 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.
2023-07-07 Visualizations loose labels when using "Fit to page" Visualizations loose labels when using "Fit to page"
2023-06-29 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.
2023-06-29 StringCellUpdateError committing data in PA for Excel An error occurs committing data in PA for Excel.
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-06-02 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&ui.compid=ps&m=portal/close.xts&h_CAM_Action=loginAs"Then, after next click "Yes", blue circle appears, it hangs and nothing happens anymore.
2023-06-02 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?
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-26 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. —> Cognos.Office.Tm1.Connections.RedirectException: Exception of type 'Cognos.Office.T
2023-04-12 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 <container_name> Cannot start service monitor: container is marked for removal and cannot be started.OrException occurred:Execution failed with exit code 1:ERROR: for <container_name> <GUID>: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
2023-04-07 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
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 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-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-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-29 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
2023-03-24 Unable to open TM1web (Planning Analytics Spreadsheet Service) – HTTP ERROR 500 TM1Web not working – Error 500
2023-03-24 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 a Planning Analytic Workspace
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-20 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.
2023-03-16 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.
2023-03-15 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.
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-27 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.
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-20 All containers are in "Restarting" state on Linux, and logs are empty On Linux, all containers are in "Restarting" state:The <PAW>/log directory contains either empty subfolders, or there are no new log files created for some time.The result of "docker logs <container_name>" 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
2023-02-10 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_
2023-02-03 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.
2023-02-02 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)
2023-01-31 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?
2023-01-27 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.
2023-01-25 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"
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-18 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
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 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.
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
2023-01-03 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
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 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-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 Excel crashing when launching Planning Analytics for Excel Launching Excel with the Planning Analytics for Excel add-in enabled crashes Excel.
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-30 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.
2022-11-24 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
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-16 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
2022-11-14 Set Editor is blank in Planning Analytics for Excel Set Editor is blank in Planning Analytics for Excel
2022-10-31 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
2022-10-31 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.
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-24 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)
2022-10-14 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
2022-09-28 How to Troubleshoot Planning Analytics Administration Agent The purpose of this document is to provide guidance with troubleshooting the Planning Analytics Administration Agent.
2022-09-20 Planning Analytics Administration Agent is unreachable When the user tries to check the agent status, it shows as unreachable.
2022-09-14 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.
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-05 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… "
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-09-01 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.
2022-08-29 Planning Analytics Workspace forecasting feature performance issue Planning Analytics Workspace forecasting feature is slow: forecasting on 100000 lines takes several hours.
2022-08-19 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
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 Planning Analytics Administration Agent is unreachable Planning Analytics Administration Agent is unreachable
2022-08-03 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
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-15 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:
2022-07-14 The term 'docker-compose' is not recognized … when trying to start containers with /scripts/paw.ps1 Error when trying to run containers by using <PAW_path>/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 …+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ +
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-07 '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.
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-24 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"
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-17 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.
2022-06-12 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.
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-03 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.
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:<IP_address>: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-23 "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"
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-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-16 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.
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-03 How to Troubleshoot a Planning Analytics Web Tier Crash Planning Analytics Web Tier crash (TM1 Application Server, TM1 Web, Spreadsheet Service)
2022-05-03 How to Troubleshoot a Planning Analytics Web Tier Hang Planning Analytics Web Tier hang (TM1 Application Server, TM1 Web, Spreadsheet Service)
2022-05-03 How to Troubleshoot a Planning Analytics TM1 Server Hang Planning Analytics TM1 Data Server hang
2022-05-03 How to Troubleshoot a Planning Analytics TM1 Server Crash Planning Analytics TM1 Server crash
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-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-20 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.
2022-04-16 "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
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-08 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
2022-04-07 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
2022-04-01 Planning Analytics Workspace becomes inaccessible frequently. Planning Analytics Workspace becomes inaccessible frequently.
2022-04-01 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.
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-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-24 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
2022-03-24 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
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-18 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.
2022-03-18 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)
2022-03-18 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.
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-03-15 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.
2022-03-13 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
2022-03-13 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.
2022-03-11 Planning Analytics Spreadsheet Services Silent Uninstall You would like to uninstall Planning Analytics Spreadsheet Services silently, without a user interface.
2022-03-10 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.
2022-03-10 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.
2022-02-28 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?":
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-17 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.
2022-02-16 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.
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-02-04 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.
2022-02-03 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.
2022-02-02 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.
2022-01-25 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?
2022-01-18 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 &lt;keyStore id="defaultKeyStore"/&gt; element, and the 'keystore_password' environment variable is not set. In console.log:CWWKG0014E: The
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-12 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
2022-01-12 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.
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-10 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.
2022-01-07 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.
2022-01-05 "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.
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-24 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.
2021-12-24 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
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-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 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
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-10 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.".
2021-12-10 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.
2021-12-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
2021-12-07 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.
2021-12-06 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.
2021-12-06 "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.
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-12-02 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.
2021-11-26 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.
2021-11-25 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 ?
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-02 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
2021-10-31 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.
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-22 Unable to stop TM1 Admin Server using IBM Cognos Configuration tool Unable to stop TM1 Admin Server using IBM Cognos Configuration tool
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-13 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
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 Ribbon and button texts are not rendering correctly in Planning Analytics for Excel Strange texts are displayed for Planning Analytics for Excel
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 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
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 Performance Modeler Error "com.ibm.cognos.tm1.TM1Exception: APIFunctionFailed" Unable to save any changes in TM1 Performance Modeler
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-27 Planning Analytics Administration not generating email alerts while stopping TM1 services Planning Analytics Administration Alerts not getting generated while stopping TM1 services
2021-09-27 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.
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-21 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
2021-09-21 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".
2021-09-21 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.
2021-09-21 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
2021-09-21 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.
2021-09-21 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.
2021-09-21 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'
2021-09-21 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.
2021-09-21 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"
2021-09-21 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.
2021-09-21 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.
2021-09-21 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.
2021-09-21 Getting "Forbidden" error when logging into TM1Web using CAM security After entering log in credentials, getting a "Forbidden" error.
2021-09-21 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.
2021-09-21 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).
2021-09-21 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" "
2021-09-21 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
2021-09-21 Planning Analytics IBM Cognos Configuration Crashes on Startup When launching IBM Cognos Configuration from the Start Menu, it crashes after a couple of seconds.
2021-09-21 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
2021-09-21 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
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 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.
2021-09-20 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
2021-09-20 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
2021-09-20 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.
2021-09-20 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.
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Customise personalisation of tm1web for branding purposes logo style- FAQ Collected information on how to customise tm1web / Planning Analytics Web
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 "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 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 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 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 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 "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 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 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 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 delete user(s) on IBM Planning Analytics on Cloud Customer wishes to delete a user from their Planning Analytics on Cloud.
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 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 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 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 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-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 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 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 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 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 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 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 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 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 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 "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 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 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 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 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 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-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-15 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
2021-09-15 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.
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-08-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.
2021-07-29 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
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-12 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
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-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 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
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 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.
2021-06-10 Internal Error 500 occurs when exporting from Planning Analytics Workspace to Excel Internal Error 500 occurs when exporting from Planning Analytics Workspace to Excel
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-05-10 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.
2021-05-04 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.
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 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.
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-27 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
2021-03-25 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.
2021-03-24 Unable to view cancel processing of a thread window in TM1 Top. Unable to view cancel processing of a thread window in TM1 Top.
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-11 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.
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-19 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.
2021-02-18 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.
2021-02-17 Unable to log in to Planning Analytics for Excel – System.Runtime.Serialization.SerializationException Users are unable to log in to Planning Analytics for Excel
2021-02-10 TIプロセスでSynchronized()を使用しているにも関わらずLockの競合が発生してプロセスがロールバックされる。 お客様は、同じプロセスを同時に複数のユーザーから実行しています。この時、プロセスでsynchronized() 関数を宣言して実行されるプロセスをシリアライズしているにも関わらず、ロックの競合が発生して、プロセスがロールバックされてしまいました。
2021-02-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.
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 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.
2021-01-25 "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.
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.
2021-01-08 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
2020-12-23 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.
2020-12-16 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"
2020-12-02 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.
2020-11-26 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)
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-12 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.
2020-11-12 "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
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-05 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
2020-11-03 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)
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 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 ?
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-16 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?
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-09-04 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,
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-08-10 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.
2020-07-31 About the )async directory in TM1 Planning Analytics server What is the }async directory in TM1 Planning Analytics server ?
2020-07-24 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"
2020-07-13 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
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-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-10 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.
2020-06-05 (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
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-06-04 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
2020-06-04 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.
2020-05-29 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)?
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 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
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-15 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.
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-03-26 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.
2020-03-12 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.
2020-02-27 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 ?"
2020-02-21 "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.
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-15 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
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-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-09 HOLD function in Planning Analytics Workspace Are HOLDs in Planning Analytics Workspace persistent or do they expire?
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-05 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
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-11-22 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.
2019-11-20 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
2019-11-14 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.
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-11-12 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.
2019-10-29 How to view unlimited rows in Planning Analytics for Excel Reports created/used in Planning Analytics for Excel are not displaying all rows expected.
2019-10-28 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.
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 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-18 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
2019-10-18 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
2019-10-15 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&amp;Type=WebSheet&amp;Workbook=Applications/Planning Sample/Management Reporting/Actual v Budget&amp;AdminHost=localhost&amp;TM1Server=Planning Sample does not permit cross-origin framing"
2019-10-10 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.
2019-10-10 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
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-10-02 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.
2019-09-28 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
2019-09-12 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.
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-06 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.
2019-09-06 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.
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-09-03 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:……}
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-20 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.
2019-08-20 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
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-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-19 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.
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-25 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
2019-06-25 Planning Analytics Workpace install fails with "Execution failed with exit code 1" Attempts to install Planning Analytics Workspace fail after running start.ps1
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 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
2019-06-12 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.
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-06 How to Troubleshoot Planning Analytics Administration Alerts You have configured Planning Analytics Administration Alerts however the alerts are not working as expected.
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-27 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
2019-05-22 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.
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 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-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-16 SUBNM, TM1PRIMARYDBNAME, DBRW, DBSS, etc. suppressed by exploit protection SUBNM, TM1PRIMARYDBNAME, DBRW, DBSS, etc. do not work, they do not execute
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-01 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.
2019-04-29 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 : &lt;Server Name&gt;500 (Internal Server Error) {"code":"Explorer","refID":"message":Failed to get children for Server cubes","cause":"java.net.SickerException:Connection reset"}"
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-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-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-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-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-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-17 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
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-12-06 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 …
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-31 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.
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-28 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…."
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-08-16 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.
2018-07-30 Operations Console prompt for CAM authentication with SSO enabled Cognos Analytics environment Operations Console prompt for CAM authentication with SSO enabled Cognos Analytics environment
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-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 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 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.3 This document describes late-breaking issues for 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 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
2018-06-15 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 "
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 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.
2018-06-15 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.
2018-06-15 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 "
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 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.
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 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
2018-06-15 Unable to refresh or create Dynamic Reports IBM Planning Analytics for Microsoft Excel is unable to refresh or create Dynamic Reports.
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 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.
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 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
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 use command line for tm1runti.exe gets error message SystemServerClientNotFound use command line for tm1runti.exe gets error message SystemServerClientNotFound Server connection failed
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 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.
2018-06-15 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
2018-06-15 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.
2018-06-15 Unable to Publish Cognos Insight Workspace to IBM Cognos Analytics You are unable to Publish your Cognos Insight Workspace to IBM Cognos Analytics
2018-06-15 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.
2018-06-15 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.
2018-06-15 Can not access to TM1 Applications Portal I could not access to TM1 Applications Portal after enter account and password.
2018-06-15 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.
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 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'.
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 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
2018-06-15 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
2018-06-15 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
2018-06-15 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.
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 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.
2018-06-15 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.
2018-06-15 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
2018-06-15 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.
2018-06-15 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.
2018-06-15 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.
2018-06-15 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
2018-06-15 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.
2018-06-15 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.
2018-06-15 Backing up Planning Analytics Workspace on a Microsoft Windows OS How to Back up your Planning Analytics Workspace on a Microsoft Windows OS
2018-06-15 "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
2018-06-15 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.
2018-06-15 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.
2018-06-15 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.
2018-06-15 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.
2018-06-15 Unable to start workspace docker image:Error creating machine: Error in driver during machine creation Workspace docker image startup script fails.
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 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 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 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 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 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