Symptom
One of the below error messages are displayed when launching an Analysis Office workbook from .sapaox file or when trying to launch Analysis Office:
- Exception Processing Message 0xc0000005 - Unexpected prameters
- The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
The last lines of the AO_Trace file (refer to SAP Note 2129389) show the list of available AO plugins and nothing else:
-----------------------------------------------
Trying to find plugins at path C:\Program Files\SAP BusinessObjects\Office AddIn\Plugins\ with expression *Plugin.dll
found the following excel plugins
Id: com.sap.ip.bi.pioneer
Id: com.sap.epm.BPFClient
-----------------------------------------------
If Excel crashes, the following error can be seen in the Windows Event Log following the application crash:
-----------------------------------------------
Application: EXCEL.EXE
Framework Version: v4.0.30319
"The process was terminated due to an internal error in the .NET Runtime at IP ... with exit code 80131506."
-----------------------------------------------
Event viewer can also show:
-------------------------------------------------------
Faulting application path: C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE
Faulting module path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll
-----------------------------------------------
Environment
- SAP Analysis for Microsoft Office
- Trellix Endpoint Security
Reproducing the Issue
1. Install Trellix Endpoint Security 10.7 September 2023 Update.
2. Download and open an Analysis for Office report that creates a .sapaox launcher (e.g. open a report from browser or from transaction RAAOE) or try to launch Analysis Office application;
3. Excel opens with the above errors.
Cause
3rd party program
Resolution
This is not an SAP bug. Certain applications using .NET runtime crash after this Trellix update.
See their article for the fix:
https://kcm.trellix.com/corporate/index?page=content&id=KB96789
Workaround 1:
- Make sure the LoadBehavior of AO is set to 0 (refer to KBA 2440829);
- Make sure that the add-in is not disabled in Excel (File > Options > Add-ins, select "Disabled Items", click on "Go" and make sure that AO is not in the list);
- Start Excel;
- Manually enable AO via Excel File > Options > Add-ins, select "COM Add-ins", click on "Go" and select "Analysis";
Workaround 2:
- Install Windows updates: KB5034123, KB5033920, KB5033734;
- Install MS 365 Apps update: 16.0.16130.20884;
- AO can now be used with LoadBehavior set to 3;
Keywords
0xc0000005, 0x800706BE, Trellix, Analysis Office, sapaox, businessobjects, excel, raaoe, clr.dll, loadbehavior
, KBA , BI-RA-AO-XLA , Excel Addin , Problem