Skip to Content
0
Former Member
Aug 23, 2012 at 11:58 AM

Error in opening Bex Workbook

84 Views

Hi,

I have built a Workbook in Bex 7.0 with macros in it.

I am able to run the workbook in my system but not in one of my team member's system.

Please find the trace below and tell me what could be the error, as I couldn't get any clue out of it.


Trace file:

BExConnect.RegistrySet: System.UnauthorizedAccessExceptionAccess to the registry key 'HKEY_CLASSES_ROOT\SAP.BusinessExplorer.Analyzer\ApolloPath' is denied.

ListSeparator: ,

ExcelVersion: 12.0

AddinVersion: 7100.1.500.1083

BExExcelApplication.OpenWorkBook

BExCheckFrontend.CheckFrontend: No Check performed (20120817) 0

-------------------8/23/2012 4:46:45 PM-------------------

System.Exception: CriticalProgramError ---> System.Exception: BExConnect.WorkbookBExExcelApplication: Exception ---> System.Exception: CriticlaProgramError ---> System.MissingMemberException: Public member 'Shapes' on type 'Workbook' not found.

at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)

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.CreateDesignShape(BExParameter iParameter)

at com.sap.bi.et.analyzer.addin.BExExcelItem.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)

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

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

at com.sap.bi.et.analyzer.api.BExItems.CreateFromDeSer(BExDeSer_Item[] iItems)

at com.sap.bi.et.analyzer.api.BExApplication.CreateFromDeSer(BExDeSer_Page iPage)

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

at com.sap.bi.et.analyzer.addin.BExExcelApplication..ctor(String iWorkbookName)

at com.sap.bi.et.analyzer.addin.BExExcelApplication.get_BExApplication(String iName, Boolean iConstruct)

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

--- 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.BExConnect.ProcessWorkbookOpen(Object iWorkbook)

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

at com.sap.bi.et.analyzer.addin.BExConnect.ProcessWorkbookOpen(Object iWorkbook)

at com.sap.bi.et.analyzer.addin.BExConnect.ExcelCommunication.WorkbookOpen(Object iWorkbook)

CriticalProgramError

at com.sap.bi.et.analyzer.addin.BExConnect.ProcessWorkbookOpen(Object iWorkbook)

at com.sap.bi.et.analyzer.addin.BExConnect.ExcelCommunication.WorkbookOpen(Object iWorkbook)

--------------------------------------------------------------------------

Inner Exception: 1

-------------------8/23/2012 4:46:45 PM-------------------

System.Exception: BExConnect.WorkbookBExExcelApplication: Exception ---> System.Exception: CriticlaProgramError ---> System.MissingMemberException: Public member 'Shapes' on type 'Workbook' not found.

at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)

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.CreateDesignShape(BExParameter iParameter)

at com.sap.bi.et.analyzer.addin.BExExcelItem.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)

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

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

at com.sap.bi.et.analyzer.api.BExItems.CreateFromDeSer(BExDeSer_Item[] iItems)

at com.sap.bi.et.analyzer.api.BExApplication.CreateFromDeSer(BExDeSer_Page iPage)

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

at com.sap.bi.et.analyzer.addin.BExExcelApplication..ctor(String iWorkbookName)

at com.sap.bi.et.analyzer.addin.BExExcelApplication.get_BExApplication(String iName, Boolean iConstruct)

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

--- 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.BExConnect.ProcessWorkbookOpen(Object iWorkbook)

BExConnect.WorkbookBExExcelApplication: Exception

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

at com.sap.bi.et.analyzer.addin.BExConnect.ProcessWorkbookOpen(Object iWorkbook)

--------------------------------------------------------------------------

Inner Exception: 2

-------------------8/23/2012 4:46:45 PM-------------------

System.Exception: CriticlaProgramError ---> System.MissingMemberException: Public member 'Shapes' on type 'Workbook' not found.

at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)

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.CreateDesignShape(BExParameter iParameter)

at com.sap.bi.et.analyzer.addin.BExExcelItem.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)

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

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

at com.sap.bi.et.analyzer.api.BExItems.CreateFromDeSer(BExDeSer_Item[] iItems)

at com.sap.bi.et.analyzer.api.BExApplication.CreateFromDeSer(BExDeSer_Page iPage)

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

at com.sap.bi.et.analyzer.addin.BExExcelApplication..ctor(String iWorkbookName)

at com.sap.bi.et.analyzer.addin.BExExcelApplication.get_BExApplication(String iName, Boolean iConstruct)

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

CriticlaProgramError

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

at com.sap.bi.et.analyzer.api.BExItems.CreateFromDeSer(BExDeSer_Item[] iItems)

at com.sap.bi.et.analyzer.api.BExApplication.CreateFromDeSer(BExDeSer_Page iPage)

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

at com.sap.bi.et.analyzer.addin.BExExcelApplication..ctor(String iWorkbookName)

at com.sap.bi.et.analyzer.addin.BExExcelApplication.get_BExApplication(String iName, Boolean iConstruct)

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

--------------------------------------------------------------------------

Inner Exception: 3

-------------------8/23/2012 4:46:45 PM-------------------

System.MissingMemberException: Public member 'Shapes' on type 'Workbook' not found.

at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)

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.CreateDesignShape(BExParameter iParameter)

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