My Oracle Support Banner

Unable To Login To RDC Onsite (Doc ID 2376110.1)

Last updated on NOVEMBER 23, 2021

Applies to:

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

Symptoms

ISSUE:
---------
Users can't connect to RDC Onsite.   Users receive the error message "Error In Your Account Setup. Please Contact Your Help Desk. You are successfully logged out. Click here to log in again"
Log files reports the following error stack:

 

Nov 09, 2021 2:03:09 PM oracle.pharma.rdc.model.dataaccess.impl.RdcViewObjectImpl executeQueryForCollection
EXCEPTION: executeQueryForCollection:View Name -> RdcAccessibleStudiesVO1 query ->SELECT * FROM (SELECT study_name, study_title, study_id, study_nls_enabled_flag, isFlexStudy, study_version FROM TABLE(CAST(rdc_zf_stateless_queries.getAccessibleStudies(RDC_ZF_STATE_PARAMS_TYPE(:PROD_TEST_MODE, :USER_NAME, :ROLE, :STUDY_ID, :STUDY_VER, :STUDY, :BOOK_ID, :VISIT_ID,
:PATIENT_ID, :PATIENT, :PATIENT_INITIALS, :PATIENT_SITE, :PATIENT_SITE_ID, :PATIENT_FREEZE_FLAG,
:INVESTIGATOR, :INVESTIGATOR_ID, :SHOW_UNPLANNED, :BOOK_NAME, :VISIT_NAME, :VISIT_NUMBER,
:SUB_EVENT_NUMBER, :SITE_ID, :MAX_ROWS)) as RDC_ACCESSIBLE_STUD_TABLE_TYPE))) QRSLT ORDER BY "STUDY_NAME"
Nov 09, 2021 2:03:09 PM oracle.pharma.rdc.model.dataaccess.impl.RdcViewObjectImpl executeQueryForCollection
EXCEPTION: executeQueryForCollection: Query Parameter -> [P, USER1, ROLE, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 300]
Nov 09, 2021 2:03:09 PM oracle.pharma.rdc.model.dataaccess.impl.RdcViewObjectImpl executeQueryForCollection
EXCEPTION: executeQueryForCollection: noparam -> false
Nov 09, 2021 2:03:09 PM oracle.hsgbu.rdc.srnd.controller.action.LoginCB postLogin
EXCEPTION: <![CDATA[[(No Name)@(No DB):JqgEy2D7HNu2436bzGSs21pK9uuipuKpCA0ndzZ06fRXAAC1y_Sk!1394280580!1636462977275] Install issue!
java.lang.NullPointerException

 

If the following query is executed in SQL*Plus connected as the user, the following errors are reported:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "RXC.RDC_ZF_STATELESS_QUERIES", line 168

 

Changes

 Study is frozen.

 

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.