The Post Timesheets job is processing at a very slow rate

Document ID : KB000005886
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

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”.