Skip to main content
Kofax

Compare Batches Between KAFC and Kofax Capture

Article # 3040827 - Page views: 17

Issue

Is there a query to compare the batches  reported by KAFC vs Kofax Capture?

 

Solution

Yes.

You can run the following query to find a list of batches that KAFC has of currently active batches in Kofax Capture:

SELECT batchguid, COUNT(*) , MIN(sessionendtime), MAX(sessionendtime) FROM kafc_data..InstantQueue

GROUP BY BatchGuid HAVING COUNT(*) >= 1 ORDER BY MIN(sessionendtime) DESC

 

The query will return a count result of batches in KAFC, with the BatchGuid and the Session End time is descending order. This is useful to troubleshoot batches not matching with KAFC and Batch Manager. The BatchGuid represents a batch and a batch name and can be used to query HistoryOfBatch table to find the batch.

Query1.png

 

Level of Complexity 

Easy

 

Applies to  

Product Version Build Environment Hardware
Kofax Analytics for Capture 2.x      

 

Article # 3040827
  • Was this article helpful?