Skip to Content

Motivation:

I started the upgrade of 7.3 portal system and sum is expecting <sid>adm password, and due to audit restriction we were not able use the <sid>adm in sum for the upgrade.  I checked couple of documents about sum and I didn’t see any workaround for the same.


I checked one document which talks about  DMO for HANA , observed that there was option where we can skip <sid>adm user/password(by changing the sumstart.conf file) and tried that option  we moved forward but unfortunately started several issues with schema user and  and several other issues(Even though I have given full permission and groups to the user) and ultimately resulted the restart of the upgrade with JSPM with the help of note 1563660 .


I checked with sap and they told that it is not meant for normal upgrade and it’s is only meant for DMO and it was not tested for other scenarios

Goal:

I spent several hours for investigating the workaround and picking the wrong tool again wasted several more working hours in solving the actual issue. I checked several blogs in SDN and here I would like summarize few points which gives idea when to use sum and sum with DMO  ,   this is not new blog with entirely new content but I would like differentiate both the tools .



Software Update Manager:

    • Release uprade (major release change)
    • System update (EHP installation)
    • applying Support Packages (SPs) / Support Package Stacks
    • applying Java patches
    • correction of installed software information

  SUM is used for all SAP NetWeaver based systems, so systems either based on AS ABAP, or AS Java, or based on a dual-stack system. 

./STARTUP

http://<host name>:4239.


SUM with DMO

Database migration option (DMO) is an option in SUM – DMO is not a separate tool and this build is only using the ABAP part of SUM, called SAPup

  1. 1. Although DMO is based on the “standard” SUM, a new user interface (UI) is used – but only for the DMO procedure. The UI is based on SAPUI5, so it’s running in a browser, and offers some comfortable features like checking the log files without having to log on to the OS of the application server.

   2.  Different start procedure

SUM is started in a different way: a browser request to the SAPHostAgent is used to start SUM, instead of starting SUM from the prompt/console. This allows you to start the SAPup process without having an additional server window open

Different UI

   3. SUM shows a new user interface which is based on SAPUI5, which is currently exclusively available for DMO only.

   4. The new UI is currently only available for the DMO procedure, but in the long run, it may become available for other use cases as well.


Where we can use

Scenario:

  • You want to migrate your existing SAP ABAP system to the SAP HANA database
  • Your SAP release needs to be upgraded prior to migration
  • MO for SAP NetWeaver BW and for SAP Business Suite systems
  • DMO is available with Software Update Manager 1.0 SP09, and can be used for systems based on AS ABAP. It can be used for SAP NetWeaver BW systems from 7.0 SP17 (and higher) to migrate to 7.31 (and higher). And it can be used for systems part of the SAP Business Suite 7.0 (and higher) to migrate to a level corresponding to SAP BASIS 7.40 (for example “SAP enhancement package 7 for SAP ERP 6.0”).


How to start SUM with DMO option


Run the command /usr/sap/<SID>/SUM/abap/SUMSTART confighostagent to create the file sumstart.conf in

Start the DMO Frontend with the following URL – (HTTP/HTTPS)


http://<server>.<domain>.<ext>:1128/lmsl/upgrade/<SID>/doc/gui

https://<server>.<domain>.<ext>:1129/lmsl/upgrade/<SID>/doc/gui


Using proper tools as suggested by sap will save your time And always it is  recommend to use sap prefered tools and follow release notes and guides before planning any upgrade .


Referecens:


http://scn.sap.com/community/it-management/alm/software-logistics/blog/2014/03/10/dmo-technical-procedure

http://scn.sap.com/docs/DOC-49580

https://scn.sap.com/docs/DOC-46824

1600846 – JSPM/SUM Calls sapcontrol without user credentials

1563660 – sapcontrol, <sid>adm authorization issues (SUM)

SAP First Guidance – migrate BW on HANA with the

database migration option (DMO)

To report this post you need to login first.

2 Comments

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

  1. Andy Silvey

    Hi Veeramalla,

    thank you for publishing this article and describing your experience and your observations on the application of the different tools.

    One of the simple rules in SAP is wherever possible stick to the standard and use the right tools for the job.

    The root cause of the challenge you experienced was that you didn’t have access to the sidadm password.

    I have seen this scenario in so many large companies.

    The problem can be solely attributed to weak Management and weak Leadership.

    In the SAP Basis world, where things are complex enough, it simply isn’t right that after the enterprise has invested all of this money into the software, hardware, human resources, that the Basis Engineers have to resort to hacking and trial and error simply to attempt to complete the execution of an upgrade.

    Upgrades are complex enough without having to add a layer of complexity around hacking the tools and procedures.

    You should not have had to do that, your Manager/Team Lead should have taken the situation,

         the SUM Tool requires the sidadm password

    to the Security Team and using the process obtained an exception/exemption.

    If the Manager/Team Lead is not having the skills and qualities to achieve that, then he/she is putting the implementation and investment at risk and costing the enterprise more money and time. Time spent hacking, reading, guessing, time spent at every hurdle trying to get the upgrade to execute step by step, time spent solving later fundamental issues caused by the upgrade not being executed with the correct tools.

    To conclude, the article is interesting in as much as it shares differences in the tools and their usage scenarios, however,

    the moral of the story is:

         . There are times when Basis Leads / Basis Managers needs to show Leadership and take challenges like this one, SUM needs to sidadm password, as high as is needed to obtain the desired result

    On top of this, upgrades are a standard routine activity, often on an annual basis and for the whole SAP landscape, and therefore, this scenario is precisely the kind of scenario which needs an exception to the rule, and so, if the Manager / Basis Lead will show leadership and get an agreement with the Security Team on this one, they solve the problem for ever more.

    Best regards,

    Andy.

    (1) 
    1. Veeramalla V Post author

      HI Andey,

         Thanks for you comments and i strongly agree with your views, Most of the time  basis consultant  need to  depends on other groups like unix/linux/database/security . Challenging part is that most of the time these groups are supported by different companies  getting the things to be done is some what difficult and it’s purely management decision and they need to take it forward .

      As a basis consultant thumb rule is , stick to basic rules like following standard guides and release notes before starting any activity.

      //Veeramalla

      (0) 

Leave a Reply