My Oracle Support Banner

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

Last updated on JUNE 06, 2019

Applies to:

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


The following error is raised when clicking on discrepancy tab :

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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(




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

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