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:
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 )
Release : 15.9.2, 15.9.3, 16.0, 16.0.1
Component : Clarity Time Slicing
DE64034 is a Known Issue
Workaround:
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
Resolved in 16.0.2