Skip to Content
Author's profile photo Naor Shalom
Naor Shalom
December 26, 2013 3 minute read

Connect HANA to SLD and Solution Manager

Connect HANA to SLD and Solution Manager

First Step: Register on SLD

To connect HANA to Solution manager you have to register the HANA in SLD

Using Life cycle manager

/wp-content/uploads/2013/12/14_351059.png

Picture 1.0

Open the HANA studio and go to Life cycle manager

/wp-content/uploads/2013/12/15_351060.png

Picture 1.1

  • SLD hostname
  • SLD port
  • SLD username
  • SLD password
  • HANA SP06

HANA SID on LMDB

16.PNG

Picture 1.2

In picture 1.2 you can see the hana register on LMDB

17.PNG

Picture 1.3

18.PNG

Picture 1.4

System configuration on Solution Manager

Go to Solman workcenter – Solution Manager configuration – Manage system configuration

Select the HANA SID – configure system

19.PNG

Picture 2.0

Assign Product to the system

20.PNG

Picture 2.1

In this step, you assign the diagnostics agents to the managed systems. You assign a diagnostics agent to each server (virtual host) on which the managed system is running

21.PNG

Picture 2.2

HostAgent check success for host “HANA server”

22.PNG

Picture 2.3

In this step, you specify all system parameters required to configure the managed system

SQL port  – Port number of HANA instance

User name  – HANA DB user – Should be “System user”

23.PNG

Picture 2.4

In this step, you verify or add landscape parameters.

Save the landscape objects

24.PNG

Picture 2.5

In this step, SAP Solution Manager performs automatic configuration activities.

  • DATABASE Extractor Setup
  • SAPRouter Setup
  • Extractor Setup
  • Introscope Host Adapter
  • Alerting Setup for Early Watch Alert

26.PNG

Picture 2.6

In this step you perform manual configuration activities.

25.PNG

Picture 2.7

Logical component assignment not required for this system type

27.PNG

Picture 2.7

    

System Landscape – Solution Manager SMSY

Errors :

Symptom:

A CCDB extractor returns the error message “CCDB: A fatal error occured for a store”. Another symptom is that the CCDB Administration reports errors in the column ‘Fatal Errors’ for a managed system.

Solution:

The detailed error message can be found in the application log of the Solution Manager. Call transaction ‘SLG1’ and set object = ‘CCDB’, Ext. Identifier = ‘*<SID>*’ and from date = ‘<Yesterday>’. Search for red entries containing the text ‘Fatal Error…’. Having the detailed error message please search for notes on component SV-SMG-DIA*.

Symptom:

SLG1

—-Fatal Error: CX_PERSIST_STORE_UPL_DATE_1: The upload date ‘16.09.2013 14:52:56 UTC’  is in the future (Check rang

Solution:

Note 1891416 – CCDB CTC and DB Extractor – upload date is in the future

Note 1731373 – CCDB: Problems and solutions

SAP SOURCES:

Note 1747682 – SolMan 7.1: Managed System Setup for HANA

Note 1625203 – saphostagent/sapdbctrl for NewDB

Note 1891416 – CCDB CTC and DB Extractor – upload date is in the future

Note 1731373 – CCDB: Problems and solutions

Thanks

Naor Shalom

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kartik Natarajan
      Kartik Natarajan

      Good Job Naor.

      regards

      kartik

      Author's profile photo Former Member
      Former Member

      Thanks for this very useful configuration guide!

      kind regards,
      Jens

      Author's profile photo Daniel basis
      Daniel basis

      Hi Noar,

      Good blog. Some questions for you..

      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 ?

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

      Should I still register the HANA database in SLD separately?

      How to verify the HANA database is entry in registered on the solman 7.2 local SLD correctly?

      Thanks in advance

       

      Author's profile photo Vadym Diachenko
      Vadym Diachenko

      Just as an addition, because this is what I experienced so it might be useful for someone else.

      After providing the SLD registration details in HDBLCM the data might not be transferred immediately but waiting for the next trigger for synchronization. You can execute the following command for triggering forced HANA DB synchronization with SLD:

      /usr/sap/hostctrl/exe/saposcol -b | sldreg -connectfile /usr/sap/<SID>/SYS/global/slddest.cfg -stdin -oldtransferdtd

      or if you don't use the default location of slddest.cfg file (configuration file generated after providing SLD details) then define the actual path.

      After the execution, you will see the command output like:

      Used URL: http://<URL:PORT of your SLD>/sld/ds
Proxy is not configured.
HTTP open status: true - NI RC=0
HTTP send successful.
Return code: 200 --- Return message: (OK)
HTTP response: HTTP status code: 200
Data send status: true