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

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.

Level of Complexity 

Moderate

Applies to  

References

Add any references to other internal or external articles