How To Fix RS_SMA805 - Selection statistic is not extracted since &1

SAP Error Message - Details

• Message type: E = Error

• Message class: RS_SMA -

• Message number: 805

• Message text: Selection statistic is not extracted since &1

What causes this issue?

The system tried to make a proposal for a data archiving process for
InfoProvider <(>&<)>v1&. The selection statistics that this proposal
would be based on have not been extracted.

System Response

No proposal for the data archiving process is made.

How to fix this error?

You can lower the requirements for the selection statistics in
Environment->Parameter or you can schedule the process chain "0TCT_C41"
that extracts the selection statistics.

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 RS_SMA805 - Selection statistic is not extracted since &1 ?

  The SAP error message RS_SMA805 indicates that the selection statistics for a specific InfoProvider or query have not been extracted since a certain date. This message typically arises in the context of SAP BW (Business Warehouse) and is related to the extraction of data for reporting and analysis.
  Cause:
  The error message RS_SMA805 can be caused by several factors, including:
  
  Data Extraction Issues: There may be issues with the data extraction process, such as missing or incomplete data in the source system.
  Selection Statistics Not Activated: The selection statistics feature may not be activated for the specific InfoProvider or query.
  Data Load Failures: Previous data loads may have failed, leading to incomplete or missing selection statistics.
  Time Frame: The selection statistics may not have been updated for a long time, leading to the message indicating that they have not been extracted since a specific date.
  
  Solution:
  To resolve the RS_SMA805 error, you can take the following steps:
  
  
  Check Data Load Status: Verify the status of the data loads for the InfoProvider or query. Ensure that all relevant data loads have been completed successfully without errors.
  
  
  Activate Selection Statistics: If selection statistics are not activated, you may need to activate them for the InfoProvider or query. This can typically be done in the SAP BW system by navigating to the relevant InfoProvider settings.
  
  
  Re-extract Data: If the selection statistics are outdated, you may need to re-extract the data. This can be done by executing the relevant data extraction process again.
  
  
  Check for Errors in the Process Chain: If the extraction is part of a process chain, check the process chain logs for any errors or warnings that may indicate why the selection statistics are not being updated.
  
  
  Review the Time Frame: If the selection statistics have not been updated for a long time, consider running a full data load or a delta load to refresh the statistics.
  
  
  Consult SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error message or provide additional troubleshooting steps.
  
  
  Related Information:
  
  Transaction Codes: You may use transaction codes like RSA1 (Data Warehousing Workbench) to check InfoProviders and monitor data loads.
  Process Chains: Familiarize yourself with process chains in SAP BW, as they are often used to manage data extraction and loading processes.
  SAP Documentation: Refer to the official SAP documentation for more detailed information on selection statistics and data extraction processes.
  
  If the issue persists after following these steps, it may be beneficial to consult with your SAP Basis or BW team for further investigation and support.