Blank Casebook Report Fails: Message 'Database Connection Could Not Be Obtained'

(Doc ID 604375.1)

Last updated on JULY 03, 2014

Applies to:

Oracle Clinical Remote Data Capture Option - Version 4.5.3 and later
Information in this document applies to any platform.
==================================
***Checked for relevance on 28-MAR-2011***
==================================


Symptoms

Blank Casebook Report fails with RS_FAILURE status.

Log file errors are



LOG :
Report: e:\opapps45\oc\RXCDMCRF_L.rep
Logged onto server: S01
Username: OPS$ONE1





MSG MSG-00005:
MSG MSG-00005: In After Parameter Form Trigger
MSG MSG-00005: Java log file : \\<serverName>\replog\j34411.log
MSG MSG-00005: General log file : \\<serverName>\replog\l34411.log
MSG MSG-00005: des type File
MSG MSG-00005: des name e:\opapps45\temp\dummy20080620121910.pdf
MSG MSG-00005: Java working path := e:\opapps45\temp
MSG MSG-00005: Java log file := \\<serverName>\replog\j34411.log
MSG MSG-00005: Java pdf file := e:\opapps45\temp\j34411.pdf
MSG MSG-00005: NLS mode(?) N
MSG MSG-00005: :book_id = 711
MSG MSG-00005: After_paramater_trigger return TRUE
MSG MSG-00005: --------------------------------------------------------
MSG MSG-00005: -----------------------------------------------------------
MSG MSG-00005: Entering Before Report Trigger.............
MSG MSG-00005: Before calling rxc_reporting.ReportMetadataPDF...............
MSG MSG-00005: After calling rxc_reporting.ReportMetadataPDF................
MSG MSG-00005: Calling PATIENTDATREPORT constructors .......................
MSG MSG-00005: Calling Setter Methods....................................
MSG MSG-00005: After Calling Setter Methods............................
MSG MSG-00005: Start Blank PDR generation...........................
MSG MSG-00005: Finish Blank PDR generation..........................
MSG MSG-00005: Graphic Blank Casebook Report ends with failure. error = 1004
MSG MSG-00005: Graphic Blank Casebook Report ends with error : Failed to connect to database.
Please see the java log file for details:   \j34411.log
MSG MSG-00001: Report ending ...
ERR REP-1419: 'beforereport': PL/SQL program aborted.
ERR Error occurred sending Job output to cache

 

j  log  shows:


Fri Jun 20 12:20:17 EDT 2008
Starting Blank PDR...
reportId : 34411
Book Id : 711
Book : NIAS
studyName : STDY1
Patient : null
Pat Pos ID : 0
reportMode : 2
prodMode : P
dateFormat : STANDARD
loc : \\orc-mt02\replog
tmpFolder : e:\opapps45\temp
Orientation : L
debug : true
Fri Jun 20 12:20:18 EDT 2008
Database connection could not be obtained. Quitting.

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