Unable to Open BEx file created using NWBC client

[RamBilasYadav]

Hi,

I am working on EhP3 & NWBC Client.

I tried to export an ALV report to "BEx Analyzer" using the option "Export -> BEx Analyzer".

If I select the option "Open" in the subsequent pop-up, it just opens an Excel window and nothing appears after that. Not even a workbook gets created.

If I select to save and then open the saved ".bex" file, an excel window opens up. But immediately I get the "Microsoft Visual Basic Error" stating "Run-Time error: '91': Object variable or With block variable not set".

If I choose "debug" option, visual basic code window appears. I get to the following line there.

Public Function LogOn(Optional iUser As String = "", Optional iSystemId As String = "", Optional iServer As String = "", Optional iSysNo As Long = 0, Optional iClient As String = "", Optional iLanguage As String = "", Optional iSNCName As String = "", Optional iSNCQuality As String = "", Optional iTicket As String = "") As Boolean

LogOn = pAddin.ExcelInterface.LogOn(iUser:=iUser, iSystemId:=iSystemId, iServer:=iServer, iSysNo:=iSysNo, iLanguage:=iLanguage, iClient:=iClient, iSNCName:=iSNCName, iSNCQuality:=iSNCQuality, iTicket:=iTicket)

End Function

I believe "pAddin" object is not getting initialized and hence the error.

Is anyone having any idea why this problem is happening?

How do I fix this?

Regards,

Ram.

[Former Member · Accepted solution]

Hi,

Uninstall all your Frontend components,

Reinstall them in the following order and yes, I would recommend you to restart the system whenever it prompts you to do so.

1) GUi FrontEnd 7.0

2) BEx 3.x or 7.0 or both

3) Respective patch (>12)

4) BW AddOn

5) BI AddOn.

this would surely solve your problem.

Rgds,

Sree

[RamBilasYadav]

Finally got the solution.

I have put the following patches, it worked.

Bi front end patch bi710_2-10004472.exe and bi710sp02p_201-10004472.exe.

(I didnt try the latest patch - which is 10)

And also install Microsoft Office Patch KB907417.

The icon becomes clickable and you get proper menu options after that.

Please refer to the following sdn post.

Regards,

Ram.

Edited by: Ram Bilas Yadav on Oct 20, 2009 9:41 PM

Edited by: Ram Bilas Yadav on Oct 20, 2009 9:42 PM

[hai_murali_here]

Hi,

Please try using the latest patch available at SMP

The Latest BEx Client can be found in the SMP at following location :

service.sap.com/swdc

->SAP Software Distribution Center

->Download

->Support Packages and Patches

->Entry by Application Group

->SAP Frontend Components

->BI ADDON FOR SAP GUI

->BI 7.0 ADDON FOR SAP GUI 7.10

Hope this helps you.

Rgds,

Murali

[Former Member]

Try applying BEx patches for the same. BEx latest patches are available in the SAP Service Market Place.

Hope this would help you.