Tuesday 18 January 2022

Error during execution of HdbCmdClazz ’GET_DEFAULT_DATA_BACKUP_LOCATION’ – SAP Control validating error resolution doc during HANA Refresh via SWPM tool

Background

SAP Control validating error resolution doc during HANA Refresh via SWPM tool. This document is not necessarily having the strategy but also config information too some extent however content can be viewed and leveraged as appropriate. It gives an overview and resolution for sapcontrol validation issue using SWPM tool

Keywords: GET_DEFAULT_DATA_BACKUP_LOCATION, SAP HANA, SYSTEM REFRESH, SWPM Refresh, SAPCONTROL,

Landscape

To demonstrate this configuration, the below landscape is required

◉ SAP Systems: ECC 6 Ehp6

◉ HANA DB 2.00.037.02 (Hana2sps03)

◉ RedHat Enterprise Linux Server Release 7.4 (Maipo) 3.10.0-957.10.1.el7.x86_64

Tools & Requirements

◉ Putty – Mobaxterm or any putty software

◉ SWPM – SAPINST 749.0.75 Build: 1929755

Issue Description:

Below steps followed for Hana Refresh using SWPM -> Generic Options – SAP HANA Database – Refresh Database

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

Selecting the option “ Homogenous System Copy ( SAP HANA – Specific Backup/Recovery)

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

Entered  the database <sid>adm user id and credentials

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

Next step encountered the error as below:

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

Error Description:


Error during execution of HdbCmdClazz ’GET_DEFAULT_DATA_BACKUP_LOCATION’:class

com.sap.hdb.sl.lib.utils.cmd.clazz.CmdClazzParameterFactory.parameters.received.Start execution. Check HdbCmdOut.log and Hdb.Stdout.txt for further information. Sun Aug 15 13:18:37 IDT 2021 |

Com.sap.hdb.core.main.cmd.HdbCmdMain | Client received SOAP Fault from server: Invalid Credentials Please see the server log to find more detail regarding exact cause of the failure.

Possible Cause:


“Error validating SAP Control credentials” error when entering the SAP Control Credentials for <sidadm> in SAP HANA Cockpit 2.0 or HANA Studio.

Noticed port issue between the Cockpit and HANA Database. Ports used are 5xx13 and 5xx14 (SSL) which are for Instance Agent that starts/stops system/service using sapstartsrv. Permission error from sapstartsrv.log SAP Note 2828626 – Web user interface hangs when validating the sidadm password from hdblcm. It seems related with limit.descriptors=1048576.

OS User: <SID> adm is trying to connect to the SAPControl service and it is unable to connect due to some network issues and throwing the below error in SWPM

Note: But  login with <SID>adm password is possible in OS level, identified the authentication from OS to SAP level is having issues

Server Log:


SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

same has been found while we trying to stop the Hana DB from Hana Studio using <SID>adm user and password the command failed due to invalid credentials

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

As per SAP recommendations and  implement the below steps:

1. Port Issue:

i. Following Help documentation should be helpful: Connections from Database Clients and Web Clients to SAP HANA

2. Permission error

ii. Check SAP Note 2828626 – Web user interface hangs when validating the sidadm password from hdblcm

3. limit.descriptors=1048576

As <SID>adm user: ps -ef | grep sapstartsrv
As ROOT: strace -f -s 5000 -y -yy -o log.txt -p <processID>
In the log.txt search for “rlim_max”, which should come up with such a line:
>> 83663 prlimit64(0, RLIMIT_NOFILE, NULL, {rlim_cur=1024*1024, rlim_max=1024*1024}) = 0

SAP Start svc will iterate all file handlers to verify sidadm user credentials, and this 1024*1024 = 1048576 is too high for it to process, the check timeout and returns ‘500 Invalid Credentials’ error.

◉ The workaround is to lower the limit value to 65536, and restart sapstartsvc to make it take effect.

i. Validate the actual value for sapstartsrv process by command: /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function OSExecute “`which csh` -c limit” 0 0

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

verified the same in DB hosted server saphanaxxx

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

Actions  followed:

Change the value for the <sid>adm user: vi /etc/security/limits.conf

Change 1048576 to 65536

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

Then ensure the values are changed by executing the below command:

Sapcontrol -nr 00 – function OSExecute “’which csh’ -c limit” 0 0

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

After setting the suggested values in limits.conf file we can proceed with the next steps in SWPM

to define the backup location

SAP HANA Exam, SAP HANA Exam Prep, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Preparation

End of Document

No comments:

Post a Comment