How To Fix RSDMD104 - Unprocessed new records in table &

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDMD - Messages for master data

• Message number: 104

• Message text: Unprocessed new records in table &

What causes this issue?

A lock should be set on table &V1&. However, before setting the lock it
was determined that unprocessed, new records exist in the table. It is
for this reason that the lock to table &V1& was not carried out.
The records found possibly come from a previous update that has been
terminated. Further processing would lead to inconsistent data in table
&V1&.

System Response

The lock cannot be set.

How to fix this error?

Delete the unprocessed new records from table &V1& and restart the
process that was terminated by the lock management. In order to delete
the unprocessed new records from the table use the delete function in
the Monitor.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSDMD104 - Unprocessed new records in table & ?

  The SAP error message RSDMD104 indicates that there are unprocessed new records in a specific table, which typically relates to issues in the data loading process in SAP BW (Business Warehouse). This error can occur during the data extraction, transformation, and loading (ETL) process when new records are not processed correctly.
  Cause:
  
  Data Load Issues: The most common cause is that the data load process has encountered an error, preventing new records from being processed.
  Data Source Configuration: There may be issues with the configuration of the data source or the InfoPackage that is responsible for loading the data.
  Data Quality Issues: The incoming data may have quality issues, such as missing mandatory fields or incorrect data formats.
  Delta Load Problems: If you are using delta loads, there may be issues with the delta mechanism, causing new records to be missed.
  Locking Issues: There may be locks on the data that prevent processing.
  
  Solution:
  
  Check the Data Load Process: Review the data load process in the SAP BW system. Check the logs for any errors or warnings that may indicate why the records were not processed.
  Reprocess the Data: If the issue is resolved, you can reprocess the data. This can be done by executing the InfoPackage again or using the "Manage" option in the Data Warehousing Workbench.
  Check Data Source Settings: Ensure that the data source and InfoPackage settings are correctly configured. Verify that the extraction logic is correct and that there are no filters that might be excluding records.
  Data Quality Checks: Perform data quality checks on the incoming data to ensure that it meets the required standards. Correct any issues found.
  Monitor Delta Loads: If using delta loads, ensure that the delta mechanism is functioning correctly. Check for any issues with the delta queue.
  Clear Locks: If there are locks on the data, you may need to clear them. This can be done using transaction codes like SM12 to check for and delete any locks.
  
  Related Information:
  
  Transaction Codes: Use transaction codes like RSA1 (Data Warehousing Workbench), RSMO (Monitor Data Load), and SM37 (Job Monitoring) to monitor and manage data loads.
  SAP Notes: Check for relevant SAP Notes that may provide additional insights or solutions for this specific error message.
  Documentation: Refer to SAP BW documentation for best practices on data loading and troubleshooting common issues.
  
  By following these steps, you should be able to identify the cause of the RSDMD104 error and implement a solution to process the unprocessed records successfully.