10 Mar 2021 02:02:06,352 INFO : Starting to run task 'org.labkey.study.pipeline.StudyReloadSourceTask' at location 'webserver' 10 Mar 2021 02:02:06,353 INFO : Starting REDCap export 10 Mar 2021 02:02:07,175 INFO : Creating study archive 10 Mar 2021 02:02:07,181 INFO : Writing dataset metadata 10 Mar 2021 02:02:07,283 INFO : Creating column lookups 10 Mar 2021 02:02:07,922 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,923 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,924 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,925 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,926 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,927 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,928 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,929 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,929 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,929 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,929 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,929 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,930 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,931 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,931 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,931 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,931 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,931 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,931 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,931 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 10 Mar 2021 02:02:07,932 INFO : Finished creating study archive 10 Mar 2021 02:02:07,932 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyReloadSourceTask' 10 Mar 2021 02:02:08,023 INFO : Starting to run task 'org.labkey.study.importer.StudyImportInitialTask' at location 'webserver' 10 Mar 2021 02:02:08,027 INFO : Reloading study from study.xml 10 Mar 2021 02:02:08,036 INFO : Loading top-level study properties (label, start/end date, description, etc.) 10 Mar 2021 02:02:08,160 INFO : Done importing top-level study properties (label, start/end date, description, etc.) 10 Mar 2021 02:02:08,197 INFO : Loading datasets manifest from datasets_manifest.xml 10 Mar 2021 02:02:08,199 INFO : Loading dataset schema from datasets_metadata.xml 10 Mar 2021 02:02:09,216 INFO : Successfully completed task 'org.labkey.study.importer.StudyImportInitialTask' 10 Mar 2021 02:02:09,255 INFO : Starting to run task 'org.labkey.study.pipeline.StudyImportDatasetTask' at location 'webserver' 10 Mar 2021 02:02:09,257 INFO : Start batch RedCap Integration.dataset 10 Mar 2021 02:02:09,303 INFO : demographics: Starting import from dataset001.tsv 10 Mar 2021 02:02:09,868 INFO : demographics: Processed 5 rows from dataset001.tsv 10 Mar 2021 02:02:09,868 INFO : demographics: Deleted 5 rows 10 Mar 2021 02:02:09,869 INFO : demographics: Merged 5 rows 10 Mar 2021 02:02:09,898 INFO : emergency_contact_info: Starting import from dataset002.tsv 10 Mar 2021 02:02:10,192 INFO : emergency_contact_info: Processed 5 rows from dataset002.tsv 10 Mar 2021 02:02:10,192 INFO : emergency_contact_info: Deleted 5 rows 10 Mar 2021 02:02:10,192 INFO : emergency_contact_info: Merged 5 rows 10 Mar 2021 02:02:10,225 INFO : baseline_lab_data: Starting import from dataset003.tsv 10 Mar 2021 02:02:10,500 INFO : baseline_lab_data: Processed 5 rows from dataset003.tsv 10 Mar 2021 02:02:10,501 INFO : baseline_lab_data: Deleted 5 rows 10 Mar 2021 02:02:10,501 INFO : baseline_lab_data: Merged 5 rows 10 Mar 2021 02:02:10,529 INFO : visit_blood_workup: Starting import from dataset004.tsv 10 Mar 2021 02:02:10,624 INFO : completion_data: Starting import from dataset005.tsv 10 Mar 2021 02:02:10,701 INFO : completion_project_questionnaire: Starting import from dataset006.tsv 10 Mar 2021 02:02:10,777 INFO : Finish batch RedCap Integration.dataset 10 Mar 2021 02:02:10,782 INFO : Updating participant visits 10 Mar 2021 02:02:10,782 INFO : Updating participants 10 Mar 2021 02:02:10,788 INFO : Updating participant visit table 10 Mar 2021 02:02:10,844 INFO : Updating visit table 10 Mar 2021 02:02:10,848 INFO : Updating cohorts 10 Mar 2021 02:02:10,848 INFO : Clearing participant visit caches 10 Mar 2021 02:02:10,852 INFO : Finished updating participants 10 Mar 2021 02:02:10,852 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyImportDatasetTask' 10 Mar 2021 02:02:10,898 INFO : Starting to run task 'org.labkey.study.pipeline.StudyImportSpecimenTask' at location 'webserver' 10 Mar 2021 02:02:10,911 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyImportSpecimenTask' 10 Mar 2021 02:02:10,959 INFO : Starting to run task 'org.labkey.study.importer.StudyImportFinalTask' at location 'webserver' 10 Mar 2021 02:02:10,976 INFO : Loading dataset cohort assignments 10 Mar 2021 02:02:10,976 INFO : Done importing dataset cohort assignments 10 Mar 2021 02:02:11,017 INFO : Loading lists 10 Mar 2021 02:02:11,019 INFO : Truncating list: vbw8 10 Mar 2021 02:25:40,084 INFO : Recreating list: vbw8 10 Mar 2021 02:25:40,319 INFO : Truncating list: cpq13 10 Mar 2021 02:25:40,457 INFO : Recreating list: cpq13 10 Mar 2021 02:25:40,578 INFO : Truncating list: sex 10 Mar 2021 02:25:40,748 INFO : Recreating list: sex 10 Mar 2021 02:25:40,819 INFO : Truncating list: withdraw_reason 10 Mar 2021 02:25:40,933 INFO : Recreating list: withdraw_reason 10 Mar 2021 02:25:41,019 INFO : Truncating list: cpq6 10 Mar 2021 02:25:41,121 INFO : Recreating list: cpq6 10 Mar 2021 02:25:41,201 INFO : Truncating list: vbw9 10 Mar 2021 02:25:41,299 INFO : Recreating list: vbw9 10 Mar 2021 02:25:41,393 INFO : Truncating list: cpq8 10 Mar 2021 02:25:41,501 INFO : Recreating list: cpq8 10 Mar 2021 02:25:41,586 INFO : Truncating list: cpq10 10 Mar 2021 02:25:41,687 INFO : Recreating list: cpq10 10 Mar 2021 02:25:41,771 INFO : Truncating list: vbw6 10 Mar 2021 02:25:41,876 INFO : Recreating list: vbw6 10 Mar 2021 02:25:41,944 INFO : Truncating list: cpq11 10 Mar 2021 02:25:42,050 INFO : Recreating list: cpq11 10 Mar 2021 02:25:42,140 INFO : Truncating list: vbw7 10 Mar 2021 02:25:42,260 INFO : Recreating list: vbw7 10 Mar 2021 02:25:42,410 INFO : Merged 5 row(s) into list: withdraw_reason 10 Mar 2021 02:25:42,477 INFO : Merged 3 row(s) into list: cpq13 10 Mar 2021 02:25:42,528 INFO : Merged 6 row(s) into list: cpq11 10 Mar 2021 02:25:42,575 INFO : Merged 4 row(s) into list: cpq10 10 Mar 2021 02:25:42,619 INFO : Merged 2 row(s) into list: sex 10 Mar 2021 02:25:42,660 INFO : Merged 2 row(s) into list: vbw9 10 Mar 2021 02:25:42,710 INFO : Merged 3 row(s) into list: vbw8 10 Mar 2021 02:25:42,766 INFO : Merged 3 row(s) into list: cpq8 10 Mar 2021 02:25:42,820 INFO : Merged 4 row(s) into list: vbw7 10 Mar 2021 02:25:42,871 INFO : Merged 5 row(s) into list: cpq6 10 Mar 2021 02:25:42,920 INFO : Merged 2 row(s) into list: vbw6 10 Mar 2021 02:25:42,924 INFO : 11 lists imported successfully 10 Mar 2021 02:25:42,924 INFO : Done importing lists 10 Mar 2021 02:25:42,934 INFO : Post-processing queries 10 Mar 2021 02:25:42,934 INFO : Skipping query validation. 10 Mar 2021 02:25:42,934 INFO : Done post-processing queries 10 Mar 2021 02:25:42,949 INFO : Successfully completed task 'org.labkey.study.importer.StudyImportFinalTask'