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:
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.
The fix will be included in KAFTA 184.108.40.206.
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
|KAFTA||220.127.116.11 and below|
Add any references to other internal or external articles