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 the Query Designer (transaction code RSRT) and locate the query that is causing the issue. Delete the query from the system.
  
  
  Recreate the Query: After deleting the query, recreate it from scratch. Ensure that you use the correct syntax and definitions based on the current data model. Pay attention to any changes in InfoObjects or InfoProviders that may affect the query.
  
  
  Test the Query: Once the query is recreated, execute it to ensure that it runs without any warnings or errors. Validate the results to confirm that they are accurate.
  
  
  Check for Updates: If the issue persists, check for any SAP Notes or updates related to the specific version of SAP BW you are using. There may be patches or fixes available that address known issues.
  
  
  Consult Documentation: Review the SAP BW documentation for best practices in query design and any specific guidelines related to the data sources you are using.
  
  
  Related Information:
  
  Transaction Codes: 
  
  RSRT: Query Monitor
  RSA1: Data Warehousing Workbench
  RSD1: InfoObject Maintenance
  
  
  SAP Notes: Search for relevant SAP Notes in the SAP Support Portal that may provide additional insights or solutions related to this error.
  Performance Considerations: After recreating the query, monitor its performance and execution time to ensure that it meets the required standards.
  
  By following these steps, you should be able to resolve the RSAN_MDL061 syntax warning and ensure that your data source query functions correctly.