Skip to main content
Kofax

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

Article # 3040762 - Page views: 45

Issue

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

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.

 

Cause

The core issue that causes this problem in reporting data is this bug:

Bug 1450138: Testing Extraction in TD can send reporting data on non-integer saved versions, causing data load errors in KAFTA

 

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.

 

Level of Complexity 

Easy

 

Applies to  

Product Version Build Environment Hardware

Kofax Analytics for TotalAgility

<1.4.1.1

     

References

Add any references to other internal or external articles

 

Article # 3040762