Time Slicing Job Performance Issue Since Upgrade to 16.2.1

Products

• Clarity PPM On Premise

Issue/Introduction

The Time Slicing job has taken more time, instead of single-digit minutes, is now taking at least 1+ hour to complete.
The only activity was an upgrade to Clarity version 16.2.1.

 

Resolution

Starting in 16.3.0, there is a job that will manage the related/tables
CMN_BROKER_SERVICES
CMN_BROKER_SERVICE_PARAMS

Until then, obtain the following to confirm and mitigate the issue:

1. Obtain database report

select count(1) from CMN_BROKER_SERVICES
select count(1) from cmn_broker_service_params
select min(created_date),max(created_date) from CMN_BROKER_SERVICES;
SELECT min(CREATED_DATE),max(CREATED_DATE) FROM CMN_BROKER_SERVICE_PARAMS;

2. Review access log if issue occurs on a particular day of the week:

SELECT count(1) FROM (
SELECT DISTINCT s.user_id
FROM LOG_SESSIONS s,
LOG_DETAILS d
WHERE s.TOKEN = d.SESSION_COOKIE
AND d.log_date = to_date('202X-MM-DD 00:00:00','YYYY-MM-DD HH24:MI:SS'));

Contact the Support team for a review/analysis of the results.