Error: 'ORA-1422: exact fetch returns more than requested number of rows.' (NETIQKB30504)

  • 7730504
  • 02-Feb-2007
  • 08-Sep-2008

Resolution

fact
VigilEnt Password Manager for Oracle 6.X

fact
VigilEnt Security Agent for Oracle 1.X

symptom
Error: 'ORA-1422: exact fetch returns more than requested number of rows.'

symptom
Error occurs when running the Audit Scanner.

cause
The most common cause of this error indicates that there are 2+ rows in the sqlcqr.sqlcqr_userdata table that have the same name. This can be in the form of multiple templates, multiple users, or a combination of users and templates. Names are considered to be duplicated if they are spelled the same, the case of the letter does not matter. For example, to an Oracle database Scott, SCOTT, and ScOtT are all the same.

fix
To resolve this issue remove all duplicate names.

Additional Information

Formerly known as NETIQKB30504