How To Fix S1091 - No table statistics found for application server &

SAP Error Message - Details

• Message type: E = Error

• Message class: S1 - Statistik / SAP-Monitor

• Message number: 091

• Message text: No table statistics found for application server &

What causes this issue?

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

System Response

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

How to fix this error?

The CALL statistics have possibly been switched off on the computer by
the startup profile parameter rsdb/staton = 0. It is also possible that
the data was deleted by the regular reorganization run. You can
increase the residence time of the data for the table statistics in the
performance database with transaction ST03 by choosing the menu options
<LS>GOTO -> PARAMETERS</>. The call statistics use the time value for
"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 S1091 - No table statistics found for application server & ?

  The SAP error message S1091, which states "No table statistics found for application server &," typically indicates that the SAP system is unable to find the necessary statistics for a specific database table on the specified application server. This can lead to performance issues, as the database optimizer relies on these statistics to make informed decisions about how to execute queries efficiently.
  Causes:
  
  Missing Statistics: The most common cause is that the database statistics for the specified table have not been generated or updated.
  Database Configuration: There may be issues with the database configuration or connectivity that prevent the retrieval of statistics.
  Transport Issues: If the table was recently transported from another system, the statistics may not have been transported along with the table definition.
  Database Maintenance: Regular maintenance tasks, such as database reorganization or updates, may have led to the loss of statistics.
  
  Solutions:
  
  
  Generate Statistics:
  
  Use the appropriate database tools or SQL commands to generate or update the statistics for the affected table. In SAP, you can use transaction codes like DB02 or ST03N to analyze and manage database performance.
  For example, in Oracle, you might use:
  EXEC DBMS_STATS.GATHER_TABLE_STATS('schema_name', 'table_name');
  
  In SQL Server, you might use:
  UPDATE STATISTICS schema_name.table_name;
  
  
  
  
  Check Database Connection: Ensure that the application server is properly connected to the database and that there are no network issues.
  
  
  Review Transport Logs: If the table was recently transported, check the transport logs to ensure that all necessary objects, including statistics, were included.
  
  
  Database Maintenance: Perform regular database maintenance tasks to ensure that statistics are kept up to date. This may include scheduling jobs to gather statistics periodically.
  
  
  Consult Documentation: Refer to the SAP documentation or your database vendor's documentation for specific commands and procedures related to gathering statistics.
  
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as DB02 (Database Performance Analysis) and ST03N (Workload Analysis).
  Database-Specific Tools: Depending on your database (e.g., Oracle, SQL Server, HANA), there may be specific tools or commands to manage statistics.
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message. SAP Notes can provide additional context or solutions specific to your version of SAP.
  
  By addressing the underlying cause of the missing statistics and ensuring that they are regularly maintained, you can resolve the S1091 error and improve the performance of your SAP system.