How To Fix ESH_DB037 - No activation of CDS-entities for Enterprise Search

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_DB - ES: Dashboard

• Message number: 037

• Message text: No activation of CDS-entities for Enterprise Search

What causes this issue?

In every system, there are CDS-based Data Sources - at least those
defined by Enterprise Search. CDS-based Data Sources are always
available for search.
Here, the CDS-based Data Sources have not been activated - a situation
which must not occur.

System Response

Search is not possible for CDS-based Data Sources; if run in a pure
CDS-mode, search as a whole is not possible.

How to fix this error?

Run report ESH_CDSABAP_ACTIVATION with default parametrization.
Contact SAP if the problem persists, or if it occurs repeatedly.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message ESH_DB037 - No activation of CDS-entities for Enterprise Search ?

  The SAP error message ESH_DB037 indicates that there is an issue with the activation of Core Data Services (CDS) entities for Enterprise Search. This error typically arises when the system is unable to activate the necessary CDS views that are required for the Enterprise Search functionality to work properly.
  
  Cause:
  
  Missing or Incomplete CDS Views: The required CDS views may not be defined or may be incomplete.
  Authorization Issues: The user may not have the necessary authorizations to activate the CDS views.
  Transport Issues: If the CDS views were transported from another system, there may have been issues during the transport process.
  Database Issues: There may be underlying database issues that prevent the activation of the CDS views.
  
  Configuration Issues: Incorrect configuration settings in the Enterprise Search or the underlying data model.
  
  
  Solution:
  
  
  Check CDS View Definitions: Ensure that the required CDS views are correctly defined and activated in the system. You can do this by navigating to