Hana Server is not responding to web requests - Msg "FAIL: process hdbstatisticsserver HDB Statisticsserver not running" on startup

[FabioPagoti]

Hi all,

I have a HANA SP06 instance on a Cloudshare instance. I tried to enable HTTPS on it according to the blog but I definitely did something wrong with the files sapgenpse and libsapcrypto.so. and in the end I used some wrong files instead.

After running the script "setUpSapCryptoSelfSigned.sh" mentioned in the blog more than once my instance is not responding to web requests at all (not even HTTP ones).

It could see that the script does change some stuff on "sapwebdisp.pfl" file and after realising that I erased some configuration by hand. Here is the current content of the file.

# Profile generated by sapwebdisp bootstrap
# unique instance number
SAPSYSTEM = 00
SAPSYSTEMNAME = HDB
_HTTP_PORT = 80$(SAPSYSTEM)
_HTTPS_PORT = 43$(SAPSYSTEM)
_LOCAL_HOST_NAME = hanacloud
# add default directory settings
DIR_EXECUTABLE = exe
DIR_INSTANCE = $(_LOCAL_HOST_NAME)
icm/security_log = LOGFILE=$(DIR_INSTANCE)/trace/dev_icm_sec,MAXSIZEKB=500
# Accessibility of Message Servers
rdisp/mshost =
ms/http_port =
# SAP Web Dispatcher Parameter
wdisp/auto_refresh = 25
wdisp/max_servers = 100
wdisp/shm_attach_mode = 6
# configuration for default scenario (medium size)
icm/max_conn = 500
icm/max_sockets = 1024
icm/req_queue_len = 500
icm/min_threads = 10
icm/max_threads = 100
mpi/total_size_MB = 80
#maximum number of concurrent connections to one server
wdisp/HTTP/max_pooled_con = 200
wdisp/HTTP/min_pooled_con = 0
wdisp/HTTPS/max_pooled_con = 200
wdisp/HTTPS/min_pooled_con = 0
wdisp/HTTP/use_pool_for_new_conn = 1
# SAP Web Dispatcher Ports
icm/server_port_0 = PROT=HTTP,PORT=$(_HTTP_PORT),PROCTIMEOUT=600
icm/server_port_1 = PROT=HTTPS,PORT=$(_HTTPS_PORT),PROCTIMEOUT=600
icm/server_port_2 = PORT=0, PROT=WEBSOCKET, TIMEOUT=-1
icm/server_port_3 = PORT=0, PROT=WEBSOCKETS, TIMEOUT=-1
# SAP Web Dispatcher Web Administration
icm/HTTP/admin_0 = PREFIX=/sap/wdisp/admin,DOCROOT=$(DIR_INSTANCE)/wdisp/admin,AUTHFILE=$(DIR_INSTANCE)/wdisp/icmauth.txt
icm/HTTP/hdb_0=TRUE
wdisp/add_client_protocol_header = 1
wdisp/system_0 = SID=$(SAPSYSTEMNAME), EXTSRV=http://localhost:3$(SAPSYSTEM)08, SRCURL=/
#icm/sleep_after_startup = 1
#icm/HTTP/server_cache_0 = PREFIX=/, CACHEDIR=$(DIR_INSTANCE)/wdisp/cache
#pagoti - add from http://scnap.com/hread/3657393
#wdisp/shm_attach_mode = 6
#wdisp/ssl_encrypt = 0
#wdisp/add_client_protocol_header = true
#ssl/ssl_lib = usr/sap/HDB/SYS/global/security/lib/libsacrypto.so
#ssl/server_pse = /usr/sap/HDB/HDB00/hanacloud/sec/SAPSSL.pse
#icm/HTTPS/verify_client= 0
#icm/server_port_1 = PROT=HTTPS,PRT+(-HTTPS_PORT),PROCTIMEOUT=600

Now, If I use command "su hdbadm ./HDB start" on /usr/sap/HDB/HDB00 I get the following error message:

hanacloud:/usr/sap/HDB/HDB00 # su hdbadm ./HDB start

StartService
Impromptu CCC initialization by 'rscpCInit'.
See SAP note 1266393.
OK
OK
Starting instance using: /usr/sap/HDB/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 00 -function StartWait 2700 2

19.01.2015 08:29:16
Start
OK

19.01.2015 08:29:26
StartWait
FAIL: process hdbstatisticsserver HDB Statisticsserver not running
hanacloud:/usr/sap/HDB/HDB00 #

On the browser, If I try to access XS engine root page I get a "This webpage is not available error". It seems that Hana is not responding web requests. I have no clue what is going on and I already gave up of trying to set SSL on my instance. I just want HTTP back if possible.

Could somebody please help me?

1 - Is my "sapwebdisp.pfl" file correct?

2 - How can I turn on the Statisticsserver?

Thanks!

[former_member191717 · Accepted solution]

Have a look at

http://scn.sap.com/thread/3752798

[FabioPagoti · Accepted solution]

Sorry but I solved the issue above just deleting the instance and giving up of using SP 6.

[former_member191717 · Accepted solution]

Great, thanks for sharing