Import files

RedCap

Job Status

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

Log File


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'