Skip to Content
author's profile photo
Former Member

BEx Analyzer, Office 2007, Windows XP Issue

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 BEx" target="_blank">https://websmp110.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000676672&">BEx Compatibility of MS Operating Systems and Office Products 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"?>

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

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

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

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

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

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

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

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

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

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

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)

-


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Jun 26, 2007 at 02:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 05:45 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded