How To Fix RSDME796 - Deletion not possible! DataSource is already attached to Infosource &2

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDME -

• Message number: 796

• Message text: Deletion not possible! DataSource is already attached to Infosource &2

What causes this issue?

BW Datasource has been deleted manually from RSA2 or RSO2.

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?

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 RSDME796 - Deletion not possible! DataSource is already attached to Infosource &2 ?

  The SAP error message RSDME796 indicates that you are trying to delete a DataSource that is currently attached to an InfoSource. This situation arises when the DataSource is still in use, and SAP prevents its deletion to maintain data integrity.
  Cause:
  The primary cause of this error is that the DataSource you are attempting to delete is linked to one or more InfoSources. In SAP BW (Business Warehouse), an InfoSource is a structure that allows you to combine data from multiple DataSources and is used for data extraction and transformation.
  Solution:
  To resolve this error, you need to detach the DataSource from the InfoSource before attempting to delete it. Here are the steps to do this:
  
  
  Identify the InfoSource: The error message provides the InfoSource name (represented as &2). Make a note of this InfoSource.
  
  
  Access the InfoSource:
  
  Go to the SAP BW modeling tools (transaction code RSA1).
  Navigate to the InfoSources section.
  
  
  
  Modify the InfoSource:
  
  Find the InfoSource that is linked to the DataSource you want to delete.
  Open the InfoSource for editing.
  Remove the DataSource from the InfoSource. This may involve deleting the DataSource from the list of attached DataSources or modifying the structure of the InfoSource.
  
  
  
  Save Changes: After detaching the DataSource, save your changes to the InfoSource.
  
  
  Delete the DataSource: Now that the DataSource is no longer attached to the InfoSource, you can proceed to delete the DataSource without encountering the error.
  
  
  Related Information:
  
  DataSource: A DataSource in SAP BW is a source of data that can be extracted from various systems (like SAP ERP, flat files, etc.) and loaded into the BW system.
  InfoSource: An InfoSource is a structure that allows you to combine data from multiple DataSources and is used for data extraction and transformation in SAP BW.
  Transaction Codes: Common transaction codes related to DataSources and InfoSources include:
  
  RSA1: Data Warehousing Workbench
  RSO2: Maintain DataSource
  RSO3: Display DataSource
  
  
  
  Additional Tips:
  
  Always ensure that you have the necessary authorizations to make changes to DataSources and InfoSources.
  Consider backing up your InfoSource configuration before making changes, especially in a production environment.
  If you are unsure about the impact of detaching a DataSource, consult with your BW team or a knowledgeable colleague to avoid disrupting data flows.