How To Fix RSM1068 - No DataSource &1 found in source system &2; no hierarchies can be loaded

SAP Error Message - Details

• Message type: E = Error

• Message class: RSM1 - Messages for AWB, Scheduler and Monitor (new)

• Message number: 068

• Message text: No DataSource &1 found in source system &2; no hierarchies can be loaded

What causes this issue?

DataSource &V1& does not exist in source system &V2&. No hierarchies
can therefore be loaded for this DataSource!

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?

Carry out a Metadata upload for source system &V2&.

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 RSM1068 - No DataSource &1 found in source system &2; no hierarchies can be loaded ?

  The SAP error message RSM1068 indicates that a specific DataSource is not found in the source system, which prevents the loading of hierarchies. This error typically occurs in the context of SAP BW (Business Warehouse) when trying to load data from a source system, such as SAP ERP or other data sources.
  Cause:
  
  
  Missing DataSource: The DataSource specified in the error message does not exist in the source system. This could be due to:
  
  The DataSource was not created or activated in the source system.
  The DataSource was deleted or renamed.
  There is a mismatch in the DataSource name or version.
  
  
  
  Incorrect Source System Configuration: The source system may not be properly configured in the BW system, leading to issues in accessing the DataSource.
  
  
  Authorization Issues: The user executing the data load may not have the necessary authorizations to access the DataSource in the source system.
  
  
  Solution:
  
  
  Verify DataSource Existence:
  
  Log into the source system (e.g., SAP ERP) and check if the DataSource exists. You can do this by navigating to the DataSource maintenance transaction (e.g., RSA1 in SAP BW).
  If the DataSource does not exist, you may need to create it or ensure it is activated.
  
  
  
  Check DataSource Activation:
  
  If the DataSource exists but is not activated, activate it in the source system.
  
  
  
  Check Source System Configuration:
  
  Ensure that the source system is correctly configured in the BW system. You can check this in the BW system under the "Source Systems" section in RSA1.
  Make sure that the connection to the source system is working properly.
  
  
  
  Review Authorizations:
  
  Ensure that the user executing the data load has the necessary authorizations to access the DataSource in the source system.
  
  
  
  Check for Naming Mismatches:
  
  Verify that the DataSource name in the BW system matches exactly with the name in the source system, including any prefixes or suffixes.
  
  
  
  Recreate the DataSource:
  
  If the DataSource is missing or corrupted, you may need to recreate it in the source system and then replicate it in the BW system.
  
  
  
  Related Information:
  
  
  Transaction Codes:
  
  RSA1: Data Warehousing Workbench in SAP BW.
  RSA3: Test DataSource in the source system.
  RSC1: Create DataSource in BW.
  
  
  
  Documentation: Refer to SAP Help documentation for detailed steps on managing DataSources and troubleshooting data loading issues.
  
  
  SAP Notes: Check for any relevant SAP Notes that may address specific issues related to the DataSource or the error message RSM1068.
  
  
  By following these steps, you should be able to identify and resolve the issue causing the RSM1068 error message in your SAP BW environment.