IBM Support

How to manually/forcibly unlock a data entry form, by directly editing the database table (for example if a Data Entry Form is locked by another user, whose session has crashed)

Troubleshooting


Problem

Customer is receiving messages indicating that a data entry form is locked by another user, but the other user is not actually using the system currently. Is there a method to forcibly remove the lock for that form?

Symptom

Scenario #1:
User1 tries to open a data entry form (for example "Company - Data Entry - Reported Values". User1 receives an error message saying that the form is locked by another user (User2).

The data entry form opens in read-only mode (greyed out) so no data entry can be entered.

However, the system administrator is 100% sure that User2 is no longer using the system (not using that data entry form). For example, User2's session might have crashed during their data-entry session.

Form XXXX for company YYYY and period YYMMAC is locked by another user (USER2). The form will be opened in read-only mode.
 
Scenario #2:
image 2231
Information
Another user has an open data entry form with this account (for the corresponding period/actuality/company and currency)

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3;10.2.1;10.2.0;10.1.1;10.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Cognos Controller

Software version:
10.3, 10.2.1, 10.2.0, 10.1.1, 10.1

Operating system(s):
Windows

Document number:
411007

Modified date:
08 May 2025

UID

swg21453847

Manage My Notification Subscriptions