2023-03-16T10:43:16.949+0100 [INFO]: Data distribution worker started
2023-03-16T10:43:16.949+0100 [INFO]: Request id: "data_load_7wGuFLwqou_wgbu4lZSHI:07fyQOfDvZyIqfJK:QoeW4vHm4ytdKrbt"
2023-03-16T10:43:16.949+0100 [INFO]: Data source: "61dfafdd19d0950001b653ea"
2023-03-16T10:43:16.949+0100 [INFO]: Additional parameters: {GDC_DE_SYNCHRONIZE_ALL=true, PROCESS_ID=057c8a93-cc46-4a93-94d1-a62c19b23adb}
2023-03-16T10:43:16.949+0100 [INFO]: Synchronization mode: all mapped datasets (default)
2023-03-16T10:43:24.216+0100 [INFO]: Synchronized datasets: [dataset.departments_sectors, dataset.departments, dataset.user_skill_preferences, dataset.user_learning_pathways, dataset.user_course_durations, dataset.user_course_assignments, dataset.ahoy_visits, dataset.tenants, dataset.user_courses, dataset.categories, dataset.user_exercise_attempts, dataset.roles, dataset.course_lessons, dataset.user_learning_pathway_durations, dataset.organisations, dataset.user_lesson_durations, dataset.sectors, dataset.skills, dataset.learning_pathways, dataset.lessons, dataset.user_lessons, dataset.users, dataset.organisation_users, dataset.courses, dataset.user_course_feedbacks, dataset.course_learning_pathways, dataset.exercise_results]
2023-03-16T10:43:24.217+0100 [INFO]: 

====================== Mapping Validation ======================

Mapping Validation is OK

====================== End of Mapping Validation ======================


2023-03-16T10:43:24.218+0100 [INFO]: 

====================== Output Stage -> LDM mapping ======================


Output Stage table/view: ahoy_visits (full, shared) -> Dataset: dataset.ahoy_visits
latitude[FLOAT8] -> fact.ahoy_visits.latitude{FACT}[DECIMAL(12,2)]
geo_location[VARCHAR(2147483647)] -> label.ahoy_visits.geo_location{LABEL}[VARCHAR(10000)]
ip[VARCHAR(2147483647)] -> label.ahoy_visits.ip{LABEL}[VARCHAR(10000)]
utm_campaign[VARCHAR(2147483647)] -> label.ahoy_visits.utm_campaign{LABEL}[VARCHAR(10000)]
country[VARCHAR(2147483647)] -> label.ahoy_visits.country{LABEL}[VARCHAR(10000)]
referring_domain[VARCHAR(2147483647)] -> label.ahoy_visits.referring_domain{LABEL}[VARCHAR(10000)]
utm_source[VARCHAR(2147483647)] -> label.ahoy_visits.utm_source{LABEL}[VARCHAR(10000)]
app_version[VARCHAR(2147483647)] -> label.ahoy_visits.app_version{LABEL}[VARCHAR(10000)]
browser[VARCHAR(2147483647)] -> label.ahoy_visits.browser{LABEL}[VARCHAR(10000)]
longitude[FLOAT8] -> fact.ahoy_visits.longitude{FACT}[DECIMAL(12,2)]
user_agent[TEXT(2147483647)] -> dataset.users{REFERENCE}[VARCHAR(128)]
id[BIGSERIAL] -> label.ahoy_visits.id{LABEL}[INT]
os[VARCHAR(2147483647)] -> label.ahoy_visits.os{LABEL}[VARCHAR(10000)]
city[VARCHAR(2147483647)] -> label.ahoy_visits.city{LABEL}[VARCHAR(10000)]
os_version[VARCHAR(2147483647)] -> label.ahoy_visits.os_version{LABEL}[VARCHAR(10000)]
visitor_token[VARCHAR(2147483647)] -> label.ahoy_visits.visitor_token{LABEL}[VARCHAR(10000)]
utm_medium[VARCHAR(2147483647)] -> label.ahoy_visits.utm_medium{LABEL}[VARCHAR(10000)]
utm_term[VARCHAR(2147483647)] -> label.ahoy_visits.utm_term{LABEL}[VARCHAR(10000)]
started_at[TIMESTAMP] -> startedat{DATE}[DATE]
user_id[INT8] -> fact.ahoy_visits.user_id{FACT}[INT]
visit_token[VARCHAR(2147483647)] -> label.ahoy_visits.visit_token{LABEL}[VARCHAR(10000)]
device_type[VARCHAR(2147483647)] -> label.ahoy_visits.device_type{LABEL}[VARCHAR(10000)]
referrer[TEXT(2147483647)] -> label.ahoy_visits.referrer{LABEL}[VARCHAR(10000)]
utm_content[VARCHAR(2147483647)] -> label.ahoy_visits.utm_content{LABEL}[VARCHAR(10000)]
platform[VARCHAR(2147483647)] -> label.ahoy_visits.platform{LABEL}[VARCHAR(10000)]
landing_page[TEXT(2147483647)] -> label.ahoy_visits.landing_page{LABEL}[VARCHAR(10000)]
region[VARCHAR(2147483647)] -> label.ahoy_visits.region{LABEL}[VARCHAR(10000)]

