How To Fix RSODSO_ROLLBACK204 - Inconsistent status data. Deletion canceled

SAP Error Message - Details

• Message type: E = Error

• Message class: RSODSO_ROLLBACK - DataStore Object: Messages for rollback

• Message number: 204

• Message text: Inconsistent status data. Deletion canceled

What causes this issue?

Different types of status data are stored in the table RSODSACTREQMPP
for various requests that were activated together. This is not allowed.

System Response

Request 1: &v1&
Request 2: &v2&

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSODSO_ROLLBACK204 - Inconsistent status data. Deletion canceled ?

  The SAP error message RSODSO_ROLLBACK204 indicates that there is an inconsistency in the status data of a DataStore Object (DSO) during a deletion process. This error typically occurs when the system encounters an issue while trying to delete data from a DSO, and it cannot complete the operation due to the inconsistent state of the data.
  Cause:
  
  
  Inconsistent Data: The DSO may have inconsistent status data, which can occur due to various reasons such as:
  
  Previous failed data loads or deletions.
  Manual changes to the DSO that did not follow the proper procedures.
  Issues during data transfer or extraction processes.
  
  
  
  Locking Issues: There may be locks on the DSO that prevent the deletion process from completing successfully.
  
  
  Data Integrity Issues: If there are integrity constraints that are violated during the deletion process, it can lead to this error.
  
  
  Solution:
  To resolve the RSODSO_ROLLBACK204 error, you can follow these steps:
  
  
  Check for Locks: 
  
  Use transaction code SM12 to check for any locks on the DSO. If there are locks, you may need to release them.
  
  
  
  Analyze the DSO:
  
  Use transaction code RSA1 to analyze the DSO and check for any inconsistencies. Look for any failed data loads or issues in the data flow.
  
  
  
  Repair the DSO:
  
  If you find inconsistencies, you may need to repair the DSO. This can involve:
  
  Reprocessing failed data loads.
  Manually correcting any data issues.
  Using the Repair function in the DSO settings.
  
  
  
  
  
  Delete Data Manually:
  
  If the automatic deletion fails, you may need to delete the data manually using the appropriate transaction (e.g., RSA1 or SE16).
  
  
  
  Check for Data Integrity:
  
  Ensure that there are no integrity constraints that are being violated. This may involve checking related InfoObjects or other dependent objects.
  
  
  
  Consult SAP Notes:
  
  Check the SAP Support Portal for any relevant SAP Notes that may address this specific error. There may be patches or updates that can resolve the issue.
  
  
  
  System Restart:
  
  In some cases, a system restart may help clear temporary issues that could be causing the error.
  
  
  
  Related Information:
  
  
  Transaction Codes: 
  
  RSA1: Data Warehousing Workbench
  SM12: Display and Delete Locks
  SE16: Data Browser
  
  
  
  SAP Notes: Always check for the latest SAP Notes related to your version of SAP BW or the specific DSO you are working with.
  
  
  Documentation: Review the SAP BW documentation for best practices on managing DSOs and handling data inconsistencies.
  
  
  If the issue persists after trying the above solutions, it may be necessary to engage SAP support for further assistance.