In SSMS, run below query’s to get some information:
SELECT
r.session_id,
r.status,
r.wait_type,
r.wait_time,
r.blocking_session_id,
r.cpu_time,
r.total_elapsed_time,
DB_NAME(r.database_id) AS database_name,
t.text
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t
ORDER BY r.total_elapsed_time DESC;
SELECT
r.session_id,
s.login_name,
s.host_name,
r.status,
r.command,
r.cpu_time,
r.total_elapsed_time,
r.logical_reads,
r.reads,
r.writes,
DB_NAME(r.database_id) AS database_name,
t.text AS sql_text
FROM sys.dm_exec_requests r
JOIN sys.dm_exec_sessions s
ON r.session_id = s.session_id
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t
WHERE r.session_id <> @@SPID
ORDER BY r.cpu_time DESC;
The key columns are:
wait_type → what resource it is waiting for.
blocking_session_id → another session blocking it.
by Roger·Comments Off on Faulting module name: jvm.dll_unloaded
Product:
Cognos Controller 11.1.1003
Issue:
When you inside the Controller client program select a java menu, like groups – command center or maintain – jobs -define. The program exist without a error message.
If you check your Windows event log, you find this error:
Application: CCR.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
Solution:
A update of EDGE on the computer, have change the way WebView2 works. This gives a conflict with Controller java parts.
Create a text file in notepad with below text:
# Avoid contending with Chromium for low address space
-Xmx1024m
-Xnocompressedrefs
-verbose:sizes
Save the file as jvm.options
Place the file in folder C:\Program Files\IBM\IBM Controller Local Client\Integration\ on your laptop.
To make a forecast happen, you need to have a few tings setup in your TM1 model. This is a list of suggestions that may be needed.
The cube you are doing the forecast must have a TIME dimension. This are in TM1 Architect set on the cube properties.
The dimension for time, need to be in a format that TM1 understands.
Like Only years, or Year – quarters – months hierarchy.
Forecasting requires the time dimension to be placed on the column.
You must have data in all the periods, if you only have data in Quarters, but the dimension contain blank months, the predict may not work. You can get a message like:
Too many missing or zero values in the historical data.
The historical data must represent at least double what is being forecasted. If you forecast 2 years, you need 4 years of old data.
The view need empty periods where the prediction can be created. If you want to look 5 years forward, your TIME dimension need to contain empty elements for 5 years.
To begin forecasting, click an exploration view in a book, then click Forecast and click either Univariate or Multivariate, depending on which type of forecast you want to generate. A univariate forecast predicts the future values of a single variable based on historical data, using the Holt-Winters model.
Use the Set up tab to define the start date and end date for your forecast.
Right-click the Dimensions node in your database on the Databases tree, then click Create time dimension.
Alternatively, you can create a time dimension by clicking the Configure time dimension option when you create a new dimension. The Configure time dimension option is only available for a dimension with one hierarchy and no members.
If required, enter a name for the dimension.
Select the Start year for the dimension.
Select the End year for the dimension.
Answer the How frequently do you plan? question by selecting the granularity of the dimension.
Months
This option gives you three levels: Months, Quarters, Years.
Quarters
This option gives you two levels: Quarters, Years.
Years
This option gives you one level: Years.
Check the preview to confirm that it matches your expectation, then click Save.
You can modify the time dimension in the dimension editor after you create it.
Forecasting requires the time dimension to be placed on the column. The algorithm requires the time dimension members to be organized in order of increasing time, where each member of a level represents a consistent unit of time. Members within the dimension definition that do not conform to this requirement, for example calculated year-to-date member, can be hidden. Relevant time periods can be chosen to be ignored, resulting in a linear interpolation of values to be predicted from. Forecasting also supports hierarchical time dimensions and nested dimensions as time: year, quarter, and month dimensions.
One consequence of this is that leaves with multiple parents along the time series would result in non-contiguous time, so special care must be taken in these cases. If possible, it is advised to consider adding a special hierarchy for time series forecasting to support the required time configuration.
This document provides a script and/or step-by-step manual instructions for generating and deploying new applixca TM1 SSL certificates. The script can be used to automate the generation of new certificates. The manual steps are available to help with an understanding of the steps that the script has automated.
Install to the default location: C:\Program Files\OpenSSL-Win64
The OpenSSL executable will be located at: C:\Program Files\OpenSSL-Win64\bin\openssl.exe
2. Other Requirements
Administrative access to TM1 installation directories
TM1 services stopped before beginning
Important Notes
Password for CA key: applix
Password for Java cacerts: changeit
Password for tm1store: applix
All commands should be run from a Command Prompt with administrative privileges
Automated Script:
For automated execution of these steps, use the included update-applixca-certs.bat script. The script performs all the above steps. To run the automated script:
Delete the following files from the bin64\ssl directory:
del /q "%TM1_ROOT%\bin64\ssl\tm1admsvrcert.pem"
del /q "%TM1_ROOT%\bin64\ssl\tm1svrcert.pem"
del /q "%TM1_ROOT%\bin64\ssl\applixca.pem"
del /q "%TM1_ROOT%\bin64\ssl\applixca.der"
del /q "%TM1_ROOT%\bin64\ssl\applixca.crl"
Update the Java cacerts keystore with the new CA certificate (password: changeit):
cd "%TM1_ROOT%\bin64\jre\7.0\bin"
REM Remove existing applixca alias (ignore errors if not present)
keytool.exe -delete -alias applixca -keystore "..\lib\security\cacerts" -storepass changeit
REM Import new CA certificate
keytool.exe -import -trustcacerts -noprompt -file "%TM1_ROOT%\bin64\ssl\applixca.pem" -keystore "..\lib\security\cacerts" -storepass changeit -alias applixca
Find and Update All Other cacerts Files
Search for all cacerts files in the TM1 installation (excluding backups):
cd "%TM1_ROOT%"
dir /s /b cacerts | findstr /v /i "_bkp\ _backup\ backup\"
For each cacerts file found (other than the one just updated), copy the updated cacerts:
Update the tm1store keystore with the new CA certificate (password: applix):
cd "%TM1_ROOT%\bin64\jre\7.0\bin"
REM Remove existing applixca alias (ignore errors if not present)
keytool.exe -delete -alias applixca -keystore "%TM1_ROOT%\bin64\ssl\tm1store" -storepass applix
REM Import new CA certificate
keytool.exe -import -trustcacerts -noprompt -file "%TM1_ROOT%\bin64\ssl\applixca.pem" -keystore "%TM1_ROOT%\bin64\ssl\tm1store" -storepass applix -alias applixca
Find and Update All Other tm1store Files
Search for all tm1store files in the TM1 installation (excluding backups):
cd "%TM1_ROOT%"
dir /s /b tm1store | findstr /v /i "_bkp\ _backup\ backup\"
For each tm1store file found (other than the one just updated), copy the updated tm1store:
You can download the stand-alone Controller client.
Notes:
The installation of the standalone Controller client will also install the Excel link.
The Excel link is provided in 64-bit format and can be installed only on computers with a 64-bit operating system and a 64-bit version of Microsoft Office. 32-bit versions are not supported.
Ensure that your computer meets each of these prerequisites:
You uninstalled Controller excel link.
You installed Microsoft Excel for Microsoft 365.
You installed Microsoft Edge Runtime.
You are logged into Microsoft account.
You installed Microsoft .Net 4.8
Note: .NET Framework 4.8 is included by default in Windows 10 Version 1903 and newer. For earlier versions of Windows OS, you must manually install .NET Framework 4.8 from the official Microsoft download page.
In a browser window, log in to Controller Web.
Download the installer:
On the landing page, click the User icon .
From the User list, click Controller Client.
In the Controller Client License Information window, select I agree to proceed.
Install the Controller Client:
Proceed with the following steps:
Open the Downloads folder or the directory where the ZIP file was saved.
Unzip the downloaded .zip file to a preferred location on your computer.
Note: Always unzip the installation file into a newly created, empty folder. If you unzip it into a folder that already contains other files, all contents of that folder may be deleted during the uninstallation process.
Inside the extracted folder, double-click the client.bat file to execute the client setup.
When prompted, for the WSS URL, enter https://your_controller_server/ibmcognos/controllerserver and click Enter.
Open the Controller Client.
Note: Make sure you are logged into Controller Classic before accessing Excel client.
Proceed with the following steps:
Navigate to the CCRRemoteClient64.zip extracted folder
Double-click CCR.exe to start the application.
Select the database.
Enter your Username and Password, and then click Login.
Important: It may take a minute or two for the login to finish. Do not click in Controller or navigate to another application during this time.
Results
You should now be able to connect to IBM® Controller.
Note: If you cannot connect to Controller Client, it may be related to an incorrect registry setting. If you continue to experience an issue with your Controller Client installation, uninstall it completely, and then reinstall it.
For native TM1 access, ensure the HTTPPortNumber are set in tm1s.cfg for your applications. If you use Admin with password apple, ensure that account exist in all your TM1 applications with the same password.
Go to folder C:\ide\tm1_ide\config and create the text file servers.json in notepad++
Enter below text, and adjust it to your ip number to your TM1 server, and the user and password to use.
TM1 IDE has been replaced by vscode-tm1, a Visual Studio Code extension for TM1. While many of the ideas from this project have been carried forward into vscode-tm1, this project has been deprecated and will be left here for reference.
Old Description
Still pending official name – for now TM1 IDE will be used. The goal of TM1 IDE is to implement a development environment with a desktop feel for both rules and processes. With the onset of the IBM provided Rest API, there has been a proliferation of web-based editors, but nothing that provides a true native experience for the more traditional developer. This project aims to cut through the feature overload that has become increasingly popular, and provide the average developer with a simple, clean interface that stays out of their way.
How to use
Ensure NodeJS/npm is installed.
Open a shell (Powershell in this example) and run the following after cloning to install project dependencies:
TM1 IDE — The Complete IDE for IBM Planning Analytics / TM1
Author: flameY3T1
TM1 IDE turns VS Code into a full development environment for IBM Planning Analytics / TM1. Write TI processes and rules with real autocomplete and a server-backed compile check, browse and edit cubes and dimensions visually, run MDX, trace process call graphs, test processes without touching your data, and mirror everything to Git — all from one tree, across as many servers as you like.
If you’ve been switching between Architect, PAW, and a text editor, TM1 IDE replaces all three with a single, modern, keyboard-driven workflow. No prior VS Code experience required — this guide gets you running.
Why TM1 IDE
Most TM1 editors stop at “edit a process, push it back.” TM1 IDE goes further:
Visual cube & dimension editing — pivot cubes, write back values, spread, and restructure hierarchies by drag-and-drop. Not just code.
Server compile-check on save — bad code never reaches the server. The save is blocked, not silently broken.
Configurable linter + formatter — per-server rule sets and severities: strict on Prod, relaxed on Sandbox.
Call-graph & references — see the blast radius of a process before you change it.
Git mirror — materialize processes and rules as files, with drift detection and diff.
Fully localized — complete English and German UI.
Getting Started
Step 1 — Install
Open your favorite IDE (VS Code, Kiro, …).
Open Extensions (Ctrl+Shift+X), search for “TM1 IDE”, click Install.
Fully restart the IDE — a window reload is not enough.
A new TM1 Explorer icon appears in the activity bar — your main entry point.
Root cause: PAW validates all logins against one specific TM1 server — the TM1 Login Server — configured in PAW Admin Console → Configuration → TM1 Login Server URI. Users created on any other server are invisible to PAW auth.
Fix shipped:
Added PAW_LOGIN_SERVER to .env and .env.example
All 10 user/group routes in server.js now always target PAW_LOGIN_SERVER regardless of selected workspace server
README updated with new “PAW Login Server” section
V12 note: TM1 Login Server is a V11-only concept. User management in the IDE must be adapter-aware — disabled or routed to IdP on V12/OIDC environments.
2. PAW Architecture — Key Facts
PAW is not a separate user store — in TM1 native auth mode, TM1 }Clients IS the user store
PAW has one designated TM1 Login Server for auth — all logins validated there (V11 only)
PAW discovers TM1 servers via the TM1 Admin Host (port 5895 HTTP / 5898 HTTPS) — a separate service acting as a server registry. TM1 servers register themselves on startup
PAW V12 replaces the TM1 Login Server concept with OIDC — identity comes from the IdP, not }Clients
The TM1 Login Server constraint is V11-only
Admin Host discovery API (direct, reliable):
GET http://{adminhost}:5895/api/v1/Servers
GET https://{adminhost}:5898/api/v1/Servers
Included in the IBM Postman collection but explicitly noted as “not exposed through the PAW proxy”. Do not depend on this without testing on your instance. tm1_paw_tree documents: “PAW has no endpoint to list TM1 server names”.
3. Arc vs Our IDE — Connection Model
Arc connects directly to TM1 via the Admin Host, bypassing PAW entirely. For IBM Cloud / AWS, Arc uses IBM IAM API keys → Bearer tokens — direct Admin Host is blocked by cloud firewalls.
Key discovery: the TM1 OData path suffix is identical across all deployment types:
Only the auth mechanism, base URL, and PAW API version prefix change. Our existing PAW-proxy architecture is the right shape — it just needs pluggable auth underneath.
by Roger·Comments Off on How edit text in excel cell
Product:
Planning Analytics 2.1.19 for excel
Microsoft Windows 2022 server
Issue:
In a PAFE (PAX) report where a cell have a formula with @DBRW the cell is not updateable, you have to write the full value again. Is there a way to edit the text in a cell without destroying the formula?
Solution:
Place the cursor in the cell to update.
In Excel press F2 followed by F9 and then edit text in cell, press enter when done.
If you publish the excel report to TM1WEB, then in TM1WEB you can edit the cell direct and the values are stored in the cube.
The wusa usage to quietly uninstall an update has been deprecated. The uninstall command with /quiet switch fails with event ID 8 in the Setup event log. Uninstalling updates quietly could be a security risk because malicious software could quietly uninstall an update in the background without user intervention.
Issue around Microsoft’s June 9th, 2026 cumulative Windows update that Microsoft is working to address. This patch has caused an error with a component that prevents the opening of word documents in CDM. Issue
When users attempt to open Word Objects or Generate Reports in CDM the following error is displayed: “The content of the file is corrupted.”
Root Cause
This issue is caused by an unanticipated change introduced in. Below is a list of the affected updates:
KB5094127 (Windows 10 version 21H2 and 22H2)
KB5093998 (Windows 11 version 23H2)
KB5094126 (Windows 11 version 24H2 and 25H2)
KB5095051 (Windows 11 version 26H1)
For instances where the CDM client may be published in Citrix (Office is on the Server):
KB5094042 (Windows Server 2012)
KB5094122 (Windows Server 2016)
KB5094123 (Windows Server 2019)
KB5094128 (Windows Server 2022)
KB5094125 (Windows Server 2025)
Solution
NOTE: Microsoft has acknowledged the issue was caused by the Microsoft June 9th update and they are also working on a resolution (as mentioned in the “Known issues with this release” section of the affected KBs above) and will be included in a future Windows update.
Additionally, the CDM team has identified the component in conflict with the update and are working hard in attempt to resolve the issue given the critical nature and its impact to our customers, coupled with the lack of a timeline on the update from Microsoft.
We believe the update will be delivered in CDM 26.2.0 (target release early July, 2026). Further updates, including progress and expected timelines, will be communicated as they become available.
.
