'PdrNoDataException' When Running The 4.5.3 Graphic Patient Data Report.

(Doc ID 549966.1)

Last updated on AUGUST 31, 2011

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.5.3 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.

Symptoms

1.  Unable to run the Graphic Patient Data Report for existing 'PDF' studies after upgrading to 4.5.3.

2.  Log file contains the following messages :

MSG MSG-00005: Graphic PDR ends with error : No CRF data has been entered for the selected visit / patient. Please see the java log file for details: \\jmorton-uk2\repout\sbains\j2310.log
ERR REP-1419: 'beforereport': PL/SQL program aborted.
ERR Error occurred sending Job output to cache


3.  Java log file contains the following error stack :

oracle.pharma.rdc.pdr.PatientDataReport$PdrNoDataException: report will contain no data since PDF
forms do not exist or the CRFs were not entered against a book. Report will not be generated
at oracle.pharma.rdc.pdr.PatientDataReport.generateFull(PatientDataReport.java:1062)
at oracle.pharma.rdc.pdr.PatientDataReport.startPdr(PatientDataReport.java:1719)
at oracle.reports.engine.EngineImpl.CRunReport(Native Method)
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:413)
at oracle.reports.engine.EngineClassPOATie.run(EngineClassPOATie.java:84)
at oracle.reports.engine.EngineClassPOA._invoke(EngineClassPOA.java:117)
at oracle.reports.engine.EngineClassPOA._invoke(EngineClassPOA.java:62)
at com.inprise.vbroker.poa.POAImpl.invoke(POAImpl.java:2355)
at com.inprise.vbroker.poa.ActivationRecord.invoke(ActivationRecord.java:104)
at com.inprise.vbroker.GIOP.GiopProto Adapter.doRequest(GiopProtocolAdapter.java:492)
at com.inprise.vbroker.IIOP.ServerProtocolAdapter.doRequest(ServerProtocolAdapter.java:64)
at com.inprise.vbroker.GIOP.GiopProtocolAdapter.dispatchMessage(GiopProtocolAdapter.java:653)
at com.inprise.vbroker.orb.TPDispatcherImpl$TPDispatcher.run(TPDispatcherImpl.java:99)
at com.inprise.vbroker.orb.ThreadPool$PoolWorker.run(ThreadPool.java:76)

4. The following query returns zero for the XMLP_PDF column where the PDF column is greater than zero (for all records)  : 

SELECT 
 dci_id,
 fl_status,
 nvl(length(PDF),0) PDF ,
 nvl(length(XMLP_PDF),0)  XMLP_PDF
FROM   dci_form_versions 
WHERE clinical_study_id = (SELECT clinical_study_id 
                           FROM clinical_studies 
                           WHERE study=upper('&YourPdfStudy'))
ORDER BY fl_status ;


 

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