How To Fix ESH_DB057 - Query logging only without user-ID

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_DB - ES: Dashboard

• Message number: 057

• Message text: Query logging only without user-ID

What causes this issue?

The query logging for users not participating in Personalized Search is
switched on, but in the anonymized mode, where the user ID gets lost in
the log.

System Response

This is not a problem, Enterprise Search works.
With this setting, the evaluation and optimization options are
drastically reduced; both for Enterprise Search internally, and for an
administrator doing search engine optimization. For instance, basic
questions cannot be answered: How many users are active in Enterprise
Search? What are trending search terms (a term could be entered by 1000
users - or by one user, but 1000 times)?

How to fix this error?

If allowed under local law and regulations, the policy should be
switched to "pseudonymized logging".

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_DB057 - Query logging only without user-ID ?

  The SAP error message ESH_DB057 indicates that there is an issue with query logging in the SAP Enterprise Search (SAP ESH) system. Specifically, this error occurs when query logging is enabled, but the user ID is not being captured or logged correctly. This can lead to difficulties in tracking user queries and analyzing search behavior.
  Cause:
  
  Configuration Issues: The query logging might not be properly configured in the SAP system. This could be due to missing settings or incorrect parameters in the configuration.
  User ID Not Passed: The user ID may not be passed correctly during the query execution, which can happen due to issues in the application logic or user session management.
  Authorization Issues: The user may not have the necessary authorizations to log queries, leading to the absence of user ID in the logs.
  System Bugs: There may be bugs or inconsistencies in the version of SAP ESH being used that affect how query logging operates.
  
  Solution:
  
  
  Check Configuration: Review the configuration settings for query logging in the SAP ESH. Ensure that all necessary parameters are set correctly, including those related to user ID logging.
  
  Navigate to the relevant configuration settings in the SAP system (usually found in the transaction codes related to ESH).
  
  
  
  Verify User Session Management: Ensure that the user ID is being correctly passed and managed during the query execution. This may involve checking the application code or settings that handle user sessions.
  
  
  Review Authorizations: Check the authorization roles assigned to users to ensure they have the necessary permissions to log queries. Adjust roles if needed.
  
  
  Update SAP ESH: If you suspect a bug, check for any available updates or patches for your version of SAP ESH. Applying the latest updates can resolve known issues.
  
  
  Consult SAP Notes: Look for relevant SAP Notes that may address this specific error message. SAP Notes often provide solutions or workarounds for known issues.
  
  
  Contact SAP Support: If the issue persists after trying the above solutions, consider reaching out to SAP Support for further assistance. They can provide more detailed troubleshooting based on your specific system configuration.
  
  
  Related Information:
  
  SAP Documentation: Refer to the official SAP documentation for Enterprise Search for detailed information on configuration and troubleshooting.
  Community Forums: Engage with the SAP Community or forums where other users may have encountered similar issues and can share their solutions.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as SE80 (Object Navigator) or SICF (HTTP Service Hierarchy Maintenance) for checking service configurations.
  
  By following these steps, you should be able to identify and resolve the issue related to the ESH_DB057 error message in your SAP system.