HDB daemon does not start after a unclean stop/shutdown of services

-

Problem: HDB daemon does not start after a unclean stop/shutdown of services and the daemon status file still has the old value

Solution: 

Command:

HDB stop ( give a try )

if not

HDB kill-9 ( not recommended for production systems )

sapcontrol -nr <> -function StopService

sapcontrol -nr <> -function StartService <SID>

HDB start

This should give a  clean restart of the services.

Comments

Post a Comment

Popular posts from this blog

FAIL: NIECONN_REFUSED (Connection refused), NiRawConnect failed in plugin_fopen()

-
Problem: HDB start command will issue the error "FAIL: NIECONN_REFUSED (Connection refused), NiRawConnect failed in plugin_fopen()" Scenario: Command 'HDB start' failed with below error:FAIL: NIECONN_REFUSED (Connection refused), NiRawConnect failed in plugin_fopen() sapcontrol commands also failed with error 'FAIL: NIECONN_REFUSED (Connection refused)' service sapstartsrv was not running, checked by command 'ps -ef | grep sapstartsrv' From OS log file /var/log/messages, find error occurred during HANA startup Cause: Permission error Troubleshooting: From the /var/log/messages, the following error was found "Unable to change to Directory /usr/sap/SID/HDBXX/hostname/trace Resolution: The instance profile may be damaged by the unexpected or mistaken shutdown. The SAPLOCALHOST parameter was pointing to wrong hostname due to which the sapstartsrv agent was not able to find/write the log files under the respective hana trace directory. After...
Read more

Exploring SAP Program RS_ABAP_SOURCE_SCAN and Its Usage

-
Image
SAP program RS_ABAP_SOURCE_SCAN is a powerful tool designed for advanced search functionality within ABAP source codes. This utility is especially useful for developers and system administrators who need to locate specific pieces of code, identify usages of particular statements or functions, and perform complex code analysis across the entire SAP system. Here’s an overview of its key features and practical applications. Key Features Comprehensive Search Capabilities:  Keyword Search : RS_ABAP_SOURCE_SCAN allows you to search for specific keywords or strings within ABAP programs. This can include function modules, methods, classes, and more. Example of How It Helped In a recent project, we were faced with the task of locating a hardcoded value within our ABAP codebase. This hardcoded value was causing issues, and we needed to identify all instances of it quickly to make the necessary adjustments. Using the RS_ABAP_SOURCE_SCAN program, we were able to scan all the programs and effi...
Read more

XS/Cockpit URLs SSL certificates are not updated after HANA DB SSL Certificate renewal

-
Problem:  XS URLs  SSL certificates are not updated after HANA DB SSL Certificate renewal Cause:  AP HANA 2.0 Cockpit is based on  SAP HANA XS Advanced (XSA)  which handles certificates a bit different than the former XS classic implementation. The XSA SSL certification is sometimes overwritten with a new installation/update. Solution: You need to bundle the certificate chain and import it to the XSA cert path. Export certificates for XSA sapgenpse export_p12 -p cockpithttps.pse -C 0 cockpithttps.p12 Export private key, certificate and CA chain & combine certificate and CA chain into 1 file. openssl pkcs12 -in cockpithttps.p12 -nocerts -nodes | sed -ne '/-BEGIN PRIVATE KEY-/,/-END PRIVATE KEY-/p' > privatekey.key openssl pkcs12 -in cockpithttps.p12 -clcerts -nokeys | sed -ne '/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p' > certificate.pem openssl pkcs12 -in cockpithttps.p12 -cacerts -nokeys | sed -ne '/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p' > cach...
Read more