Load Data warehouse job is failing post upgrade

Document ID : KB000097560
Last Modified Date : 25/06/2018
Show Technical Document Details
Issue:
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
Cause:
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). 
Resolution:
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.