Unable to login into BEX in Silent Mode Since SAP GUI 7.50 Upgrade

[former_member212236]

Hello All,

I am unable to login into BEx in silent mode using the VB script since I upgraded the GUI to 7.50

With the use of SAP.Functions in the VBA code, the code runs without crashing but it does not log me into BI.

The .Isconnected returns value of 1 but I’m not connected.

Maybe I’m missing setting a parameter within .connection? or is it a security permission within SAP? Or am I missing something else?

Could you please help identify what needs to be modified in the VB code I am using.

I am not sure whether SAP had stopped supporting silent logon?

Any insights would be helpful.

Below is my code.

Set myConnection = Application.Run("bexanalyzer.xla!sapbexgetconnection")   

If SAPFunctions Is Nothing Then  

Set SAPFunctions = CreateObject("SAP.Functions")

End If

latest = SAPFunctions.Connection.IsConnected

If SAPFunctions.Connection.IsConnected <> 1 Then

With SAPFunctions.Connection  

.client = login_sht.Cells(1, 2).Value  ‘value = 100  

.user = login_sht.Cells(2, 2).Value  ‘value = TEST  

.Password = login_sht.Cells(3, 2).Value       ‘value = bilalin2!  

.Language = login_sht.Cells(4, 2).Value     ‘value = EN  

.systemnumber = login_sht.Cells(5, 2).Value  ‘value = 02  

.system = login_sht.Cells(6, 2).Value  ‘value = BWP  

.ApplicationServer = login_sht.Cells(7, 2).Value  ‘value = XX.XX.XX.XX  

.SAProuter = login_sht.Cells(8, 2).Value  ‘value = null          

.Logon 0, True         'returns .isconnected value of 1 but still not connected  

End With  

If SAPFunctions.Connection.IsConnected <> 1 Then  

MsgBox "something went wrong ..."  

Exit Sub  

Else  

MsgBox "login Success"  End IfElse  MsgBox "SAPFunctions is still connected"End If

Reference Links:

https://wiki.scn.sap.com/wiki/display/BI/Using+VBA+to+connect+to+BW+server+with+SAPBEXgetConnection

https://answers.sap.com/questions/1665734/sapbexgetconnection-doesnt-return-proper-values-wh.html

Regards,

Vinoth V

[former_member212236 · Accepted solution]

Hi,

The issue got resolved after installing the latest SAP GUI. Closing the thread.

Regards,

Vin

[former_member245939]

Hello Vinoth Vasudevan ,

first of all, please try SAP note 2541995 - BEx Analyzer: Using VBA to connect to BW server with SAPBEXgetConnection , where you can find code snippet attached.

When LandscapeFormatEnabled parameter is enabled (in SAP Logon options), you have to provide "MSHOST plus SYSID and GROUP" for silent logon, as below :

.MessageServer = objCon.MessageServer

.GroupName = objCon.GroupName

[vinothvasudevan]

Hello Sergey Musatov,

Thank You so much for your response.

I had now asked the basis team to help me with the patch as mentioned on the note 2541995. I will get this installed and update you on the outcome soon.

Thanks again.

[former_member245939]

Hello Vinoth Vasudevan ,

I also would like to advice you to install the latest BI Addon (BEx) for SAP GUI 7.50, because it likely contains all the corrections to already known errors of this issue.

Sergey

[former_member212236]

Hello Sergey Musatov,

I had got the patch file from the Basis team and tried installing the same. But, got the below error. I have also tried to uninstall and reinstall the gui last week but no luck. Kindly let me know if you have come across similar errors.

I am planning to install the patch file from a thumb drive to see if that helps. I will update you on what happens.