1972235 - Duplicate HANA DB in SLD with different hostnames

Symptom

In SLD there are duplicate Hana Database Systems (SAP_HDBSystem) records with different hostnames for the same system.
The duplicate records can be checked under:

• For releases 7.1X and higher, go to SLD UI -> CIM Instances -> Choose Subset: Classes With Instances; Class: Hana Database Server(SAP_HDBSystem)
• For releases 7.X   and lower, go to SLD UI -> Administration -> Content Maintenance -> Choose Subset: All With Instances; Class: Hana Database Server(SAP_HDBSystem)

Examples of duplicate records are:

• Name: <SID>.DBTypeForSAP.HDB.SystemHome.<hostname1>
• Name: <SID>.DBTypeForSAP.HDB.SystemHome.<hostname2>

Other Terms

Hana Database Server, SAP_HDBSystem, SLD, System Landscape Directory

Reason and Prerequisites

The Hana Database Systems information reported to SLD is delivered from two different sources:

1. HANA data supplier
2. ABAP System data supplier (transaction RZ70)

Each of these data suppliers reports separately the hostname information, which is used to build the SAP_HDBSystem instance. If these hostnames are different, this will result in different records in the SLD.

Solution

To make the data in the SLD consistent, you need to change the hostname report from ABAP System in order to be the same as the one reported from HANA.
Follow the steps below:

1. Identify in SLD which SAP_HDBSystem instance was delivered with ABAP System data supplier and remove it manually.
• Steps to identify the record:
• For releases 7.1X and higher
• Navigate to SLD UI->CIM Instances-> Choose Subset: Classes With Instances; Class: Hana Database Server(SAP_HDBSystem)
• Go Associations tab and choose association with ‘Associated Class’ ‘Supplied Element’. For example, ‘HanaDatabase SID on hostname1’.
• On Supplied Element 'General' tab, check field with name ‘SupplierName’.  The name of the supplier can be HanaDatabase (if it was supplied by HANA) or BCSystem (if it was supplied by ABAP system). The instance, which you have to delete must be supplied by BCSystem.
• For releases 7.X and lower
• Navigate to SLD UI-> Administration-> Content Maintenance-> Choose Subset: All With Instances; Class: Hana Database Server(SAP_HDBSystem)
• Go to the number allocated under Assos’s column. The list of associations will be displayed.
• Click the link of Supplied Elements. For example, ‘HanaDatabase SID on hostname1’.
• On the Supplied Element General tab, ‘SupplierName’ is set as field name. The name of the supplier can be HanaDatabase (if it was supplied by HANA) or BCSystem (if it was supplied by ABAP system). The instance, which you have to delete must be supplied by BCSystem.
• Steps to delete the record:
• Navigate to CIM Instances and choose Class: Hana Database Server(SAP_HDBSystem)
• Choose the SAP_HDBSystem instance, which was delivered by BCSystem data supplier
• Choose Delete
2. Add parameter SLDSYSTEMHOME to the DEFAULT profile by applying note 1174300. The value of this parameter should be the same as the hostname delivered by the HanaDatabase data supplier.
3. Execute transaction RZ70 and manually trigger the ABAP system data supplier.
4. Check the SLD if there is only one SAP_HDBSystem instance.

Header Data

Released On	04.02.2014 15:01:01
Release Status	Released for Customer
Component	BC-CCM-SLD-JAV System Landscape Directory Java Client & Server
Other Components	BC-CCM-SLD System Landscape Directory / Component Repository
Priority	Correction with medium priority
Category	Workaround of missing functionality