Error Message

[#41049] Error during term expansion. [#90056] The expansion of [*] yielded too many results (max [100,000])
 

The search criteria scope is too open, allowing more than the 100,000 limit of indexed words to be used in the search.

Using a small common combination of characters followed by an asterisk (ex: th* OR an*) will return too many expansion terms. 

When using the asterisk directly after a special character, the special character is ignored and the code will look for perform a search on * (every word indexed).  Then compare the returned results with the starting characters.

Example:  Search the month of April.
Using 04/* OR 04-*

The program will pull every word that is indexed and then compare it to 04 to determine if it is a hit.

 

 

The same search without the special character, using 04* instead, the variations are more specific and have a more likely chance of falling under the 100,000 expansion limit.

 

Change the search criteria to not use short common alpha characters followed by an asterisk.  Also do not use an asterisk directly following a special character.

 

Attempting to run an Advanced Search using a special character (non-Alphanumeric) followed by an asterisk (ex: hi/* OR hi-*) will fail if the case contains more than 100,000 indexed words.

[#41049] Error during term expansion. [#90056] The expansion of [*] yielded too many results (max [100,000])
Another example to cause this warning, is to use a very common set of letters followed directly by an asterisk (ex: th* or an*) in which the probability of words with ‘th’ or ‘an’ would exceed the 100,000 expansion limit.