Skip to Content

They say knowledge is power. Previously, one had to jump through a few hoops to get logs which imparted the knowledge of what was happening at a low level on the HANA server. They may have had to go to HANA studio and open the administration view with a user that had access to do so. Or perhaps they had to request that their system administrator get the logs for them which would be done on the administrator’s timeline. There is now an option to generate the logs by first creating a role and granting it to a user and then simply running a URL in a browser.

I’m sure many of us have gotten an error similar to the following:

GenericExcelError.png

With this type of error message, obtaining logs is essential. Below I’ll show how it’s done.

STEPS TO ENABLE

1) Create a DEBUG role (only needs to be done once) in the S&OP web ui

DebugRoleCreation.png

2) Assign the newly created DEBUG role to the user wishing to generate logs:

AssignDebugToUser.png

GET THE ERROR LOG

1. Login to the Web UI with the user that has DEBUG access – https://<server>/sap/sop/ui/login.html

2. Once you log into the UI, you can launch one of the below URLs, in the same browser window, to get the error log (please note that if you don’t have an error id, just use the first URL).


To return last 200 lines of the error log:

      https://<server>/sap/sop/sopfnd/services/admin/querylogfile.xsjs?addlines=200


To get the error log neighboring the error id “0bc82458-719d-47fc-b2b9-2a1cb9c606d6”

       https://<server>/sap/sop/sopfnd/services/admin/querylogfile.xsjs?addlines=200&logid=0bc82458-719d-47fc-b2b9-2a1cb9c606d6

I hope this empowers you in your use of S&OP on HANA.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Alecsandra Dimofte

    Thank you!

    This is very useful specially for those working with productive systems, not having db exposed to ui.

    Now I should grab my spectacles 🙂

    Cheers,

    Alecsandra

    (0) 
  2. Lars Breddemann

    Hey John,

    thanks for putting the description together.

    Still, I’ve got to say, that this way of getting to error related information is pretty much broken.

    Handing the end-user a 32-digit hexadecimal log entry identifier is beyond all doubt not the right way to communicate system failure – especially not for an application that prides itself with a first class UX design.

    Hope to see large improvements here…

    – Lars

    (0) 
  3. Pablo Tortosa

    Hi John,

    we are working on a SOP IBP 4.0 and I cannot find the role “Application debugging” you are mentioning. Has this option somewhat disappeared in the new version?

    SOP IBP 4 permissions.pngregards,

    Pablo

    (0) 
    1. Aditya Gupta

      Hi Pablo,

      Application debugging permission is not available anymore and debugging has been shifted to HANA database through index server logs.

      Regards,

      Aditya G

      (0) 

Leave a Reply