Skip to Content

AO 64-bit crashing in Windows 8.x and Office 2013 64-bit

Hi

I have an interesting issue when testing the 64-bit version of SAP BusinessObjects Analysis for Office 1.4 and I have done a comparison/test of the various combinations of Operating Systems, Microsoft Office and SAP BusinessObjects Analysis software to determine the compatibility and below is the results:

64-bit Operating system + Office 32-bit + Analysis 32-bit versions:
---------------------------------------------------------------------------------------------
Windows 7 64-bit, Office 2007 32-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 32-bit = Working
Windows 7 64-bit, Office 2010 32-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 32-bit = Working
Windows 7 64-bit, Office 2013 32-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 32-bit = Working
Windows 8 64-bit, Office 2010 32-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 32-bit = Working
Windows 8 64-bit, Office 2013 32-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 32-bit = Working
Windows 8.1 64-bit, Office 2010 32-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 32-bit = Working
Windows 8.1 64-bit, Office 2013 32-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 32-bit = Working

64-bit Operating system + Office 64-bit + Analysis 64-bit versions:
----------------------------------------------------------------------------------------------
Windows 7 64-bit, Office 2013 64-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 64-bit = Working
Windows 8 64-bit, Office 2013 64-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 64-bit = Not Working (crashes)
Windows 8.1 64-bit, Office 2013 64-bit, SAP BusinessObjects Analysis for Office 1.4 SP7 64-bit = Not Working (crashes)

The following errors were encountered with the last 2 combinations:
1. - Error: General .NET Exception:
Connect to addin failed; launch file cannot be evaluated.

Resolved by installing the Analysis add-in on the laptop/pc

2. - Error: Error while reading from the registry:
General .NET Exception:
Input string was not in a correct format.

Resolved by settings the Windows Regional settings on the laptop/pc

3. - Error: General .NET Exception:
Exception from HRESULT: 0x800A01A8
   at Microsoft.Office.Core.CommandBarPopup.get_Controls()

Unresolved, a search of SAP OSS Notes found a number of OSS Notes, i.e. 1968330 - AO: Excel freezes or crashes when it is getting closed by the user refers to this error and is resolved in SP6 and SP7 of AO 1.4, however this still occurs in my test with AO 1.4 SP7.

4. - Error: General .NET Exception:
Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))
   at Microsoft.Office.Interop.Excel._Application.get_Selection()

Unresolved, a search of SAP OSS Notes results in no OSS Notes

5. - Error: General .NET Exception:
The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
   at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)

Unresolved, a search of SAP OSS Notes results in no OSS Notes

The PAM for Analysis for Office 1.4 shows that Windows 8 64-bit is supported:

Checklist:
1. Latest Microsoft Windows 8/8.1 64-bit updates applied
2. Latest Microsoft Office 2013 64-bit updates applied
3. Latest Analysis 1.4 patch applied - Check - Currently on version 1.4 SP7 (Update as of 2014/05/14) I see there is already a note with reference to a hotfix soon to be available.

Retesting still results in the same issues with Windows 8/8.1 and Office 2013 64-bit and Analysis 1.4 SP7 64-bit

Has anyone else encountered this issue(s) before with Windows 8/8.1 and Microsoft Office 2013 64-bit and Analysis for Office 1.4 SP 7 64-bit?

Regards

Derek

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 11, 2014 at 04:08 PM

    Hi Derek Fox,

    This issue solved with Below Note

    http://service.sap.com/sap/support/notes/2079301

    Please follow the note(expected to release with AO 1.4 SP10 Soon)

    Best regards,

    Subhash

    Add comment
    10|10000 characters needed characters exceeded

  • May 27, 2014 at 11:08 AM

    I don't have Office 64 bit software, but I wouldn't expect Analysis Office to work with Windows 8.1 since the PAM doesn't specifically list it at https://websmp105.sap-ag.de/~sapidb/011000358700000429322013E

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      Update:

      With reference to OSS Note: 2118372 - AO 1.4: Context Menu on AO Taskpane disabled for Windows 8 / 8.1 / Server 2012 / Server 2012 R2.

      I can confirm that the combination software of Windows 8.1 and Office 2013 64-bit and Analysis 1.4 SP10 Patch 1 64-bit is now working (I have tested this now) as SAP does mention that there is the limitation of the context menu disabled in the taskpane for now and that they hope to have it fixed with SP11 later.

      AO 1.4 SP11 is expected in calendar week 10 (+/-2nd March 2015 to 8th March 2015).

      Regards

      Derek