How To Fix ESH_SQL_SEARCH010 - No HANA-config. available, reactivate the corresponding CDS-View

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 010

• Message text: No HANA-config. available, reactivate the corresponding CDS-View

What causes this issue?

The search ends with the error:
'HANA ESH_SEARCH stored procedure: exception 9620013: Where/Why found
can only be requested together with an anchor table definition.'

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

System Response

The CDS connector has no HANA configuration required for the search.

How to fix this error?

Reactivate the CDS-View corresponding to the CDS-connector or execute
the report ESH_REFRESH_CDS_CONFIGURATION to update the HANA
configuration for all CDS connectors available in the system.
Restart the search for the required CDS connector.

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_SQL_SEARCH010 - No HANA-config. available, reactivate the corresponding CDS-View ?

  The SAP error message ESH_SQL_SEARCH010 indicates that there is no HANA configuration available for the corresponding Core Data Services (CDS) view. This typically occurs in the context of SAP's Enterprise Search or when trying to execute a search that relies on a specific CDS view that has not been properly configured or activated in the HANA database.
  Cause:
  
  CDS View Not Activated: The CDS view that is being referenced may not be activated in the HANA database. This can happen if the view was recently created or modified and the changes have not been activated.
  Missing HANA Configuration: The necessary HANA configuration for the CDS view may not exist, which can occur if the view is not properly set up to be used with HANA.
  Transport Issues: If the CDS view was transported from another system, it may not have been activated in the target system.
  Authorization Issues: There may be authorization issues preventing the activation or access to the CDS view.
  
  Solution:
  
  
  Reactivate the CDS View:
  
  Go to the ABAP Development Tools (ADT) in Eclipse or the SAP GUI.
  Navigate to the CDS view that is causing the error.
  Right-click on the view and select "Activate" to ensure it is properly activated in the HANA database.
  
  
  
  Check HANA Configuration:
  
  Ensure that the CDS view is correctly configured to work with HANA. This may involve checking the annotations and ensuring that the view is set up to be consumed by HANA.
  
  
  
  Transport the CDS View:
  
  If the view was transported, ensure that all necessary objects and dependencies are also transported and activated in the target system.
  
  
  
  Check Authorizations:
  
  Verify that the user has the necessary authorizations to access and activate the CDS view.
  
  
  
  Check for Errors in Activation:
  
  If there are errors during activation, check the activation logs for any issues that need to be resolved.
  
  
  
  Related Information:
  
  CDS Views: Core Data Services (CDS) are a way to define semantic data models in SAP. They are used extensively in SAP S/4HANA and other SAP applications.
  HANA Database: SAP HANA is an in-memory database that allows for real-time data processing and analytics. CDS views are often used to leverage the capabilities of HANA.
  Enterprise Search: This is a feature in SAP that allows users to search across various data sources. It often relies on CDS views for data retrieval.
  
  If the issue persists after following these steps, it may be beneficial to consult SAP support or check the SAP Community for similar issues and solutions.