How To Fix RD020 - DataSource &1 was deleted in the source System

SAP Error Message - Details

• Message type: E = Error

• Message class: RD - CO-PA Connection to SAP BW

• Message number: 020

• Message text: DataSource &1 was deleted in the source System

What causes this issue?

DataSource &V1& was deleted in the source system.

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?

As necessary, you may have to delete the SAP BW portions of the
DataSource separately. Use the transaktion RSA2 in the source system and
the functions of the Administrators Workbench in SAP BW.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RD020 - DataSource &1 was deleted in the source System ?

  The SAP error message RD020 indicates that a DataSource has been deleted in the source system, which means that the system can no longer find the DataSource that is expected to be available for data extraction. This can occur in various scenarios, such as when a DataSource is removed or deactivated in the source system (like an SAP ERP system) but is still referenced in the SAP BW (Business Warehouse) system.
  Cause:
  
  DataSource Deletion: The DataSource was intentionally deleted or deactivated in the source system.
  Transport Issues: The DataSource might have been transported to another system without the necessary dependencies or configurations.
  System Upgrades: Changes during system upgrades or migrations can lead to the deletion or deactivation of DataSources.
  Configuration Changes: Changes in the configuration of the source system can lead to the DataSource being unavailable.
  
  Solution:
  
  Check Source System: Verify in the source system (e.g., SAP ERP) whether the DataSource still exists. You can do this by navigating to the DataSource maintenance transaction (e.g., RSA1 or RSA2).
  Recreate DataSource: If the DataSource was deleted, you may need to recreate it in the source system. Ensure that it is configured correctly and activated.
  Update BW System: After recreating the DataSource, you may need to refresh the metadata in the BW system. This can be done by:
  
  Going to the DataSource in the BW system.
  Using the "Update" or "Activate" option to refresh the DataSource metadata.
  
  
  Check Transport Requests: If the DataSource was transported, ensure that all related transport requests were successfully imported into the target system.
  Consult Documentation: Review any documentation or change logs to understand why the DataSource was deleted and if there are any alternative DataSources available.
  Contact Support: If you are unable to resolve the issue, consider reaching out to SAP support for assistance.
  
  Related Information:
  
  Transaction Codes: Common transaction codes related to DataSources include RSA1 (Data Warehousing Workbench), RSA2 (DataSource Maintenance), and RSO2 (DataSource Administration).
  DataSource Types: Understand the type of DataSource (e.g., standard, custom, or generic) and its dependencies.
  Data Extraction: Familiarize yourself with the data extraction process and how DataSources interact with InfoProviders in BW.
  Monitoring: Use transaction codes like RSMO (Monitor) to check for any data load issues related to the DataSource.
  
  By following these steps, you should be able to address the RD020 error and restore functionality to your data extraction processes.