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

ESH_SQL_SEARCH010 - Overview

• 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.

ESH_SQL_SEARCH010 - Details

• 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