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 4.0.3.49 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

Symptoms

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:

SELECT LONG_VALUE
,TEMPLATE_ID
FROM REFERENCE_CODELIST_VALUES
,TEMPLATES
WHERE REF_CODELIST_NAME = 'DX_CONFIG'
AND REF_CODELIST_VALUE_SHORT_VAL = 'KEY_TEMPLATE'
AND TEMPLATE_TYPE = 'KEY'
AND NAME = LONG_VALUE;


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.

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.