Encountering Core Dump When Executing Batch Validation Session For 1 Study. (Doc ID 729525.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version 4.5.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

CUSTOMER IS TRYING TO: Execute Batch Validation Session (BVS) in Remote Data Capture (RDC) by Site.

LOSS OF FUNCTIONALITY: study execution does not clear up the problem.

ERROR MESSAGES: multiple sources for error messages are excerpted below:
1) log file:


Found line in oratab file for database "OCPR".
echo Code env "451" found in opa_settings for database "OCPR".
echo Database "OCPR" found in oratab.
echo Setting ORACLE_HOME and ORACLE_SID for local database "OCPR"
echo Setting RXC_ROOT
echo ...Done.
sh: 8858 Memory fault(coredump)
se.
Job started.
Database state set to P
Starting 3GL command...
OS User=psub
Exit status of 3GL=139, Pid=8857
Completed with FAILURE status.

2) another log file:

Connected.

database charset = UTF8.
local language = en_US.
global language = en_US.
copy is required = YES.
copy indicator = ~.

study 921 is NOT NLS enabled.

Starting initiate_batch_processing...
Batch Validation for clinical_study_id = 300701
Batch Start: 03-JUN-2008 18:08:52
Last success batch run timestamp for this study is 30-MAY-2008 07:23:36
Batch Validation at 000 for Study 921 owned by 000
Definition cutoff timestamp corresponding to last successful batch run
for this study is: 30-MAY-2008 07:23:36
79 patients with modified data of which 0 have lab mods only.
Number of patients with modified data: 79

DVG, DVG Subset, Thesaurus Resolution
resolving existing dvg errors
de 489124401, resp 12338805903.000000, dvg (49702, 4) val {BID}
Validation error: DVG Value_text = {BID} Exception_value_text = {}
de 488720701, resp 12250528903.000000, dvg (16079202, 1) val {5XQD}
Validation error: DVG Value_text = {5XQD} Exception_value_text = {}
de 488720901, resp 12250536603.000000, dvg (16079302, 1) val {MG}
Validation error: DVG Value_text = {MG} Exception_value_text = {}
de 498226501, resp 12887026403.000000, dvg (16079302, 1) val {tablet}
Validation error: DVG Value_text = {tablet} Exception_value_text = {}
de 488721101, resp 12250539203.000000, dvg (16079302, 1) val {MG}
Validation error: DVG Value_text = {MG} Exception_value_text = {}
Committed DVG revalidation.
resolving existing dvg subset errors
Committed DVG SUBSET revalidation.
Resolving existing thesaurus errors
Committed THESAURUS revalidation.


A good process log file is:

Connecting... Connected.
Batch Start: 05-JUN-2008 22:57:33
Batch Validation at CLINUS04 for Study ORAQA owned by CLINUS04
Number of patients with modified data: 18

DVG, DVG Subset, Thesaurus Resolution
0 DVG discrepancies processed, 0 became obsolete, 0 changed to DVG Subset
0 DVG Subset discrepancies processed, 0 became obsolete
0 Thesaurus Terms discrepancies processed, 0 became obsolete
0 Data Type discrepancies processed, 0 became obsolete
0 Length discrepancies processed, 0 became obsolete

Modified Univariate Validation Resolution
DCM PE, Question BODY_SYSTEM: 0 new, 0 remain current, 0 became obsolete
DCM DATE2D, Question DATE2D: 0 new, 0 remain current, 0 became obsolete
DCM DATE2D, Question DATE4D: 0 new, 0 remain current, 0 became obsolete
DCM DEMOGPDF, Question SEX: 0 new, 0 remain current, 0 became obsolete
DCM DEMOGPDF, Question WEIGHT: 0 new, 0 remain current, 0 became obsolete
DCM DVGTEST-TMS, Question JV_QUESTION_TMS: 0 new, 0 remain current, 0 became obsolete
TMS Thesaurus Validation Execution
calling TMS_OCL_DERV.DERIVATION first time
Processing Complete
Successful TMS Thesaurus Validation

Derivation Procedure Execution
Validation Procedure Execution
Procedure CHECKWT(1), version 0 start time is 05-JUN-2008 22:57:42
Procedure CHECKWT: 3 deleted, 2 new, 0 remain current, 0 became obsolete
Completed procedure CHECKWT at 05-JUN-2008 22:57:43
Procedure CHK_PE(101), version 0 start time is 05-JUN-2008 22:57:44
Procedure CHK_PE: 0 new, 0 remain current, 0 became obsolete
Completed procedure CHK_PE at 05-JUN-2008 22:57:44
Procedure YEARS-PE(201), version 0 start time is 05-JUN-2008 22:57:44
Procedure YEARS-PE: 0 new, 0 remain current, 0 became obsolete
Completed procedure YEARS-PE at 05-JUN-2008 22:57:44

Indicator Question Checks for Patients with modified data
0 new, 0 remain current, 0 became obsolete
TMS Thesaurus Validation Execution
exec_tms_procs second time
Batch Validation completed successfully at 05-JUN-2008 22:57:44.
User also reported: “Comparing this file with the one created by the job 4688871, we can say the
problem happens when the job tries to process Data Type discrepancies (Section DVG, DVG Subset,
Thesaurus Resolution)”


OCCURRENCE PATTERNS: always when attempting to process data in an incorrect format


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