How To Fix RSDRD120 - &1 data records deleted from DataStore table &2

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDRD - Messages for Delete Module

• Message number: 120

• Message text: &1 data records deleted from DataStore table &2

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDRD120 - &1 data records deleted from DataStore table &2 ?

  The SAP error message RSDRD120 indicates that a certain number of data records have been deleted from a DataStore Object (DSO) table. This message typically occurs during data loading or data processing activities in SAP BW (Business Warehouse) when records are removed from the DSO due to various reasons.
  Cause:
  
  Data Overwrite: The data being loaded may overwrite existing records, leading to the deletion of old records.
  Data Cleansing: During data processing, records that do not meet certain criteria may be deleted as part of a data cleansing process.
  Data Load Errors: If there are issues with the data being loaded (e.g., duplicates, incorrect formats), the system may delete records to maintain data integrity.
  Data Retention Policies: There may be configured retention policies that automatically delete old or unnecessary records from the DSO.
  Manual Deletion: Records may have been manually deleted by users or through a process that is part of data management.
  
  Solution:
  
  Check Data Load Process: Review the data load process to ensure that it is functioning correctly and that the data being loaded is valid.
  Review Transformation Rules: If you are using transformations, check the rules to ensure they are not inadvertently causing records to be deleted.
  Data Quality Checks: Implement data quality checks to ensure that only valid records are being loaded into the DSO.
  Retention Policy Review: If there are retention policies in place, review them to ensure they align with your data management strategy.
  Error Logs: Check the error logs for any additional messages that may provide more context on why records were deleted.
  Backup and Restore: If necessary, restore data from backups if the deletion was unintentional and the data is critical.
  
  Related Information:
  
  Transaction Codes: You can use transaction codes like RSA1 (Data Warehousing Workbench) to monitor and manage your DataStore Objects.
  DataStore Object Settings: Review the settings of the DSO in question to understand its configuration and how it handles data loading and deletion.
  SAP Notes: Check for any relevant SAP Notes that may address specific issues related to this error message or provide guidance on best practices for managing DSOs.
  Documentation: Refer to SAP BW documentation for detailed information on DataStore Objects, data loading processes, and error handling.
  
  By following these steps, you should be able to identify the cause of the RSDRD120 error message and implement appropriate solutions to address it.