How To Fix S1093 - No table access statistics for day & found

SAP Error Message - Details

• Message type: E = Error

• Message class: S1 - Statistik / SAP-Monitor

• Message number: 093

• Message text: No table access statistics for day & found

What causes this issue?

There are no table CALL statistics for the selected application
server/instance in the performance database MONI or in the main storage
area (for your own instance) for the required day.

System Response

You do not get any analysis data for the table statistics.

How to fix this error?

The CALL statistics may possibly have been deactivated by the startup
profile parameter <LS>rsdb/staton = 0</>. It is also possible that the
data was deleted during the regular reorganization run. You can
increase the residence time of the table statistics data in the
performance database using transaction ST03, menu options <LS>GOTO ->
PARAMETERS</>. The call statistics use the time value of the
"Long-term" dates as a residence time.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message S1093 - No table access statistics for day & found ?

  The SAP error message S1093 "No table access statistics for day & found" typically occurs when the system is trying to access table statistics for a specific day, but no statistics are available for that day. This can happen for various reasons, such as the statistics not being generated or the data being purged.
  Cause:
  
  Statistics Not Generated: The database statistics for the specified day may not have been generated due to a lack of activity or a failure in the statistics collection process.
  Data Purging: The statistics data may have been purged or deleted based on retention policies or manual intervention.
  Incorrect Date: The date specified in the error message may not correspond to any existing statistics in the system.
  
  Solution:
  
  
  Generate Statistics: Ensure that the statistics for the relevant tables are being generated correctly. You can do this by running the appropriate transaction or report to collect statistics. In SAP, this is often done using transaction codes like DB02 or ST03N.
  
  
  Check Retention Settings: Review the settings for how long statistics are retained in your system. If they are being purged too frequently, consider adjusting the retention policy.
  
  
  Verify Date: Check the date specified in the error message to ensure it is correct. If you are looking for statistics for a specific day, confirm that the statistics were indeed collected for that day.
  
  
  Database Administration: If you have access to the database, you can also check the underlying database management system (DBMS) for any issues related to statistics collection.
  
  
  Consult Documentation: Refer to SAP documentation or notes related to performance monitoring and statistics collection for your specific version of SAP.
  
  
  Contact SAP Support: If the issue persists and you cannot resolve it, consider reaching out to SAP support for further assistance.
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with transaction codes like DB02 (Database Performance Analysis) and ST03N (Workload Analysis) for monitoring and analyzing database performance and statistics.
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  Performance Tuning: Regularly monitor and tune database performance to ensure that statistics are collected and maintained properly.
  
  By following these steps, you should be able to address the S1093 error and ensure that table access statistics are available for analysis.