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
Selecting the option “ Homogenous System Copy ( SAP HANA – Specific Backup/Recovery)
Entered the database <sid>adm user id and credentials
Next step encountered the error as below:
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:
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
As per SAP recommendations and implement the below steps:
- Port Issue:
- Following Help documentation should be helpful: Connections from Database Clients and Web Clients to SAP HANA
- Permission error
- Check SAP Note 2828626 – Web user interface hangs when validating the sidadm password from hdblcm
- 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.
-
- Validate the actual value for sapstartsrv process by command: /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function OSExecute “`which csh` -c limit” 0 0
verified the same in DB hosted server saphanaxxx
Actions followed:
Change the value for the <sid>adm user: vi /etc/security/limits.conf
Change 1048576 to 65536
Then ensure the values are changed by executing the below command:
Sapcontrol -nr 00 – function OSExecute “’which csh’ -c limit” 0 0
After setting the suggested values in limits.conf file we can proceed with the next steps in SWPM
to define the backup location
End of Document
