Subquery returned more than 1 value. This is not permitted when the subquery follows

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

https://www.ibm.com/support/pages/subquery-returned-more-1-value-not-permitted-when-subquery-follows-or-when-subquery-used-expression-when-trying-lockunlock-any-period-change-period-locking-caused-apar-ph12550

https://www.ibm.com/support/pages/apar/PH20395

https://www.ibm.com/support/pages/how-track-changes-made-users-controller-database-using-system-audit-log-functionality