How To Fix RSDD_LM009 - Source '&1', linked as a union with field '&2', does not exist

SAP Error Message - Details

• Message type: E = Error

• Message class: RSDD_LM - Messages for Lean Modeler (API and RSLIMO)

• Message number: 009

• Message text: Source '&1', linked as a union with field '&2', does not exist

What causes this issue?

Every link has a source (a field in the provider) and a target (a field
in the CompositeProvider).
Source &V1& of the link to CompositeProvider field &V2& does not exist
in provider &V3& (union).

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?

The provider might have been changed, and the field deleted or renamed.
Delete the link.

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 RSDD_LM009 - Source '&1', linked as a union with field '&2', does not exist ?

  The SAP error message RSDD_LM009 indicates that there is an issue with a data source in the context of a data model or a query. Specifically, it suggests that a source (likely a data source or InfoProvider) that is linked as a union with a specific field does not exist or cannot be found.
  Cause:
  
  Missing Data Source: The data source specified in the error message (&1) may have been deleted, renamed, or is not activated.
  Incorrect Field Reference: The field specified (&2) may not exist in the data source or may have been incorrectly referenced.
  Transport Issues: If the data source was transported from another system, it may not have been transported correctly or completely.
  Authorization Issues: The user may not have the necessary authorizations to access the specified data source.
  Modeling Errors: There may be errors in the data model or query definition that are causing the system to look for a non-existent source.
  
  Solution:
  
  Verify Data Source: Check if the data source (&1) exists in the system. You can do this by navigating to the relevant transaction (e.g., RSA1 for Data Warehousing Workbench) and looking for the data source.
  Check Field Existence: Ensure that the field (&2) exists in the data source. You can do this by checking the structure of the data source.
  Re-activate Data Source: If the data source exists but is not activated, try reactivating it.
  Review Transport Requests: If the data source was recently transported, check the transport logs to ensure that it was transported correctly.
  Check Authorizations: Ensure that the user has the necessary authorizations to access the data source.
  Review Query/Model Definition: If the error occurs in a query or model, review the definition to ensure that all sources and fields are correctly referenced.
  
  Related Information:
  
  Transaction Codes: Use transaction codes like RSA1 (Data Warehousing Workbench) or RSRT (Query Monitor) to investigate the issue further.
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  Documentation: Refer to SAP documentation for information on data modeling and query design best practices.
  Support: If the issue persists, consider reaching out to SAP support for further assistance.
  
  By following these steps, you should be able to identify and resolve the issue causing the RSDD_LM009 error message.