Time slicing consuming longer time post upgrade to 15.9.2

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

 Time slicing job taking long time to complete since upgrade to 15.9.2 and the job seems to get slow while inserting data into table temp_ts_slice_counts

 
STEPS TO REPRODUCE: 

1. Login to Clarity.
2. Make sure that you have around 130+ Million records in PRJ_BLB_SLICES.
3. Run time slicing job. 

Expected Results: Job takes less than a minute to complete.

Actual Results: Job takes more than a minute to complete and upon reviewing the job takes longer time for the below query execution 

 

insert into temp_ts_slice_counts(job_run_id, slice_request_id, slice_count, min_slice_date, max_slice_date, request_completed_date, log_num, created_date)
with slices as (
select slice_request_id, count(*) slice_count, min(slice_date) min_slice_date, max(slice_date) max_slice_date
from PRJ_BLB_SLICES
group by slice_request_id order by slice_request_id
)
select :v0 ,r.id, s.slice_count, s.min_slice_date, s.max_slice_date, r.request_completed_date, :"SYS_B_0", :v1
from prj_blb_slicerequests r left outer join slices s onr.id = s.slice_request_id
where r.is_template = :"SYS_B_1"
and r.is_active = :"SYS_B_2"
and r.table_name = upper( :v2 )

Environment

Release : 15.9.2, 15.9.3, 16.0, 16.0.1

Component : Clarity Time Slicing

Cause

DE64034 is a Known Issue 

Workaround: 

• Disable the  TSV_LOGGING feature by executing the below stored procedure
  • call cmn_feature_toggle_sp('TSV_LOGGING',0)
  • Commit; 
• Reatart the bg service for the changes to take effect

The impact of disabling the TSV Logging is that data under under Administration --> Jobs Monitor -> Current Processing Time Slice Requests -> Time Slice Counts will not appear 

Resolution

Resolved in 16.0.2