SAP BW 3.X Error

[Former Member]

We have SAP 640 Compilation 5 installed and use BW 3.X

All installed okay but when running a report, Excel launches and the following error is displayed:

Run-time error 91

Object variable or With block variable not set

When we click on Debug it displays Bexanalyzer.xla and highlights the following line:

Call paddin.setconnectionfromhandle(pc_connectionObj)

No reports appear to run and all display this same error messaage. Would this be a compatibility issue with the back end server ?

Any help would be great.

[Former Member]

Could you provide a link ?

[former_member181887]

Hi,

I would suggest that you execute the BEx installation check tool. It is a excel macro called sapbexc.xla. It will check your installation and tell you if anything was not successfull installed or registered.

Patches can be downloaded from the SAP Service marketplace (http://service.sap.com/patches

Cheers,

Mike.

[Former Member]

Thanks very much. I have run the XLA file and it reports that none of the files are an incorrect version (ie none are red). There are a few files which are marked yellow which state the version is higher than required.

It is strange it says this as the files that state this are located on our SAP640 installation server (run from server install)....

A reinstall does not seem to cure this problem. The issue seems to be all reports which use the BEXAnalyzer.xla file. The issue does not appear to be an issue with the Install as such, it seems more to be an issue with the VB Code in this XLA file.

When using the debug option on the error, the code appears in the VB editor tool and highlights the following line:

Call paddin.setconnectionfromhandle(p_connectionobj)

It is like the p_connectionobj is not defined properly or is not getting a result from the above section which reads:

If isconnected then

with p_connectionObj

End with

Call paddin.setconnectionfromhandle(p_connectionobj)

It does not seem to do anything in the With statement, as though the call paddin line should be in the with statement not out of it.....

Any advice/comparison with working BexAnalyzer.xla would be great.

Thanks

Toby

[Former Member]

Toby,

I have moved BW Add-Ins into Excel Add-In folder and the error is gone. When trying to execute any of the controls however, Excel crashes and the trace file has the following message:

(Error)(dd.mm.yy 07:22:42.593): CALL METHOD "Run" OF [#9/0x002121AC/101]

#0: STRING "SAPBEX0.XLA!SAPBEX0directLaunch"

#1: STRING "sid"

#2: STRING "userid"

#3: STRING ""

#4: STRING ""

#5: STRING ""

#6: STRING ""

#7: STRING "server"

IDispatch::Invoke raised exceptionException occurred

(Error) : Error occured at Verb : Run

(Error) : Object: 9

(Error) : SAPAWRFC leaving RfcFlushOle with RfcRaise(CALL_METHOD_FAILED)

[Former Member]

Hi Toby:

Have you tried to download the latest patch for SAPGui and BEX ?

Try that !

Regards,

Federico