SAP Knowledge Base Article - Public

3487621 - Replication Flow fails : "No source partition is available" due to Subscription authorization issues

Symptom

Replication Flow of CDS views and other objects fails for both Load Types: "Initial only" or "Initial+Delta" with the error message, as per Data Integration Monitor in SAP Datasphere :

"No source partition is available. Replication runs will restart on DD-MM-YYYY at HH:MM:SS UTC."

"No source data is available for replication. Replication runs will restart on DD-MM-YYYY at HH:MM:SS UTC." 

The status is:  "Running" and/or " Active (Retrying)" ;  "Partitioning Initial Load"

The corresponding error raised in SLG1 is one of the following messages:

Subscription interface error / User <username> is not authorized to process changes for subscriber RMS  
User XXX is not authorized to access <CDS view> for subscriber RMS

Environment

SAP Datasphere

Cause

Missing Authorizations/Code Corrections.

Resolution

  • Ensure the below authorization SAP Notes are implemented in the system
    3100673 - SAP Data Intelligence / SAP Datasphere - ABAP Integration - Security Settings
    2855052 - Authorizations required for ODP Data Replication API 2.0 
  • Ensure the notes are implemented as per SAP Note 2890171 - SAP Data Intelligence / SAP Datasphere - ABAP Integration based on Source system Release version.
  • Make the user as a dialog user and run SU53 transaction for the respective user and assign the missing authorizations.

See Also

Authorizations

Keywords

SLG1, DHCDC, replication flow,  authorization, authorized, subscriber, subscription, subscription interface error, DHCDC_AUTH008 , KBA , DS-DI-RF , Replication Flows , Problem

Product

SAP Datasphere 1.0