Oracle® Clinical Remote Data Capture Onsite Administrator's Guide Release 4.6.2 Part Number E18823-01 |
|
|
View PDF |
In the RDC Onsite application, you can use the Reports page to define report parameters, and generate Patient Data Reports and Blank Casebook Reports. In addition, RDC Onsite includes a DOS command-line interface for generating either a Patient Data Report or a Blank Casebook Report from the command line.
Generating reports from the command line can be useful when producing electronic submissions for new drug applications (NDAs). Adding the commands to a batch file lets you generate many Patient Data Reports at once.
This chapter includes the following topics:
For every desktop where a user must be able to generate Patient Data Reports or Blank Casebook Reports from the command line, you must:
Install the Java Runtime Environment (JRE)
Copy the desktoppdr folder and files to the appropriate location on each desktop
Copy the xdo.cfg file to the JRE installation folder, and then modify the file to define the location of the PC's Windows directory
Edit settings in the RunPDR.cmd file and the RunBlankCasebook.cmd file to configure the user's environment
During the installation of Oracle Clinical, the system creates a desktoppdr folder in the installation directory.
The desktoppdr folder has the following files:
charsets.jar, olsablankpdr.jar, and olsapdr.jar — Java ARchive (JAR) files containing the required class files for generating Patient Data Reports and Blank Casebook Reports.
RunBlankCasebook.cmd — Command file used to generate a Blank Casebook Report from the command line.
RunPDR.cmd — Command file used to generate a Patient Data Report from the command line.
xdo.cfg — Configuration file with information about the Arial font generation in the reports.
Figure 13-1 Sample PC Desktop Showing the desktoppdr Folder
You must install the Java Runtime Environment (JRE) onto the PC desktop if it is not already installed.
The desktop PDR supports Java SE 6 Update 17 (Standard Edition, Version 1.6.0.17) or later.
You can download the current JRE from the Oracle Web site at this URL:
http://www.oracle.com/technetwork/java/javase/downloads/index.html
Copy the desktoppdr folder and its files to the RDC directory on your PC desktop. For example:
C:\opapps46\rdc
In addition, you need to copy the xdo.cfg file from the desktoppdr folder to the directory where you installed the JRE. For more information, see Section 13.1.4, "Copying and Modifying the xdo.cfg File."
The xdo.cfg file stores system information about the Arial font, which is the font used by the Patient Data Report and the Blank Casebook Report.
During the installation of the Reports Server component of Oracle Clinical, the system automatically creates and copies the xdo.cfg file to the following location:
RS_Install_Directory/jdk/jre/lib
In addition, any PC that will be used to generate reports from the command line must have a copy of the xdo.cfg file in the JRE installation directory on the desktop. You must also edit the file to define the location of the Windows directory.
To copy and modify the xdo.cfg file:
Copy the xdo.cfg file to the following directory where you installed the JRE on your PC desktop:
JRE_Install_Directory/jdk/jre/lib
Open the xdo.cfg file with a text editor.
Locate the following two lines in the file:
<truetype path="%OUI_WIN_DIR%\fonts\Arial.ttf" />
<truetype path="%OUI_WIN_DIR%\fonts\arialbd.ttf" />
Replace each occurrence of the %OUI_WIN_DIR% variable with the location of the Windows directory on your PC.
For example:
<truetype path="C:\WINDOWS\fonts\Arial.ttf" />
To modify the RunPDR.cmd file:
Navigate to the desktoppdr folder on your PC.
Open the RunPDR.cmd file with a text editor.
Modify the following lines in the file:
set JAVA_CMD to the directory path where you installed the JRE. For example:
set JAVA_CMD=C:\Progra~1\Java\jre\bin\java
set JAR_PATH to the directory path where you installed the JAR files (charsets.jar, olsapdr.jar, and olsablankpdr.jar). For example:
set JAR_PATH=C:\OLSAPDR
set DB_CONNECT_STRING in the following format to specify the database connection:
host-name
:port-number
:database-sid
For example, if you have a database with sid, proddb, that is installed on the prodserver host machine at port number 1532, then you define your database connection string as follow:
set DB_CONNECTION=prodserver:1532:proddb
In the command line, add the -Xms and the -Xmx options to set the initial and maximum amount of memory for the report generation. For example:
%JAVA_CMD% -classpath %CLASSPATH% -Xms64M -Xmx512M %JAV…
For more information on these options, see Section 13.1.7, "Adjusting the Heap Size for the Java Virtual Machine (JVM)."
Save your changes.
Copy and rename the RunPDR.cmd file for every database that your users need to connect to and access. For example, if your users need to connect to a production database and a test database, create the following two new files: RunPDRprod.cmd and RunPDRtest.cmd.
Open each copy of the RunPDR.cmd file.
Modify the set DB_CONNECT_STRING parameter for each database connection.
Save your changes.
To modify the RunBlankCasebook.cmd file:
Navigate to the desktoppdr folder on your PC.
Open the RunBlankCasebook.cmd file with a text editor.
Modify the following lines in the file:
set JAVA_CMD to the directory path where you installed the JRE. For example:
set JAVA_CMD=C:\Progra~1\Java\jre\bin\java
set JAR_PATH to the directory path where you installed the JAR files (charsets.jar, olsapdr.jar, and olsablankpdr.jar). For example:
set JAR_PATH=C:\OLSAPDR
Use the following lines to specify the database connection:
set HOST=
host-name
set PORT=
port-number
set SID=
database-sid
In the command line, add the -Xms and the -Xmx options to set the initial and maximum amount of memory for the report generation. For example:
%JAVA_CMD% -classpath %CLASSPATH% -Xms64M -Xmx512M %JAV…
For more information on these options, see Section 13.1.7, "Adjusting the Heap Size for the Java Virtual Machine (JVM)."
Save your changes.
Copy and rename the RunBlankCasebook.cmd file for every database that your users need to connect to and access. For example, if your users need to connect to a production database and a test database, create the following two new files:
RunBlankCasebookprod.cmd
RunBlankCasebooktest.cmd
Open each copy of the RunBlankCasebook.cmd file.
Modify the set HOST, set PORT, and set SID parameters for each database connection.
Save your changes.
Report generation may fail with an OutOfMemoryError message. This failure occurs when the Java program needs more memory than the amount currently allocated. As the number of pages in the Patient Data Reports and the Blank Casebook Reports increases, you may need to increase the JVM heap size accordingly.
To support large reports, use the following JVM options to specify the heap size:
Use the -Xms option to set the initial amount of memory allocated for the program.
Use the -Xmx option to set the maximum amount of memory that can be allocated for the program.
As a benchmark, Oracle has successfully generated a 4000-page report with an allocation of 512M.
To adjust the heap size available for reports generated from the command line, you need to modify the RunPDR.cmd file (for Patient Data Reports) and the RunBlankCasebook.cmd file (for Blank Casebook Reports).
To adjust the heap size in the files:
Open the RunPDR.cmd file or the RunBlankCasebook.cmd file.
Locate the following line in the file:
%JAVA_CMD% -classpath %CLASSPATH% …
Add the -Xms and -Xmx options to the line. For example:
%JAVA_CMD% -classpath %CLASSPATH% -Xms64M -Xmx512M %JAVA…
Substitute the 64M value for the initial amount of memory to allocate, and the 512M value for the maximum amount of memory to allocate.
Save your changes.
You can adjust the heap size available to reports generated from either the RDC Onsite or the Oracle Clinical application.
To adjust the heap size on the Reports Server:
Log in to Oracle Enterprise Manager 10g Application Server Control.
Click the name of the Reports Server (for example, oclw2k36) in the System Components table.
Click the Configuration link in the Administration section. The system opens the Configuration page and displays the Reports Engine Parameters section.
Description of the illustration pdr_heapsize01.gif
Click the JVM Option field. Set the appropriate values for the JVM heap size options as follows:
-Xms64M -Xmx512M
Substitute the 64M value for the initial amount of memory to allocate, and the 512M value for the maximum amount of memory to allocate.
Click OK to save your changes. The system prompts for confirmation to restart the Reports Server now.
Click Yes. You must restart the Reports Server before your changes to the JVM heap size will take effect.
When the system confirms that the Reports Server has been restarted, click OK.
You can generate a Patient Data Report by issuing the RunPDR command from the Microsoft Windows command line.
You enter the RunPDR command in the following format:
RunPDR.cmd -st study [-si study_site] [-p patient] [-bk DCI_Book] -l folder_location -u user [-pw password] [-aud] [-disc] [-debug] [-trace] [-nobm] [-o orientation] [-test]
To display the syntax for the command:
Type RunPDR on the command line.
Press Enter.
Table 13-1 describes the required and optional parameters for the RunPDR command.
Table 13-1 Parameters for the RunPDR Command
Parameter | Required? | Description |
---|---|---|
-st study |
Yes |
Runs the Patient Data Report for the specified study. The system produces a separate PDF report file for each patient. |
-si study_site |
No |
Runs a report for all patients currently assigned to the specified study site. If you do not specify a site, the system runs the report for all patients assigned to those study sites that your user role has privileges to access. The system produces a separate PDF report file for each patient. |
-p patient |
No |
Runs a report for the specified patient only. If you do not specify a patient, the system runs a report for all patients in the specified study and sites. |
-bk DCI_Book |
No |
Denotes the DCI Book (casebook) to use for any CRF that was not entered against a casebook. Note that:
|
-l folder_location |
Yes |
Specifies the directory where the system saves the PDF file created for each report, and the log files created during the generation of the report. In addition, the system uses this directory to write the debug information if you include the -debug parameter on the command line. The directory that you specify must already exist. If the directory does not exist, the command fails and displays an error message that the folder is invalid. |
-u user |
Yes |
Specifies your user name for logging in to the Oracle Clinical database. |
-pw password |
No |
Specifies your password for logging in to the Oracle Clinical database. When you use this parameter, your password is visible on the screen. If you do not use this parameter, the system prompts you for your password. Asterisks mask your password as you type it. For security reasons, Oracle recommends that you do not specify your password directly on the command line. |
-aud |
No |
Includes audit information in the report. |
-disc |
No |
Includes discrepancy information in the report. |
-debug |
No |
Leaves data in temporary tables and outputs files to the directory that you specified with the -l folder_location parameter. This data is useful when working with customer support to debug an issue. After you resolve the issue and the debug information is no longer necessary, be sure you truncate the temporary pdr_temp and pdr_superscripts tables. |
-trace |
No |
Turns on database trace and creates a trace file during the execution of the report. Trace data is useful when debugging performance problems. The system saves the trace file in the directory specified in the init.ora file of the database. Check with your database administrator for the location. |
-nobm |
No |
Does not create the bookmarks or a table of contents for the report. |
-o orientation |
No |
Denotes the orientation of the pages in the cover, table of contents, ancillary data sections, and appendixes. Valid entries are:
|
-test |
No |
Runs the report in test mode for test data. The report uses provisional DCI form versions in place of active ones when the provisional versions exist. |
You can generate a Blank Casebook Report by issuing the RunBlankCasebook command from the Microsoft Windows command line.
You enter the RunBlankCasebook command in the following format:
RunBlankCasebook.cmd -st study [-p patient] -bk DCI_Book -l folder_location -u user [-pw password] [-debug] [-trace] [-o orientation]
To display the syntax for the command:
Type RunBlankCasebook on the command line.
Press Enter.
Table 13-2 describes the required and optional parameters for the RunBlankCasebook command.
Table 13-2 Parameters for the RunBlankCasebook Commands
Parameter | Required? | Description |
---|---|---|
-st study |
Yes |
Specifies the name of the study to use for the generated report.
|
-p patient |
No |
Specifies a unique patient number (ID). The system generates a Blank Casebook Report that is specific to the specified patient. |
-bk DCI_Book |
Yes |
Specifies the name of the DCI Book (casebook) to use for the generated report. Note that for a patient-specific report, this value may not match the casebook assigned to the specified patient. |
-l folder_location |
Yes |
Specifies the directory where the system saves the PDF file created for each report, and the log files created during the generation of the report. In addition, the system uses this directory to write the debug information if you include the -debug parameter on the command line. The directory that you specify must already exist. If the directory you specify does not exist, the command fails and displays an error message that the folder is invalid. |
-u user |
Yes |
Specifies your user name for logging in to the Oracle Clinical database. |
-pw password |
No |
Specifies your password for logging in to the Oracle Clinical database. When you use this parameter, your password is visible on the screen. If you do not use the -pw parameter, the system prompts you for your password. Asterisks mask your password as you type it. For security reasons, Oracle recommends that you do not specify your password directly on the command line. |
-debug |
No |
Leaves data in temporary tables and outputs files to the directory that you specified with the -l folder_location parameter. This data is useful when working with customer support to debug an issue. After you resolve the issue and the debug information is no longer necessary, be sure you truncate the temporary pdr_temp and pdr_superscripts tables. |
-trace |
No |
Turns on database trace and creates a trace file during the execution of the report. Trace data is useful when debugging performance problems. The system saves the trace file in the directory specified in the init.ora file of the database. Check with your database administrator for the location. |
-o orientation |
No |
Denotes the orientation of the pages in the cover, table of contents, ancillary data sections, and appendixes. Valid entries are:
|
The output file name for the Patient Data Report and the Blank Casebook Report uses the following format:
crf--STUDY--SITE--PATIENT.pdf
where STUDY, SITE, and PATIENT are the study name, the site ID, and the patient number.
Example: crf--demo2--a9898--b205.pdf
Note:
If you generate a Blank Casebook Report that is not specific to a patient, the PDF file name does not include the site and patient information. In this case, the output file name has this format:crf--STUDY.pdf
About the File Naming Conventions
The file naming conventions follow the PDF specifications defined by the United States Food and drug Administration (FDA).
Use numeric and lowercase alphabetic characters.
Use hyphens.
Avoid using the underscore (_) character.
Note that RDC Onsite uses two hyphens (--) instead of the underscore character to separate the names of the study, site, and patient from each other.
If you use an underscore in the name of the study, site, or patient, RDC Onsite preserves those underscores in the output file name. For example:
crf--demo_alpha--s2244--male_107.pdf
Do not use spaces, punctuation, or other non-alphanumeric symbols (for example, \ / : * ? < > | " % # +).
In addition, these naming conventions comply not only with the FDA guidelines, but also with Image Solutions eCTD Express tool for publishing eSubmissions.