Unable To Login To RDC Onsite (Doc ID 2376110.1)

Last updated on NOVEMBER 23, 2021

Applies to:

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

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