My Oracle Support Banner

CRF Data Entry : Custom Review Type deactivated. Please retry operation. null (Doc ID 2524271.1)

Last updated on JUNE 20, 2024

Applies to:

Oracle Clinical Remote Data Capture Option - Version 5.2.0 and later
Information in this document applies to any platform.

Symptoms

The following error is raised when clicking on discrepancy tab :


Error
Log code XXXXXX, Custom Review Type deactivated. Please retry operation.null."

 

Issue can occur for one / or multiple CRF(s) .

In above example, the CRF had 2 pages where there are a total of 70 discrepancies generated from a total of 8 Validation Procedures.

So for this one CRF, they have 80 MULTIVARIATE discrepancies of which 70 are CURRENT (10 are OBSOLETE) and these 70 discrepancies have a total of 1230 validated reported values.

 

*OPA_1-diagnostic.log file shows in the error stack based on the Log code, the below SQL Exception :

 

 

Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at
oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:228)

...

...

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.