How To Fix RSR_EXCEL_RUNTIME104 - Errors while upgrading 3.x Analyzer APIs

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 104

• Message text: Errors while upgrading 3.x Analyzer APIs

What causes this issue?

Errors occurred while upgrading the 3.x Analyzer APIs. The APIs were not
upgraded successfully.
When 3.x APIs are upgraded, the VBA code called from the 3.x Analyzer
exit SAPBEXonRefresh(queryID As String, resultArea As Range) is adjusted
so that the 3.x Analyzer APIs are compatible with the 7.0 Analyzer. In
some cases, the 3.x APIs are not supported but dummy wrapper functions
replace those functions so that the VBA code in the workbook does not
result in runtime errors.

System Response

The Analyzer is unable to upgrade all the APIs in the VBA code for the
workbook. Without sufficient error handling, this may cause compile time
errors when the custom APIs are run in the workbook.

How to fix this error?

The most probable reason is that access to the VBA project is denied.
This can be corrected as follows:
In Microsoft Excel, choose <ZK>Tools</> --> <ZK>Macros</> -->
<ZK>Security</>.
On the <ZK>Trusted Publishers</> tab page, select <ZK>Trust access to
Visual Basic Project</> to allow access to the Visual Basic project. If
you are not authorized to do this, contact your system administrator.
Another possible reason is incorrect use of APIs. We recommend checking
whether it is possible to refresh the workbook and run the VBA code in
the 3.x Analyzer successfully. If this is not possible, APIs are not
being used correctly.
If the problem persists, you may need to manually check and correct how
the APIs are used in the VBA code.

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_RUNTIME104 - Errors while upgrading 3.x Analyzer APIs ?

  The SAP error message RSR_EXCEL_RUNTIME104 typically occurs when there are issues related to the Excel Analyzer, particularly during the upgrade of 3.x Analyzer APIs to newer versions. This error can arise due to various reasons, including compatibility issues, configuration problems, or missing components.
  Causes of RSR_EXCEL_RUNTIME104
  
  
  Compatibility Issues: The version of the Excel Analyzer you are using may not be compatible with the version of SAP BW or the underlying data source.
  
  
  Missing or Incorrect Configuration: The configuration settings for the Excel Analyzer may not be set correctly, leading to runtime errors.
  
  
  Corrupted Installation: The installation of the Excel Analyzer or the SAP BW system may be corrupted or incomplete.
  
  
  Data Source Issues: The data source being accessed may have issues, such as missing data or incorrect settings.
  
  
  Excel Version Compatibility: The version of Microsoft Excel being used may not be compatible with the SAP Excel Analyzer.
  
  
  Solutions to RSR_EXCEL_RUNTIME104
  
  
  Check Compatibility: Ensure that the version of the Excel Analyzer is compatible with your SAP BW version. Refer to SAP notes or documentation for compatibility matrices.
  
  
  Reconfigure the Analyzer: Review the configuration settings for the Excel Analyzer. Ensure that all necessary settings are correctly configured.
  
  
  Reinstall the Analyzer: If you suspect that the installation is corrupted, consider uninstalling and then reinstalling the Excel Analyzer.
  
  
  Update Excel: Make sure that you are using a supported version of Microsoft Excel. If necessary, update Excel to a version that is compatible with the SAP Excel Analyzer.
  
  
  Check Data Sources: Verify that the data sources being accessed are correctly set up and that there are no issues with the data itself.
  
  
  Review SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that address the RSR_EXCEL_RUNTIME104 error. There may be specific patches or updates available.
  
  
  Consult Logs: Look at the application logs and system logs for more detailed error messages that can provide additional context for the issue.
  
  
  Contact SAP Support: If the issue persists after trying the above solutions, consider reaching out to SAP Support for further assistance.
  
  
  Related Information
  
  
  SAP Notes: Always check for the latest SAP Notes related to the Excel Analyzer and the specific error message. SAP frequently updates their documentation and provides fixes for known issues.
  
  
  Documentation: Review the official SAP documentation for the Excel Analyzer and SAP BW for any specific configuration or upgrade instructions.
  
  
  Community Forums: Engage with the SAP Community or other forums where users discuss similar issues. You may find solutions or workarounds that have worked for others.
  
  
  By following these steps, you should be able to diagnose and resolve the RSR_EXCEL_RUNTIME104 error effectively.