How To Fix ESH_ENG_CDSVAL_SRCH003 - 'fuzzinessThreshold' less than &2 is questionable (&1)

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_ENG_CDSVAL_SRCH - ES-CDS/ABAP: Validation of domain @Search

• Message number: 003

• Message text: 'fuzzinessThreshold' less than &2 is questionable (&1)

What causes this issue?

For a fuzzy search, the threshold has to be defined. A threshold of 1
equals an exact search, a threshold of 0 finds simply everything. The
threshold value chosen here supposedly yields results the user does not
want to see, respectively the user will not understand how the result
relates to his input.

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?

Check whether the chosen fuzziness threshold is indeed to be kept. Mind
to test the configuration on actual data so that the effect of this
value can be judged.

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 ESH_ENG_CDSVAL_SRCH003 - 'fuzzinessThreshold' less than &2 is questionable (&1) ?

  The SAP error message ESH_ENG_CDSVAL_SRCH003 indicates that the fuzzinessThreshold parameter is set to a value that is considered questionable. This error typically arises in the context of SAP's Enterprise Search or SAP HANA when dealing with fuzzy search functionalities.
  Cause:
  The fuzzinessThreshold parameter is used to define the acceptable level of similarity between the search term and the indexed terms. If the value of fuzzinessThreshold is set too low (less than the minimum acceptable value, which is indicated by &2), the system may not be able to return relevant results, leading to this warning or error message.
  Solution:
  
  
  Check Configuration: Review the configuration settings for the fuzzy search in your SAP system. Ensure that the fuzzinessThreshold is set to a value that meets the minimum requirement specified in the error message.
  
  
  Adjust the Threshold: If the current value of fuzzinessThreshold is less than the recommended minimum, increase it to a value that is acceptable. This can typically be done in the configuration settings of the search engine or the relevant CDS (Core Data Services) view.
  
  
  Test the Changes: After adjusting the fuzzinessThreshold, perform a test search to ensure that the changes have resolved the issue and that the search results are relevant.
  
  
  Consult Documentation: Refer to the official SAP documentation for the specific version of your system to understand the implications of changing the fuzzinessThreshold and to find the recommended settings.
  
  
  Seek Support: If you are unsure about making these changes or if the problem persists, consider reaching out to SAP support or consulting with an SAP expert who can provide guidance based on your specific system configuration.
  
  
  Related Information:
  
  Fuzzy Search: This feature allows for approximate string matching, which is useful for handling misspellings or variations in search terms.
  SAP HANA: The underlying database technology that often supports advanced search functionalities, including fuzzy search.
  Enterprise Search: A feature in SAP that allows users to search across various data sources within the SAP landscape.
  
  By addressing the fuzzinessThreshold setting, you should be able to resolve the error and improve the effectiveness of your search functionality within SAP.