How To Fix ESH_ENG_CDSVAL_SRCH028 - Fulltext index required but not activated (&1)

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 028

• Message text: Fulltext index required but not activated (&1)

What causes this issue?

Annotation @Search.fulltextIndex.required signifies that the underlying
data base table field is to have a fulltext index; this requirement is
not met. A fulltext index is defined, but not switched on, because it is
bound to a Business Function.

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?

Whether or not the full-text index ought to be bound to a switch,
depends on the footprint as the full-text index might require even more
storage space than the column itself.
The fulltext index in question belongs to field &V4& of table &V3&. The
Business Function to be switched on is: &V2&. There may be other
Business Functions having the same effect, though; in doubt, please
refer the documentation.

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_SRCH028 - Fulltext index required but not activated (&1) ?

  The SAP error message ESH_ENG_CDSVAL_SRCH028 indicates that a full-text index is required for a specific search operation, but it has not been activated in the system. This error typically occurs in the context of SAP Enterprise Search or when using Core Data Services (CDS) views that rely on full-text search capabilities.
  
  Cause:
  The primary cause of this error is that the full-text index for the relevant data source has not been created or activated. Full-text indexing is necessary for enabling efficient search capabilities on large datasets, and without it, the system cannot perform the required search operations.
  
  Solution:
  To resolve this error, you need to activate or create the full-text index for the relevant data source. Here are the steps to do this:
  
  
  Check the Data Source: Identify the specific data source or CDS view that is causing the error. This information is usually provided in the error message.
  
  
  Activate Full-Text Index:
  
  Go to the SAP GUI