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

SAP Error Message - Details

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

Smart SAP Assistant

• What is the cause and solution for SAP error message ESH_SQL_SEARCH037 - No access to ESH procedure SYS.ESH_CONFIG ?

  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 that include the required authorizations. Common roles related to ESH include:
  
  SAP_ESH_ADMIN
  SAP_ESH_USER
  
  
  You can assign these roles through transaction PFCG.
  
  
  
  Database User Privileges:
  
  If the issue persists, check the database user privileges. Ensure that the database user has the necessary permissions to execute the ESH procedures.
  You may need to work with your database administrator to grant the required privileges.
  
  
  
  Check ESH Configuration:
  
  Verify that the ESH configuration is correctly set up in your SAP system. This includes checking the settings in transaction EHS_CONFIG or similar configuration transactions.
  
  
  
  Consult Documentation:
  
  Refer to the SAP Help Portal or relevant SAP Notes for more detailed information on the specific authorizations required for ESH.
  
  
  
  Related Information:
  
  SAP Notes: Search for relevant SAP Notes that might address this specific error or provide additional troubleshooting steps.
  Transaction Codes: Familiarize yourself with transaction codes related to ESH, such as EHS_CONFIG, EHS_SEARCH, and others that might be relevant to your configuration and search functionalities.
  Support: If the issue cannot be resolved through the above steps, consider reaching out to SAP Support for further assistance.
  
  By following these steps, you should be able to resolve the ESH_SQL_SEARCH037 error and ensure that the user has the necessary access to the ESH configuration.