How To Fix RS_SMA804 - Statistics for InfoProvider &1 only recorded since &3

SAP Error Message - Details

• Message type: E = Error

• Message class: RS_SMA -

• Message number: 804

• Message text: Statistics for InfoProvider &1 only recorded since &3

What causes this issue?

The system tried to generate a proposal for a data archiving process for
InfoProvider <(>&<)>v1&. As part of this proposal<(>,<)> the system
tried to determine the period that data should be archived for. This
proposal is based on statistics of data manager selections. In the
parameters (Environment --> Parameter), the date starting from which
statistics should be considered is defined. This date is currently
<(>&<)>v2&. Statistics have only been recorded since <(>&<)>v3<(>&<)>
however.

System Response

The system is not able to make a reasonable proposal for a data
archiving process.

How to fix this error?

Collect more statistical data<(>,<)> or create a data transfer process
manually.

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_SMA804 - Statistics for InfoProvider &1 only recorded since &3 ?

  The SAP error message RS_SMA804 indicates that statistics for a specific InfoProvider (denoted as &1) have only been recorded since a certain date (denoted as &3). This message typically arises in the context of SAP BW (Business Warehouse) and is related to the statistics that are collected for performance monitoring and optimization.
  Cause:
  The primary cause of this error message is that the statistics for the specified InfoProvider have not been collected for a longer period, which can happen due to several reasons:
  
  New InfoProvider: The InfoProvider might be newly created, and statistics have only started being collected since its creation.
  Statistics Reset: The statistics might have been reset or deleted, leading to a loss of historical data.
  Data Load Issues: There may have been issues with data loads that prevented statistics from being recorded properly.
  Configuration Changes: Changes in the configuration of the InfoProvider or the data model could also lead to this situation.
  
  Solution:
  To address the RS_SMA804 error message, consider the following steps:
  
  Check InfoProvider Configuration: Ensure that the InfoProvider is correctly configured and that data is being loaded as expected.
  Review Data Loads: Verify that data loads are running successfully and that there are no errors in the process. Check the data load logs for any issues.
  Collect Statistics: If the InfoProvider is new, allow some time for statistics to accumulate. You can also manually trigger the collection of statistics if needed.
  Reset Statistics: If you suspect that the statistics are corrupted or not useful, you can reset them and allow the system to collect new statistics.
  Monitor Performance: Use transaction codes like RSSTAT or RSRT to monitor the performance of the InfoProvider and ensure that statistics are being collected over time.
  
  Related Information:
  
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as:
  
  RSSTAT: For viewing and managing statistics.
  RSA1: For accessing the Data Warehousing Workbench.
  RSD1: For InfoProvider maintenance.
  
  
  
  SAP Notes: Check SAP Notes for any known issues or updates related to statistics collection for InfoProviders.
  
  
  Documentation: Refer to SAP BW documentation for best practices on managing InfoProviders and collecting statistics.
  
  
  By following these steps, you should be able to resolve the RS_SMA804 error and ensure that statistics for your InfoProvider are being collected appropriately.