My Oracle Support Banner

Unable To View 'Discrepancy Review History' ('Custom Review Type deactivated' Error Appears). (Doc ID 3031370.1)

Last updated on JUNE 27, 2024

Applies to:

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

Symptoms

1)
RDC Data Entry Window: the following error appears when trying to view the Discrepancy Review History:

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

i.e.

 

2)
The below error is logged in the 'server_OPA_1-diagnostic.log' log file on the RDC Application Server:

[2024-06-21T05:25:47.749-07:00] [server_OPA_1] [ERROR] [] [oracle.pharma.rdc.de.servlet.RuntimeController]
[tid: [ACTIVE].ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: xxx,0:1]
[APP: olsardc] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: xxxn]  
[8510857133390220] Exception thrown from service while processing command cmdGetDhs with parameters {"discentryid":"126601","id":"cmdGetDhs_0"}

[2024-06-21T05:25:47.749-07:00] [server_OPA_1] [ERROR] [] [oracle.pharma.rdc.de.servlet.RuntimeController]
[tid: [ACTIVE].ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: xx,0:1]
[APP: olsardc] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: xxx]  [6590819915]
[8510857133390220] Exception in RuntimeController,
Reference: xx,null[[
oracle.pharma.rdc.de.exception.FailedOperationException: SQL Exception. Unable to proceed further.
    at oracle.pharma.rdc.de.service.dps.Discrepancy.getRespDataForDiscHist(Discrepancy.java:83)
    at oracle.pharma.rdc.de.service.dps.DataProviderService.getDiscHistForDisc(DataProviderService.java:1138)
    at oracle.pharma.rdc.de.service.dps.DataProviderService.processCommand(DataProviderService.java:251)
.
.
.
Caused by: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "RXC.RDC", line 2113
ORA-06512: at "RXC.RDC_ANCILLARY", line 1192
ORA-06512: at line 1
.
.
.
at oracle.pharma.rdc.de.service.dps.Discrepancy.getRespDataForDiscHist(Discrepancy.java:80)
    ... 45 more
Caused by: Error : 1422, Position : 0, Sql = BEGIN :1  := rdc_ancillary.return_disc_history(:2 , :3 , :4 ) ; END;, OriginalSql = { call ? := rdc_ancillary.return_disc_history(?, ?, ?) }, Error Msg = ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "RXC.RDC", line 2113
ORA-06512: at "RXC.RDC_ANCILLARY", line 1192
ORA-06512: at line 1

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
    ... 61 more

 

3)
FYI: side issue: the error message which appears in the Data Entry Window (in later releases) is not correct. The following internal bug is logged for this:

'Bug 29444980 - Incorrect error msg: 'Custom Review Type deactivated. Please retry operation. null' seen in HTML DE'.

In earlier releases an error like the following would be displayed: 'Error: XMLHttp request failed: xxxx (Servlet error: SQL Exception. Unable to proceed further'.

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.