OC Out Of Study Load Failed In Prepare Stage (Doc ID 1482910.1)

Last updated on NOVEMBER 01, 2024

Applies to:

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 ------- <STUDY NAME>
 Data File ------- <DATA FILE NAME>
 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=<UID> oct=6 lid=281 tim=11155609361706 hv=2657888595 ad='492b4cb30' sqlid='<SQL ID>'
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=<STUDY ID>)
  and R.SITE_ID=S.SITE_ID) and P.PATIENT=TBDCM.PATIENT)
  and P.CLINICAL_STUDY_ID=<STUDY ID>)
  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=<STUDY ID>)
  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=<STUDY ID>)
      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=<STUDY ID>)
  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=<STUDY ID>)
         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=<STUDY ID>)
 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.