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 laterInformation 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 |