Exception=String Or Binary Data Would Be Truncated Error In Search
When tried to search an item, this message will be displayed: Exception=String or binary data would be truncated error in search
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.
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
Connected Business 22.214.171.124