Skip to main content
Kofax

Document Processing Time and Capture Resource Productivity showing old data

Article # 3043851 - Page views: 7

Issue

After manually executing the Load Old Data Plan successfully, old data is still being shown in the Document Processing Time and Capture Resource Productivity views.

 

Below is the sequence of events to run the Load Old Data Plan with certain From date references and exhibit the issue for reference:

set plans to manual.jpg

run old data plan.jpg

old data shown.jpg

 

Cause

Document Processing Time and Resource Productivity reports are based primarily on the SessionData record, and the data shown in the views are based on the time of the actual session (dt_end_datetime). However the old data cleanup plan deletes data from that record based on when the data was actually processed by reporting (etl_end_time).  So if this data was delayed in processing through reporting server, then data from old events (based on dt_end_datetime) would still be present in reports and not deleted due to later etl times.

This is a software defect under this certain scenario submitted under Bug ID: 1796384 - Document Processing Time and Resource Productivity reports may still contain old data after running Old Data Cleanup Plan.

 

Solution

The fix will be included in KAFTA 1.4.1.4.

 

The workaround that can be used it to add the following SQL statements to the Old Data Plan and re-run:

DELETE FROM [SessionDocument] WHERE "dt_end_datetime" < <FromDate>

DELETE FROM [Session] WHERE "dt_end_datetime" < <FromDate>

 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
KAFTA 1.4.1.3 and below      

References

Add any references to other internal or external articles

 

Article # 3043851
  • Was this article helpful?