Load Data warehouse job is failing post upgrade or post time slice rollover.
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 one or more of the Weekly Time Slices that go in the Data Warehouse (Administration -> Time Slices).
Release: All Supported Releases
Component: Data Warehouse
Reslice the DWH time slices using the steps below to start on a day consistent with the First Day of Work Week set in Administration ->Settings
Note: It's recommended to only reslice 1-2 slices at a time, and reslice after normal business hours. Depending on the amount of data being resliced, it can cause the time slicing to take a long time to complete the first time after the reslice, which can cause slow performance in the application)
Tip: To check what your First day of Work Week is set to from the UI side:
If the problem still persists ,set the monthly DWH slice ids to the 1st of the month, and repeat steps 2 and 3 above.
CA PPM Tuesday Tip: How to Set Up the DWH (Data Warehouse) time slices to avoid errors with the 'Update Report Tables' and 'Load DWH' jobs