How To Fix ICL_TREX018 - Search with wildcard characters is not possible in fuzzy mode

SAP Error Message - Details

• Message type: E = Error

• Message class: ICL_TREX - Messages for Integration of TREX Search Engine

• Message number: 018

• Message text: Search with wildcard characters is not possible in fuzzy mode

What causes this issue?

In a search in fuzzy mode, the wildcard characters '*' (asterisk) and
'?' (question mark) are not permitted as part of the search term.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Do one of the following:
Remove the wildcard characters from the search term.
Deactivate the indicator for fuzzy mode.
<ZH>Note</>: You cannot deactivate the indicator in the search in Mini
Business Partner.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message ICL_TREX018 - Search with wildcard characters is not possible in fuzzy mode ?

  The SAP error message ICL_TREX018 indicates that a search operation using wildcard characters (like * or ?) is not allowed when the search is set to fuzzy mode. Fuzzy search is designed to find results that are similar to the search term, but it does not support the use of wildcards.
  Cause:
  The primary cause of this error is an attempt to perform a search using wildcard characters while the search mode is set to fuzzy. Fuzzy search algorithms work by finding matches that are close to the search term based on certain criteria (like spelling variations), and the inclusion of wildcards can complicate this process.
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Change Search Mode: If you need to use wildcard characters in your search, switch from fuzzy mode to a standard search mode that allows wildcards. This can typically be done in the search settings or parameters of your SAP application.
  
  
  Modify Search Query: If you want to keep the fuzzy search, modify your search query to remove any wildcard characters. Instead, use complete words or phrases that you expect to match.
  
  
  Check Documentation: Refer to the SAP documentation or help resources for your specific version of SAP to understand the limitations and capabilities of the search functionalities.
  
  
  Consult with SAP Support: If you are unsure how to change the settings or if the issue persists, consider reaching out to SAP support for assistance.
  
  
  Related Information:
  
  Fuzzy Search: This is a search technique that finds matches that are not exact but are similar. It is useful for handling misspellings or variations in data.
  Wildcard Characters: In many search systems, * represents zero or more characters, and ? represents a single character. These are commonly used in search queries to broaden the search results.
  SAP Search Configuration: Depending on your SAP system, there may be specific configurations or settings that control how searches are performed, including the ability to toggle between fuzzy and standard search modes.
  
  By following these steps, you should be able to resolve the error and perform your search as intended.