My Oracle Support Banner

"Reset User" In Argus Safety Sometimes Does Not Work - "too Many Rows" Error Message In SQLTimes (Doc ID 2041738.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 7.0.2 and later
Information in this document applies to any platform.

Symptoms

Intermittently the following error is observed in SQLTimes when a user session is reset from User Login List:

SQL execution error, ORA-20004: ORA-20004: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "ARGUS_APP.GSS", line 1974
ORA-06512: at line 1

The only way to reset the user session is to have the user themselves log out.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.