Cognos Controller 10.4.2
Microsoft Windows 2019 server
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”
Delete the entire contents of the temporary table ‘sactrlinfo’.
Delete FROM [CCR_UKFPM].[fastnet].[sactrlinfo]
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”