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

Last updated on MAY 12, 2009

Applies to:

Oracle Clinical - Version: 4.0.3 to 4.5.3
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms