How To Fix ESH_DB040 - CDS-only search currently active

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_DB - ES: Dashboard

• Message number: 040

• Message text: CDS-only search currently active

What causes this issue?

Enterprise Search runs on CDS-based search connectors only. But as there
are traditional Enterprise Search-models available, the assumption is
that these search connectors simply have not yet been set up.

System Response

Enterprise Search is fully operational.

How to fix this error?

Check whether search connectors ought to be created from the traditional
Enterprise Search-models. If none of them are required, no action has to
be taken.

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_DB040 - CDS-only search currently active ?

  The SAP error message ESH_DB040 indicates that a CDS (Core Data Services) only search is currently active in the SAP system. This error typically arises in the context of SAP Enterprise Search or SAP HANA when a search operation is attempted while the system is configured to only allow searches through CDS views.
  Cause:
  
  CDS-Only Configuration: The system is configured to perform searches exclusively through CDS views, which may limit the search capabilities to specific data models.
  Search Mode: The search mode may be set to CDS-only, which means that other search methods (like traditional database searches) are not available.
  System Settings: The settings in the SAP system or the search application may not be correctly configured to allow for broader search capabilities.
  
  Solution:
  
  Check Configuration: Review the configuration settings for the search application in SAP. Ensure that the search mode is set correctly and that it allows for the desired search types.
  Adjust Search Settings: If you need to perform a search that is not supported in CDS-only mode, consider changing the search settings to allow for other search methods.
  Use CDS Views: If the system is intended to operate in CDS-only mode, ensure that you are using the appropriate CDS views for your search queries.
  Consult Documentation: Refer to the SAP documentation for Enterprise Search and CDS views to understand the limitations and capabilities of the current configuration.
  Contact SAP Support: If the issue persists and you cannot resolve it through configuration changes, consider reaching out to SAP support for further assistance.
  
  Related Information:
  
  SAP HANA: Understanding how SAP HANA handles data and search operations can provide insights into the limitations and capabilities of CDS views.
  Enterprise Search: Familiarize yourself with the features and configurations of SAP Enterprise Search, especially in relation to CDS views.
  CDS Views: Learn more about how to create and utilize CDS views effectively in your SAP environment to ensure that your searches return the expected results.
  
  By addressing the configuration and understanding the limitations of the CDS-only search mode, you can resolve the ESH_DB040 error and improve your search capabilities within the SAP system.