How To Fix ESH_DB018 - Query logging is switched off

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_DB - ES: Dashboard

• Message number: 018

• Message text: Query logging is switched off

What causes this issue?

The anonymized query logging has been switched off.

System Response

This is not a problem, Enterprise Search works. But switching this
feature off implies that it is not possible to analyze and to optimize
the usage and behavior of Enterprise Search.

How to fix this error?

Consider switching the query log on.

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_DB018 - Query logging is switched off ?

  The SAP error message ESH_DB018 indicates that query logging is switched off in the Enterprise Search (ES) system. This can prevent the system from logging queries, which is essential for performance analysis, troubleshooting, and monitoring user activity.
  Cause:
  The primary cause of this error message is that the query logging feature in the SAP Enterprise Search configuration is disabled. This can happen due to:
  
  Configuration Settings: The logging settings may not have been enabled during the initial setup or may have been disabled later.
  System Performance: In some cases, logging may be turned off to improve system performance, especially in high-load environments.
  Administrative Decisions: Administrators may choose to disable logging for privacy or compliance reasons.
  
  Solution:
  To resolve the ESH_DB018 error, you need to enable query logging in the SAP Enterprise Search configuration. Here are the steps to do this:
  
  
  Access the SAP System: Log in to your SAP system with appropriate administrative privileges.
  
  
  Navigate to the Configuration:
  
  Go to the transaction code /IWFND/MAINT_SERVICE or /IWFND/ERROR_LOG to access the relevant configuration settings.
  Alternatively, you can use the transaction SE80 to navigate to the relevant Enterprise Search configuration.
  
  
  
  Enable Query Logging:
  
  Look for the settings related to query logging. This is typically found under the Enterprise Search settings or the specific search service configuration.
  Enable the query logging option. This may involve setting a parameter or checkbox to activate logging.
  
  
  
  Save Changes: After making the necessary changes, ensure you save the configuration.
  
  
  Restart Services: In some cases, you may need to restart the relevant services or the entire SAP system for the changes to take effect.
  
  
  Verify Logging: After enabling logging, perform a test query to ensure that logging is now active and that the error message no longer appears.
  
  
  Related Information:
  
  Performance Considerations: While enabling query logging is important for monitoring and troubleshooting, be aware that it may have an impact on system performance, especially in high-traffic environments. Monitor the system performance after enabling logging.
  Data Privacy: Ensure that enabling query logging complies with your organization's data privacy policies, as it may log sensitive user query information.
  Documentation: Refer to the official SAP documentation for Enterprise Search for detailed instructions and best practices regarding configuration and logging.
  
  If you continue to experience issues after enabling query logging, consider checking the system logs for additional error messages or consulting with SAP support for further assistance.