Import files

RedCap

Job Status

Created: 2021-03-10 02:02
Modified: 2021-03-10 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-10_02-02-05.log
Files: study_reload_source_2021-03-10_02-02-05.log

Log File


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'