Skip to main content
Kofax

Failed to execute query String or binary data would be truncated - error when Hourly Plan executes

Article # 3047938 - Page views: 14

Issue

When the Hourly Plan executes the following error is encountered:

Failed to execute a query. Please contact the Administrator.

String or binary data would be truncated.

The statement has been terminated.

 

Cause

This is caused when Category IDs exceed the length of 50 characters defined in the Category Translation Table.

 

Solution

The workaround to this known issue is to increase the Length Property in Insight Studio.  This issue has been submitted under TFS Bug ID: 1715306.

The official fix will be a part of Fix Pack 4 for KAFTA 1.4.1.

workaround.jpg

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
KAFTA 1.4.1.3      

References

Add any references to other internal or external articles

 

Article # 3047938