My Oracle Support Banner

Unable To View The Audit History For A Specific Study (Doc ID 1201426.1)

Last updated on MARCH 08, 2017

Applies to:

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


You wish to review the audit history in RDC Onsite Data Entry. When you click the history tab to review the audit history you receive the following error.


X Error
XMLHttp request failed: 9433348515 (Servlet error: SQL Exception. Unable to proceed further

The error line from the delog0.log file from the application server throws the following:

Caused by: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "RXC.RDC", line 1938
ORA-06512: at "RXC.RDC_ANCILLARY", line 1167
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CCallableStatement.doOall8(
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.execute(
at oracle.jdbc.driver.OracleCallableStatement.execute(
... 12 more

Responsibility: RDC
Base Release/Patchset:

OCCURRENCE PATTERNS: happens intermittently within given studies.

WORKAROUNDS: None available


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

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.