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 and navigate to the transaction code ESH_COCKPIT (Enterprise Search Cockpit).
  In the Enterprise Search Cockpit, find the relevant search connector or data source.
  Check if the full-text index is activated. If not, you will need to activate it.
  You may also need to create a new full-text index if one does not exist.
  
  
  
  Use Transaction Code: You can also use transaction code SE11 to check the database table or CDS view and see if the full-text index is defined. If it is not, you may need to create it.
  
  
  Rebuild Index: If the index exists but is not functioning correctly, you may need to rebuild it. This can often be done through the same Enterprise Search Cockpit or relevant administration tools.
  
  
  Check Authorization: Ensure that you have the necessary authorizations to create or activate full-text indexes.
  
  
  Consult Documentation: If you are unsure about the steps or the specific data source, refer to the SAP documentation or consult with your SAP Basis or technical team for assistance.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might provide additional guidance or fixes related to this error.
  Performance Considerations: Keep in mind that full-text indexing can impact system performance, especially during the indexing process. Plan accordingly.
  Search Configuration: Ensure that your search configuration is set up correctly to utilize full-text search capabilities.
  
  By following these steps, you should be able to resolve the error and enable full-text search functionality in your SAP system.