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

SAP Error Message - Details

• Message type: E = Error

• Message class: AQ_RSQBW - SAP Query: Copy message class RSUQ from BW 2.0 system

• Message number: 120

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

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message AQ_RSQBW120 - Query & in user group & was deleted ?

  The SAP error message AQ_RSQBW120 typically indicates that a query in the SAP BW (Business Warehouse) system has been deleted, and it is being referenced in a user group. This can happen for various reasons, such as changes in the data model, deletion of queries by users, or changes in the authorization settings.
  Cause:
  
  Query Deletion: The query that was previously part of a user group has been deleted from the system.
  User Group Configuration: The user group is still trying to reference the deleted query, leading to this error.
  Transport Issues: If queries are transported between systems (e.g., from development to production), and the query was not included in the transport, it may lead to this error.
  Authorization Issues: Changes in user authorizations may also lead to this error if users no longer have access to the query.
  
  Solution:
  
  Check Query Existence: Verify if the query still exists in the system. You can do this by navigating to the Query Designer or using transaction codes like RSRT (Query Monitor) or RSQ1 (Query Designer).
  Update User Group: If the query has been deleted and is no longer needed, you should remove it from the user group. This can be done by:
  
  Going to the user group configuration (transaction code: RSCUSTV10).
  Editing the user group and removing the reference to the deleted query.
  
  
  Recreate the Query: If the query is still needed, consider recreating it in the Query Designer and then adding it back to the user group.
  Check Transport Requests: If the issue arose after a transport, ensure that all necessary objects, including queries, were included in the transport request.
  Review Authorizations: Ensure that users have the necessary authorizations to access the queries in the user group.
  
  Related Information:
  
  Transaction Codes:
  
  RSRT: Query Monitor
  RSQ1: Query Designer
  RSCUSTV10: User Group Maintenance
  
  
  Documentation: Refer to SAP Help documentation for more details on managing queries and user groups in SAP BW.
  SAP Notes: Check for any relevant SAP Notes that might address specific issues related to this error message.
  
  If the problem persists after following these steps, it may be beneficial to consult with your SAP Basis or BW administrator for further investigation.