Batch Data Load Does Not Completely Load Data. (Doc ID 1494269.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical - Version 4.6.0 and later
Information in this document applies to any platform.

Symptoms

You are running the Batch Data Load (BDL) process, but the first row of a Repeating Question Group (RQG) has two columns of data replaced with NULLs.  The actual data file contained valid data which should have shown up in these columns. Two of the uploaded columns were successfully brought in. For the subsequent data targeted for the next five RQG's all of the columns successfully made their way into the RESPONSES table.


Here’s the data which is available but the value for the first two rows gets turned to NULLs before they end up in RESPONSES.

||S6||SCREENING|0|||MEDHX|MEDHX|MEDHX|PCI|CASS_SITE_NUM|0|1|1 - Proximal Right Coronary Artery||01|COREVALVE_SCRN
||S6||SCREENING|0|||MEDHX|MEDHX|MEDHX|PCI|TRT_DT|0|1|20120820||01|COREVALVE_SCRN
||S6||SCREENING|0|||MEDHX|MEDHX|MEDHX|PCI|TRT_TYP|0|1|BMS||01|COREVALVE_SCRN
||S6||SCREENING|0|||MEDHX|MEDHX|MEDHX|PCI|VESSEL_TYP|0|1|Native||01|COREVALVE_SCRN


Query of data inserted into RESPONSES table by BDL process shows the following result:


DCI_NAME DCM_NAME SUBSET_NAME QG_NAME REPEAT_SN QUESTION_NAME OCC_SN RESPONSE_ENTRY_TS VALUE_TEXT EXCEPTION_VALUE_TEXT

MEDHX MEDHX MEDHX PCI 1 CASS_SITE_NUM 0 8/27/2012 19:44 <<<This is where the value is missing it should include '1 - Proximal Right Coronary Artery'
MEDHX MEDHX MEDHX PCI 1 TRT_DT 0 8/27/2012 19:44 <<<This is also missing. Should include '20120820'
MEDHX MEDHX MEDHX PCI 1 TRT_TYP 0 8/27/2012 19:44 BMS
MEDHX MEDHX MEDHX PCI 1 VESSEL_TYP 0 8/27/2012 19:44 Native

ERROR MESSAGES:


You also find the following statements in the output file:

 

Warning: The following questions are in the DCM but are missing in Data File.

BNP
BNP_DT
BNP_TM
CARD_HIST_OTH
CARD_HIST_SP
PRO_BNP

One of the questions noted above occurs in the Data File immediately prior to the data intended for the first RQG.


OCCURRENCE PATTERNS: consistent with only this set of data





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