My Oracle Support Banner

Patient Data Report fails with the '1007' error after applying Patch 5.1.0.74 (Doc ID 2428983.1)

Last updated on MAY 10, 2021

Applies to:

Oracle Clinical - Version 5.1.0 and later
Oracle Clinical Remote Data Capture Option - Version 5.1.0 and later
Information in this document applies to any platform.

Symptoms

i.
Unable to generate a Patient Data Report (PDR) after applying the OC_5.1.0.74 patch ( Patch ID - 26127153 ).


ii.
The below message appears in the PDR log file and there is no error reported as such :

"Form Versions for the DCIs available in this report requires migration/regeneration to enable hyperlinks on superscripts in the CRF. (Note: if the DCI form version for any CRF in the report requires regeneration, return hyperlinks in the Footnotes section are disabled for all CRFs.)".

The log file contains:

1:==> Graphic PDR ends with failure. error = 1007
1:==> Graphic PDR ends with unexpected error. Please see the java log file for details: \\phc-xxx\reports\xyz\j1639977.log
1:==> Report ending ...

The j file contains:

 

Example:

Tue Jun 19 16:25:55 EDT 2018
Starting Graphic PDR...
reportId : <ID>
studyName : <STUDY_NAME>
reportMode : 1
prodMode : P
dateFormat : STANDARD
loc : \\phc-xxx\reports\xyz
tmpFolder : D:\opapps51\temp
logFileName : \\phc-xxx\reports\xyz\j1639977.log
reportQueryId: 0
aud : 1
disc : 1
debug : false
orientation : P
Form Versions for the DCIs available in this report requires migration/regeneration to enable hyperlinks on superscripts in the CRF. (Note: if the DCI form version for any CRF in the report requires regeneration, return hyperlinks in the Footnotes section are disabled for all CRFs.)
Tue Jun 19 16:25:57 EDT 2018
Reading XML Publisher Template for RDCI 294733103 DCI 3998103 Version 6
Tue Jun 19 16:25:57 EDT 2018
Generate: Getting data for RDCI 294733103 DCI 3998103 Book 626003 Version 6 Role DM dateFormat STANDARD prodMode P
Tue Jun 19 16:25:58 EDT 2018
Generating Overflow Section for RDCI/ Blank Crf 2947331031
Tue Jun 19 16:26:02 EDT 2018
Generating Soft Deleted Appendix for Patient R1

 

iii.
There is a 'Regenerating Forms Utility' section  documented in the Patch Readme and this has been implemented.

 

iv.
The 'XMLP_INTERNAL_OBJECTS' table is populated with records / not empty.

 

v.
When an attempt is made to run the 'ocdcitemplate utility' as per the patch readme then the following error is observed (in FULL and INCREMENTAL mode) :

Env:
Report Server being used: %REPORTS_SERVER%
Datebase:<STUDY_NAME>
Username: OPS$xyz
Image Folder path: /crfimages
Image URL path: http://<server name.domain>/opa51/rdc/dcif_images
Html Image URL path: /crfimages
---------------------------------------------------
Note:
For help resolving any failures reported in this log file, refer to the Oracle Clinical guide Creating a Study (create.pdf), the section titled Creating Graphic Layouts, subsection Troubleshooting.
---------------------------------------------------
Start Time 12-JUL-2018 09:18:38
Generating PDR Templates and HTML DE Forms for study: OLSQA
  Generating PDR Template for dci: AE (id : <ID> ) version: 1
  Fatal failure with  - ORA-27369: job of type EXECUTABLE failed with exit code: 127 /opt/app/oracle/ohsapp/xmltemp/convertpdfscript.sh: line 2: java: command n
ORA-06512: at "RXC.OCL_DCIF_XMLP_GENERATOR", line 468
Setting batch jobs status to FAILURE
Possible reasons - Migration failed for a PDR Template or a HTML DE Form Version / Nothing to migrate / Reports server not configured for user
End Time 12-JUL-2018 09:18:43
Navigated to the record.

NOTE :With referenced to the above it was confirmed that path '/opt/app/oracle/ohsapp/xmltemp/' is correct and file convertpdfscript.sh exists.  As well as all the files called in the convertpdfscript.sh, exist under /opt/app/oracle/ohsapp/xmltemp/

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.