Skip to Content
0

HAN-DB : SLD registration via hdblcm

Feb 28 at 09:23 PM

230

avatar image

Hi Experts,

I am working on registering HANA system to SLD and facing issue. The screen stays in HANG status. I already checked below notes but still the same issue

2530768 - Registering HANA to SLD got hanged using HLM tool : - I tried this first and it didn't work as per note and stays in HANG status forever. As per this note i tried doing it at OS level and that is also in HANG status as well.

2533657 - SLD registration via hdblcm hangs

Could you please guide me the solution for this issue.

Regards,

Pankaj

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jimmy Yang
Mar 02 at 06:35 PM
0

Hi Pankaj,

When you do this on the O/S and it hangs, there should be some logs created in the /var/tmp directory.

It will be helpful to have those as an attachment or a picture of the error that is contained there.


Best Regards,
Jimmy

Show 5 Share
10 |10000 characters needed characters left characters exceeded

Hi Jimmy Yang,

Thank you for your response, below is the log from hdblcm.cfg. It just show the input we give while we run the hdblcm command to configure the SLD. I waited for more than 30 min on the same screen after putting the inputs but no logs after that and ultimately i have to close the session.

For analysis.xml log I see below error mentioned.

Please suggest.

devadm-##-##dev1:/var/tmp/hdb_DEV_hdblcm_configure_sld_2018-02-28_15.58.39> more hdblcm.cfg

[Action]

# Execution scenario

action=configure_sld

[General]

# SLD Host Name

sld_hostname= #######FQN#

# SLD Port

sld_port=50200

# SLD User Name

sld_username= ######

# Use HTTPS

https=n

devadm@bi-v-hdb-dev1:/var/tmp/hdb_DEV_hdblcm_configure_sld_2018-02-28_15.58.39>

devadm@####:/var/tmp/hdb_DEV_hdblcm_configure_sld_2018-02-28_15.46.54> more DEV_####_00_1519850847_analysis.xml <?xml version="1.0" encoding="utf-8"?> <analysis> <title>SAP HANA Database Lifecycle Management via HDBLCM</title> <application_system> <application_system_item> <extsidname>####:DEV</extsidname> <computer_system> <computer_system_item> <opsys>SLES_SAP</opsys> <opsysrelease>12.1.0.1</opsysrelease> <application_system_instance> <application_system_instance_item> <instancenumber>00</instancenumber> <hostname>#####</hostname> <sapsystemname>DEV</sapsystemname> </application_system_instance_item> </application_system_instance> </computer_system_item> </computer_system> <database_system> <database_system_item> <systemhome>/hana/shared/DEV</systemhome> <dbtypeforsap>HDB</dbtypeforsap> <release>2.00.011.00</release> <patchlevel>2.00.011.00</patchlevel> <dbname>SAP HANA database</dbname> </database_system_item> </database_system> </application_system_item> </application_system> <general_scenario_details> <lmprocess>HDBLCM_CONFIGURE_SLD</lmprocess> <startdate>1519850847</startdate> <enddate>1519851480</enddate> <general_process> <process_item> <runtime>633</runtime> <processname>HDBLCM_CONFIGURE_SLD</processname> <processtype>HDBLCM</processtype> <startdate>1519850847</startdate> <enddate>1519851480</enddate> <runstatus>ERROR</runstatus> <specific_process_details> <specific_process_details_item> <runstatus>ERROR</runstatus> <runstatusmsg>Configure System Landscape Directory Registration failed.</runstatusmsg> <usagetype>INTERNAL</usagetype> <execution_mode>CLI</execution_mode> <multidb>true</multidb> <parameters><![CDATA[action=configure_sld sld_username=j2ee_admin sld_hostname=##### sld_port=50200]]></parameters> </specific_process_details_item> </specific_process_details> <steps> <step> <stepname>Configure System Landscape Directory Registration</stepname> <startdate>1519850847</startdate> <enddate>1519851480</enddate> <runtime>633</runtime> <stepstatus>slp.task.state.ERROR</stepstatus> <modules/> </step> </steps> </process_item> </general_process> </general_scenario_details> <VERSION>1.0</VERSION> </analysis> devadm@####:/var/tmp/hdb_DEV_hdblcm_configure_sld_2018-02-28_15.46.54>

0

Hi,

I apologize for the delay in responding to you. We need to take a look at the hdblcm.log, not the cfg file. Can you please DM me the info. Please remove all private details about your hostname and sid from the trace file. If we can find a solution, I will summarize it for the general community audience afterwards.

Cheers,
Jimmy

0

Hi Jimmy Yang,

Please find logs below.

Below is the trace file logs:

SAP HANA Lifecycle Management - SAP HANA Database 2.00.011.00.1493936640 ************************************************************************ 14:51:44.370 - INFO: Start Date: 2018-03-23 - hdblcm 14:51:44.370 - INFO: Checking instance in /usr/sap/D##/HDB00 14:51:44.370 - INFO: Found SAP HANA Database host: D##-## 14:51:44.370 - INFO: Host D####1 is local 14:51:44.373 - INFO: Getting global.ini 14:51:44.373 - INFO: Reading global.ini 14:51:44.373 - INFO: Layer 'Default' found 14:51:44.382 - INFO: Layer 'System' found 14:51:44.382 - INFO: Layer 'Host' not found 14:51:44.382 - INFO: Found value 'multidb/mode' = 'multidb' in layer 'System' 14:51:44.383 - INFO: Found value 'multidb/database_isolation' = 'low' in layer 'System' 14:51:44.383 - INFO: Found value 'multidb/reserved_instance_numbers' = '0' in layer 'Default' 14:51:44.383 - INFO: Checking instance in /usr/sap/DAA/SMDA98 14:51:44.383 - INFO: Checking instance in /hana/shared/D##/HDB00 14:51:44.384 - INFO: Found SAP HANA Database host: D####1 14:51:44.384 - INFO: Host D####1 is local 14:51:44.384 - INFO: Checking instance in /hana/shared/D##/HDB00 14:51:44.384 - INFO: Found SAP HANA Database host: D####1 14:51:44.384 - INFO: Host D####1 is local 14:51:44.384 - INFO: 14:51:46.165 - INFO: Parameter 'action' (Action) is set by user, value = 'configure_sld' 14:51:46.165 - INFO: Parameter 'uninstall' (Uninstall) is not set 14:51:46.167 - INFO: Checking instance in /hana/shared/D##/HDB00 14:51:46.167 - INFO: Found SAP HANA Database host: D####1 14:51:46.167 - INFO: Host D####1 is local 14:51:58.133 - INFO: Parameter 'sld_hostname' (SLDHostname) is set by user, value = 'mc-v-sol-prd1.enercare.corp' 14:52:02.958 - INFO: Parameter 'sld_port' (SLDPort) is set by user, value = '50200' 14:52:07.917 - INFO: Parameter 'sld_username' (SLDUsername) is set by user, value = 'j2ee_adm_sp2' 14:52:14.851 - INFO: Parameter 'sld_password' (SLDPassword) is set by user, value = '***' 14:52:17.254 - INFO: Parameter 'https' (UseHTTPS) is set by user, value = 'Yes' 14:52:17.254 - INFO: Parameter 'sld_hostname' (SLDHostname) is set to value = 'mc-v-sol-prd1.enercare.corp' 14:52:17.255 - INFO: Parameter 'sld_port' (SLDPort) is set to value = '50200' 14:52:17.255 - INFO: Parameter 'sld_username' (SLDUsername) is set to value = 'j2ee_adm_sp2' 14:52:17.255 - INFO: Parameter 'sld_password' (SLDPassword) is set to value = '***' 14:52:17.255 - INFO: Parameter 'https' (UseHTTPS) is set to value = 'No' 14:52:17.255 - INFO: Creating section 'Action' 14:52:17.255 - INFO: Adding value 'action' = 'configure_sld' to section 'Action' 14:52:17.255 - INFO: Creating section 'General' 14:52:17.255 - INFO: Adding value 'sld_hostname' = '#########' to section 'General' 14:52:17.255 - INFO: Adding value 'sld_port' = '50200' to section 'General' 14:52:17.255 - INFO: Adding value 'sld_username' = 'j2ee_adm' to section 'General' 14:52:17.255 - INFO: Adding value 'https' = 'n' to section 'General' 14:52:17.256 - INFO: File '/var/tmp/hdb_D##_hdblcm_configure_sld_2018-03-23_14.51.43/hdblcm.cfg' updated 14:52:17.264 - INFO: 14:52:17.268 - INFO: Checking instance in /hana/shared/D##/HDB00 14:52:17.268 - INFO: Found SAP HANA Database host: D####1 14:52:17.268 - INFO: Host D####1 is local 14:52:17.268 - INFO: 14:52:17.271 - INFO: Checking instance in /hana/shared/D##/HDB00 14:52:17.271 - INFO: Found SAP HANA Database host: ####-b-D##1 14:52:17.271 - INFO: Host D####1 is local 14:52:23.728 - INFO: Getting global.ini 14:52:23.728 - INFO: Reading global.ini 14:52:23.728 - INFO: Layer 'Default' found 14:52:23.737 - INFO: Layer 'System' found 14:52:23.738 - INFO: Layer 'Host' not found 14:52:23.738 - INFO: Found value 'multidb/mode' = 'multidb' in layer 'System' 14:52:23.738 - INFO: Found value 'multidb/database_isolation' = 'low' in layer 'System' 14:52:23.738 - INFO: Configuring SLD registration... 14:52:23.739 - INFO: Switching to user id 700 and group id 500. 14:52:23.739 - INFO: Starting external program /hana/shared/D##/HDB00/exe/sldreg 14:52:23.739 - INFO: Command line is: /hana/shared/D##/HDB00/exe/sldreg -usekeyfile -configure /usr/sap/D##/SYS/global/slddest.cfg 14:52:58.743 - INFO: Output line 1: Command line used to start sldreg: 14:52:58.743 - INFO: Output line 2: /hana/shared/D##/HDB00/exe/sldreg -usekeyfile -configure /usr/sap/D##/SYS/global/slddest.cfg 14:52:58.743 - INFO: Output line 3: Profile is not explicitly specified on cmd line using pf=<profile> 14:52:58.743 - INFO: Output line 4: Looking for implicit profile in current working directory: /var/tmp/hdb_D##_hdblcm_configure_sld_2018-03-23_14.51.43 14:52:58.743 - INFO: Output line 5: Fri Mar 23 14:52:23 2018 SLD Registration Program [7.49.2] (Apr 3 2017) [Non-Unicode] 14:52:58.743 - INFO: Output line 6: 14:52:58.744 - INFO: Output line 7: Use configuration file '/usr/sap/D##/SYS/global/slddest.cfg' for output! 14:52:58.744 - INFO: Output line 8: Please specify the HTTP connect information: [User, Password, Host, Port, HTTP/HTTPS and Proxy details] 14:52:58.744 - INFO: Output line 9: User Name : Password : ************* 14:52:58.744 - INFO: Output line 10: Verify Password : ************* 14:52:58.744 - INFO: Output line 11: Server Host : Port [80,443,1024..65535]: Use HTTPS? (y/n): Use Proxy? (y/n): Proxy User : Proxy password : *********************************** ***************************************************************** 14:52:58.744 - INFO: Output line 12: Verify Password : **************************************************************************************************** 14:52:58.744 - INFO: Output line 13: Proxy : Proxy port [1024..65535]: Invalid port specified! 14:52:58.744 - INFO: Output line 14: Proxy port [1024..65535]: Invalid port specified! 14:52:58.744 - INFO: Output line 15: Proxy port [1024..65535]: Invalid port specified! 14:52:58.744 - INFO: Output line 16: Proxy port [1024..65535]: Invalid port specified! 14:52:58.744 - INFO: Output line 17: Proxy port [1024..65535]: Invalid port specified! 14:52:58.744 - INFO: Output line 18: Proxy port [1024..65535]: Invalid port specified! 14:52:58.744 - INFO: Output line 19: Proxy port [1024..65535]: Invalid port specified! 14:52:58.744 - INFO: Output line 20: Proxy port [1024..65535]: Invalid port specified! 14:52:58.745 - INFO: Output line 21: Proxy port [1024..65535]: Invalid port specified! 14:52:58.745 - INFO: Output line 22: Proxy port [1024..65535]: Invalid port specified! 14:52:58.745 - INFO: Output line 23: Proxy port [1024..65535]: Invalid port specified! 14:52:58.745 - INFO: Output line 24: Proxy port [1024..65535]: Invalid port specified! 14:52:58.745 - INFO: Output line 25: Proxy port [1024..65535]: Invalid port specified! 14:52:58.745 - INFO: Output line 26: Proxy port [1024..65535]: Invalid port specified! 14:52:58.745 - INFO: Output line 27: Proxy port [1024..65535]: Invalid port specified! 14:52:58.745 - INFO: Output line 28: Proxy port [1024..65535]: Invalid port specified!

0

Hi

I have to abort hdblcm cofig because of the above trace issue "Port not found"

And also find hdblcm.log file:

15:01:46.773 - INFO: Installing signal handler 15:01:46.773 - INFO: Handler for signal INT 15:01:46.773 - INFO: Handler for signal PIPE 15:01:46.773 - INFO: Handler for signal ABRT 15:01:46.773 - INFO: Handler for signal FPE 15:01:46.773 - INFO: Handler for signal QUIT 15:01:46.773 - INFO: Handler for signal SYS 15:01:46.773 - INFO: Handler for signal TRAP 15:01:46.774 - INFO: Handler for signal TERM 15:01:46.774 - INFO: Checking process limits 15:01:46.774 - INFO: nproc limit: hard = 2087659, soft = 2087659 15:01:46.774 - INFO: Setting limit 'nproc' to 'unlimited' 15:01:46.774 - INFO: ----------------------------------------------------------- 15:01:46.774 - INFO: System Information 15:01:46.774 - INFO: ----------------------------------------------------------- 15:01:46.774 - INFO: Operating System: Linux 15:01:46.774 - INFO: Architecture : #### 15:01:46.774 - INFO: Version : 3.12.74 15:01:46.774 - INFO: Subversion : 60.64.40-default 15:01:46.774 - INFO: C Runtime : GLIBC 2.19 15:01:46.774 - INFO: Host Name : D# 15:01:46.774 - INFO: Manufacturer : ### 15:01:46.774 - INFO: Product : ### 15:01:46.774 - INFO: Distribution : #### 15:01:46.774 - INFO: ----------------------------------------------------------- 15:01:46.774 - INFO: END: System Info 15:01:46.774 - INFO: ----------------------------------------------------------- 15:01:46.775 - INFO: Handler for signal INT 15:01:46.775 - INFO: ----------------------------------------------------------- 15:01:46.775 - INFO: Installer Information 15:01:46.775 - INFO: ----------------------------------------------------------- 15:01:46.775 - INFO: using installed Installer 15:01:46.775 - INFO: Version is 2.1.29 (git hash: a341ed03ed36) 15:01:46.775 - INFO: GitHash is a341ed03ed36 15:01:46.775 - INFO: Platform is linuxppc64le 15:01:46.775 - INFO: Perl version is v5.22.1 15:01:46.775 - INFO: Running as console application 15:01:46.775 - INFO: --------------------------------------------------------- 15:01:46.775 - INFO: Program Call Information 15:01:46.775 - INFO: --------------------------------------------------------- 15:01:46.775 - INFO: Caller program name is hdblcm 15:01:46.775 - INFO: Command line arguments: 15:01:46.775 - INFO: Current directory: /hana/shared/D##/hdblcm 15:01:46.775 - INFO: Installer directory: /hana/shared/D##/hdblcm/instruntime 15:01:46.775 - INFO: Pid is 89577 15:01:46.775 - INFO: Effective uid 0 15:01:46.775 - INFO: Real uid 0 15:01:46.775 - INFO: Effective gid 0 0 777 1001 15:01:46.775 - INFO: Real gid 0 0 777 1001 15:01:46.775 - INFO: --------------------------------------------------------- 15:01:46.775 - INFO: END: Program Call Information 15:01:46.775 - INFO: --------------------------------------------------------- 15:01:46.775 - INFO: --------------------------------------------------------- 15:01:46.775 - INFO: Environment Dump 15:01:46.775 - INFO: --------------------------------------------------------- 15:01:46.775 - INFO: ALSA_CONFIG_PATH = /etc/alsa-pulse.conf 15:01:46.775 - INFO: AUDIODRIVER = pulseaudio 15:01:46.775 - INFO: COLORTERM = 1 15:01:46.775 - INFO: CPU = ppc64le 15:01:46.776 - INFO: CSHEDIT = emacs 15:01:46.776 - INFO: CVS_RSH = ssh 15:01:46.776 - INFO: FROM_HEADER = 15:01:46.776 - INFO: GPG_TTY = /D##/pts/1 15:01:46.776 - INFO: G_BROKEN_FILENAMES = 1 15:01:46.776 - INFO: HISTSIZE = 1000 15:01:46.776 - INFO: HOME = /root 15:01:46.776 - INFO: HOST = D##ev1 15:01:46.776 - INFO: HOSTNAME = D##ev1 15:01:46.776 - INFO: HOSTTYPE = ppc64le 15:01:46.776 - INFO: INPUTRC = /etc/inputrc 15:01:46.776 - INFO: JAVA_BINDIR = /usr/lib64/jvm/jre/bin 15:01:46.776 - INFO: JAVA_HOME = /usr/lib64/jvm/jre 15:01:46.776 - INFO: JAVA_ROOT = /usr/lib64/jvm/jre 15:01:46.776 - INFO: JRE_HOME = /usr/lib64/jvm/jre 15:01:46.776 - INFO: LANG = POSIX 15:01:46.776 - INFO: LC_CTYPE = en_US.UTF-8 15:01:46.776 - INFO: LD_LIBRARY_PATH = /hana/shared/D##/hdblcm/./instruntime 15:01:46.776 - INFO: LESS = -M -I -R 15:01:46.776 - INFO: LESSCLOSE = lessclose.sh %s %s 15:01:46.776 - INFO: LESSKEY = /etc/lesskey.bin 15:01:46.776 - INFO: LESSOPEN = lessopen.sh %s 15:01:46.776 - INFO: LESS_ADVANCED_PREPROCESSOR = no 15:01:46.776 - INFO: LIBGL_DEBUG = quiet 15:01:46.776 - INFO: LOGNAME = root 15:01:46.776 - INFO: LS_COLORS = no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.xz=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32: 15:01:46.776 - INFO: LS_OPTIONS = -A -N --color=tty -T 0 15:01:46.776 - INFO: MACHTYPE = ppc64le-suse-linux 15:01:46.776 - INFO: MAIL = /var/mail/root 15:01:46.776 - INFO: MANPATH = /usr/share/man:/usr/local/man 15:01:46.776 - INFO: MINICOM = -c on 15:01:46.776 - INFO: MORE = -sl 15:01:46.776 - INFO: NNTPSERVER = news 15:01:46.776 - INFO: NO_AT_BRIDGE = 1 15:01:46.776 - INFO: OLDPWD = /root 15:01:46.776 - INFO: OSTYPE = linux 15:01:46.777 - INFO: PAGER = less 15:01:46.777 - INFO: PATH = /sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games 15:01:46.777 - INFO: PROFILEREAD = true 15:01:46.777 - INFO: PWD = /hana/shared/D##/hdblcm 15:01:46.777 - INFO: PYTHONSTARTUP = /etc/pythonstart 15:01:46.777 - INFO: QEMU_AUDIO_DRV = pa 15:01:46.777 - INFO: QT_SYSTEM_DIR = /usr/share/desktop-data 15:01:46.777 - INFO: SDL_AUDIODRIVER = pulse 15:01:46.777 - INFO: SHELL = /bin/bash 15:01:46.777 - INFO: SHLVL = 1 15:01:46.777 - INFO: SSH_CLIENT = ###### 61205 22 15:01:46.777 - INFO: SSH_CONNECTION = ###### 61205 ######1 22 15:01:46.777 - INFO: SSH_TTY = /D##/pts/1 15:01:46.777 - INFO: TERM = xterm 15:01:46.777 - INFO: USER = root 15:01:46.777 - INFO: WINDOWMANAGER = /usr/bin/icewm-session 15:01:46.777 - INFO: XCURSOR_THEME = DMZ 15:01:46.777 - INFO: XDG_CONFIG_DIRS = /etc/xdg 15:01:46.777 - INFO: XDG_DATA_DIRS = /usr/share 15:01:46.777 - INFO: XDG_RUNTIME_DIR = /run/user/0 15:01:46.777 - INFO: XDG_SESSION_ID = 174082 15:01:46.777 - INFO: XKEYSYMDB = /usr/X11R6/lib/X11/XKeysymDB 15:01:46.777 - INFO: XNLSPATH = /usr/share/X11/nls 15:01:46.777 - INFO: _ = ./hdblcm 15:01:46.777 - INFO: --------------------------------------------------------- 15:01:46.777 - INFO: END: Environment Dump 15:01:46.777 - INFO: --------------------------------------------------------- 15:01:46.777 - INFO: ----------------------------------------------------------- 15:01:46.777 - INFO: END: Installer Information 15:01:46.777 - INFO: ----------------------------------------------------------- 15:01:46.997 - INFO: Handler for signal INT 15:01:47.016 - INFO: SAP HANA Lifecycle Management - SAP HANA Database 2.00.011.00.1493936640 ************************************************************************ 15:01:47.016 - INFO: Start Date: 2018-03-19 - hdblcm 15:01:47.030 - INFO: 15:01:48.596 - INFO: Parameter 'action' (Action) is set by user, value = 'configure_sld' 15:01:48.596 - INFO: Parameter 'uninstall' (Uninstall) is not set 15:02:03.115 - ERR : Host name contains an invalid symbol; valid symbols are 0-9, a-z, A-Z, '.', '-'. 15:04:23.528 - INFO: User canceled hdblcm with Ctrl + c 15:04:23.528 - INFO: Registration in System Landscape Directory aborted.

Please suggest.

Thank You,

Pankaj

0

I just came across a known issue with the sldreg. There are issues with the proxy configuration.

Please refer to note: 2082466 - Known Issues in SAP HANA Platform Lifecycle Management (HDBLCM)

It appears this is fixed in 122.12 and 2.00.12

1
Pankaj Dadhich Apr 24 at 05:19 PM
0

Hi Jimmy,

You are correct. We already fixed it by upgrading the HANA to 2.00.24

Thank You!

Share
10 |10000 characters needed characters left characters exceeded