My Oracle Support Banner

ORA-01403 No Data Found Error In RDC Classic When Site Is Not Specified For Studies With Large Sites/Patients (Doc ID 1356022.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version: 4.5.0.59 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

Symptoms

When accessing a study which has a large number of sites and/or patients in RDC Classic, if the site number is not specified, the following errors are presented and no data is returned:

ERRORS
----------
ORA-01403: no data found

FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502

-- Steps to Reproduce --

1. Log-in to RDC Classic
2. Chose Study
3. Leave Default for all Sites
4. After several seconds receive error - ORA-01403: no data found
4. Select OK
5. No data returned in grid
6. Select Search from search and select a specific site
7. Data for Site is returned

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
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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