Hi Pavel,
Thanks for the logs and it looks like there is problem in dataware house and the error is below
3/22/17 4:58 PM (ExecTask) MATERIALIZED VIEW DWH_X_INV_BEN_PER_FACTS_MV ( INVESTMENT_KEY, PERIOD_KEY, PLAN_BENEFIT, BDGT_BENEFIT, PLAN_ACTUAL_BENEFIT, BDGT_ACTUAL_BENEFIT, DW_UPDATED_DATE ) AS
3/22/17 4:58 PM (ExecTask) SELECT f.investment_key,
3/22/17 4:58 PM (ExecTask) f.period_key,
3/22/17 4:58 PM (ExecTask) SUM(CASE WHEN c.fin_plan_type_key = 'FORECAST' THEN f.benefit ELSE 0 END) plan_benefit,
3/22/17 4:58 PM (ExecTask) SUM(CASE WHEN c.fin_plan_type_key = 'BUDGET' THEN f.benefit ELSE 0 END) bdgt_benefit,
3/22/17 4:58 PM (ExecTask) SUM(CASE WHEN c.fin_plan_type_key = 'FORECAST' THEN f.actual_benefit ELSE 0 END) plan_actual_benefit,
3/22/17 4:58 PM (ExecTask) SUM(CASE WHEN c.fin_plan_type_key = 'BUDGET' THEN f.actual_benefit ELSE 0 END) bdgt_actual_benefit,
3/22/17 4:58 PM (ExecTask) MAX(f.dw_updated_date) dw_updated_date
3/22/17 4:58 PM (ExecTask) FROM dwh_fin_benefit_period_facts f
3/22/17 4:58 PM (ExecTask) INNER JOIN dwh_fin_benefit_plan b ON f.benefitplan_detail_key = b.benefitplan_detail_key
3/22/17 4:58 PM (ExecTask) INNER JOIN (SELECT DISTINCT plan_key, fin_plan_type_key, benefitplan_key
3/22/17 4:58 PM (ExecTask) FROM dwh_fin_plan
3/22/17 4:58 PM (ExecTask) WHERE is_plan_of_record = 1) c ON b.benefitplan_key = c.benefitplan_key
3/22/17 4:58 PM (ExecTask) WHERE 1=1
3/22/17 4:58 PM (ExecTask) GROUP BY f.investment_key, f.period_key
3/22/17 4:58 PM (ExecTask) UNION ALL
3/22/17 4:58 PM (ExecTask) SELECT i.investment_key,
3/22/17 4:58 PM (ExecTask) p.period_key,
3/22/17 4:58 PM (ExecTask) CASE WHEN p.plan_benefit_period_days <> 0 AND p.plan_benefit_total_days <> 0
3/22/17 4:58 PM (ExecTask) THEN (i.plan_benefit / p.plan_benefit_total_days) * p.plan_benefit_period_days
3/22/17 4:58 PM (ExecTask) ELSE 0 END plan_benefit,
3/22/17 4:58 PM (ExecTask) CASE WHEN p.bdgt_benefit_period_days <> 0 AND p.bdgt_benefit_total_days <> 0
3/22/17 4:58 PM (ExecTask) THEN (i.bdgt_benefit / p.bdgt_benefit_total_days) * p.bdgt_benefit_period_days
3/22/17 4:58 PM (ExecTask) ELSE 0 END bdgt_benefit,
3/22/17 4:58 PM (ExecTask) 0 plan_actual_benefit,
3/22/17 4:58 PM (ExecTask) 0 bdgt_actual_benefit,
3/22/17 4:58 PM (ExecTask) i.dw_updated_date dw_updated_date
3/22/17 4:58 PM (ExecTask) FROM dwh_x_inv_sum_facts i
3/22/17 4:58 PM (ExecTask) INNER JOIN (SELECT i.investment_key,
3/22/17 4:58 PM (ExecTask) p.period_key,
3/22/17 4:58 PM (ExecTask) p.period_end_date period_finish,
3/22/17 4:58 PM (ExecTask) CASE WHEN i.bdgt_benefit_start <= p.period_end_date AND i.bdgt_benefit_finish >= p.period_start_date
3/22/17 4:58 PM (ExecTask) THEN (LEAST(i.bdgt_benefit_finish, p.period_end_date) - GREATEST(i.bdgt_benefit_start, p.period_start_date)) + 1
3/22/17 4:58 PM (ExecTask) ELSE 0 END bdgt_benefit_period_days,
3/22/17 4:58 PM (ExecTask) (i.bdgt_benefit_finish - i.bdgt_benefit_start) + 1 bdgt_benefit_total_days,
3/22/17 4:58 PM (ExecTask) CASE WHEN i.plan_benefit_start <= p.period_end_date AND i.plan_benefit_finish >= p.period_start_date
3/22/17 4:58 PM (ExecTask) THEN (LEAST(i.plan_benefit_finish, p.period_end_date) - GREATEST(i.plan_benefit_start, p.period_start_date)) + 1
3/22/17 4:58 PM (ExecTask) ELSE 0 END plan_benefit_period_days,
3/22/17 4:58 PM (ExecTask) (i.plan_benefit_finish - i.plan_benefit_start) + 1 plan_benefit_total_days
3/22/17 4:58 PM (ExecTask) FROM dwh_x_inv_sum_facts i
3/22/17 4:58 PM (ExecTask) INNER JOIN dwh_cmn_period p ON p.period_type_key = 'FISCAL'
3/22/17 4:58 PM (ExecTask) AND LEAST(i.bdgt_benefit_start, i.bdgt_benefit_start, i.plan_benefit_start, i.plan_benefit_start) <= p.period_end_date
3/22/17 4:58 PM (ExecTask) AND GREATEST(i.bdgt_benefit_finish, i.bdgt_benefit_finish, i.plan_benefit_finish, i.plan_benefit_finish) >= p.period_start_date
3/22/17 4:58 PM (ExecTask) WHERE i.plans_exist = 0) p ON i.investment_key = p.investment_key
3/22/17 4:58 PM (ExecTask)
3/22/17 4:58 PM (ExecTask)
3/22/17 4:58 PM (ExecTask) Note: Foreign Keys and Triggers have been enabled
So below is the next action I propose
1. Roll back to 14.2, ensure you have correct patch for upgrade to 15.1
2. Delete the DWH schema and reimport the blank schema
3. Upgrade the DWH schema by running the command admin db dwh-upgrade -Dupgrade.phase=maintenance
4. Run the Load DWH job in full mode and ensure it completes
5. Rerun the upgrade
Regards
Suman Pramanik