Skip to Content
Author's profile photo Naor Shalom

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


Picture 1.0

Open the HANA studio and go to Life cycle manager


Picture 1.1

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



Picture 1.2

In picture 1.2 you can see the hana register on LMDB


Picture 1.3


Picture 1.4

System configuration on Solution Manager

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

Select the HANA SID – configure system


Picture 2.0

Assign Product to the system


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


Picture 2.2

HostAgent check success for host “HANA server”


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”


Picture 2.4

In this step, you verify or add landscape parameters.

Save the landscape objects


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


Picture 2.6

In this step you perform manual configuration activities.


Picture 2.7

Logical component assignment not required for this system type


Picture 2.7


System Landscape – Solution Manager SMSY

Errors :


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.


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*.



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


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

Note 1731373 – CCDB: Problems and solutions


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


Naor Shalom

Assigned Tags

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

      Good Job Naor.



      Author's profile photo Former Member
      Former Member

      Thanks for this very useful configuration guide!

      kind regards,

      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