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.

Symptoms



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.

ERROR MESSAGES:

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:

at java.lang.Thread.run(Thread.java:534)
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(DatabaseError.java:137)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:183)
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:872)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3000)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3092)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4285)
at oracle.pharma.rdc.de.service.dps.Discrepancy.getRespDataForDiscHist(Discrepancy.java:79)
... 12 more

NAVIGATION / REPLICATION PATH / CONFIGURATION CONTROL:
Responsibility: RDC
Base Release/Patchset: 4.5.1.23.5


OCCURRENCE PATTERNS: happens intermittently within given studies.

WORKAROUNDS: None available


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