How To Fix RSAN_MDL061 - Syntax warning: delete data source query (&1) and recreate -> long text

SAP Error Message - Details

• Message type: E = Error

• Message class: RSAN_MDL - Messages on Analysis Object Model

• Message number: 061

• Message text: Syntax warning: delete data source query (&1) and recreate -> long text

What causes this issue?

For BW Release 3.50, the length of fields names was reduced to 30
characters. New functions in the Analysis Process Designer such as
intermediate results or data mining functions will not be supported
with longer fields names.
Old analysis processes that contain queries as data sources are affected
by this change. Here, the field names for display attributes and the
field names of the units and currency key of key figures have to be
renamed. Since the old field names can be used in the subsequent node,
the analysis process has to be adapted manually.

System Response

The node "&V1&" / "&V2&" was added in an older release.
The analysis process will be executed in compatibility mode.

How to fix this error?

The analysis process can continue to be used with older functions.
The use of newer functions such as intermediate results and data mining
functions is not possible. Thus we recommend adapting the definition of
the analysis process:
Create a new, empty analysis process and model the analysis process
again.
Alternatively: Delete the data source query node, add the node from the
function selection again, and link the new node with the subsequent node
again. The correct the settings in the subsequent node of the
renamed fields were used there.

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

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 RSAN_MDL061 - Syntax warning: delete data source query (&1) and recreate -> long text ?

  The SAP error message RSAN_MDL061 indicates a syntax warning related to a data source query in SAP BW (Business Warehouse). This warning suggests that there is an issue with the query definition that may lead to incorrect results or performance issues. The message advises deleting the data source query and recreating it to resolve the problem.
  
  Cause:
  The syntax warning can be caused by several factors, including:
  
  Changes in Data Model: If there have been changes in the underlying data model (e.g., InfoObjects, InfoProviders, or transformations), the existing query may no longer be valid.
  Inconsistent Query Definition: The query may have been defined with incorrect or deprecated syntax, leading to potential issues when executing the query.
  Updates or Upgrades: After an upgrade of the SAP BW system, certain queries may become incompatible due to changes in the underlying data structures or query processing logic.
  
  
  Solution:
  To resolve the RSAN_MDL061 error, follow these steps:
  
  
  Delete the Query: Go to