Cannot insert duplicate key row in object

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  

References

Add any references to other internal or external articles