Cannot insert duplicate key row in object
Article # 3047354 - Page views: 10
Issue
KAFC is not showing real data, a lot of data is missing in the reports.
In the logs this error is seen:
"Cannot insert duplicate key row in object 'dbo.HistoryOfBatch' with unique index 'IX_HOB_BatchGuidSessionNumber'. The duplicate key value is ...", as designed the IX_HOB_BatchGuidSessionNumber index is unique type to ensure no duplicated data existing in HistoryOfBatch table.
Cause
Bug in the product
Solution
We have fixed the issue since Listener FP3 (2.1.0.3 version), therefore upgrade to Listener FP4 (2.1.0.4 version).
Level of Complexity
Moderate
Applies to
Product | Version | Build | Environment | Hardware |
---|---|---|---|---|
Kofax Analytics fro Capture | 2.1 | N/A | N/A | N/A |
References
Add any references to other internal or external articles
Article # 3047354