Skip to Content

Hello Friends,

In this document I am covering all about Managed system configuration of SAP HANA 2.0

 

Since this is new version some additional steps required in order to configure system.

 

Step 1 : Update SLD CR Content in your Solution Manager Master SLD

Before:

After:

For Any error like below please look SAP notes under SAP notes section

SAP Notes:

2297508 – The content of uploaded file is corrupted

2425670 – CIM_ERR_FAILED: CIM Error during import preparation – SLD CR Import issue

Step 2: Register HANA system to SLD

Open URL https://<HANAServerHostname>:1129/lmsl/HDBLCM/<SID>/index.html

Login with <sid>adm user and open “Configure System Landscape Directory Registration”

Provide required details and press Next

Click on Run

Restart Hana system to push your system data in to SLD (HDB stop & HDB start)

Step 3 : Update Stores as per SAP note : 2403493 – Solution Manager: Enabling the Monitoring of HANA 2.0 (SAP HANA DATABASE 2.00.xml)

Workcenter Solution Manager Administration -> Infrastructure -> Content -> Root Cause Analysis Content -> Stores.

Link : http://hostname:port/sap/bc/webdynpro/sap/diag_app_starter?APP_ID=SMADMIN_RCA&DATABASES&HOSTS&TECH_SCEN&TECH_SYS&APP_NAME=Root%20Cause%20Analysis&sap-client=XXX&sap-language=EN#

 

Step 4 : Update Views as per SAP note : 2403493 – Solution Manager: Enabling the Monitoring of HANA 2.0 (config.xml)

Workcenter Solution Manager Administration -> Infrastructure -> Content -> Root Cause Analysis Content -> Views.

Link: http://hostname:port/sap/bc/webdynpro/sap/diag_app_starter?APP_ID=SMADMIN_RCA&DATABASES&HOSTS&TECH_SCEN&TECH_SYS&APP_NAME=Root%20Cause%20Analysis&sap-client=XXX&sap-language=EN#

Step 5 : Upload the Extractors for HANA 2.0 (Templextr_HANA_20.csv)

Workcenter Solution Manager Administration -> Infrastructure -> Content -> Root Cause Analysis -> Extractors. Than go to Change Mode and press the ‘Expert Mode’.

Link: http://hostname:port/sap/bc/webdynpro/sap/diag_app_starter?APP_ID=SMADMIN_RCA&DATABASES&HOSTS&TECH_SCEN&TECH_SYS&APP_NAME=Root%20Cause%20Analysis&sap-client=XXX&sap-language=EN#

 

Step 6: Ensure that the MAI Content is up-to-date. It is available with:

Solution Manager 7.1: ST_CONT 100 SP 28

Solution Manager 7.2: ST_CONT 200 SP 9

Link for Solman 7.2: http://host:port/sap/bc/webdynpro/sap/diag_app_starter?APP_ID=SMADMIN_RAPID_CONTENT_DELIVERY&DATABASES&HOSTS&TECH_SCEN&TECH_SYS&APP_NAME=Rapid%20Content%20Delivery&sap-client=XXX&sap-language=EN#

 

 

More information : Part 16 : SAP Solution Manager 7.2 SR1 (+ SPS03) : Rapid Content Delivery Automatic Download (RCD)

https://blogs.sap.com/2016/11/04/part-16-sap-solution-manager-7.2-sr1-sps03-rapid-content-delivery-automatic-download-rcd/

Step 7 : Install Diagnostics Agent on SAP HANA Server

SAP notes to look after installation complete :

2216601 – Invalid Response Code (403) error occurs when checking SAP Host Agent in step “Assign Diagnostics Agent”

1890035 – How to avoid common Outside Discovery issues – Solution Manager 7.10

Step 8 : Install HANA client on SAP Solution Manager server (hdbsetup.exe)

Install providing installation path

 

Wait till installation finish

“E:\sap\hdbclient” Set path to the environment variable of Solution Manager <sid>adm user of ABAP

Restart SAP ABAP Stack

Step 9: Manage System Configuration

Set Diagnostics-relevance with Automatic settings

Execute automatic activities first

Create HANA Database user

We are creating MONITOR user in HANA as below

Note: We do now want to change this user password so make sure you run script below

ALTER USER MONITOR DISABLE PASSWORD LIFETIME;

 

 

Note: Check user is able to connect DB

CONNECT MONITOR PASSWORD <password>;

Assign DAA agent

Setup DB connection and other settings as below

 

Note: 2370773 – During the Managed System Configuration, the DBA cockpit connection of HANA ends with the error: Database connection ADBC error ‘internal error 16 has occurred’

Provide system parameters

Execute Automatic activities and perform manual activities as below

Check configuration

Finish

 

Now Managed system is configured. Next step is to configure your HANA system for monitoring.

Thank you for reading

Yogesh

To report this post you need to login first.

