How To Fix ESH_SQL_SEARCH036 - No access to ESH procedure SYS.ESH_SEARCH

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 036

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

What causes this issue?

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

System Response

The search cannot be executed.

How to fix this error?

For missing authorizations for search in 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_SEARCH036 - No access to ESH procedure SYS.ESH_SEARCH ?

  The SAP error message ESH_SQL_SEARCH036 indicates that there is no access to the ESH (Enterprise Search) procedure SYS.ESH_SEARCH. This error typically arises when a user or a role does not have the necessary authorizations to execute the ESH search functionality.
  Cause:
  
  Authorization Issues: The user executing the search does not have the required authorizations to access the ESH procedure.
  Missing Roles: The user may not be assigned the necessary roles that include the required permissions for ESH.
  Database Permissions: There may be restrictions at the database level that prevent access to the ESH procedures.
  
  Solution:
  
  
  Check User Authorizations:
  
  Use transaction code SU53 immediately after the error occurs to check for missing authorizations.
  Review the authorization objects related to ESH, such as S_RFC, S_DEVELOP, and any specific ESH-related authorization objects.
  
  
  
  Assign Required Roles:
  
  Ensure that the user has been assigned the appropriate roles that include access to ESH functionalities. Common roles include:
  
  SAP_BC_ESH_ADMIN
  SAP_BC_ESH_USER
  
  
  You can check and assign roles using transaction code PFCG.
  
  
  
  Database Permissions:
  
  If the issue persists, check with your database administrator to ensure that the user has the necessary permissions to execute stored procedures in the database.
  
  
  
  Consult Documentation:
  
  Refer to the SAP Help Portal or the specific documentation for your version of SAP to understand the required authorizations for ESH.
  
  
  
  Contact SAP Support:
  
  If you are unable to resolve the issue, consider reaching out to SAP Support for further assistance.
  
  
  
  Related Information:
  
  Transaction Codes:
  
  SU53: Display Authorization Check
  PFCG: Role Maintenance
  
  
  Authorization Objects:
  
  S_RFC: Allows remote function calls.
  S_DEVELOP: Allows access to development objects.
  
  
  SAP Notes: Check for any relevant SAP Notes that might address this specific error or provide additional guidance.
  
  By following these steps, you should be able to diagnose and resolve the issue related to the ESH_SQL_SEARCH036 error message.