Rate Matrix Extraction job is increasing rows in Clarity

Document ID : KB000123739
Last Modified Date : 13/03/2019
Show Technical Document Details
Issue:
When running a full Rate Matrix Extraction (RME) with options 2 & 3, Prepare and Update, the job is taking much longer to complete and several more rows are appearing in the table. This slower performance is observed in 15.3 through 15.5.1.
Cause:
The job should be removing inactive projects from the table, however they are remaining.
 
Resolution:
This is reported as DE45595 and is fixed in Clarity 15.6.

There are also a few suggestions mentioned in KB000007301  that may help, such as:
  1. The following best practices can lower the job runtime, therefore forcing project managers to maintain projects:
  • Remove any rate matrices from Administration > Finance > Setup > Defaults > Project Transaction Entry Defaults
  • Remove any rate matrices from Administration > Finance > Setup > Entities that are no longer used
       2. Another suggestion is to remove and rows from the Rate Matrix that are no longer needed.  
However, the suggestion to inactivate projects will not help as these projects are not being removed from the table.

3. Consider how the job is being ran regarding the parameters, as it is highly suggested that the parameter(Prepare Rate Matrix Data) should not be selected at every run.
The scheduled run should only be running with the following parameters selected:
-Update Rate Matrix Data 
-Incremental Update