OC Out Of Study Load Failed In Prepare Stage (Doc ID 1482910.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

While attempting to use Batch Data Load in production mode you find an error in the log file indicating that the process is failing in the Prepare Stage with the following error:

ERROR MESSAGES:

***************************************
 Study ------- XXXX885M2301
 Data File ------- GASCOEV1_XXXX885M2301_FILE_0
 OS File Name ---- Not Applicable - OOS
 DF Creation TS - 19-JUL-12 22:23:57
 Mask ID - 2041
***************************************
Prepare started at Fri Jul 20 16:49:34 2012

Setting roll back segment if any specified

Error: The following patient(s) are not valid.

1001002
1001004
.
.
.
1559003
1559005
Max errors reached!

Prepare ended at Fri Jul 20 16:50:30 2012


Error occurred while preparing the data file.
Updating Data_Files with Status: BAD PREPARE.


You also find in the database trace which is run with bind variables the following information. Note specifically the error message:

 

The critical error condition was displayed as follows (some irrelevant information deleted for clarity)

PARSING IN CURSOR #36 len=2115 dep=0 uid=281 oct=6 lid=281 tim=11155609361706 hv=2657888595 ad='492b4cb30' sqlid='8atwzc2g6saam'
update TEMPORARY_BATCH_DCMS tbdcm  set
(INVESTIGATOR,INVESTIGATOR_ID)=
(select (TBDCM.INVESTIGATOR||TO_CHAR(null )) ,TO_NUMBER(null )  
from DUAL
where ( not exists
(select I.INVESTIGATOR_ID
from OCL_INVESTIGATORS I, TEMPORARY_BATCH_DCMS TBDCM
where I.INVESTIGATOR=TBDCM.INVESTIGATOR)
and TBDCM.INVESTIGATOR is  not null )
 
union

select I.INVESTIGATOR ,I.INVESTIGATOR_ID  
from OCL_INVESTIGATORS I
where (I.INVESTIGATOR=TBDCM.INVESTIGATOR and TBDCM.INVESTIGATOR is  not null )

union

select I.INVESTIGATOR ,I.INVESTIGATOR_ID  
from OCL_SITES S
,STUDY_SITE_ROLES R
,OCL_INVESTIGATORS I
,PATIENT_POSITIONS P
,STUDY_SITE_PATIENT_POSITIONS SSPP
where (((((((((((I.INVESTIGATOR_ID=R.INVESTIGATOR_ID and R.CURRENT_FLAG='Y')
      and R.CLINICAL_STUDY_ID=28051)
  and R.SITE_ID=S.SITE_ID) and P.PATIENT=TBDCM.PATIENT)
  and P.CLINICAL_STUDY_ID=28051)
  and P.CLINICAL_STUDY_VERSION_ID=1)
  and P.PATIENT_POSITION_ID=SSPP.PATIENT_POSITION_ID)
  and SSPP.CURRENT_FLAG='Y')
  and SSPP.CLINICAL_STUDY_ID=28051)
  and SSPP.SITE_ID=S.SITE_ID)
  and TBDCM.INVESTIGATOR is null ))
,(SITE,SITE_ID)=(select (TBDCM.SITE||TO_CHAR(null )) ,TO_NUMBER(null )  
from DUAL
where ( not exists (select S.SITE  
                   from OCL_SITES S
where TBDCM.SITE=S.SITE)
and TBDCM.SITE is  not null )
union

select S.SITE ,S.SITE_ID  
from OCL_SITES S
where (TBDCM.SITE=S.SITE and TBDCM.SITE is  not null )

union

select S.SITE ,S.SITE_ID  
from OCL_SITES S
,PATIENT_POSITIONS P
,STUDY_SITE_PATIENT_POSITIONS SSPP
where (((((((P.PATIENT=TBDCM.PATIENT and P.CLINICAL_STUDY_ID=28051)
      and P.CLINICAL_STUDY_VERSION_ID=1)
  and P.PATIENT_POSITION_ID=SSPP.PATIENT_POSITION_ID)
  and SSPP.CURRENT_FLAG='Y')
  and SSPP.CLINICAL_STUDY_ID=28051)
  and SSPP.SITE_ID=S.SITE_ID)
  and TBDCM.SITE is null ))
,patient_position_id=
    (select patient_position_id  
     from patient_positions p
 where ((p.patient=tbdcm.patient and p.clinical_study_id=28051)
         and p.clinical_study_version_id=1))
,(clin_plan_eve_id,visit_number)=(select clin_plan_eve_id ,visit_number  
                                 from clinical_planned_events cp
 where (((cp.name=tbdcm.clin_plan_eve_name
 and cp.clin_study_id=28051)
 and cp.clin_study_version_id=1)
 and cp.clin_plan_eve_type_code='VISIT'))
 where data_file_id=627451
END OF STMT
PARSE #36:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,plh=0,tim=11155609361706

BINDS #36:
Bind#0 value=28051
Bind#1 value=28051
Bind#2 value=1
Bind#3 value=28051
Bind#4 value=28051
Bind#5 value=1
Bind#6 value=28051
Bind#7 value=28051
Bind#8 value=1
Bind#9 value=28051
Bind#10 value=1
Bind#11 value=627451
 
 ERROR #36:err=1427


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