Output Stage table/view: categories (full, shared) -> Dataset: dataset.categories
id[SERIAL] -> label.categories.id{LABEL}[VARCHAR(128)]
name[VARCHAR(2147483647)] -> label.categories.name{LABEL}[VARCHAR(10000)]
corporate[BOOL] -> label.categories.corporate{LABEL}[VARCHAR(128)]
organisation_id[INT8] -> dataset.organisations{REFERENCE}[VARCHAR(128)]

Output Stage table/view: course_learning_pathways (full, shared) -> Dataset: dataset.course_learning_pathways
learning_pathway_id[INT4] -> dataset.learning_pathways{REFERENCE}[VARCHAR(128)]
position[INT4] -> fact.course_learning_pathways.position{FACT}[INT]
id[BIGSERIAL] -> label.course_learning_pathways.id{LABEL}[VARCHAR(128)]
course_id[INT4] -> dataset.courses{REFERENCE}[VARCHAR(128)]

Output Stage table/view: course_lessons (full, shared) -> Dataset: dataset.course_lessons
lesson_type[VARCHAR(2147483647)] -> label.course_lessons.lesson_type{LABEL}[VARCHAR(10000)]
position[INT4] -> fact.course_lessons.position{FACT}[INT]
lesson_id[INT4] -> dataset.lessons{REFERENCE}[VARCHAR(128)]
course_id[INT4] -> dataset.courses{REFERENCE}[VARCHAR(128)]
id[BIGSERIAL] -> label.course_lessons.id{LABEL}[VARCHAR(128)]

