BEXAnaylzer, Excel 2007 and Win 7 32 bit / 64 bit Issue

[Former Member]

Good Day,

After install of the application, when running, Bexanaylzer.exe, open query, I receive a error message - "Encountered an Improper Argument". I have Bex 7.0 installed. I used the following source files for install.

Source install - gui720_0-10007878.exe

Patch used - bi720sp01p_101-20006596.exe

The Sap gui side works with no issues. My only problem seems to be the BexAnalyzer.exe. It does launch excel with no issues and puts ribbon bar up. Its upon selecting open query that I consistantly receive this error. Event Viewer shows that excel open and closed normally, but no information about the improper argument is logged. Process monitor shows a couple of buffer overflows, however I am not sure they are directly related to bex / excel 2007.

I have run NwCheckWorkstation.exe to check front end, it returns with no errors detected.

Has anyone encountered this issue with Win 7 installs? Theories and or resolutions would be appreciated.

thanks

-K

[Former Member · Accepted solution]

Hi ,

You will find the limitations here :

http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/business-intelligen...

- Mayuri

[former_member220449 · Accepted solution]

I have the same problem. Did anybody find a solution for the problem?

When I open a report, BEX gives me an error:

"A critical program error has occured. The program will now terminate"

I have office 2007, GUI 7.2, Win7 64 bit installed.

[Former Member · Accepted solution]

I ran into the same problem with Excel 2007 on a Windows & 64 bit system. A BW developer advised to remove the *.BAK files (I had three of them). After I did this Bex analyzer worked as before.

I had to search to C drive for *.exd files and then the 3 BAK files showed up.

Roel

[former_member220449 · Accepted solution]

Thanks for your answer. But I didn't undestand enough good. Can you explain it more?

You say that you removed three BAK files.. From which directory?

When I search for BAK files, I find them it the following directory:

C:\Program Files (x86)\SAP\FrontEnd\SAPgui\wwi

I removed 3 bak files :

wwi.ini.bak,

wwi_all.lbl.bak,

wwi_user.lbl.bak.

But it doesn't work.

And can you tell why did you search *.exd files?

When I search it, it find following files:

C:\Users\coskun\AppData\Local\Temp\VBE\MSForms.exd

C:\Users\coskun\AppData\Local\Temp\Excel8.0\MSForms.exd

[former_member188011]

Hi zen2010:

Please refer to slide 12 of the Presentation below.

"Microsoft Excel 2007 & SAP Business Explorer Compatibility"

Regards,

Francisco Milán.

[Former Member]

Hi zen 2010..

Have you applied the frontend and abap fix from note: 1435326? customer applying the new gui 7.20 were getting event viewer errors and development adjusted the abap part of this note to apply to 3x . Please apply it and regenerate your queries in tx: rsrt/environment/generate queries.

I hope this helps

best regards

Orla.