Thursday, February 4, 2016

2217798 - Not automatically detected HANA database after registering it to SLD

Symptom
Followed http://wiki.scn.sap.com/wiki/display/TechOps/Managed+System+Setup+of+HANA+in+Solution+Manager+7.1 for registering HANA in SLD
However, HANA database is not automatically detected on the product instance menu ( LMDB -> Software -> Product instances )
Important Terms:
Platform components: SAP HANA database
Server: nameserver
Other terms: Solution manager


Other Terms
SAP HANA


Reason and Prerequisites
Reason:
Case1. landscapeDescription.xml ( located at /hana/shared/<sid>/lm_structure ) generated by LCM has changed in the way that the section of SAP HANA database server is not the first entry. Because of this reason, the sldreg.xml generated by SLD data supplier has missing production information.
Case2. The installation of products might be not correctly done or landscapeDescription.xml file is manually changed. Because of this, the sldreg.xml generated by SLD data supplier has missing HANA database information.
Prerequisites:
  • Case 1. landscapeDescription.xml includes following section which is NOT in the first entry within <collectedSoftwareFeatures>
<installedSWFeature>
               <caption>SAP HANA PLATFORM EDIT. 1.0: SAP HANA database server</caption>
                <instanceKey>2</instanceKey>
                <identifyingNumber>01200314694900011972</identifyingNumber>
                <software-components>
                  <software-component>
                    <caption>SAP HANA DATABASE</caption>
                    ...
                  </software-component>
                </software-components>
</installedSWFeature>
  • Case 2. landscapeDescription.xml doesn’t have <software-component> section for installed “SAP HANA PLATFORM EDIT. 1.0: SAP HANA database server” as following
<installedSWFeature>
           <caption> SAP HANA PLATFORM EDIT. 1.0: SAP HANA database server</caption>
           <instanceKey>2</instanceKey>
           <!-- In CIM it is called "name". In PPMS it is called "Instance Key" -->
           <identifyingNumber>01200314694900011972</identifyingNumber>
           <!-- CIM stores the identifying number of the product version. in PPMS this field is called "Number of Activated Instance" and can be seen in the list of "Activated Instances". -->
</installedSWFeature>


Solution
For case 1, plan to release the fix in SPS11
For case 2, please check whether there was any problems in product installation or landscapeDescription.xml was modified.
These are permanent solution. Please check below for workaround.
Remarks:
  • Workaround:
For case 1, please follow steps below
   1. Change landscapeDescripton.xml by moving the section
<installedSWFeature>
               <caption>SAP HANA PLATFORM EDIT. 1.0: SAP HANA database server</caption>
                <instanceKey>2</instanceKey>
                <identifyingNumber>01200314694900011972</identifyingNumber>
                <software-components>
                  <software-component>
                    <caption>SAP HANA DATABASE</caption>
                    ...
                  </software-component>
                </software-components>
</installedSWFeature>
to the first position of within <collectedSoftwareFeatures>.
   2. Run following to regenerate sldreg.xml
alter system alter configuration ('nameserver.ini','SYSTEM') set ('sld','enable') = 'false' with reconfigure;
alter system alter configuration ('nameserver.ini','SYSTEM') set ('sld','enable') = 'true' with reconfigure;
   3. Run following to register SLD again
/usr/sap/hostctrl/exe/saposcol -b | sldreg -connectfile /usr/sap/ <SID>/SYS/global/slddest.cfg -stdin –oldtransferdtd
For case 2, please recreate landscapeDescription.xml after logging in OS as <sid>adm as following, and follow the steps below.
   1. recreate landscapeDescription.xml
cd /hana/shared/<sid>/hdblcm
./hdblcm --action=update_component_list
   2. remove the empty line in the beginning of newly created landscapeDescription.xml
   3. follow additional steps which are defined for case 1 above.



Header Data

Released On 14.12.2015 06:10:34
Release Status Released for Customer
Component HAN-DB SAP HANA Database
Priority Correction with medium priority
Category Program error

No comments:

Post a Comment