Runtime error Bex Query Execution

[Former Member]

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 ?

[Former Member]

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)

-

---

[Former Member]

Thank you for your respond

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

[Former Member]

Try updating patch level for BEx...