18 Comments

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

  1. Mohamed Fergany

    thank you very much ,really amazing

    but i still face an issue so appreciated if you help me in solving it

    .mce-content-body div.mce-resizehandle {position: absolute;border: 1px solid black;box-sizing: box-sizing;background: #FFF;width: 7px;height: 7px;z-index: 10000}.mce-content-body .mce-resizehandle:hover {background: #000}.mce-content-body img[data-mce-selected],.mce-content-body hr[data-mce-selected] {outline: 1px solid black;resize: none}.mce-content-body .mce-clonedresizable {position: absolute;outline: 1px dashed black;opacity: .5;filter: alpha(opacity=50);z-index: 10000}.mce-content-body .mce-resize-helper {background: #555;background: rgba(0,0,0,0.75);border-radius: 3px;border: 1px;color: white;display: none;font-family: sans-serif;font-size: 12px;white-space: nowrap;line-height: 14px;margin: 5px 10px;padding: 5px;position: absolute;z-index: 10001}
    .mce-visual-caret {position: absolute;background-color: black;background-color: currentcolor;}.mce-visual-caret-hidden {display: none;}*[data-mce-caret] {position: absolute;left: -1000px;right: auto;top: 0;margin: 0;padding: 0;}
    .mce-content-body .mce-offscreen-selection {position: absolute;left: -9999999999px;}.mce-content-body *[contentEditable=false] {cursor: default;}.mce-content-body *[contentEditable=true] {cursor: text;}
    body {min-height: 150px}

    The DBACockpit connection %_TDB_APP-HANA can not be established

     

    The DB extractors for collecting DB Performance data will not be activated.

    GP Framework Wizard Application UCF_DomUtil.attachEvent(window, “load”, wdaOnPopupLoad)

    Message Message
    The connection ‘%_TDB_APP-HANA’ is not set up correctly.
    Message Message
    Database connection %_TDB_APP-HANA: ADBC error ‘Internal error 16 has occured’

     

    (0) 
      1. Mohamed Fergany

        sorry.this what i wanted to write

        The DBACockpit connection %_TDB_APP-HANA can not be established

        The DB extractors for collecting DB Performance data will not be activated.

        Message Message
        The connection ‘%_TDB_APP-HANA’ is not set up correctly.

        Message Message
        Database connection %_TDB_APP-HANA: ADBC error ‘Internal error 16 has occured’

         

        (0) 
  2. Mohamed Fergany

    i wish i can take you e-mail and send you my team viewer ID and you help me in this critical issue as it is related to PCOE and the audit coming soon in few days

    (0) 
  3. Petrica Avdei-Mina

    Hello Yogesh,

    Please help me solve an issue related to your blog post.

    We have an solman 7.1 sp15 and we are trying to add an s4hana system on hana 2.0. We also have to implement  SAP note : 2403493 – Solution Manager: Enabling the Monitoring of HANA 2.0, but we encounter an issue at step 4 ( Upload the Extractors for HANA 2.0. Please upload the attached File ‘Templextr_HANA_20.csv’). The browse for extractor template is not active. We don’t find enything related to help us. Any ideea on how to solve the issue?

    Thank you in advance!

    Best regards,

    Peter A.

    (0) 
    1. Yogesh Patel Post author

      Hello,

      This issue might be because of 2 reasons listed below

      1. You are not in edit mode on this screen, There is edit button on screen
      2. You do not have proper security role assigned, Check SU53

      Thanks

      Yogesh

      (1) 
      1. Petrica Avdei-Mina

        Thank you Yogesh!

        The su53 I have tried for the first time and it was fine. Also the edit button, but it asked me to transport some modifications. So I have canceled it, not knowing what kind of modifications it will be transported. Today I said YES for the transport and the button become active. 🙂

        Thank you!

        Best regards,

        Peter

        (0) 
  4. Daniel basis

    Hi Yogesh,

     

    HANA Database(1.0)  is part of the ABAP application server.

    while performing managed system config. Should I do first for the ABAP system or HANA database ?

    RZ70 datasupplier from ABAP system..will it not add the HANA database entry also into SLD and solution manager 7.2?

    Should i still register the HANA database in SLD separately?

    Thanks in advance

     

    (0) 
    1. Yogesh Patel Post author

      Connect HDB first and after configure system. Do not forgot to install HDB client on your Solman system to connect HDB.

      enjoy !

      Yogesh

      (0) 
  5. Daniel basis

    Hi Yogesh,

    I am thinking to follow the below document steps as well.

    https://wiki.scn.sap.com/wiki/display/TechOps/Managed+System+Setup+of+HANA+Standard+Installations#ManagedSystemSetupofHANAStandardInstallations-SetupHDBUserStoreforSAPHostAgent

    Setup HDB User Store for SAP Host Agent

    The next step is to make sure the SAP Host Agent can connect to HANA and can receive process information. To enable this you need to set up the HDBUSERSTORE on each HANA host.

    Log on as <sid>adm to OS level and run the command:

    /usr/sap/hdbclient/hdbuserstore SET <SID>SAPDBCTRL <hana-master-host>:3<Sys-No>15 MONITOR password

    In newer installations you will find the hdbuserstore executable in the folder /hana/shared/<SID>/hdbclient.

    If you have a multi-node HANA database, please add all possible <hana-master-nodes> separated by semicolon surounded by “”.

    /usr/sap/hdbclient/hdbuserstore SET <SID>SAPDBCTRL "<hana-master-host1>:3<Sys-No>15;<hana-master-host2>:3<Sys-No>15" MONITOR password123

    Now my questions:

    1. Should I have the <sidadm> on the HANA db server to connect the hostagent running on the db server in distribution environment for ?
    2. I dont see the path
      /usr/sap/hdbclient on my hana database.
      
      Can I use the /hana/shared/hdbclient?

    Please clarify.

    Thanks in advance

    (0) 
  6. Vemuri MedhaDakshinaMurthy

    Hi Yogesh,

    Nice blog with clear steps.

    Since now we have ABAP and JAVA split up with 2 different SID’s with Solman 7.2, Is there a need to install HDB client for both ABAP & JAVA separately or just ABAP should be ok.

    Appreciate your help.

    Thanks in advance.

    (0) 

Leave a Reply