How To Fix RSSM_TT014 - Object &3(&4) contains ADSOs and InfoCubes as PartProviders

SAP Error Message - Details

• Message type: E = Error

• Message class: RSSM_TT - Transfer Tool

• Message number: 014

• Message text: Object &3(&4) contains ADSOs and InfoCubes as PartProviders

What causes this issue?

Object &V3&(&V4&), which is a MultiProvider, HybridProvider, or a
semantically partitioned object, is a source of delta data transfer
processes. For such an object, delta data transfer processes are only
supported if all PartProviders are either InfoCubes or DataStore objects
(advanced).
Object &V3&(&V4&) contains both, DataStore object (advanced) &V1& and
InfoCube &V2&, however.

System Response

After conversion of this scope, the delta data transfer processes that
are extracting from object &V3&(&V4&) will not work anymore. They will
stay inactive and cannot be activated anymore.

How to fix this error?

You have the following options:
Change your object &V3&(&V4&) in a way that it contains only DataStore
objects (advanced) or only InfoCubes, not both.
Change all delta data transfer processes that extract from object &V3&(
&V4&) to data transfer processes that do a full load.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSSM_TT014 - Object &3(&4) contains ADSOs and InfoCubes as PartProviders ?

  The SAP error message RSSM_TT014 indicates that there is an issue with the configuration of a CompositeProvider in SAP BW (Business Warehouse). Specifically, the error states that the object you are trying to work with contains Advanced DataStore Objects (ADSOs) and InfoCubes as part providers, which is not allowed in certain contexts.
  Cause:
  The error occurs because:
  
  Mixed Provider Types: The CompositeProvider is trying to include both ADSOs and InfoCubes as part providers. In SAP BW, certain operations or configurations do not support mixing these two types of data providers.
  Incompatibility: The system does not allow the combination of these two types of providers due to differences in how they handle data and queries.
  
  Solution:
  To resolve this error, you can take the following steps:
  
  
  Review CompositeProvider Configuration:
  
  Open the CompositeProvider in the SAP BW modeling tools.
  Check the list of part providers included in the CompositeProvider.
  
  
  
  Separate Providers:
  
  If you find that both ADSOs and InfoCubes are included, you will need to create separate CompositeProviders for each type. 
  Create one CompositeProvider that only includes ADSOs and another that only includes InfoCubes.
  
  
  
  Adjust Queries:
  
  If you have queries that rely on the mixed CompositeProvider, you may need to adjust them to point to the new, separate CompositeProviders.
  
  
  
  Testing:
  
  After making the changes, test the new CompositeProviders to ensure they work as expected and that the error no longer occurs.
  
  
  
  Related Information:
  
  SAP BW Modeling: Understanding the differences between ADSOs and InfoCubes is crucial. ADSOs are more flexible and are designed for data modeling in BW/4HANA, while InfoCubes are part of the older BW architecture.
  Documentation: Refer to the official SAP documentation for BW modeling and CompositeProviders for best practices and guidelines.
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or updates regarding this error message.
  
  By following these steps, you should be able to resolve the RSSM_TT014 error and successfully configure your CompositeProviders in SAP BW.