Import files

RedCap

Job Status

Created: 2021-03-31 02:02
Modified: 2021-03-31 02:26
Email: jony@labkey.com
Status: COMPLETE
Info:
Description: Import files
File Path: /labkey/labkey/files/home/Demos/RedCap/@files/study_reload_source_2021-03-31_02-02-29.log
Files: study_reload_source_2021-03-31_02-02-29.log

Log File


31 Mar 2021 02:02:29,739 INFO : Starting to run task 'org.labkey.study.pipeline.StudyReloadSourceTask' at location 'webserver'
31 Mar 2021 02:02:29,739 INFO : Starting REDCap export
31 Mar 2021 02:02:30,943 INFO : Creating study archive
31 Mar 2021 02:02:30,950 INFO : Writing dataset metadata
31 Mar 2021 02:02:31,058 INFO : Creating column lookups
31 Mar 2021 02:02:31,769 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,769 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,769 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,769 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,769 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,769 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,769 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,769 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
31 Mar 2021 02:02:31,770 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,771 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,771 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,771 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,784 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,784 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,784 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,784 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,784 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,785 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,786 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,787 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,788 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,788 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,788 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,788 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,788 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,793 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,794 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,796 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,796 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,796 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,797 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,798 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,798 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,798 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,798 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,798 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,798 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,798 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,798 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
31 Mar 2021 02:02:31,803 INFO : Finished creating study archive
31 Mar 2021 02:02:31,803 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyReloadSourceTask'
31 Mar 2021 02:02:31,891 INFO : Starting to run task 'org.labkey.study.importer.StudyImportInitialTask' at location 'webserver'
31 Mar 2021 02:02:31,894 INFO : Reloading study from study.xml
31 Mar 2021 02:02:31,900 INFO : Loading top-level study properties (label, start/end date, description, etc.)
31 Mar 2021 02:02:32,593 INFO : Done importing top-level study properties (label, start/end date, description, etc.)
31 Mar 2021 02:02:32,620 INFO : Loading datasets manifest from datasets_manifest.xml
31 Mar 2021 02:02:32,623 INFO : Loading dataset schema from datasets_metadata.xml
31 Mar 2021 02:02:33,790 INFO : Successfully completed task 'org.labkey.study.importer.StudyImportInitialTask'
31 Mar 2021 02:02:33,828 INFO : Starting to run task 'org.labkey.study.pipeline.StudyImportDatasetTask' at location 'webserver'
31 Mar 2021 02:02:33,830 INFO : Start batch RedCap Integration.dataset
31 Mar 2021 02:02:33,919 INFO : demographics: Starting import from dataset001.tsv
31 Mar 2021 02:02:34,383 INFO : demographics: Processed 5 rows from dataset001.tsv
31 Mar 2021 02:02:34,383 INFO : demographics: Deleted 5 rows
31 Mar 2021 02:02:34,383 INFO : demographics: Merged 5 rows
31 Mar 2021 02:02:34,419 INFO : emergency_contact_info: Starting import from dataset002.tsv
31 Mar 2021 02:02:34,708 INFO : emergency_contact_info: Processed 5 rows from dataset002.tsv
31 Mar 2021 02:02:34,708 INFO : emergency_contact_info: Deleted 5 rows
31 Mar 2021 02:02:34,708 INFO : emergency_contact_info: Merged 5 rows
31 Mar 2021 02:02:34,762 INFO : baseline_lab_data: Starting import from dataset003.tsv
31 Mar 2021 02:02:35,119 INFO : baseline_lab_data: Processed 5 rows from dataset003.tsv
31 Mar 2021 02:02:35,119 INFO : baseline_lab_data: Deleted 5 rows
31 Mar 2021 02:02:35,119 INFO : baseline_lab_data: Merged 5 rows
31 Mar 2021 02:02:35,152 INFO : visit_blood_workup: Starting import from dataset004.tsv
31 Mar 2021 02:02:35,249 INFO : completion_data: Starting import from dataset005.tsv
31 Mar 2021 02:02:35,340 INFO : completion_project_questionnaire: Starting import from dataset006.tsv
31 Mar 2021 02:02:35,440 INFO : Finish batch RedCap Integration.dataset
31 Mar 2021 02:02:35,445 INFO : Updating participant visits
31 Mar 2021 02:02:35,445 INFO : Updating participants
31 Mar 2021 02:02:35,456 INFO : Updating participant visit table
31 Mar 2021 02:02:35,546 INFO : Updating visit table
31 Mar 2021 02:02:35,549 INFO : Updating cohorts
31 Mar 2021 02:02:35,549 INFO : Clearing participant visit caches
31 Mar 2021 02:02:35,551 INFO : Finished updating participants
31 Mar 2021 02:02:35,552 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyImportDatasetTask'
31 Mar 2021 02:02:35,634 INFO : Starting to run task 'org.labkey.api.specimen.pipeline.StudyImportSpecimenTask' at location 'webserver'
31 Mar 2021 02:02:35,634 INFO : Successfully completed task 'org.labkey.api.specimen.pipeline.StudyImportSpecimenTask'
31 Mar 2021 02:02:35,696 INFO : Starting to run task 'org.labkey.study.importer.StudyImportFinalTask' at location 'webserver'
31 Mar 2021 02:02:35,712 INFO : Loading dataset cohort assignments
31 Mar 2021 02:02:35,712 INFO : Done importing dataset cohort assignments
31 Mar 2021 02:02:35,756 INFO : Loading lists
31 Mar 2021 02:02:35,760 INFO : Truncating list: vbw8
31 Mar 2021 02:26:16,156 INFO : Recreating list: vbw8
31 Mar 2021 02:26:16,310 INFO : Truncating list: cpq13
31 Mar 2021 02:26:16,483 INFO : Recreating list: cpq13
31 Mar 2021 02:26:16,546 INFO : Truncating list: sex
31 Mar 2021 02:26:16,630 INFO : Recreating list: sex
31 Mar 2021 02:26:16,693 INFO : Truncating list: withdraw_reason
31 Mar 2021 02:26:16,785 INFO : Recreating list: withdraw_reason
31 Mar 2021 02:26:16,846 INFO : Truncating list: cpq6
31 Mar 2021 02:26:16,932 INFO : Recreating list: cpq6
31 Mar 2021 02:26:16,986 INFO : Truncating list: vbw9
31 Mar 2021 02:26:17,074 INFO : Recreating list: vbw9
31 Mar 2021 02:26:17,133 INFO : Truncating list: cpq8
31 Mar 2021 02:26:17,219 INFO : Recreating list: cpq8
31 Mar 2021 02:26:17,276 INFO : Truncating list: cpq10
31 Mar 2021 02:26:17,359 INFO : Recreating list: cpq10
31 Mar 2021 02:26:17,412 INFO : Truncating list: vbw6
31 Mar 2021 02:26:17,498 INFO : Recreating list: vbw6
31 Mar 2021 02:26:17,555 INFO : Truncating list: cpq11
31 Mar 2021 02:26:17,639 INFO : Recreating list: cpq11
31 Mar 2021 02:26:17,706 INFO : Truncating list: vbw7
31 Mar 2021 02:26:17,791 INFO : Recreating list: vbw7
31 Mar 2021 02:26:17,915 INFO : Merged 5 row(s) into list: withdraw_reason
31 Mar 2021 02:26:17,958 INFO : Merged 3 row(s) into list: cpq13
31 Mar 2021 02:26:17,998 INFO : Merged 6 row(s) into list: cpq11
31 Mar 2021 02:26:18,035 INFO : Merged 4 row(s) into list: cpq10
31 Mar 2021 02:26:18,071 INFO : Merged 2 row(s) into list: sex
31 Mar 2021 02:26:18,110 INFO : Merged 2 row(s) into list: vbw9
31 Mar 2021 02:26:18,150 INFO : Merged 3 row(s) into list: vbw8
31 Mar 2021 02:26:18,189 INFO : Merged 3 row(s) into list: cpq8
31 Mar 2021 02:26:18,224 INFO : Merged 4 row(s) into list: vbw7
31 Mar 2021 02:26:18,262 INFO : Merged 5 row(s) into list: cpq6
31 Mar 2021 02:26:18,300 INFO : Merged 2 row(s) into list: vbw6
31 Mar 2021 02:26:18,304 INFO : 11 lists imported successfully
31 Mar 2021 02:26:18,304 INFO : Done importing lists
31 Mar 2021 02:26:18,316 INFO : Post-processing queries
31 Mar 2021 02:26:18,316 INFO : Skipping query validation.
31 Mar 2021 02:26:18,316 INFO : Done post-processing queries
31 Mar 2021 02:26:18,326 INFO : Successfully completed task 'org.labkey.study.importer.StudyImportFinalTask'