SAP Logon. Export to Excel. Microsoft has blocked macros from running because the source of this file is untrusted.

Posted on by

When you export a report from SAP to MS Excel this error may occur. New MS Office update prevents running unsigned VBA scripts.

You need to upload new templates to SAP. The problem is that SAP uses several templates for different cases. I found it for Report Writer and EHS Excel. The notes mentioned below might help you. You just need to download these new templates and upload them according to the notes information. In addition, you need to download new SAP certificates for digitally signed VBA scripts. It’s needed to upload to each workstation in Trusted Publishers. Group policy can be used to automate it.


Transaction OAOR:
Class name: REPORTWRITER
Class type:OT
https://me.sap.com/notes/1992004
https://me.sap.com/notes/0003261967

Class name:EHSEXCEL
Class type: OT
https://me.sap.com/notes/2594418
https://me.sap.com/notes/3247649

Yeah there’s a hole in my soul

Posted on by
For inexplicable reasons, every person in the world is born with a huge hole right in the center of their chest.
Not particularly uncomfortable, but still quite unsightly, people are constantly trying to fill it with something.
Someone fills it with religion, someone buys a bunch of stuff, and someone even stuffs other people into it.
I left mine empty because I noticed one interesting thing: if you run into the wind without bending, a cool whistling sound is heard from the hole.

SAP SSO trouble – Server does not trust my certificate path

Posted on by 
G5S-API(maj): Miscellaneous failure
GSS-API(min): A2210223:Server does not trust my certificate path
target='p:CN=<SID>, OU=SAP-HEC, O= SAP SE, C=DE*
Error in SNC
Do you want to see the detailed error description?

There is an SAP note for this problem, but it didn’t help me:
https://userapps.support.sap.com/sap/support/knowledge/en/2516117

The resolution was simple, I checked my SPN records by typing the command:
setspn -L SSO-ABAP-<SID>

And I got an expected error:

FindDomainForAccount: Call to DsGetDcNameWithAccountW failed with return value 0x00000525. Could not find account SSO-ABAP-<SID>.

The answer is: Check your technical account that is used for SAP Kerberos SSO. It might be locked in MS Active Directory.

In my case, this account was simply locked by AD security script.

SAPSPRINT stopped printing all documents

Posted on by

Ensure you didn’t check the box “Save output as file”, thinking it sends a copy to a file. In fact, it redirects all printing to a file, despite the fact you are able to see in the Windows print spooler: “Printed successfully”.

By the way, with the release of 7.6 SAPPDRPRINT is no longer needed, it became a part of SAPSPRINT with the new engine ASPOSE PDF.