Return
-
Title
Error when doing a search, "value was either to large or too small for INT32" -
Description
When typing in keywords into the Search, the following message is displayed on screen:
"Value was either too large or too small for INT32"
-
Cause
Full Text Max Results value in the Configuration Console is not between -2,147,483,647 and 2,147,483,647. If the Value in the console is lower or higher, you will see the error. -
Resolution
1. Open the Configuration Console
2. Click Advanced Settings
3. Edit the Full Text Max Results value to be the item count (or amount of messages) in your database. To find this run:
use ArchiveManagerselect count (*) from message4. Take the count and make that the value of the Full Text Max Results.E.g. 2000005. Click Apply in the Configuration Console.6. You may need to restart the Full Text Search Service from services.msc and then perform the keyword search.