Recalculate rollups for a specific baseline

Document ID : KB000100578
Last Modified Date : 08/06/2018
Show Technical Document Details
Issue:
When rollups are skipped or missing between specific dates you might see significantly different values of CPU / Rx.  Is there some trigger (SQL query) to launch total recalc? Or recalc for list of given entities? 
 
Resolution:
1. Top Apache tomcat service.
2. Run the below query from Oracle SQL developer and  Start Precalc&Rollup at CCC 
insert into rollup_pending_days 
(table_name, 
day_id, 
completed_flag ) 
select 
'tpp', 
day_dim_id, 

from day_dim 
where day_dim_id between '<fromdate>' and '<todate>';  

update datamanager_params_config 
set dm_param_value = '1' 
where dm_param_name = 'REROLLUP_TPP_FLAG'; 

commit;