Load Data warehouse job is failing post upgrade
Truncate Table - An error occurred executing this job entry : Couldn't execute SQL: BEGIN RPT_CALENDAR_SP(); RPT_INV_HIERARCHY_SP(); END; [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "PPM_Schema.RPT_CALENDAR_SP", line 330 ORA-06512: at line 2
This error indicates the Data Warehouse is failing due to a mismatch between the first day of the week set on the PPM side (in Administration -> Settings -> First Day of Work Week) and the Weekly Time Slices that go in the Data Warehouse (Administration -> Time Slices).
1) Go to Administration -> Time Slices and sort by Slice Period. Then check the weekly ones and make sure the From Date corresponds to a First Day of the Week in Administration -> Settings. Once corrected
2) Go to Home -> Jobs and run the Update Report Tables job with the Calendar option checked on
3) Then run the Load Data Warehouse - Full Sync mode.
If the problem still persists,set the monthly DWH slice ids to the 1st of the month, and repeat steps 2 and 3 above.