cancel
Showing results for 
Search instead for 
Did you mean: 

BEx Analyzer, Office 2007, Windows XP Issue

Former Member
0 Kudos
116

I am having a problem getting BEx Analyzer to work with Office 2007 on my Windows XP machine.

Configuration:

Windows XP SP2 with all Windows updates

SAPGui 7.10 with Patch 2

Office 2007

SAP NetWeaver BI 7.0 Stack 12

According to the <a href="http://https://websmp110.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000676672&">BEx Compatibility of MS Operating Systems and Office Products</a> my configuration should work. I am able to start BEx Analyzer and select a query to open, but then it fails on the load. I get the following error:

<b>A critical program error has occurred.</b>

Below is the trace log. Any help would be appreciated.

-


BExConnect.Trace3: 0

BExExcelTraceListener.AddTraceListener: Added a tracelistener for Version: 7100.0.461

BExConnect.constructor2: 99.53125

BExMenu.CreateSubMenu1: 0

BExMenu.CreateSubMenu2: 2.5

ListSeparator: ,

GetSystemInformation

SUNI Const: 0

CommunicationFactory.GetSystemInformation (Setting Conn 1)): 0.3125

CommunicationFactory.GetSystemInformation (Setting Conn 2)): 0.3125

CommunicationFactory.GetSystemInformation (Setting init Propties)): 0.3125

CommunicationFactory.GetSystemInformation (SUNI.FUNCTION_EXISTS)): 1.71875

RSR_XLS_RFCtrc: 9.84375

CommunicationFactory.GetSystemInformation (RSR_XLS_NET_INTERFACE)): 16.09375

CommunicationFactory.GetSystemInformation (XML Stuff)): 20.46875

CommunicationFactory.GetSystemInformation (Prop Stuff)): 20.46875

CommunicationFactory.GetSystemInformation (Version)): 20.46875

CommunicationFactory.ObtainSystemInformationandCheckVersion (GetSysInfo)): 20.625

CommunicationFactory.ObtainSystemInformationandCheckVersion (CheckAfterLogin)): 0.15625

CommunicationFactory.LogOnUsingComConnection (ObtainSystemInfo)): 20.78125

CommunicationFactory.LogOnUsingComConnection (MainConnectionChangedEvent)): 2.34375

CommunicationFactory.LogOn: 144.53125

RSR_XLS_RFCtrc: 0.625

BExThemes.LoadFromBackend: 4.84375

BExThemes.LoadFromBackend: 0

BExConnect.LogOn: 299.21875

RSR_XLS_RFCtrc: 0.625

<?xml version="1.0" encoding="utf-16"?>

<I_T_SEARCH_ATTR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />

<?xml version="1.0" encoding="utf-16"?>

<I_T_SEARCH_ATTR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />

<?xml version="1.0" encoding="utf-16"?>

<I_T_SEARCH_ATTR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />

<?xml version="1.0" encoding="utf-16"?>

<I_T_SEARCH_ATTR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />

<?xml version="1.0" encoding="utf-16"?>

<I_T_SEARCH_ATTR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />

<?xml version="1.0" encoding="utf-16"?>

<I_T_SEARCH_ATTR xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" />

RSR_XLS_RFCtrc: 1.25

openworkbook with param

OpenWorkbookGetTheMimeAndStoreItOnTemp

BExItems.CreateFromDeSer: Trying to deserialize the Items...

-


6/25/2007 7:54:58 PM----


System.NullReferenceException: Object variable or With block variable not set.

at Microsoft.VisualBasic.CompilerServices.Symbols.Container..ctor(Object Instance)

at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)

at com.sap.bi.et.analyzer.addin.BExExcelItem.SetDesignShape(BExParameter iParameter)

at com.sap.bi.et.analyzer.addin.BExExcelItem.Create(BExParameter iParameter)

at com.sap.bi.et.analyzer.addin.BExItemTextElement.Create(BExParameter iParameter)

at com.sap.bi.et.analyzer.api.BExItem.CreateInternal(BExParameter iParameter, BExApplication iApplication)

at com.sap.bi.et.analyzer.api.BExItems.CreateItem(BExParameter iParameter)

Object variable or With block variable not set.

at Microsoft.VisualBasic.CompilerServices.Symbols.Container..ctor(Object Instance)

at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)

at com.sap.bi.et.analyzer.addin.BExExcelItem.SetDesignShape(BExParameter iParameter)

at com.sap.bi.et.analyzer.addin.BExExcelItem.Create(BExParameter iParameter)

at com.sap.bi.et.analyzer.addin.BExItemTextElement.Create(BExParameter iParameter)

at com.sap.bi.et.analyzer.api.BExItem.CreateInternal(BExParameter iParameter, BExApplication iApplication)

at com.sap.bi.et.analyzer.api.BExItems.CreateItem(BExParameter iParameter)

-


Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Tyler,

Please check to make sure that you are on the correct support package.

For Microsoft Office and Vista support, you need to be on SAP NetWeaver support package <b>stack</b> 12, which is equivalent to SAP NetWeaver <b>BI support package 13</b>.

Please see https://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000674496&; for the mapping of BI support packages to NW support package stacks.

See also https://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000676672&; for Microsoft compatibility information.

Regards,

Katie Beavers

SAP NetWeaver Product Management

Former Member
0 Kudos

Please forgive me for my ignorance, but if I was to do an 'About' on BEx Analyzer, it says Release 2004s, Support Package 0, Revision 461. Is this where I should see Support Package 13? Or will I see that in the SAPGui under the Component Information for the SAP_BW software component?

Thanks

Former Member
0 Kudos

Hi Tyler,

The support packages/stacks are applied to the backend system. You would need to log on to your BI system via the SAP logon and select System > Status and then the icon for Component Information. Your entry for SAP_BW should show level 0013. This is required for Vista/Office 2007 support.

Based on what you listed in your response, you will also need to apply patch 1 to your BI 7.x Add-On, which is required for all supported Microsoft versions. You can download the executable from service.sap.com/swdc at the path:

>Support Packages and Patches

>BI 7.0 ADDON FOR SAP GUI 7.10

              >WIN32

                  >BI710 patch #1 (SP-level #01)

Regards,

Katie

Former Member
0 Kudos

Katie,

I found patch level 1 and 2 for SAPGui 7.1, but I am unable to navigate to the location you mentioned for a BI 7.0 ADDON FOR SAP GUI 7.10. Is it possible that the location in the marketplace has changed, or that I don't have access?

Tyler

Former Member
0 Kudos

An alternative path in /swdc is:

Support Packages and Patches

>>SAP Frontend Components

>>>>BI ADDON FOR SAP GUI

>>>>>>BI 7.0 ADDON FOR SAP GUI 7.10

>>>>>>>>BI 7.0 ADDON FOR SAP GUI 7.10

>>>>>>>>>>Win 32

If you still can't access it, you'll have to contact Support.

Katie

Answers (1)

Answers (1)

Former Member
0 Kudos

I finally checked back to see if I could see Patch 1. It was still not there, but Patch 2 was there. After installing it, it resolved all issues with Excel 2007.

Thanks!