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

[Derek_Fox]

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

[former_member110741]

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

[ksehjpal]

This message was moderated.

[ksehjpal]

This message was moderated.

[TammyPowlas]

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

[Former Member]

Hi Derek,

I'm having a similar issue. Till morning , I was using Windows 7 -64 bit with Office 2013 64 bit , the Analysis 64 bit addin was working perfectly fine...

But, when I installed BO Analysis 1.4  64 bit with latest SP 0.7 in Windows 8.1 64 bit with office 2013 64 bit, the analysis is getting crashed when i open the query..

Did you find a solution for this issue ?.

I'm thinking to raise a message to SAP on this.

Please let me know.

Regards.

Prashant

[TammyPowlas]

Prashant,

As said above per the PAM, Analysis Office does not support Windows 8.1

https://websmp107.sap-ag.de/~sapidb/011000358700000429322013E

[Former Member]

Hi Tammy,

Thanks. I overlooked your statement.

[Former Member]

Hi Tammy,

Will this issue be resolved in the next upcoming service pack ?

[Derek_Fox]

Hi Prashant

I have logged a call with SAP requesting clarification on certain topics, still awaiting a reply back.

Regards

Derek

[Derek_Fox]

Hi

OSS Note 1466118 - Hardware & Software requirements for Analysis, edition for MS Office has been updated (document version 7, valid from 2014/06/20).

Software requirements on Windows 8 & 8.1
32bit OS
OS: Windows 8 and 8.1
Excel: 2007, 2010 and 2013
Powerpoint: 2007, 2010 and 2013

64bit OS, 32bit MS Office
OS: Windows 8 and 8.1
Excel: 2007, 2010 and 2013
Powerpoint: 2007, 2010 and 2013

64bit OS, 64bit MS Office
OS: Windows 8 and 8.1 64bit
Excel: 2010 and 2013 (64bit version of MS Office)
Powerpoint: 2010 and 2013 (64bit version of MS Office)

I did receive a reply from SAP regarding the issue I was having with Office 2013 64bit crashing and they recommended to apply Analysis 1.4 SP7 Hotfix 1 (patch 1) and see if that corrects the issue, will test later when I am back at the office.

Regards

Derek

[Derek_Fox]

Hi

I've retested Analysis for Office 1.4 SP7 patch 1 (64-bit) with Microsoft Office 2013 (64-bit) this morning and Excel still crashes.

I have submitted the logs to SAP for further analysis.

PS:

I have seen there is an OSS note which refers to SP8 (due +/-mid August 2014 according to the SBOP support pack maintenance schedule) where there is further correction(s) to Analysis with regards to Microsoft Office 2013.

Regards

Derek

[Derek_Fox]

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