How To Fix ESH_DB041 - CDS-only search mandatory

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_DB - ES: Dashboard

• Message number: 041

• Message text: CDS-only search mandatory

What causes this issue?

The system does not contain traditional Enterprise Search-models, from
which search connectors could be created. Hence, the system runs in a
CDS-only mode.

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?

No action required.

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_DB041 - CDS-only search mandatory ?

  The SAP error message ESH_DB041 with the description "CDS-only search mandatory" typically occurs in the context of SAP's Enterprise Search or SAP HANA when a search operation is being executed that requires the use of Core Data Services (CDS) views, but the system is not configured to use them properly.
  Cause:
  
  Configuration Issue: The system may not be configured to use CDS views for the search operation. This can happen if the search is set to use a different data source or if the necessary CDS views are not activated.
  Search Settings: The search settings in the SAP system may not be aligned with the requirements for using CDS views.
  Missing Authorization: The user executing the search may not have the necessary authorizations to access the CDS views.
  
  Solution:
  
  
  Check Configuration:
  
  Ensure that the search configuration is set to use CDS views. This can typically be done in the SAP Fiori Launchpad or the relevant configuration transaction.
  Verify that the necessary CDS views are activated in the system. You can check this in the ABAP Development Tools or the relevant transaction (e.g., SE11 for Data Dictionary).
  
  
  
  Adjust Search Settings:
  
  Navigate to the settings for the search application and ensure that it is configured to use the appropriate CDS views. This may involve adjusting the search connector settings.
  
  
  
  User Authorizations:
  
  Check the user roles and authorizations to ensure that the user has access to the required CDS views. You may need to assign additional roles or permissions.
  
  
  
  Consult Documentation:
  
  Refer to the SAP Help Portal or the specific documentation for your version of SAP to understand the requirements for configuring CDS-based searches.
  
  
  
  System Logs:
  
  Check the system logs (transaction SLG1) for any additional error messages or warnings that may provide more context about the issue.
  
  
  
  Related Information:
  
  SAP Notes: Look for relevant SAP Notes that may address this specific error or provide additional troubleshooting steps.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they found effective.
  Training and Documentation: Consider reviewing training materials or documentation related to SAP HANA and CDS views to better understand their configuration and usage.
  
  If the issue persists after following these steps, it may be beneficial to reach out to SAP support for further assistance.