Product:
Cognos Controller 10.4.2
CONTRL_UPDATE_version=CCR-AW64-ML-RTM-10.4.2000.1063-0
Microsoft Windows 2019 server
Issue:
You try to unlock a company in Cognos Controller. You get a error message:
“Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression”
Workaround:
Delete the entire contents of the temporary table ‘sactrlinfo’.
Delete FROM [CCR_UKFPM].[fastnet].[sactrlinfo]
or
Disable the system audit log functionality entirely.
Go to Maintain – System Audit Log – Configuration and deselect:
“Enable tracking of structure change details for System Audit Log > Structures”
“Enable tracking of data change details for Audit Trail”
More information:
https://www.ibm.com/support/pages/node/883764
https://www.ibm.com/support/pages/node/375041
https://www.ibm.com/support/pages/node/960392