BEX critical program error - "com.sap.bi.et.analyzer.api.BExItem+DeleteMe"

[Former Member]

Hi,

We have written some VBA script in our workbook that deletes and adds some columns and data dyamically in an Excel-sheet. When executing the workbook it ends in "A critical program error". We use SAP GUI 7.1. The trace log shows below message. It throws an exception "com.sap.bi.et.analyzer.api.BExItem+DeleteMe" which seems to be the problem. Anyone that has a clue what could cause this?

/Daniel

-

---

1/15/2009 1:44:57 PM----

---

System.Exception: CriticalProgramError ---> System.Exception: CriticalProgramError ---> com.sap.bi.et.analyzer.api.BExItemDeleteMe: Exception of type 'com.sap.bi.et.analyzer.api.BExItemDeleteMe' was thrown.

at com.sap.bi.et.analyzer.addin.BExExcelItem.get_Worksheet()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AutofitRanges()

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

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AutofitRanges()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AfterRenderCommon()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AfterRender()

at com.sap.bi.et.analyzer.api.BExApplication.Render()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.SwitchModeToAnalysisMode()

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

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

at com.sap.bi.et.analyzer.addin.BExUserInteraction.Process(String iStepName)

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

at com.sap.bi.et.analyzer.addin.BExUserInteraction.Process(String iStepName)

at com.sap.bi.et.analyzer.addin.BExUserInteraction.ProcessUserInteraction(Sub iSubDelegate, BExStepType iStepType)

at com.sap.bi.et.analyzer.addin.BExMenu.Process(CMD iCMD)

at com.sap.bi.et.analyzer.addin.BExMenu.ProcessCMD(CMD iCMD)

at com.sap.bi.et.analyzer.addin.BExConnect.ExcelCommunication.ProcessBExMenuCommand(String iCMD)

CriticalProgramError

at com.sap.bi.et.analyzer.addin.BExUserInteraction.Process(String iStepName)

at com.sap.bi.et.analyzer.addin.BExUserInteraction.ProcessUserInteraction(Sub iSubDelegate, BExStepType iStepType)

at com.sap.bi.et.analyzer.addin.BExMenu.Process(CMD iCMD)

at com.sap.bi.et.analyzer.addin.BExMenu.ProcessCMD(CMD iCMD)

at com.sap.bi.et.analyzer.addin.BExConnect.ExcelCommunication.ProcessBExMenuCommand(String iCMD)

-

---

Inner Exception: 1

-

---

1/15/2009 1:44:57 PM----

---

System.Exception: CriticalProgramError ---> com.sap.bi.et.analyzer.api.BExItemDeleteMe: Exception of type 'com.sap.bi.et.analyzer.api.BExItemDeleteMe' was thrown.

at com.sap.bi.et.analyzer.addin.BExExcelItem.get_Worksheet()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AutofitRanges()

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

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AutofitRanges()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AfterRenderCommon()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AfterRender()

at com.sap.bi.et.analyzer.api.BExApplication.Render()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.SwitchModeToAnalysisMode()

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

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

at com.sap.bi.et.analyzer.addin.BExUserInteraction.Process(String iStepName)

CriticalProgramError

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AutofitRanges()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AfterRenderCommon()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AfterRender()

at com.sap.bi.et.analyzer.api.BExApplication.Render()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.SwitchModeToAnalysisMode()

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

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

at com.sap.bi.et.analyzer.addin.BExUserInteraction.Process(String iStepName)

-

---

Inner Exception: 2

-

---

1/15/2009 1:44:57 PM----

---

com.sap.bi.et.analyzer.api.BExItemDeleteMe: Exception of type 'com.sap.bi.et.analyzer.api.BExItemDeleteMe' was thrown.

at com.sap.bi.et.analyzer.addin.BExExcelItem.get_Worksheet()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AutofitRanges()

Exception of type 'com.sap.bi.et.analyzer.api.BExItem+DeleteMe' was thrown.

at com.sap.bi.et.analyzer.addin.BExExcelItem.get_Worksheet()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.AutofitRanges()

-

---

[Former Member · Accepted solution]

Hi,

Check U R Bex patch(might be patch issue) .

Rgds,

Satya.