Symptoms:
Load Data Warehouse job fails, the following example message gets thrown in bg-dwh.log:
2015/10/24 11:12:14 - User Defined Java Class.0 - 2015/10/24 11:12:14 - dwh_db_check_ - UPDATE STATISTICS DWH_INV_TASK;
2015/10/24 11:12:14 - User Defined Java Class.0 - 2015/10/24 11:12:14 - dwh_db_check_ - END
2015/10/24 11:12:14 - User Defined Java Class.0 - 2015/10/24 11:12:14 - dwh_db_check_ -
2015/10/24 11:12:14 - User Defined Java Class.0 - 2015/10/24 11:12:14 - dwh_db_check_ - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'WBS_LEVEL', table 'PPM_DWH.ppm_dwh.DWH_INV_TASK'; column does not allow nulls. INSERT fails
(this message is an MSSQL example, there will be a similar error message for Oracle too)
Causes:
Resolution:
CLRT-79130 is in review with our Sustaining Engineering team.
Workaround:
Identify and fix the WBS levels on the tasks that can cause this issue through the application UI:
select * from dwh_task_v where wbs_level is null
select name from inv_investments where id in
(select investment_key from dwh_task_v where wbs_level is null)
If you still experience an issue, please contact CA Support and refer to this article.