How To Fix ESH_ENG_CDSVAL_ES015 - &1: 'usageMode #AUTO_FACET' cannot be used with data type &2

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_ENG_CDSVAL_ES - ES-CDS/ABAP: Validation of domain @EnterpriseSearch

• Message number: 015

• Message text: &1: 'usageMode #AUTO_FACET' cannot be used with data type &2

What causes this issue?

Annotation @EnterpriseSearch.usageMode: #AUTO_FACET cannot be used with
elements of data type STRING.

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?

Remove the annotation.
Theoretically, the underlying data type could be changed so that facets
can be built for the element.

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_ES015 - &1: 'usageMode #AUTO_FACET' cannot be used with data type &2 ?

  The SAP error message ESH_ENG_CDSVAL_ES015 typically occurs in the context of SAP's Enterprise Search or the SAP HANA database when there is an issue with the configuration of a Core Data Services (CDS) view or a search model. The error message indicates that a specific usage mode (#AUTO_FACET) cannot be used with the specified data type.
  Cause:
  The error is caused by a mismatch between the usage mode specified in the CDS view or search model and the data type of the field being used. The #AUTO_FACET usage mode is intended for fields that can be used as facets in search results, but not all data types are compatible with this mode. For example, certain complex data types or unsupported types may trigger this error.
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Check Data Type: Review the data type of the field that is causing the error. Ensure that it is compatible with the #AUTO_FACET usage mode. Typically, simple data types like STRING, INTEGER, or DATE are supported.
  
  
  Modify Usage Mode: If the data type is not compatible, consider changing the usage mode of the field. You can either remove the #AUTO_FACET usage mode or replace it with a different mode that is appropriate for the data type.
  
  
  Adjust CDS View: If you are working with a CDS view, you may need to adjust the definition of the view to ensure that the fields used for faceting are of compatible types.
  
  
  Consult Documentation: Refer to the SAP documentation for Core Data Services and Enterprise Search to understand the supported data types and usage modes. This can provide insights into how to configure your models correctly.
  
  
  Testing: After making changes, test the CDS view or search model to ensure that the error is resolved and that the desired functionality is achieved.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes or Knowledge Base Articles that may provide additional context or solutions for this specific error.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Version Compatibility: Ensure that you are using a version of SAP that supports the features you are trying to implement, as there may be differences in behavior across versions.
  
  By following these steps, you should be able to identify the cause of the error and implement a suitable solution.