'ERROR' Appears When Clicking On The 'Case Books > Search' [GO] Button.

(Doc ID 726112.1)

Last updated on DECEMBER 13, 2011

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.5.3 to 4.6.0 - Release: 4.5 to 4.6
z*OBSOLETE: Microsoft Windows Server 2003 R2 (32-bit)
***Checked for relevance on 11-OCT-2010***

Symptoms

RDC 4.6

The following error :

'Error'
RDC has encountered an unexpected error. Please logout and try again. If the problem persists, please contact your help desk

appears when going to the Casebooks tab > entering some search parameters and pressing the [GO] button. In this scenario CRFs which have been Verified or Approved would get returned in the Search.

The following error appears in the 'log.xml' file

<MSG_TEXT>&lt;![CDATA[error in onMultiPatientCaseBook method!
oracle.jbo.SQLStmtException: JBO-27122: Erreur SQL lors de la préparation d'une instruction. Instruction : SELECT PATIENT_POSITION_ID
, RECEIVED_DCI_ID
, CRF_ICON
, DOCUMENT_NUMBER
, SHORT_NAME
, DCI_NAME
, VISIT_NUMBER
, VISIT_NAME
, PAGE_NUMBER
, SUBEVENT_NUMBER
, DCI_BOOK_NAME
, DCI_BOOK_ID
, DISPLAY_SN
, CLIN_PLAN_EVE_ID
, DCI_ID
, DCI_VERSION_SN
, INVESTIGATOR_ID
, INVESTIGATOR
, DATA_LOCK_FLAG
, RECEIVED_DCI_STATUS_CODE
, SITE_ID
, DCI_HTML_GEN_TSMP
FROM TABLE(rdc_zf_mpcasebook.getCRFDetails( RDC_ZF_SEARCH_PARAMS_TYPE(
:STUDY_ID
,:SITE_ID
,:DCI_BOOK_ID
,:PATIENT_FROM
,:PATIENT_TO
,:VISIT_ID
,:DCI_ID
,:APPROVAL_STATUS
,:VERIFICATION_STATUS
,:PATIENT_BOOK_ID
,:CRF_ENTRY_STATUS
,:PAT_DISC_STATUS
,:CRF_DISC_STATUS
,:DISC_STATUS
,:PATIENT_ENTRY_STATUS
,:PATIENT_LIST
,:CRF_LIST
,:IS_CRF_SEARCH_SELECTED
,:IS_SNOW_BIRD
,:LANGUAGE
,:GRAPHIC_CONTENT
,:REPORTED_PATIENT_REFERENCE
,:FLEX_STUDY_ENABLED_FLAG)))
at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:775)
at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:548)
at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3354)
at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:667)
etc

## Detail 0 ##
java.sql.SQLException: ORA-01843: ce n'est pas un mois valide
ORA-06512: à "RXC.RDC", ligne 351
ORA-06512: à "RXC.RDC_ZF_MPCASEBOOK", ligne 1509



 

RDC 4.5.3

'Error' appears in red when going to the Casebooks tab > entering some search parameters and pressing the [GO] button.

The following error appears in the debug log file (even though the Locale is set to say 'English (United States) in 'Control Panel > Regional Settings on the 4.5.3 web server ) :

<![CDATA[oracle.jbo.SQLStmtException: JBO-27122: Error SQL durante la preparaci�n de la
sentencia.

## Detail 0 ##
java.sql.SQLException: ORA-01843: not a valid month
ORA-06512: at "RXC.PKGGLOBAL", line 10
ORA-06512: at "RXC.DCCOMMON", line 7
ORA-06512: at "RXC.DCDCIVERSIONSN", line 80
ORA-06512: at line 1
ORA-06512: at "RXC.RDC_ZF_MPCASEBOOK", line 1271



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms