SAP Knowledge Base Article - Preview

3200804 - sldreg.xml not created on the secondary host

Symptom

Facing issue on HANA hosts, where have replication active.
If the sldreg.xml is generated, it does not put this file onto the trace folder of the secondary database host.
This seems to cause that the replication relationship do not get to SLD and Solman for monitoring.

Using instruction in SAP Note#2436986 with special focus on SLD Registration for SAP HANA System Replcation systems.
If all settings are in place, the sldreg.xml file will be generated in the /hana/shared/<SID>/HDB<nr>/<hostname>/trace folder of both system (primary and secondary host):

sldreg -connectfile /usr/sap/<SID>/SYS/global/slddest.cfg -file /hana/shared/<SID>/HDB<instance number>/<hostname>/trace/sldreg.xml

It succeed on the primary host, but the sldreg.xml file is not created on the secondary system.

On the SLD trace of primary and secondary, it show that the payload file sldreg.xml was created and sent to SLD:

nameserver_s-zyxwv-2-8x.31001.000.trc
[26133]{-1}[-1/-1] 2022-03-09 15:31:11.978299 d SLDCollect       CIMModel.cpp(02970) : ComponentOnComputerSystem: HDB_CLIENT
[26133]{-1}[-1/-1] 2022-03-09 15:31:11.978971 i SLDSend          Sld.cpp(00388) : SldReg xml=/usr/sap/ABC/HDB10/s-zyxwv-2-8x/trace/sldreg.xml, log=/usr/sap/ABC/HDB10/s-zyxwv-2-8x/trace/sldreg.log, cfg=/usr/sap/ABC/SYS/global/slddest.cfg
[26133]{-1}[-1/-1] 2022-03-09 15:31:12.162771 i Basis            ProcessExecution.cpp(00859) : Child process exited: 0, "sldreg" "-connectfile" "/usr/sap/ABC/SYS/global/slddest.cfg" "-file" "/usr/sap/ABC/HDB10/s-zyxwv-2-8x/trace/sldreg.xml" "-logfile" "/usr/sap/ABC/HDB10/s-zyxwv-2-8x/trace/sldreg.log"

nameserver_s-zyxwv-1-o1.31001.004.trc
[29701]{-1}[-1/-1] 2022-03-09 14:49:26.798673 d SLDCollect       CIMModel.cpp(02970) : ComponentOnComputerSystem: HDB_CLIENT
[29701]{-1}[-1/-1] 2022-03-09 14:49:26.799662 i SLDSend          Sld.cpp(00388) : SldReg xml=/usr/sap/ABC/HDB10/s-zyxwv-1-o1/trace/sldreg.xml, log=/usr/sap/ABC/HDB10/s-zyxwv-1-o1/trace/sldreg.log, cfg=/usr/sap/ABC/SYS/global/slddest.cfg
[29701]{-1}[-1/-1] 2022-03-09 14:49:26.923800 i Basis            ProcessExecution.cpp(00859) : Child process exited: 0, "sldreg" "-connectfile" "/usr/sap/ABC/SYS/global/slddest.cfg" "-file" "/usr/sap/ABC/HDB10/s-zyxwv-1-o1/trace/sldreg.xml" "-logfile" "/usr/sap/ABC/HDB10/s-zyxwv-1-o1/trace/sldreg.log"


Read more...

Environment

SAP HANA DB 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-MON , SAP HANA Monitoring , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.