How To Fix ESH_HANA_FL_ADMIN097 - Required success threshold &1% NOT met (non-fail ratio: &2%)

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_HANA_FL_ADMIN - ESH HANA File Loader

• Message number: 097

• Message text: Required success threshold &1% NOT met (non-fail ratio: &2%)

What causes this issue?

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

To change settings like "Success Threshold", use the following
maintenance views or go to IMG (SPRO, SAP NetWeaver Implementation Guide
-> Search and Operational Analytics -> Enterprise Search -> File Loader
Configuration
Change global settings:
File Loader System Settings:
Maintain Table Views (transaction SM30, view ESH_CU_FL_SET_SY)
Change connector specific settings:
File Loader Settings:
View Cluster Maintenance (transaction SM34, view VC_ESH_PSIZE)

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message ESH_HANA_FL_ADMIN097 - Required success threshold &1% NOT met (non-fail ratio: &2%) ?

  The SAP error message ESH_HANA_FL_ADMIN097 indicates that a required success threshold for a certain operation has not been met. This error typically arises in the context of SAP HANA and the SAP Enterprise Search (ESH) framework, particularly when dealing with the administration of full-text search indexes.
  Cause:
  The error message specifies that the non-fail ratio (the percentage of successful operations) is below the required threshold. This can occur due to several reasons:
  
  Indexing Issues: There may be problems with the indexing process, such as data inconsistencies or failures during the indexing of documents.
  System Performance: The HANA system may be under heavy load, leading to timeouts or failures in processing requests.
  Configuration Errors: Incorrect configuration settings for the search or indexing processes can lead to failures.
  Data Quality Issues: If the data being indexed has quality issues (e.g., missing fields, incorrect formats), it can lead to failures in the indexing process.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  Check Indexing Logs: Review the logs for the indexing process to identify any specific errors or warnings that may indicate the root cause of the failures.
  Monitor System Performance: Use SAP HANA monitoring tools to check for performance bottlenecks. Ensure that the system has sufficient resources (CPU, memory, disk I/O) to handle the indexing workload.
  Review Configuration Settings: Verify the configuration settings for the full-text search and indexing processes. Ensure that they are set correctly according to the best practices and your specific use case.
  Data Quality Assessment: Conduct a data quality assessment to ensure that the data being indexed is complete and correctly formatted. Address any issues found.
  Retry Indexing: After addressing the underlying issues, retry the indexing process to see if the success threshold is met.
  Adjust Thresholds: If appropriate, consider adjusting the success threshold settings, but this should be done with caution and understanding of the implications.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional guidance or patches related to this error.
  Documentation: Refer to the official SAP documentation for Enterprise Search and HANA administration for best practices and troubleshooting steps.
  Community Forums: Engage with the SAP Community or forums where other users may have encountered similar issues and can share their solutions.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to meet the required success threshold.