Orphaned Rows on Kofax Stats database - MonitorStatsModuleLaunch - Registry key

Issue

How to prevent Orphaned rows on the Kofax Stats DB tables

Cause

Querying for orphaned records without any other condition isn't correct. 

Some records might be truly orphaned, however, some could not.

True orphaned records are part of the application's architecture and they're all technically valid.

Solution

Adding the following Registry Key should mitigate the issue

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Kofax Image Products\Ascent Capture\3.0]
"MonitorStatsModuleLaunch"=dword:ffffffff
 

What the registry key does:

It disables a feature for monitoring orphaned statistical records. The feature intermittently inadvertently marks a record as orphaned as seen in this circumstance.

MonitorStatsModuleLaunch registry key works also on StatsBatchModule table.

Level of Complexity 

High

Applies to  

References

Add any references to other internal or external articles