Patient Data Report fails with the '1007' error after applying Patch 220.127.116.11
(Doc ID 2428983.1)
Last updated on APRIL 01, 2022
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.
Unable to generate a Patient Data Report (PDR) after applying the OC_18.104.22.168 patch ( Patch ID - 26127153 ).
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 'l' 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' log file contains:
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
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
There is a 'Regenerating Forms Utility' section documented in the Patch Readme and this has been implemented.
The 'XMLP_INTERNAL_OBJECTS' table is populated with records / not empty.
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) :
Report Server being used: %REPORTS_SERVER%
Image Folder path: /crfimages
Image URL path: http://<server name.domain>/opa51/rdc/dcif_images
Html Image URL path: /crfimages
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 reference 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/'.
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