Patient Data Report fails with the '1007' error after applying Patch 5.1.0.74
(Doc ID 2428983.1)
Last updated on APRIL 01, 2022
Applies to:
Oracle Clinical - Version 5.1.0 and laterOracle 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 '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
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) :
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 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/'.
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 |