How To Fix ESH_SQL_SEARCH037 - No access to ESH procedure SYS.ESH_CONFIG

ESH_SQL_SEARCH037 - Overview

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 037

• Message text: No access to ESH procedure SYS.ESH_CONFIG

What causes this issue?

The technical user has no authorizations to execute in HANA the Stored
Procedure "SYS.ESH_CONFIG".

System Response

The HANA configuration cannot be written for the CDS-view.

How to fix this error?

For missing authorizations to writing the HANA configuration for
CDS-views consider the link:
https://wiki.wdf.sap.corp/wiki/display/HDBSearch/System+Setup+for+ABAP+C
DS+Search

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.

ESH_SQL_SEARCH037 - Details

• The SAP error message ESH_SQL_SEARCH037 indicates that there is no access to the ESH (Enterprise Search) procedure SYS.ESH_CONFIG. This error typically arises when a user or a role does not have the necessary authorizations to access the ESH configuration settings in the database.
  
  Cause:
  
  Authorization Issues: The user executing the search does not have the required permissions to access the ESH configuration procedure.
  Missing Roles: The user might not be assigned the necessary roles that include access to the ESH functionalities.
  Database User Privileges: The database user might not have the required privileges to execute the ESH procedures.
  
  
  Solution:
  
  
  Check User Authorizations:
  
  Ensure that the user has the necessary authorizations to access the ESH configuration. This can be done by checking the roles assigned to the user in the SAP system.
  The user should have roles that include access to ESH-related transactions and functions.
  
  
  
  Assign Required Roles:
  
  If the user lacks the necessary roles, you may need to assign roles