How To Fix RSQBW120 - Query & in user group & was deleted

SAP Error Message - Details

• Message type: E = Error

• Message class: RSQBW -

• Message number: 120

• Message text: Query & in user group & was deleted

What causes this issue?

When you regenerate InfoSets for a DataStore object, there are fewer
fields contained in the new version of the DataStore object. There are,
however, queries in the old version of the InfoSet that use this field
and that are formed in such a way that without this field the query
cannot produce any meaningful output.

System Response

The query has been deleted.

How to fix this error?

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 RSQBW120 - Query & in user group & was deleted ?

  The SAP error message RSQBW120 indicates that a query in the SAP BW (Business Warehouse) system has been deleted, and it is no longer available for the user group specified. This can occur for various reasons, such as administrative actions, changes in the data model, or user permissions.
  Cause:
  
  Query Deletion: The query was intentionally deleted by an administrator or through a transport request.
  User Group Changes: The user group associated with the query may have been modified, leading to the query being inaccessible to certain users.
  Transport Issues: If the query was transported from one system to another, it might not have been included in the transport request.
  Authorization Issues: The user may not have the necessary authorizations to access the query, even if it exists.
  
  Solution:
  
  Check Query Existence: Verify if the query still exists in the Query Designer or the relevant InfoProvider. If it has been deleted, you may need to recreate it.
  Review User Group Settings: Ensure that the user group associated with the query is correctly configured and that the query is assigned to the appropriate user groups.
  Transport Check: If the query was supposed to be transported, check the transport logs to ensure it was included and successfully imported into the target system.
  Authorization Check: Review the authorization roles assigned to the user. Ensure that the user has the necessary permissions to access the query.
  Recreate the Query: If the query is indeed deleted and cannot be restored, you may need to recreate it based on the original specifications.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message. SAP frequently updates its knowledge base with solutions for common problems.
  Query Designer: Familiarize yourself with the Query Designer tool in SAP BW, as it is used to create and manage queries.
  User Groups: Understand how user groups work in SAP BW, as they play a crucial role in query access and authorization.
  Transport Management: Learn about the transport management system in SAP to ensure that objects are correctly moved between environments.
  
  If the issue persists after trying the above solutions, consider reaching out to your SAP Basis or BW support team for further assistance.