26 May 2021 02:01:47,155 INFO : Starting to run task 'org.labkey.study.pipeline.StudyReloadSourceTask' at location 'webserver' 26 May 2021 02:01:47,156 INFO : Starting REDCap export 26 May 2021 02:01:50,443 INFO : Creating study archive 26 May 2021 02:01:50,445 INFO : Writing dataset metadata 26 May 2021 02:01:50,570 INFO : Creating column lookups 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,272 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,273 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,274 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored. 26 May 2021 02:01:51,275 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,276 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,277 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored. 26 May 2021 02:01:51,280 INFO : Finished creating study archive 26 May 2021 02:01:51,280 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyReloadSourceTask' 26 May 2021 02:01:51,370 INFO : Starting to run task 'org.labkey.study.importer.StudyImportInitialTask' at location 'webserver' 26 May 2021 02:01:51,376 INFO : Reloading study from study.xml 26 May 2021 02:01:51,386 INFO : Loading top-level study properties (label, start/end date, description, etc.) 26 May 2021 02:01:51,701 INFO : Done importing top-level study properties (label, start/end date, description, etc.) 26 May 2021 02:01:51,763 INFO : Loading datasets manifest from datasets_manifest.xml 26 May 2021 02:01:51,780 INFO : Loading dataset schema from datasets_metadata.xml 26 May 2021 02:01:52,830 INFO : Successfully completed task 'org.labkey.study.importer.StudyImportInitialTask' 26 May 2021 02:01:52,874 INFO : Starting to run task 'org.labkey.study.pipeline.StudyImportDatasetTask' at location 'webserver' 26 May 2021 02:01:52,875 INFO : Start batch RedCap Integration.dataset 26 May 2021 02:01:52,925 INFO : demographics: Starting import from dataset001.tsv 26 May 2021 02:01:53,284 INFO : demographics: Processed 5 rows from dataset001.tsv 26 May 2021 02:01:53,284 INFO : demographics: Deleted 5 rows 26 May 2021 02:01:53,284 INFO : demographics: Merged 5 rows 26 May 2021 02:01:53,311 INFO : emergency_contact_info: Starting import from dataset002.tsv 26 May 2021 02:01:53,593 INFO : emergency_contact_info: Processed 5 rows from dataset002.tsv 26 May 2021 02:01:53,593 INFO : emergency_contact_info: Deleted 5 rows 26 May 2021 02:01:53,593 INFO : emergency_contact_info: Merged 5 rows 26 May 2021 02:01:53,621 INFO : baseline_lab_data: Starting import from dataset003.tsv 26 May 2021 02:01:53,859 INFO : baseline_lab_data: Processed 5 rows from dataset003.tsv 26 May 2021 02:01:53,859 INFO : baseline_lab_data: Deleted 5 rows 26 May 2021 02:01:53,859 INFO : baseline_lab_data: Merged 5 rows 26 May 2021 02:01:53,887 INFO : visit_blood_workup: Starting import from dataset004.tsv 26 May 2021 02:01:53,980 INFO : completion_data: Starting import from dataset005.tsv 26 May 2021 02:01:54,087 INFO : completion_project_questionnaire: Starting import from dataset006.tsv 26 May 2021 02:01:54,159 INFO : Finish batch RedCap Integration.dataset 26 May 2021 02:01:54,163 INFO : Updating participant visits 26 May 2021 02:01:54,163 INFO : Updating participants 26 May 2021 02:01:54,168 INFO : Updating participant visit table 26 May 2021 02:01:54,263 INFO : Updating visit table 26 May 2021 02:01:54,267 INFO : Updating cohorts 26 May 2021 02:01:54,267 INFO : Clearing participant visit caches 26 May 2021 02:01:54,269 INFO : Finished updating participants 26 May 2021 02:01:54,269 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyImportDatasetTask' 26 May 2021 02:01:54,302 INFO : Starting to run task 'org.labkey.api.specimen.pipeline.StudyImportSpecimenTask' at location 'webserver' 26 May 2021 02:01:54,302 INFO : Successfully completed task 'org.labkey.api.specimen.pipeline.StudyImportSpecimenTask' 26 May 2021 02:01:54,348 INFO : Starting to run task 'org.labkey.study.importer.StudyImportFinalTask' at location 'webserver' 26 May 2021 02:01:54,368 INFO : Loading dataset cohort assignments 26 May 2021 02:01:54,368 INFO : Done importing dataset cohort assignments 26 May 2021 02:01:54,402 INFO : Loading lists 26 May 2021 02:01:54,405 INFO : Truncating list: vbw8 26 May 2021 02:23:50,982 INFO : Recreating list: vbw8 26 May 2021 02:23:51,131 INFO : Truncating list: cpq13 26 May 2021 02:23:51,302 INFO : Recreating list: cpq13 26 May 2021 02:23:51,389 INFO : Truncating list: sex 26 May 2021 02:23:51,489 INFO : Recreating list: sex 26 May 2021 02:23:51,567 INFO : Truncating list: withdraw_reason 26 May 2021 02:23:51,666 INFO : Recreating list: withdraw_reason 26 May 2021 02:23:51,756 INFO : Truncating list: cpq6 26 May 2021 02:23:51,850 INFO : Recreating list: cpq6 26 May 2021 02:23:51,936 INFO : Truncating list: vbw9 26 May 2021 02:23:52,029 INFO : Recreating list: vbw9 26 May 2021 02:23:52,106 INFO : Truncating list: cpq8 26 May 2021 02:23:52,204 INFO : Recreating list: cpq8 26 May 2021 02:23:52,280 INFO : Truncating list: cpq10 26 May 2021 02:23:52,366 INFO : Recreating list: cpq10 26 May 2021 02:23:52,441 INFO : Truncating list: vbw6 26 May 2021 02:23:52,533 INFO : Recreating list: vbw6 26 May 2021 02:23:52,611 INFO : Truncating list: cpq11 26 May 2021 02:23:52,709 INFO : Recreating list: cpq11 26 May 2021 02:23:52,805 INFO : Truncating list: vbw7 26 May 2021 02:23:52,898 INFO : Recreating list: vbw7 26 May 2021 02:23:53,069 INFO : Merged 5 row(s) into list: withdraw_reason 26 May 2021 02:23:53,116 INFO : Merged 3 row(s) into list: cpq13 26 May 2021 02:23:53,170 INFO : Merged 6 row(s) into list: cpq11 26 May 2021 02:23:53,210 INFO : Merged 4 row(s) into list: cpq10 26 May 2021 02:23:53,258 INFO : Merged 2 row(s) into list: sex 26 May 2021 02:23:53,350 INFO : Merged 2 row(s) into list: vbw9 26 May 2021 02:23:53,390 INFO : Merged 3 row(s) into list: vbw8 26 May 2021 02:23:53,466 INFO : Merged 3 row(s) into list: cpq8 26 May 2021 02:23:53,485 INFO : Merged 4 row(s) into list: vbw7 26 May 2021 02:23:53,527 INFO : Merged 5 row(s) into list: cpq6 26 May 2021 02:23:53,577 INFO : Merged 2 row(s) into list: vbw6 26 May 2021 02:23:53,580 INFO : 11 lists imported successfully 26 May 2021 02:23:53,580 INFO : Done importing lists 26 May 2021 02:23:53,586 INFO : Post-processing queries 26 May 2021 02:23:53,586 INFO : Skipping query validation. 26 May 2021 02:23:53,587 INFO : Done post-processing queries 26 May 2021 02:23:53,597 INFO : Successfully completed task 'org.labkey.study.importer.StudyImportFinalTask'