Graphic PDR Reports fails while Generating the Cover Page (Doc ID 387796.1)

Last updated on NOVEMBER 17, 2011

Applies to:

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

Symptoms

The execution of the PDR report in graphic mode ends with failure.

The PDR report fails while generating the cover page.

These are the specific symptoms of the problem:

- Reports queue manager displays the standard error rep-1825 for the PDR job:


Terminated with Error :
BACKGROUND is deprecated. See help for more information. MSG-00010: 328900: SRW.RUN_REPORT failed.
Updating faiulre text. REP-1825: Before Report trigger returned FALSE.



- When PDR debug is enabled only the lxxxx.log file is created. The file shows the following:


MSG MSG-00005: Distinct_rpt_id =
MSG MSG-00005: rxcdmlpd: entering "after paramater form trigger"
MSG MSG-00005: PDF_MODE = Y
MSG MSG-00005: Distinct_rpt_id = 1488
MSG MSG-00005: INT_PDR_SUBTYPE = UNDEFINED
MSG MSG-00005: ---------------------------------------
MSG MSG-00005: generateCoverPage:
MSG MSG-00005: pdr cover batch file name := D:\Oracle\opapps45\temp\pdr_cover_GCPOCT_270994.bat
MSG MSG-00005: about to submit a batch job to generate the cover page
MSG MSG-00005: checkFileValidity := D:\Oracle\opapps45\temp\h270994.pdf
MSG MSG-00005: could not generate the cover page. Exiting...
MSG MSG-00001: Report ending ...
ERR REP-1419: 'afterreport': PL/SQL program aborted.


- Execution of the bat file that generates the cover page does not produce any pdf output file.

Since the PDR report fails in the generation of the cover page you will be able to find the bat file that generates the cover page. The file name is c:\opapps45\temp\pdr_cover_server_jobid.bat.

 

An attempt to manually execute this bat file from a command line prompt (as noted below) will not generate the corresponding cover page.

Manual Execution from Command Line Prompt:


rwrun REPORT=test paramform=NO printjob=NO pdfcomp=YES ORIENTATION=Portrait desformat=PDF
destype=FILE desname="test_out.pdf" USERID="username/pwd@db_string"


File test_out.pdf is not created.

Instead a reports.log file will be created with the following messages, and no errors at all will be registered in the file:


MSG-00005: Distinct_rpt_id =
MSG-00005: rxcdmlpd: entering "after paramater form trigger"
MSG-00005: PDF_MODE = Y
MSG-00005: Distinct_rpt_id =
MSG-00005: INT_PDR_SUBTYPE = HEADER
MSG-00005: DATE DISPLAY FORMAT (COMING) =
MSG-00005: DATE DISPLAY FORMAT (DATABASE DEFAULT) = STANDARD
MSG-00005: DATE_TIME DISPLAY = DD-MON-YYYY HH24:MI:SS
MSG-00005: subquery_id = 0
MSG-00005: Test/Prod mode = P
MSG-00005: NLS/ENG mode = NON-NLS
MSG-00005: Customized Boilers := N
MSG-00005: before get_subquery
MSG-00005: After_paramater_trigger return TRUE

 

The execution of the reports test report did not generate any output file:

Go to directory:
c:\oracle\10g\samples\demo


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