The Post Timesheets job is processing at a very slow rate

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Post Timesheets is slow.
It is the first time running this job.

Check the rate at which the number of timesheets are getting posted with

a. query:

select count(*) from PRTIMESHEET
where prstatus = 3

or

b. From the Home > Timesheets list page with filter set to Approved or Posted.

Environment

Release: 451-101-15.1-Clarity-Creator User License
Component:

Cause

The on-the-fly rate matrix extraction is enabled and causing the Post Timesheets job to perform poorly.
The poor rate is typically 1 timesheet per minute.
 

Resolution

Run SQL:

update cmn_option_values set value=0
where option_id = (select id from cmn_options where option_code='PRJ_RT_RATES_EXTRACTION');
commit; 

Check the rate at which the number of timesheets are getting posted with query:
select count(*) from PRTIMESHEET
where prstatus = 3

Additional Information

This article is based on:
https://communities.ca.com/thread/241771345
Tec Tip: Post Timesheets job slow on 14.3, 14.4 and 15.1

DE31729: PPMSAAS_15.1_DEFECT HADNI01  Post Timesheets slow due to on-the-fly

For CA PPM 15.2 or higher, the on-the-fly rate matrix extraction will be disabled by default.
If a customer wishes to enable it, they can access it on the Health Report and click on the ‘Enable’ link present in the Status column for “On-the-fly Rate Matrix”.