SAP GUI 720 Precalculation Error Message Cannot run the macro 'LogOn'.

[chris_mason2]

We are testing the SAP GUI 720 with the corresponding version of the Precalculation Server. We have applied OSS Notes 0001435326 Usage of transaction RRMX / precalc server with SAP Gui 7.20

0001471630 BExAnalyzer: connection problems with RRMX and SAP Gui 7.20

0001477686 Business Explorer: duplicate usage of file extension ".bex".

We run Excel 2007 on the server.

Now we are getting a new error message/stack trace:

Connection passed

Unresolved exception occurred on the precalculation server

System.Runtime.InteropServices.COMException (0x800 0A03EC): Cannot run the macro 'LogOn'. The macro may not be available in this workbook or all macros may be disabled.

at Microsoft.VisualBasic.CompilerServices.LateB Binding.LateGet(Object o, Type objType, String name

, Object[] args, String[] paramnames, Boolean[] CopyBack) at Microsoft.VisualBasic.CompilerServices.NewLa ateBinding.LateGet(Object Instance, Type Type

etc...

at com.sap.bi.et.precalculation.BExPreCalcRFCSe erverImpl.RS_PREC_PRECALCULATE.

We have tried to select "enable macros" inside Excel 2007, but it doesn't seem to help. Has anyone found a work around for this error? Could it be that our logon ID is having problems?

[former_member225306 · Accepted solution]

Hi,

This error is typical of a precalc server installed on a virtual

machine. Can you please confirm if this is the case. SAP not

recommend to use VM ware. please check Notes

1461398 BW 7.X(7.20) Precalculation - General Info. & Limitations

1236773 BI7.X(7.10) Precalculation - General Information&Limitations

Limitation for VM ware:

o Virtual machines are not supported for the installation and

distribution of the precalculation service. It means, you can not

use a VMWare machine to install the precalculation server and use

it as a server to schedule the delivery of precalculated

workbooks.

It is critical to run Precalculation on virtual machines.

SAP not recommand to do that. Because you have no real access to

Host resources. If on the real host are a lot of VMwares installed the

IO Rate is quite bad, and in some cases this leads to an issue in RPC

automation, because the RPC server (Excel) will not react in time and we

get Automation errors like:

BWIB-02P1:System.Runtime.InteropServices.COMException (0x80010105): The

server threw an exception. (Exception from HRESULT: 0x80010105

(RPC_E_SERVERFAULT))

So please install precalc in dedicated resource.

2. Your precalc server is running with user account

"Administrator" . You have to Add this user to the below folders.

C:\Windows\SysWOW64\config\systemprofile\Desktop

C:\Windows\System32\config\systemprofile\Desktop

C:\Windows\Microsoft .Net framework\framework\v2.0.50727

C:\Windows\Microsoft .Net framework\framework64\v2.0.50727

please have a look to below note 1453559.

check do you have Desktop folder in the below path

C:\Windows\SysWOW64\config\systemprofile &

C:\Windows\System32\config\systemprofile\Desktop

you have to create it manually.

Thanks,

Venkat

[chris_mason2]

This error disappeared when the system administrator uninstalled the software, and then did a clean reinstall. Apparently there was some problem in the initial install that left the precalc service incorrectly installed.

[arvind_doomra]

Dear Chris,

Are you able to run the workbook without any errors on precalculation machine ? Are you able to execute RRMX on prec systems?

Please try to resave the workbook on precalculation system and then try to broadcast it again,

This will resolve your issue,

Regards,

Arvind