How To Fix RSR_EXCEL_RUNTIME111 - Errors while upgrading query: &1

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 111

• Message text: Errors while upgrading query: &1

What causes this issue?

When 3.x workbooks are upgraded, the query areas, such as the result
set, navigation block, and text elements, are converted to the
corresponding design items in the 7.0 workbook. However, it was not
possibleto convert one or more areas to the corresponding design items
because of errors that occurred during conversion.

System Response

As a result of these errors, the query in the workbook is not fully
upgraded and the upgrade is terminated.

How to fix this error?

Try refreshing this upgraded workbook in the 7.0 Analyzer. If you can
refresh the workbook successfully in the 7.0 Analyzer, this warning can
be ignored.
This warning can also occur if the workbook became corrupt during a
transport or while saving it, for example. We recommend that you open
the workbook in the 3.x Analyzer and check whether it is possible to
refresh the workbook successfully. If you cannot refresh the workbook
successfully, the workbook is corrupt and cannot be upgraded. You
therefore need to recreate the workbook.
If you can refresh the workbook successfully, also check whether the
workbook is protected. If the workbook is protected, unprotect it. Since
design items cannot be created in protected workbooks, this could be the
cause of the problem.
If the problem persists, manually adjust the workbook and replace the
query result areas with the corresponding design items in the 7.0
Analyzer to solve the issue.

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 RSR_EXCEL_RUNTIME111 - Errors while upgrading query: &1 ?

  The SAP error message RSR_EXCEL_RUNTIME111 typically occurs when there are issues related to the upgrade of a query in SAP BW (Business Warehouse) that is being exported to Excel. This error can arise due to various reasons, including compatibility issues, data inconsistencies, or problems with the query definition itself.
  Causes:
  
  Query Definition Issues: The query may have been defined in a way that is not compatible with the current version of SAP BW or the Excel add-in.
  Data Source Changes: Changes in the underlying data sources or InfoProviders that the query relies on can lead to this error.
  Excel Add-in Issues: The version of the Excel add-in being used may not be compatible with the SAP BW version.
  Missing Authorizations: The user may not have the necessary authorizations to execute the query or access the data.
  Data Model Changes: Changes in the data model, such as changes to InfoObjects or InfoProviders, can lead to inconsistencies.
  
  Solutions:
  
  Check Query Definition: Review the query definition in the Query Designer to ensure that it is correctly set up and compatible with the current version of SAP BW.
  Validate Data Sources: Ensure that all data sources and InfoProviders used in the query are available and functioning correctly.
  Update Excel Add-in: Make sure that you are using the latest version of the SAP Excel add-in that is compatible with your SAP BW version.
  Check Authorizations: Verify that the user executing the query has the necessary authorizations to access the query and the underlying data.
  Recreate the Query: If the query is significantly outdated or corrupted, consider recreating it from scratch.
  Consult SAP Notes: Check the SAP Support Portal for any relevant SAP Notes or patches that address this specific error.
  
  Related Information:
  
  SAP BW Documentation: Refer to the official SAP BW documentation for guidelines on query design and troubleshooting.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as RSRT (Query Monitor) to test and analyze queries.
  
  If the issue persists after trying the above solutions, it may be beneficial to reach out to SAP support for further assistance.