cancel
Showing results for 
Search instead for 
Did you mean: 

BEx of GUI 7.10 not working after MS Office upgrade to 2007

Former Member
0 Kudos

Hi

We upgraded MS Office 2003 to 2007. And installed GUI 7.10 (Patch 9).

When we run BEx Analyser from start menu or RRMX, we notice the error message: "A critical program error occured. The program has to close. Please refer to the trace for further information".

We have also applied "BI AddOn Patch for GUI 7.10"

Kindly help me with the solution.

Thanks & Regards

Madhu

Accepted Solutions (1)

Accepted Solutions (1)

ChandranGanesan
Active Contributor
0 Kudos

Hello Madhu,

See these OSS Notes

1152092 - Error opening MS Excel 2007 workbook in MS Excel 2003

1013201 - Hardware and Software requirement for BI Standalone frontend

1089212 - BI Addon (7.10): not able display workbooks with Office 2007

1013139 - Pre-requisite for BI 7.x Frontend

Have a look at this

Also see,

Note 1175947 - Known Limitations of Analyzer with Excel 2007

[Troubleshoot the SAP NetWeaver 2004s BI Frontend Installation|]

Thanks

Chandran

Answers (1)

Answers (1)

Private_Member_101989
Contributor
0 Kudos

Hello Madhu,

Do a repair of your Office 2007 installation, it will work.

Regards,

Jorge Diogo

Former Member
0 Kudos

Hi

What are the pre-requisites to do office 2007 repair? Just straight forward or do I have to uninstall GUI?

Regards

Madhu

Private_Member_101989
Contributor
0 Kudos

Hello,

You don't have to uninstall sap gui, just insert Office 2007 cd and choose repair installation.

Regards,

Jorge Diogo

Former Member
0 Kudos

Sorry.. This didn't work out..

I am surprised that only I have received this problem.. I dont find suitable notes related to my problem.

Regards

Madhu

Former Member
0 Kudos

Hi

How do we convert xls workbook format to new Excel 2007 format and is required to save the workbook again?

Regards

Madhu

ChandranGanesan
Active Contributor
0 Kudos

Hello Madhu,

What is the BI 7.0 Support pack you are in?

You need to save the workbook in Excel 2007 version again.

Excel 2007 by default saves the workbook as .xlsx format. If you still want the workbook to be supported by older version of excel, then choose "Excel 97 - 2003 (*.xls)",

Try to install [Microsoft .Net 3.0|http://www.microsoft.com/downloads/details.aspx?familyid=10CC340B-F857] (if its not installed)

Note 1236489 BEx Analyzer:Convert xls workbook to new Excel2007 formats

Thanks

Chandran

Former Member
0 Kudos

Hi

Our BI 7.0 is at SP14.

As per OSS note 1236489, we already applied BI 700 add-on patch 700.

And our Windows XP system has .Net 3.0 by default.

I have referred most of the OSS notes and couple of SDN messages, but I didn't come across similar problem any where.

Is there any RRMX settings or BEx settings that needs to be changed?

Thanks & Regards

Madhu

Former Member
0 Kudos

Hi

I notice the following information in the trace file.. What does this say?? BEx problem, MIcrosoft ?

********************************************************************************

System.Exception: CriticalProgramError ---> System.Exception: CriticalProgramError ---> System.Exception: CriticalProgramError ---> System.Exception: CriticlaProgramError ---> System.Exception: CriticlaProgramError ---> System.Exception: CriticalProgramError ---> System.ArgumentException: The item with the specified name wasn't 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.BExChart.get_Chart(ChartDescription iChart, BExExcelItem iItem)

at com.sap.bi.et.analyzer.addin.BExItemGrid.UpdateCharts()

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

at com.sap.bi.et.analyzer.addin.BExItemGrid.UpdateCharts()

at com.sap.bi.et.analyzer.addin.BExItemGrid.OnRender(Boolean iForceRendering)

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

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

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

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

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

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

at com.sap.bi.et.analyzer.addin.BExExcelApplication.OpenQueryThreaded(BExParameter iParameter)

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

at com.sap.bi.et.analyzer.addin.BExExcelApplication.OpenQueryThreaded(BExParameter iParameter)

at com.sap.bi.et.analyzer.addin.BExThreads.ProcessParameterSubExecuter.Execute()

at com.sap.bi.et.analyzer.addin.BExExcelApplication.OpenQuery(OSObjectInformation iObjectDescription, String iRRIVariableName, String iRRIVariableValue)

at com.sap.bi.et.analyzer.addin.BExThreads.ProcessOpenQueryExecuter.Execute()

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

at com.sap.bi.et.analyzer.addin.BExThreads.ProcessOpenQueryExecuter.Execute()

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

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)

************************************************************************************************

Thanks & Regards

Madhu

ChandranGanesan
Active Contributor
0 Kudos

Hello Madhu,

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

Please check your RFC connection.

Can you check whether you have BExAnalyzer.xla in this path,

C:\Program Files\Common Files\SAP Shared\BW

If not place it and try again.

Thanks

Chandran

Former Member
0 Kudos

Hi, guys!

I have same problem.

I added file .xla to C:\Program Files\Common Files\SAP Shared\BW, but it doesn't help

Somebody can help me?

Former Member
0 Kudos

Hi

For my case, this problem was solved by changing the global settings in BEx Analyzer.. Following are the steps:

  • After executing RRMX, BEx Analyzer screen opens

  • Open Global Settings

  • Select u201CDefault Workbooku201D tab

  • Click u201CUse SAP Standardu201D

  • And then execute the query

Regards

Madhu