Portal Home > Knowledgebase > eCommerce > Exception=String Or Binary Data Would Be Truncated Error In Search

Exception=String Or Binary Data Would Be Truncated Error In Search

Synopsis:

When tried to search an item, this message will be displayed: Exception=String or binary data would be truncated error in search 

 

Cause:

This was caused by a Category name that has a text greater than 30 in length. The search script was not able to handle it properly.

 

Solution:

1. Download update.sql in http://www.screencast.com/users/nolly.c/folders/Knowledgebases%20Files/media/83ef2bc7-6def-4cea-a459-0ec10fee6486
2. Run update.sql into the database using SQL Server. Make sure to backup first the database.

Steps On How To Backup Database: https://my.connectedbusiness.com/index.php?rp=/knowledgebase/255/How-to-Back-Up-and-Restore-Database-in-Microsoft-SQL-Server.html

Steps On How To Run Scripts: https://my.connectedbusiness.com/index.php?rp=/knowledgebase/125/How-to-Run-a-Patch-Script.html

 

Applicable Products:

Connected Business 13.2.2.50


Also Read