How To Fix RSZA013 - Query was not created with the Web item ad-hoc query designer

SAP Error Message - Details

• Message type: E = Error

• Message class: RSZA - WebQueryDesigner

• Message number: 013

• Message text: Query was not created with the Web item ad-hoc query designer

What causes this issue?

The <ZK>Ad-hoc Query Designer</> Web item has not been tested/released
with BW 3.0A, service pack 03. To avoid inconsistencies in existing
queries, change only those queries with the <ZK>Ad-hoc Query Designer
</> Web item that you created with this tool.

System Response

The <ZK>Ad-hoc Query Designer</> Web item loads the query but you
cannot make changes to it.

How to fix this error?

If you want to change the query, use the BEx Query Designer. If you
want to test or demonstrate the functions of the <ZK>Ad-hoc Query
Designer </> Web item, you can do this with queries that you created
using the <ZK>Ad-hoc Query Designer </> Web item.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSZA013 - Query was not created with the Web item ad-hoc query designer ?

  The SAP error message RSZA013 indicates that a query was not created using the Web item ad-hoc query designer. This typically occurs when you attempt to use a query in a context that requires it to be created with the specific ad-hoc query designer, but it was created using a different method or tool.
  Cause:
  
  Query Creation Method: The query was created using a different tool (e.g., Query Designer in SAP BW) rather than the Web item ad-hoc query designer.
  Compatibility Issues: The query may not be compatible with the ad-hoc query features or functionalities that the Web item expects.
  System Configuration: There may be configuration settings in the SAP system that restrict the use of certain queries in the ad-hoc context.
  
  Solution:
  
  Recreate the Query: The most straightforward solution is to recreate the query using the Web item ad-hoc query designer. This ensures that the query is compatible with the requirements of the Web item.
  Check Query Properties: If you have access to the original query, check its properties and settings to ensure it aligns with the requirements for ad-hoc queries.
  Use Compatible Queries: If you have existing queries that are compatible with the ad-hoc query designer, use those instead.
  Consult Documentation: Refer to SAP documentation or help resources for specific guidelines on creating queries with the ad-hoc query designer.
  System Configuration Review: If the issue persists, review the system configuration or consult with your SAP Basis or BW administrator to ensure that there are no restrictions or settings that could be causing the issue.
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or patches related to the RSZA013 error message.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Training and Documentation: Consider training or reviewing documentation on using the ad-hoc query designer effectively to avoid similar issues in the future.
  
  By following these steps, you should be able to resolve the RSZA013 error and successfully create or use queries in the desired context.