Troubleshooting
Problem
User receives similar errors when using Controller functionality relating to company locks.
Problem is solved by manually clearing some 'bad' data.
- However, problem returns soon afterwards (for example a few hours later).
Symptom
Example #1: Reconcile - Between Accounts/Opening Balances
User runs a reconciliation (to reconcile data):
"The statement has been terminated. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression".
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Example #2: Change Period Locking by Company
If you try to lock a company:
"The statement has been terminated. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression".
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Example #3:
If you try to open the company in 'Command Center' you get this error:
"Something unexpected happened...
[InjectionException] com.sun.xml... Client received SOAP Fault from server:.... Invalid parameter in: <LOCKDATA SETSTATUS = "true"> <LOCK> <COMPANY> ....The statement has been terminated. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression"
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.0","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"}}]
Log InLog in 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 Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
ibm10885642