How To Fix RSAOLTP124 - No authorization to extract DataSource &1 from source system &2

SAP Error Message - Details

• Message type: E = Error

• Message class: RSAOLTP - Notifications in OLTP Source Environment

• Message number: 124

• Message text: No authorization to extract DataSource &1 from source system &2

What causes this issue?

The BW is not authorized to extract data from the specified DataSource.

System Response

The DataSource is not replicated.

How to fix this error?

If you want to extract data from this DataSource, contact your system
administrator and ask for authorization for the DataSource.

Procedure for System Administrators

To limit or delimit authorizations for DataSources, go to the
source-system tree of the BW Administrator Workbench and choose
<LS>Customizing of Extractors -> Business Information Warehouse ->
General Settings -> Limit Authorizations for Extraction</>.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSAOLTP124 - No authorization to extract DataSource &1 from source system &2 ?

  The SAP error message RSAOLTP124 indicates that a user does not have the necessary authorization to extract data from a specific DataSource in a source system. This error typically occurs in the context of SAP BW (Business Warehouse) when trying to extract data from an OLTP (Online Transaction Processing) system.
  Cause:
  The error is caused by insufficient authorizations for the user trying to perform the data extraction. This can happen due to several reasons:
  
  The user lacks the necessary roles or authorizations assigned in the source system.
  The DataSource may have specific authorization checks that the user does not meet.
  The user may not have the required access to the underlying tables or fields from which the DataSource is extracting data.
  
  Solution:
  To resolve the RSAOLTP124 error, follow these steps:
  
  
  Check User Authorizations:
  
  Verify that the user has the necessary roles assigned in the source system. This can be done by checking the user’s profile in transaction SU01 or PFCG.
  Ensure that the user has the appropriate authorizations for the DataSource in question.
  
  
  
  Assign Required Roles:
  
  If the user does not have the required roles, assign the necessary roles that include access to the DataSource and the underlying tables.
  Common roles that may be required include those related to data extraction, such as SAP_BW_EXTRACTOR or custom roles that have been defined for your organization.
  
  
  
  Check DataSource Authorization:
  
  In the source system, check the DataSource settings to see if there are specific authorization objects that need to be fulfilled. This can be done in transaction RSA1 (Data Warehousing Workbench) under the DataSource settings.
  
  
  
  Test the Authorization:
  
  After making changes to the user’s roles or authorizations, test the extraction process again to see if the error persists.
  
  
  
  Consult with Security Team:
  
  If you are unsure about which roles or authorizations are needed, consult with your SAP security team or BASIS team for assistance in identifying the correct authorizations.
  
  
  
  Related Information:
  
  Authorization Objects: Common authorization objects related to data extraction include S_BW_AUTH (for BW authorizations) and S_TABU_DIS (for table access).
  Transaction Codes:
  
  SU01: User Maintenance
  PFCG: Role Maintenance
  RSA1: Data Warehousing Workbench
  
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional guidance or updates related to this error message.
  
  By following these steps, you should be able to resolve the RSAOLTP124 error and successfully extract data from the specified DataSource.