Skip to Content
author's profile photo Former Member
Former Member

Runtime error Bex Query Execution

Hi guys,

I'm facing an BW-BEX error, when I Execute a Bex Query that supposed to

make some time to retreive data, about 30000 records, un Excel runtime

error occurs

with the same query but enough restricted to retreive less than 5000

records, this time it works fine

This bug occurs on any PC workstation not only on my computer.

ST22 shows no thing abnormal.

ON RSRT, it works fine

Any Idea ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2007 at 06:39 PM

    Try updating patch level for BEx...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 10:05 AM

    Thank you for your respond

    I'm Already with the latest patches ON SAPGUI et BI components

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 04:32 PM

    I had this in the Bex Log file

    ListSeparator: ,

    ExcelVersion: 11.0

    AddinVersion: 7005.5.1502.949

    GetSystemInformation

    SUNI Const: 0

    CommunicationFactory.GetSystemInformation (Setting Conn 1)): 0

    CommunicationFactory.GetSystemInformation (Setting Conn 2)): 0

    CommunicationFactory.GetSystemInformation (Setting init Propties)): 0

    CommunicationFactory.GetSystemInformation (SUNI.FUNCTION_EXISTS)): 0.779665

    RSR_XLS_RFCtrc: 3.898325

    CommunicationFactory.GetSystemInformation (RSR_XLS_NET_INTERFACE)): 6.393253

    CommunicationFactory.GetSystemInformation (XML Stuff)): 8.576315

    CommunicationFactory.GetSystemInformation (Prop Stuff)): 8.576315

    CommunicationFactory.GetSystemInformation (Version)): 8.576315

    CommunicationFactory.ObtainSystemInformationandCheckVersion (GetSysInfo)): 8.732248

    CommunicationFactory.ObtainSystemInformationandCheckVersion (CheckAfterLogin)): 0.155933

    CommunicationFactory.LogOnUsingComConnection (ObtainSystemInfo)): 8.888181

    CommunicationFactory.LogOnUsingComConnection (MainConnectionChangedEvent)): 0.935598

    CommunicationFactory.LogOn: 10.135645

    BExCheckFrontend.CheckFrontend: No Check performed (20071119) 0

    RSR_XLS_RFCtrc: 0.467799

    BExThemes.LoadFromBackend: 2.338995

    BExThemes.LoadFromBackend: 0

    BExConnect.LogOn: 91.220805

    RSR_XLS_RFCtrc: 0.155933

    RSR_XLS_RFCtrc: 0.155933

    OpenWorkbookGetTheMimeAndStoreItOnTemp

    BExProperties.CreateFromDeSer: CompId was not provided!

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

    BExApplication.AfterRender: 01Pas de cellules correspondantes.

    BExApplication.AfterRender: 01Pas de cellules correspondantes.

    OpenWorkbookOpenTheSavedWorkbook 4

    RSR_XLS_RFCtrc: 1.091531

    RSR_XLS_RFCtrc: 0.935598

    RSR_XLS_RFCtrc: 0.623732

    BExProperties.CreateFromDeSer: CompId was not provided!

    RSR_XLS_RFCtrc: 0

    RSR_XLS_RFCtrc: 0.311866

    RSR_XLS_RFCtrc: 0.467799

    RSR_XLS_RFCtrc: 0.155933

    RSR_XLS_RFCtrc: 2.338995

    RSR_XLS_RFCtrc: 0

    RSR_XLS_RFCtrc: 0.311866

    RSR_XLS_RFCtrc: 0.155933

    RSR_XLS_RFCtrc: 0.779665

    RSR_XLS_RFCtrc: 2.338995

    RSR_XLS_RFCtrc: 0.311866

    RSR_XLS_RFCtrc: 282.082797

    RSR_XLS_RFCtrc: 1.403397

    RenderIndent: 1.24736

    RenderBorders: 0.156032

    RenderHierarchyShapes: 0

    7.0 Workbook : SAPBEXonRefresh exit called

    BExApplication.AfterRender: 01Pas de cellules correspondantes.

    BExApplication.AfterRender: 01Pas de cellules correspondantes.

    RSR_XLS_RFCtrc: 0.155933

    RSR_XLS_RFCtrc: 3.898325

    RSR_XLS_RFCtrc: 0.155933

    RSR_XLS_RFCtrc: 0.155933

    RSR_XLS_RFCtrc: 0.155933

    RSR_XLS_RFCtrc: 0.467799

    RSR_XLS_RFCtrc: 1.871196

    RSR_XLS_RFCtrc: 0.155933

    RSR_XLS_RFCtrc: 2448.469559

    -


    11/20/2007 5:07:42 PM----


    System.Exception: BExConnect.BExWorkbook: Exception ---> System.OutOfMemoryException: Exception of type System.OutOfMemoryException was thrown.

    --- End of inner exception stack trace ---

    at com.sap.bi.et.analyzer.addin.BExConnect.get_BExWorkbook(String iWorkbookName, Boolean iConstruct)

    at com.sap.bi.et.analyzer.addin.BExMenu.UpdateMenuSubMenuControls()

    at com.sap.bi.et.analyzer.addin.BExMenu.UpdateMenu()

    at com.sap.bi.et.analyzer.addin.BExMenu.Update()

    at com.sap.bi.et.analyzer.addin.BExMenu.CommunicationFactory_MainConnectionChanged(BExCommunicationEventArgs iArguments)

    at com.sap.bi.et.Communication.MainConnectionChangedEventHandler.Invoke(BExCommunicationEventArgs iArgs)

    at com.sap.bi.et.Communication.CommunicationFactory.LogOff()

    at com.sap.bi.et.analyzer.api.BExConnectionLostException..ctor(Exception iException, BICS_PROV_T_MESSAGE itMessage)

    at com.sap.bi.et.analyzer.api.BExDataProvider.RetrieveResultSet()

    at com.sap.bi.et.analyzer.api.BExApplication.GetTemplate(Boolean iDoNotReadData)

    BExConnect.BExWorkbook: Exception

    at com.sap.bi.et.analyzer.addin.BExConnect.get_BExWorkbook(String iWorkbookName, Boolean iConstruct)

    at com.sap.bi.et.analyzer.addin.BExMenu.UpdateMenuSubMenuControls()

    at com.sap.bi.et.analyzer.addin.BExMenu.UpdateMenu()

    at com.sap.bi.et.analyzer.addin.BExMenu.Update()

    at com.sap.bi.et.analyzer.addin.BExMenu.CommunicationFactory_MainConnectionChanged(BExCommunicationEventArgs iArguments)

    at com.sap.bi.et.Communication.MainConnectionChangedEventHandler.Invoke(BExCommunicationEventArgs iArgs)

    at com.sap.bi.et.Communication.CommunicationFactory.LogOff()

    at com.sap.bi.et.analyzer.api.BExConnectionLostException..ctor(Exception iException, BICS_PROV_T_MESSAGE itMessage)

    at com.sap.bi.et.analyzer.api.BExDataProvider.RetrieveResultSet()

    at com.sap.bi.et.analyzer.api.BExApplication.GetTemplate(Boolean iDoNotReadData)

    -


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.