How To Fix RSMPC066 - Request &1 was already retrieved from a DM that cannot be deleted

SAP Error Message - Details

• Message type: E = Error

• Message class: RSMPC - Messages for Process Chains of Generic Processes

• Message number: 066

• Message text: Request &1 was already retrieved from a DM that cannot be deleted

What causes this issue?

The request <(>&<)>V1& cannot be deleted from InfoCube <(>&<)>V2&,
because a DataMart that cannot be deactivated automatically, has
already retrieved this request.
Deletion would create inconsistencies in the DataMart.

System Response

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?

Before you can delete the request, you need to deactivate the DataMarts
that have already retrieved this request.

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 RSMPC066 - Request &1 was already retrieved from a DM that cannot be deleted ?

  The SAP error message RSMPC066 indicates that a data request (request &1) has already been retrieved from a Data Mart (DM) and cannot be deleted. This typically occurs in the context of SAP BW (Business Warehouse) or SAP BW/4HANA when dealing with data requests in the context of data extraction and loading processes.
  Cause:
  
  Data Retrieval: The request has already been processed and the data has been retrieved from the Data Mart. Once a request is retrieved, it is locked for deletion to maintain data integrity.
  Data Mart Configuration: The configuration of the Data Mart may prevent the deletion of requests that have been processed.
  Request Status: The status of the request may indicate that it is still in use or has been marked as completed, which prevents deletion.
  
  Solution:
  
  Check Request Status: Verify the status of the request in the Data Mart. If it is marked as "Completed" or "In Use," you may need to wait until it is no longer in use before attempting to delete it.
  Data Mart Management: If you have the necessary authorizations, you can check the Data Mart settings to see if there are restrictions on deleting requests. Adjust the settings if necessary.
  Use Transaction Codes: Use transaction codes like RSA1 (Data Warehousing Workbench) to manage requests and check their statuses.
  Consult Logs: Check the logs for any additional error messages or warnings that may provide more context on why the request cannot be deleted.
  Contact Support: If the issue persists and you cannot determine the cause, consider reaching out to your SAP support team or consulting SAP Notes for any known issues related to this error.
  
  Related Information:
  
  SAP Notes: Search for relevant SAP Notes in the SAP Support Portal that may address this specific error message or provide additional troubleshooting steps.
  Documentation: Review SAP BW documentation for best practices on managing data requests and Data Mart configurations.
  User Authorizations: Ensure that you have the necessary authorizations to delete requests in the Data Mart.
  
  By following these steps, you should be able to identify the cause of the error and take appropriate action to resolve it.