How To Fix ESH_DB039 - CDS-only search possible but not active

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_DB - ES: Dashboard

• Message number: 039

• Message text: CDS-only search possible but not active

What causes this issue?

With the current HANA-release, Enterprise Search could be run on
CDS-based connectors only. Currently, the system works in a mixed mode,
as search connectors based on Enterprise Search-models have been
created.
This mixed mode is the usual state as long as the migration to CDS-based
connectors has not been completed.

System Response

Enterprise Search is fully operational.

How to fix this error?

No action required.

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_DB039 - CDS-only search possible but not active ?

  The SAP error message ESH_DB039 indicates that a CDS (Core Data Services) view is required for a search operation, but the necessary configuration for the CDS-based search is not active. This error typically occurs in the context of SAP Enterprise Search or SAP HANA when the system is trying to perform a search that relies on CDS views, but those views are not properly activated or configured.
  Cause:
  
  CDS View Not Active: The required CDS view for the search is not activated in the system.
  Search Configuration Issues: The search configuration may not be set up correctly to utilize CDS views.
  Missing Authorization: The user may not have the necessary authorizations to access the CDS views.
  System Settings: The system may not be configured to use CDS-based search.
  
  Solution:
  
  
  Activate the CDS View:
  
  Go to the ABAP Development Tools (ADT) in Eclipse or use transaction SE11/SE80 in the SAP GUI.
  Locate the CDS view that is required for the search.
  Ensure that the view is activated. If it is not, activate it.
  
  
  
  Check Search Configuration:
  
  Navigate to the SAP Enterprise Search configuration (transaction ESH_COCKPIT).
  Ensure that the search connector for the CDS view is properly configured and activated.
  
  
  
  Review Authorizations:
  
  Check the user roles and authorizations to ensure that the user has access to the necessary CDS views.
  Use transaction SU53 to analyze authorization issues after the error occurs.
  
  
  
  System Settings:
  
  Ensure that the system is set up to support CDS-based searches. This may involve checking system parameters or settings in the SAP HANA database.
  
  
  
  Consult Documentation:
  
  Refer to the SAP Help Portal or relevant SAP Notes for specific guidance on configuring and troubleshooting CDS-based searches.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might address specific issues related to the error message ESH_DB039.
  SAP Community: Engage with the SAP Community forums for insights from other users who may have encountered similar issues.
  Documentation: Review the official SAP documentation on Enterprise Search and CDS views for best practices and configuration steps.
  
  By following these steps, you should be able to resolve the ESH_DB039 error and enable CDS-based search functionality in your SAP system.