Output Stage table/view: courses (full, shared) -> Dataset: dataset.courses
access[INT4] -> label.courses.access{LABEL}[INT]
has_strict_lesson_order[BOOL] -> label.courses.has_strict_lesson_order{LABEL}[VARCHAR(128)]
author_id[INT4] -> dataset.users{REFERENCE}[VARCHAR(128)]
complete_type[INT4] -> label.courses.completetype{LABEL}[INT]
corporate[BOOL] -> label.courses.corporate{LABEL}[VARCHAR(128)]
id[SERIAL] -> label.courses.id{LABEL}[VARCHAR(128)]
is_certificate[BOOL] -> label.courses.is_certificate{LABEL}[VARCHAR(128)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
compliance[INT4] -> label.courses.compliance{LABEL}[INT]
deadline[INT4] -> fact.courses.deadline{FACT}[INT]
organisation_id[INT8] -> dataset.organisations{REFERENCE}[VARCHAR(128)]
type[VARCHAR(2147483647)] -> label.courses.type{LABEL}[VARCHAR(10000)]
category_id[INT4] -> dataset.categories{REFERENCE}[VARCHAR(128)]
title[VARCHAR(2147483647)] -> label.courses.title{LABEL}[VARCHAR(10000)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
level[INT4] -> label.courses.level{LABEL}[INT]
published[BOOL] -> label.courses.published{LABEL}[VARCHAR(128)]
status[INT4] -> label.courses.status{LABEL}[INT]

Output Stage table/view: departments (full, shared) -> Dataset: dataset.departments
id[BIGSERIAL] -> label.departments.id{LABEL}[VARCHAR(128)]
name[VARCHAR(2147483647)] -> label.departments.name{LABEL}[VARCHAR(10000)]

Output Stage table/view: departments_sectors (full, shared) -> Dataset: dataset.departments_sectors
department_id[INT8] -> dataset.departments{REFERENCE}[VARCHAR(128)]
sector_id[INT8] -> dataset.sectors{REFERENCE}[VARCHAR(128)]

Output Stage table/view: exercise_results (full, shared) -> Dataset: dataset.exercise_results
course_id[INT4] -> dataset.courses{REFERENCE}[VARCHAR(128)]
total[INT4] -> fact.exercise_results.total{FACT}[INT]
avg_score[INT4] -> fact.exercise_results.avg_score{FACT}[INT]
exercise_id[INT4] -> dataset.lessons{REFERENCE}[VARCHAR(128)]
learning_pathway_id[INT4] -> dataset.learning_pathways{REFERENCE}[VARCHAR(128)]
result[INT4] -> fact.exercise_results.result{FACT}[INT]
user_id[INT4] -> dataset.users{REFERENCE}[VARCHAR(128)]
id[SERIAL] -> label.exercise_results.id{LABEL}[VARCHAR(128)]
score[NUMERIC(0,0)] -> fact.exercise_results.score{FACT}[DECIMAL(12,2)]
pass_mark[INT4] -> fact.exercise_results.pass_mark{FACT}[INT]
exercise_type[VARCHAR(2147483647)] -> label.exercise_results.exercise_type{LABEL}[VARCHAR(10000)]
category_id[INT4] -> dataset.categories{REFERENCE}[VARCHAR(128)]
record_type[INT4] -> fact.exercise_results.record_type{FACT}[INT]
course_lesson_id[INT4] -> dataset.course_lessons{REFERENCE}[VARCHAR(128)]

Output Stage table/view: learning_pathways (full, shared) -> Dataset: dataset.learning_pathways
id[BIGSERIAL] -> label.learning_pathways.id{LABEL}[VARCHAR(128)]
status[INT4] -> fact.learning_pathways.status{FACT}[INT]
organisation_id[INT4] -> dataset.organisations{REFERENCE}[VARCHAR(128)]
compliance[INT4] -> fact.learning_pathways.compliance{FACT}[INT]
author_id[INT4] -> dataset.users{REFERENCE}[VARCHAR(128)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
certificate[BOOL] -> label.learning_pathways.certificate{LABEL}[VARCHAR(128)]
access[INT4] -> fact.learning_pathways.access{FACT}[INT]
published[BOOL] -> label.learning_pathways.published{LABEL}[VARCHAR(128)]
name[VARCHAR(2147483647)] -> label.learning_pathways.name{LABEL}[VARCHAR(10000)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
access_order[INT4] -> fact.learning_pathways.access_order{FACT}[INT]

Output Stage table/view: lessons (full, shared) -> Dataset: dataset.lessons
number[INT4] -> fact.lessons.number{FACT}[INT]
organisation_id[INT4] -> dataset.organisations{REFERENCE}[VARCHAR(128)]
author_id[INT4] -> dataset.users{REFERENCE}[VARCHAR(128)]
mode[INT4] -> fact.lessons.mode{FACT}[INT]
course_id[INT4] -> fact.lessons.course_id{FACT}[INT]
title[VARCHAR(2147483647)] -> label.lessons.title{LABEL}[VARCHAR(10000)]
type[VARCHAR(2147483647)] -> label.lessons.type{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
id[SERIAL] -> label.lessons.id{LABEL}[VARCHAR(128)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]

Output Stage table/view: organisation_users (full, shared) -> Dataset: dataset.organisation_users
active[BOOL] -> label.organisation_users.active{LABEL}[VARCHAR(128)]
organisation_id[INT4] -> dataset.organisations{REFERENCE}[VARCHAR(128)]
id[SERIAL] -> label.organisation_users.id{LABEL}[VARCHAR(128)]
user_id[INT4] -> dataset.users{REFERENCE}[VARCHAR(128)]
role[INT4] -> fact.organisation_users.role{FACT}[INT]

Output Stage table/view: organisations (full, shared) -> Dataset: dataset.organisations
archived[BOOL] -> label.organisations.archived{LABEL}[VARCHAR(128)]
name[VARCHAR(2147483647)] -> label.organisations.name{LABEL}[VARCHAR(10000)]
tenant_id[INT4] -> dataset.tenants{REFERENCE}[VARCHAR(128)]
subdomain[VARCHAR(2147483647)] -> label.organisations.subdomain{LABEL}[VARCHAR(10000)]
id[SERIAL] -> label.organisations.id{LABEL}[VARCHAR(128)]
sector_id[INT4] -> dataset.sectors{REFERENCE}[VARCHAR(128)]
email_domain[VARCHAR(2147483647)] -> label.organisations.email_domain{LABEL}[VARCHAR(10000)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
from_email[VARCHAR(2147483647)] -> label.organisations.from_email{LABEL}[VARCHAR(10000)]

Output Stage table/view: roles (full, shared) -> Dataset: dataset.roles
department_id[INT4] -> dataset.departments{REFERENCE}[VARCHAR(128)]
name[VARCHAR(2147483647)] -> label.roles.name{LABEL}[VARCHAR(10000)]
id[BIGSERIAL] -> label.roles.id{LABEL}[VARCHAR(128)]

Output Stage table/view: sectors (full, shared) -> Dataset: dataset.sectors
name[VARCHAR(2147483647)] -> label.sectors.name{LABEL}[VARCHAR(10000)]
id[BIGSERIAL] -> label.sectors.id{LABEL}[VARCHAR(128)]

Output Stage table/view: skills (full, shared) -> Dataset: dataset.skills
category_id[INT8] -> dataset.categories{REFERENCE}[VARCHAR(128)]
name[VARCHAR(2147483647)] -> label.skills.name{LABEL}[VARCHAR(10000)]
id[BIGSERIAL] -> label.skills.id{LABEL}[VARCHAR(128)]

Output Stage table/view: tenants (full, shared) -> Dataset: dataset.tenants
name[VARCHAR(2147483647)] -> label.tenants.name{LABEL}[VARCHAR(10000)]
id[BIGSERIAL] -> label.tenants.id{LABEL}[VARCHAR(128)]
subdomain[VARCHAR(2147483647)] -> label.tenants.subdomain{LABEL}[VARCHAR(10000)]

Output Stage table/view: user_course_assignments (full, shared) -> Dataset: dataset.user_course_assignments
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
user_id[INT8] -> fact.user_course_assignments.user_id{FACT}[INT]
id[BIGSERIAL] -> label.user_course_assignments.id{LABEL}[INT]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
expiry_date[TIMESTAMP] -> expirydate{DATE}[DATE]
allow_to_edit_start_date[BOOL] -> label.user_course_assignments.allow_to_edit_start_date{LABEL}[VARCHAR(128)]
course_id[INT8] -> dataset.courses{REFERENCE}[VARCHAR(128)]
deleted_at[TIMESTAMP] -> deletedat{DATE}[DATE]
end_date[TIMESTAMP] -> enddate{DATE}[DATE]
deadline[INT4] -> fact.user_course_assignments.deadline{FACT}[INT]
access_period[INT4] -> fact.user_course_assignments.access_period{FACT}[INT]
reason_ids[TEXT(2147483647)] -> label.user_course_assignments.reason_ids{LABEL}[VARCHAR(10000)]
start_date[TIMESTAMP] -> startdate{DATE}[DATE]

Output Stage table/view: user_course_durations (full, shared) -> Dataset: dataset.user_course_durations
duration[INT4] -> label.user_course_durations.duration{LABEL}[VARCHAR(128)]
user_course_id[INT4] -> dataset.user_courses{REFERENCE}[INT]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
id[BIGSERIAL] -> label.user_course_durations.id{LABEL}[INT]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]

Output Stage table/view: user_course_feedbacks (full, shared) -> Dataset: dataset.user_course_feedbacks
learning_pathway_id[INT4] -> dataset.learning_pathways{REFERENCE}[VARCHAR(128)]
feedback[TEXT(2147483647)] -> label.user_course_feedbacks.feedback{LABEL}[VARCHAR(10000)]
record_type[INT4] -> fact.user_course_feedbacks.record_type{FACT}[INT]
rating[INT4] -> fact.user_course_feedbacks.rating{FACT}[INT]
id[BIGSERIAL] -> label.user_course_feedbacks.id{LABEL}[VARCHAR(128)]

Output Stage table/view: user_courses (full, shared) -> Dataset: dataset.user_courses
user_id[INT4] -> fact.user_courses.user_id{FACT}[INT]
expiry_period[INT4] -> fact.user_courses.expiry_period{FACT}[INT]
user_learning_pathway_id[INT4] -> fact.user_courses.user_learning_pathway_id{FACT}[INT]
record_type[INT4] -> fact.user_courses.record_type{FACT}[INT]
course_id[INT4] -> dataset.courses{REFERENCE}[VARCHAR(128)]
recommended_by_id[INT4] -> fact.user_courses.recommended_by_id{FACT}[INT]
complete_date[TIMESTAMP] -> completedate{DATE}[DATE]
start_date[TIMESTAMP] -> startdate{DATE}[DATE]
learning_pathway_id[INT4] -> fact.user_courses.learning_pathway_id{FACT}[INT]
data_json[TEXT(2147483647)] -> label.user_courses.data_json{LABEL}[VARCHAR(10000)]
expiry_duration[INT4] -> fact.user_courses.expiry_duration{FACT}[INT]
id[SERIAL] -> label.user_courses.id{LABEL}[INT]
duration_type[INT4] -> fact.user_courses.duration_type{FACT}[INT]
complete[BOOL] -> label.user_courses.complete{LABEL}[VARCHAR(128)]
last_visited_lesson_id[INT4] -> fact.user_courses.last_visited_lesson_id{FACT}[INT]
status[INT4] -> label.user_courses.status{LABEL}[INT]
result_status[INT4] -> fact.user_courses.result_status{FACT}[INT]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
completion_status[INT4] -> fact.user_courses.completion_status{FACT}[INT]
certificate_expiry_type[INT4] -> fact.user_courses.certificate_expiry_type{FACT}[INT]
type[VARCHAR(2147483647)] -> label.user_courses.type{LABEL}[VARCHAR(10000)]
due[TIMESTAMP] -> due{DATE}[DATE]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
certificate_expire_on[TIMESTAMP] -> certificateexpireon{DATE}[DATE]

Output Stage table/view: user_exercise_attempts (full, shared) -> Dataset: dataset.user_exercise_attempts
course_id[INT4] -> dataset.courses{REFERENCE}[VARCHAR(128)]
id[BIGSERIAL] -> label.user_exercise_attempts.id{LABEL}[VARCHAR(128)]
attempt[INT4] -> fact.user_exercise_attempts.attempt{FACT}[INT]
user_answers[JSON] -> label.user_exercise_attempts.user_answers{LABEL}[VARCHAR(128)]
learning_pathway_id[INT4] -> dataset.learning_pathways{REFERENCE}[VARCHAR(128)]
record_type[INT4] -> fact.user_exercise_attempts.record_type{FACT}[INT]
user_id[INT8] -> dataset.users{REFERENCE}[VARCHAR(128)]
lesson_id[INT8] -> dataset.lessons{REFERENCE}[VARCHAR(128)]
course_lesson_id[INT4] -> dataset.course_lessons{REFERENCE}[VARCHAR(128)]

Output Stage table/view: user_learning_pathway_durations (full, shared) -> Dataset: dataset.user_learning_pathway_durations
duration[INT4] -> fact.user_learning_pathway_durations.duration{FACT}[INT]
id[BIGSERIAL] -> label.user_learning_pathway_durations.id{LABEL}[VARCHAR(128)]

Output Stage table/view: user_learning_pathways (full, shared) -> Dataset: dataset.user_learning_pathways
last_visited_course_id[INT4] -> fact.user_learning_pathways.last_visited_course_id{FACT}[INT]
start_date[TIMESTAMP] -> startdate{DATE}[DATE]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
id[BIGSERIAL] -> label.user_learning_pathways.id{LABEL}[VARCHAR(128)]
learning_pathway_id[INT8] -> dataset.learning_pathways{REFERENCE}[VARCHAR(128)]
status[INT4] -> fact.user_learning_pathways.status{FACT}[INT]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
user_id[INT8] -> dataset.users{REFERENCE}[VARCHAR(128)]
complete_date[TIMESTAMP] -> completedate{DATE}[DATE]

Output Stage table/view: user_lesson_durations (full, shared) -> Dataset: dataset.user_lesson_durations
user_lesson_id[INT8] -> dataset.user_lessons{REFERENCE}[VARCHAR(128)]
duration[INT4] -> fact.user_lesson_durations.duration{FACT}[INT]
id[BIGSERIAL] -> label.user_lesson_durations.id{LABEL}[VARCHAR(128)]

Output Stage table/view: user_lessons (full, shared) -> Dataset: dataset.user_lessons
learning_pathway_id[INT4] -> dataset.learning_pathways{REFERENCE}[VARCHAR(128)]
course_lesson_id[INT4] -> dataset.course_lessons{REFERENCE}[VARCHAR(128)]
user_learning_pathway_id[INT4] -> dataset.user_learning_pathways{REFERENCE}[VARCHAR(128)]
course_id[INT4] -> dataset.courses{REFERENCE}[VARCHAR(128)]
record_type[INT4] -> fact.user_lessons.record_type{FACT}[INT]
user_id[INT4] -> dataset.users{REFERENCE}[VARCHAR(128)]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
data_json[TEXT(2147483647)] -> label.user_lessons.data_json{LABEL}[VARCHAR(10000)]
id[SERIAL] -> label.user_lessons.id{LABEL}[VARCHAR(128)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
status[INT4] -> fact.user_lessons.status{FACT}[INT]
lesson_id[INT4] -> dataset.lessons{REFERENCE}[VARCHAR(128)]

Output Stage table/view: user_skill_preferences (full, shared) -> Dataset: dataset.user_skill_preferences
skill_id[INT8] -> dataset.skills{REFERENCE}[VARCHAR(128)]
user_id[INT8] -> dataset.users{REFERENCE}[VARCHAR(128)]
id[BIGSERIAL] -> label.user_skill_preferences.id{LABEL}[VARCHAR(128)]
interest_level[INT4] -> fact.user_skill_preferences.interest_level{FACT}[INT]

Output Stage table/view: users (full, shared) -> Dataset: dataset.users
points[INT4] -> fact.users.points{FACT}[INT]
id[SERIAL] -> label.users.id{LABEL}[VARCHAR(128)]
updated_at[TIMESTAMP] -> updatedat{DATE}[DATE]
is_tenant_admin[BOOL] -> label.users.is_tenant_admin{LABEL}[VARCHAR(128)]
sign_in_count[INT4] -> fact.users.sign_in_count{FACT}[INT]
created_at[TIMESTAMP] -> createdat{DATE}[DATE]
user_type_cd[INT4] -> fact.users.user_type_cd{FACT}[INT]
role_id[INT4] -> dataset.roles{REFERENCE}[VARCHAR(128)]
gender[INT4] -> fact.users.gender{FACT}[INT]
profile_type[INT4] -> fact.users.profile_type{FACT}[INT]
department_id[INT4] -> dataset.departments{REFERENCE}[VARCHAR(128)]

====================== End of Output Stage -> LDM mapping ======================


2023-03-16T10:43:24.228+0100 [INFO]: 

====================== Data distribution scope ======================


2023-03-16T10:43:24.228+0100 [INFO]: Project="j4rqrpe1jtar4s1tj62usxxyw230gxjx"; datasets=[{dataset.departments_sectors, full, loadDataFrom=1970-01-01T00:00}, {dataset.departments, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_skill_preferences, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_learning_pathways, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_course_durations, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_course_assignments, full, loadDataFrom=1970-01-01T00:00}, {dataset.ahoy_visits, full, loadDataFrom=1970-01-01T00:00}, {dataset.tenants, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_courses, full, loadDataFrom=1970-01-01T00:00}, {dataset.categories, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_exercise_attempts, full, loadDataFrom=1970-01-01T00:00}, {dataset.roles, full, loadDataFrom=1970-01-01T00:00}, {dataset.course_lessons, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_learning_pathway_durations, full, loadDataFrom=1970-01-01T00:00}, {dataset.organisations, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_lesson_durations, full, loadDataFrom=1970-01-01T00:00}, {dataset.sectors, full, loadDataFrom=1970-01-01T00:00}, {dataset.skills, full, loadDataFrom=1970-01-01T00:00}, {dataset.learning_pathways, full, loadDataFrom=1970-01-01T00:00}, {dataset.lessons, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_lessons, full, loadDataFrom=1970-01-01T00:00}, {dataset.users, full, loadDataFrom=1970-01-01T00:00}, {dataset.organisation_users, full, loadDataFrom=1970-01-01T00:00}, {dataset.courses, full, loadDataFrom=1970-01-01T00:00}, {dataset.user_course_feedbacks, full, loadDataFrom=1970-01-01T00:00}, {dataset.course_learning_pathways, full, loadDataFrom=1970-01-01T00:00}, {dataset.exercise_results, full, loadDataFrom=1970-01-01T00:00}]
2023-03-16T10:43:24.228+0100 [INFO]: 

====================== End of Data distribution scope ======================


2023-03-16T10:43:24.229+0100 [INFO]: 

====================== Downloading and integrating data ======================


2023-03-16T10:43:44.257+0100 [INFO]: Data for project="j4rqrpe1jtar4s1tj62usxxyw230gxjx" was downloaded. Datasets: [{dataset.ahoy_visits, upsert, rows=77, size=34882 bytes}, {dataset.categories, upsert, rows=36, size=826 bytes}, {dataset.course_learning_pathways, upsert, rows=365, size=4985 bytes}, {dataset.course_lessons, upsert, rows=1516, size=42503 bytes}, {dataset.courses, upsert, rows=602, size=72441 bytes}, {dataset.departments, upsert, rows=16, size=236 bytes}, {dataset.departments_sectors, upsert, rows=44, size=245 bytes}, {dataset.exercise_results, upsert, rows=693, size=29558 bytes}, {dataset.learning_pathways, upsert, rows=155, size=14782 bytes}, {dataset.lessons, upsert, rows=986, size=96507 bytes}, {dataset.organisation_users, upsert, rows=507, size=8300 bytes}, {dataset.organisations, upsert, rows=8, size=831 bytes}, {dataset.roles, upsert, rows=35, size=578 bytes}, {dataset.sectors, upsert, rows=15, size=221 bytes}, {dataset.skills, upsert, rows=89, size=1396 bytes}, {dataset.tenants, upsert, rows=1, size=50 bytes}, {dataset.user_course_assignments, upsert, rows=13838, size=1137321 bytes}, {dataset.user_course_durations, upsert, rows=876, size=58807 bytes}, {dataset.user_course_feedbacks, upsert, rows=336, size=4631 bytes}, {dataset.user_courses, upsert, rows=22235, size=2342497 bytes}, {dataset.user_exercise_attempts, upsert, rows=473, size=442864 bytes}, {dataset.user_learning_pathway_durations, upsert, rows=154, size=1122 bytes}, {dataset.user_learning_pathways, upsert, rows=2517, size=181663 bytes}, {dataset.user_lesson_durations, upsert, rows=1509, size=19199 bytes}, {dataset.user_lessons, upsert, rows=2977, size=363268 bytes}, {dataset.user_skill_preferences, upsert, rows=597, size=8041 bytes}, {dataset.users, upsert, rows=507, size=38017 bytes}]
2023-03-16T10:43:49.270+0100 [WARN]: Project "j4rqrpe1jtar4s1tj62usxxyw230gxjx" was not integrated. Reason: Non-synchronized dataset "dataset.user_course_durations/2185", identified unrelated columns "17630,17624,17626,17628".
2023-03-16T10:43:59.274+0100 [INFO]: 

====================== End of downloading and integrating data ======================


2023-03-16T10:43:59.275+0100 [ERROR]: Data distribution worker failed. Reason: All projects failed to load.