Error when doing a search, "value was either to large or too small for INT32" (4229533)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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 ArchiveManager
select count (*) from message
4. Take the count and make that the value of the Full Text Max Results.
E.g. 200000
5. 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.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title