Skip to main content
Kofax

"Error converting data type nvarchar to bigint" error when running KAFTA Hourly Execution Plan

3018100

Question / Problem: 

When running the KAFTA Hourly Execution Plan the following error message is seen in the logs.

In the InsightServer_WinApp.log you'll see the following error:
2018-12-21 11:44:34,025 [2d478d26-7277-4c27-aff2-71cb0aac838b] ERROR AltoSoft.Insight.Storage.ExternalData.BaseExternalDataProvider - Can't execute query for record 'DocumentClassBase'. Error : System.Data.SqlClient.SqlException (0x80131904): Error converting data type nvarchar to bigint.
 

Answer / Solution: 

This issue has been resolved in KAFTA 1.4.1.1 which is available on the Kofax Fulfillment Site.  

To resolve the issue, please apply the fix pack per the instructions in the included readme.

Applies to:  

Product Version
KAFTA < 1.4.1.1
Insight 6.1, 6.2