Skip to main content
Kofax

No new data in Dashboard

Article # 3032307 - Page views: 11

Article # 3032307 - Page views: 11

Issue

No new data showing in KAFC views and Event Listener log getting the error "The duplicate key value is":

021-08-09 10:34:01,179 [30] ERROR [xxxxxxxxxx Error updating Insight DB #0 AltoSoft.Insight.DBCore.AltoSoftDBException: Cannot insert duplicate key row in object 'dbo.HistoryOfBatch' with unique index 'IX_HOB_BatchGuidSessionNumber'. The duplicate key value is ({2c7ef6b4-7ccc-49b4-87f0-a7b1ae5e833e}, 11).

Also the Event Listener logs is filled with many "Duplicated", "Add", "Read" and "Save" but not "Write":

2021-03-21 09:27:28,303 [9] INFO  [testing.as.local] Add("{fe86adc8-dcf1-46f2-9819-cd7f53acecdd}", 3/5/2021 7:56:30 AM, 4)
2021-03-21 09:27:28,303 [9] INFO  [testing.as.local] Duplicated("4:201903050754500000000:201903050756300000000")
2021-03-21 09:27:28,303 [9] INFO  [testing.as.local] Add("{e102bbd8-f8a4-4dbf-9878-6cc7f1a5b46f}", 3/5/2021 7:56:30 AM, 5)
2021-03-21 09:27:28,303 [9] INFO  [testing.as.local] Duplicated("5:201903050650390000000:201903050756300000000")

2021-03-21 09:27:32,655 [56] INFO  [testing.as.local] Read("Session20", "{979dd5c6-1d68-4150-ae53-f9f1525382e5}cfe4d35a-6910-44ca-92d4-2db5387c085f", 0)
2021-03-21 09:27:32,655 [56] INFO  [testing.as.local] Read("Session20", "{4b8c551e-df8f-4e22-9e78-726299d64911}01dee18d-673b-4d6a-9635-4bc2b09909e3", 10)
2021-03-21 09:27:32,655 [56] INFO  [testing.colo.as.local] Read("Session20", "{257f454c-2446-4312-bca7-fea9ca1063a3}c77f4719-5fac-4f29-ac69-3224f344dcdb", 66)

2021-03-21 09:28:57,638 [53] INFO  [testing.as.local] Save("{35c15c20-510d-4c96-a98b-0daa1b79c2ca}00b4a7a5-8597-4ae8-b64b-7cca2e535878", 3/21/2021 2:28:57 PM)

Cause

The problem is related to the Event Listener not able to process duplicate entries (TFS 1402682).

 

Solution

This was fixed in Fix Pack 3 for KAFC 2.1.

 

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
KAFC 2.1      

References

Add any references to other internal or external articles