My Oracle Support Banner

RXASTMQC Creating A New Study Throws: Ora-1422: Exact Fetch Returns Too Many Rows (Doc ID 261149.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Clinical - Version to 4.5.3 [Release 4.0.0 to 4.5.3]
Information in this document applies to any platform.
This problem can occur on any platform.
RXASTMQC - Easy Study Design


After defining the Study Details in Easy Study Design,

Open OC Design > Study > Easy Study Design.
Choosing study name, project, program code, and so on...

you attempt to save the study pressing F10 or by clicking the [Save] button then the error message is displayed at the bottom left of the screen:

ORA-01422: Exact fetch returns too many rows


To check for duplicates which could cause this problem do the following. Run the following query from
a sqlplus session against this database as the RXC user:

If this returns more than on key template with the same name you are experiencing this issue.

Next confirm if one of these duplicate names has been set as the default KEY_TEMPLATE
entry under

NAV: OC:  Admin >  Reference Codelists >  Installation Codelists >  F7 to Enter a query
   > Query the codelist named 'DX_CONFIG' > Check the value entry for KEY_TEMPLATE.




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

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