Error: 'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, (NETIQKB52821)

  • 7752821
  • 02-Feb-2007
  • 23-Oct-2007

Resolution

fact
Security Manager 5.5

symptom
Error: 'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.'

symptom
Error encountered in eeaupgradetables.sql script during upgrade.

symptom
Error executing SQL Statement in database OnePoint.

cause
The upgrade script does not make a distinction between the agent global persistence maxfilesize and the central computer global persistence maxfilesize.

fix

If at any time a change was made to the global settings for both the central computer and agent temporary storage, then the upgrade will not complete correctly.  To determine whether someone modified the maxfilesize, run the following query on the OnePoint database.  If this query returns more than one entry, then the upgrade will fail.

use onepoint
select * from configuration where idcomputer is NULL and datacategory='persistence' and dataname='maxfilesize'

To remove the entry for the agent global setting, run one of the following queries on the OnePoint database and then re-attempt the upgrade.

For SM 5.0 to 5.5 upgrade, run the following SQL query:

use onepoint
delete from configuration where idcomputer is NULL and datacategory='persistence' and dataname='maxfilesize' and idcomponent='{50CB9CA0-E283-4190-A5A2-99E8474922FF}'

For SM 5.1 to 5.5 upgrade, run the following SQL query:

use onepoint
delete from configuration where idcomputer is NULL and datacategory='persistence' and dataname='maxfilesize' and idcomponent='{9802F715-7968-42F6-B3C0-01EF55DC9DA2}'



Additional Information

Formerly known as NETIQKB52821