Import files

RedCap

Job Status

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

Log File


03 Mar 2021 02:02:05,460 INFO : Starting to run task 'org.labkey.study.pipeline.StudyReloadSourceTask' at location 'webserver'
03 Mar 2021 02:02:05,460 INFO : Starting REDCap export
03 Mar 2021 02:02:07,872 INFO : Creating study archive
03 Mar 2021 02:02:07,876 INFO : Writing dataset metadata
03 Mar 2021 02:02:07,941 INFO : Creating column lookups
03 Mar 2021 02:02:08,625 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,625 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,625 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,626 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: demographics row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,627 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: emergency_contact_info row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,628 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: baseline_lab_data row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,629 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,630 WARN : Unable to locate subject id field: first_name for dataset: visit_blood_workup row ignored.
03 Mar 2021 02:02:08,631 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,631 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,631 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,641 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,641 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,641 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,641 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,641 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,641 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,641 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_data row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,642 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,643 WARN : Unable to locate subject id field: first_name for dataset: completion_project_questionnaire row ignored.
03 Mar 2021 02:02:08,645 INFO : Finished creating study archive
03 Mar 2021 02:02:08,645 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyReloadSourceTask'
03 Mar 2021 02:02:08,702 INFO : Starting to run task 'org.labkey.study.importer.StudyImportInitialTask' at location 'webserver'
03 Mar 2021 02:02:08,705 INFO : Reloading study from study.xml
03 Mar 2021 02:02:08,713 INFO : Loading top-level study properties (label, start/end date, description, etc.)
03 Mar 2021 02:02:08,763 INFO : Done importing top-level study properties (label, start/end date, description, etc.)
03 Mar 2021 02:02:08,786 INFO : Loading datasets manifest from datasets_manifest.xml
03 Mar 2021 02:02:08,789 INFO : Loading dataset schema from datasets_metadata.xml
03 Mar 2021 02:02:09,599 INFO : Successfully completed task 'org.labkey.study.importer.StudyImportInitialTask'
03 Mar 2021 02:02:09,635 INFO : Starting to run task 'org.labkey.study.pipeline.StudyImportDatasetTask' at location 'webserver'
03 Mar 2021 02:02:09,636 INFO : Start batch RedCap Integration.dataset
03 Mar 2021 02:02:09,679 INFO : demographics: Starting import from dataset001.tsv
03 Mar 2021 02:02:10,021 INFO : demographics: Processed 5 rows from dataset001.tsv
03 Mar 2021 02:02:10,021 INFO : demographics: Deleted 5 rows
03 Mar 2021 02:02:10,021 INFO : demographics: Merged 5 rows
03 Mar 2021 02:02:10,064 INFO : emergency_contact_info: Starting import from dataset002.tsv
03 Mar 2021 02:02:10,314 INFO : emergency_contact_info: Processed 5 rows from dataset002.tsv
03 Mar 2021 02:02:10,314 INFO : emergency_contact_info: Deleted 5 rows
03 Mar 2021 02:02:10,314 INFO : emergency_contact_info: Merged 5 rows
03 Mar 2021 02:02:10,340 INFO : baseline_lab_data: Starting import from dataset003.tsv
03 Mar 2021 02:02:10,547 INFO : baseline_lab_data: Processed 5 rows from dataset003.tsv
03 Mar 2021 02:02:10,547 INFO : baseline_lab_data: Deleted 5 rows
03 Mar 2021 02:02:10,547 INFO : baseline_lab_data: Merged 5 rows
03 Mar 2021 02:02:10,576 INFO : visit_blood_workup: Starting import from dataset004.tsv
03 Mar 2021 02:02:10,643 INFO : completion_data: Starting import from dataset005.tsv
03 Mar 2021 02:02:10,721 INFO : completion_project_questionnaire: Starting import from dataset006.tsv
03 Mar 2021 02:02:10,765 INFO : Finish batch RedCap Integration.dataset
03 Mar 2021 02:02:10,770 INFO : Updating participant visits
03 Mar 2021 02:02:10,770 INFO : Updating participants
03 Mar 2021 02:02:10,775 INFO : Updating participant visit table
03 Mar 2021 02:02:10,828 INFO : Updating visit table
03 Mar 2021 02:02:10,831 INFO : Updating cohorts
03 Mar 2021 02:02:10,831 INFO : Clearing participant visit caches
03 Mar 2021 02:02:10,833 INFO : Finished updating participants
03 Mar 2021 02:02:10,834 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyImportDatasetTask'
03 Mar 2021 02:02:10,869 INFO : Starting to run task 'org.labkey.study.pipeline.StudyImportSpecimenTask' at location 'webserver'
03 Mar 2021 02:02:10,872 INFO : Successfully completed task 'org.labkey.study.pipeline.StudyImportSpecimenTask'
03 Mar 2021 02:02:10,928 INFO : Starting to run task 'org.labkey.study.importer.StudyImportFinalTask' at location 'webserver'
03 Mar 2021 02:02:10,941 INFO : Loading dataset cohort assignments
03 Mar 2021 02:02:10,942 INFO : Done importing dataset cohort assignments
03 Mar 2021 02:02:10,974 INFO : Loading lists
03 Mar 2021 02:02:10,982 INFO : Truncating list: vbw8
03 Mar 2021 02:25:51,797 INFO : Recreating list: vbw8
03 Mar 2021 02:25:51,991 INFO : Truncating list: cpq13
03 Mar 2021 02:25:52,126 INFO : Recreating list: cpq13
03 Mar 2021 02:25:52,216 INFO : Truncating list: sex
03 Mar 2021 02:25:52,310 INFO : Recreating list: sex
03 Mar 2021 02:25:52,376 INFO : Truncating list: withdraw_reason
03 Mar 2021 02:25:52,463 INFO : Recreating list: withdraw_reason
03 Mar 2021 02:25:52,526 INFO : Truncating list: cpq6
03 Mar 2021 02:25:52,611 INFO : Recreating list: cpq6
03 Mar 2021 02:25:52,666 INFO : Truncating list: vbw9
03 Mar 2021 02:25:52,769 INFO : Recreating list: vbw9
03 Mar 2021 02:25:52,832 INFO : Truncating list: cpq8
03 Mar 2021 02:25:52,919 INFO : Recreating list: cpq8
03 Mar 2021 02:25:52,982 INFO : Truncating list: cpq10
03 Mar 2021 02:25:53,075 INFO : Recreating list: cpq10
03 Mar 2021 02:25:53,134 INFO : Truncating list: vbw6
03 Mar 2021 02:25:53,221 INFO : Recreating list: vbw6
03 Mar 2021 02:25:53,276 INFO : Truncating list: cpq11
03 Mar 2021 02:25:53,366 INFO : Recreating list: cpq11
03 Mar 2021 02:25:53,428 INFO : Truncating list: vbw7
03 Mar 2021 02:25:53,520 INFO : Recreating list: vbw7
03 Mar 2021 02:25:53,643 INFO : Merged 5 row(s) into list: withdraw_reason
03 Mar 2021 02:25:53,697 INFO : Merged 3 row(s) into list: cpq13
03 Mar 2021 02:25:53,737 INFO : Merged 6 row(s) into list: cpq11
03 Mar 2021 02:25:53,783 INFO : Merged 4 row(s) into list: cpq10
03 Mar 2021 02:25:53,835 INFO : Merged 2 row(s) into list: sex
03 Mar 2021 02:25:53,887 INFO : Merged 2 row(s) into list: vbw9
03 Mar 2021 02:25:53,931 INFO : Merged 3 row(s) into list: vbw8
03 Mar 2021 02:25:53,975 INFO : Merged 3 row(s) into list: cpq8
03 Mar 2021 02:25:54,017 INFO : Merged 4 row(s) into list: vbw7
03 Mar 2021 02:25:54,068 INFO : Merged 2 row(s) into list: vbw6
03 Mar 2021 02:25:54,108 INFO : Merged 5 row(s) into list: cpq6
03 Mar 2021 02:25:54,112 INFO : 11 lists imported successfully
03 Mar 2021 02:25:54,112 INFO : Done importing lists
03 Mar 2021 02:25:54,126 INFO : Post-processing queries
03 Mar 2021 02:25:54,126 INFO : Skipping query validation.
03 Mar 2021 02:25:54,126 INFO : Done post-processing queries
03 Mar 2021 02:25:54,137 INFO : Successfully completed task 'org.labkey.study.importer.StudyImportFinalTask'