The following error appears when the Update Report Tables job is run:
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 "RPT_CALENDAR_SP", line 255
ORA-06512: at line 2
All Clarity versions
The weekly time slices do not start on the designated first day of the workweek.
When setting up the DWH time slices from the Administration > Data Administration > Time Slices page, ensure that the start day of the slice ID matches that of the Administration > Project Management > Settings > General > First Day of Work Week
Use the following queries to quickly find out what the days are set to:select sr.id, sr.request_name, SR.FROM_DATE
from PRJ_BLB_SLICEREQUESTS SR
where SR.IS_DWH_REQUEST = 1
and SR.PERIOD = 1 --weekly
order by SR.id
select prweekstart from PRSITE
0 - SundayReslice the DWH slice request to start on a day consistent with the First Day of Work Week set in Administration ->Settings
Tip: To check what your First day of Work Week is set to from the UI side: