xsengine not started not able to restart

[slim_trabelsi]

Hi,

Since few days I observed that in my HANA system the xsengine service was down.

Even after restarting the whole system the xsengine remains down .. when I wright click on the service as you can see, I don't have the option start.

Any hint ?

[former_member182832 · Accepted solution]

Hi Slim,

From the command line (OS level) please authenticate with <SID>adm user and try to start the xsenginee manually (execute the command : hdbxsengine). If it fails to start it will show a short error message. Also please share the dump file.

Regards,

Mehdi.

[slim_trabelsi · Accepted solution]

Hi Mehdi,

When I executed the command in adm mode this is the error:

root@mo-0f5ffe310:/usr/sap/SVM/SYS/exe/hdb # ./hdbxsengine

./hdbxsengine: error while loading shared libraries: libxsengine.so: cannot open shared object file: No such file or directory

Thanks

Cheers

Slim

[former_member182832 · Accepted solution]

Hi Slim

Please setup the SECUDIR environment variable (SECUDIR=/usr/sap/<SID>/HDB00/<hostname folder>/sec)

After you can run the command sapgenpse. It will show you information about your environment and if the variable SECUDIR is correctly configured.

Regards,

Mehdi.

[slim_trabelsi · Accepted solution]

Done:

USER="svmadm"

  Environment variable $SECUDIR is defined:

  "/usr/sap/SVM/HDB00/sec"

knwowing the the sec folder is empty .. on the hana security guide it is written that SECUDIR should contain sapsrv.pse

cheers

Slim

[former_member182832 · Accepted solution]

The sec folder should be under /usr/sapSVM/HDB/<hostname>/sec (not "/usr/sap/SVM/HDB/sec")

Please can you run the command sapgenpse (with svmadm user) and share the result ?

If you are unable to run properly this command please install  properly your security libraries (Commons cryptolib...). 

Thank you,

Mehdi

[slim_trabelsi · Accepted solution]

tanks you for your patience

  Loaded CommonCryptoLib from sapgenpse folder

  "/usr/sap/SVM/exe/linuxx86_64/HDB_1.00.095.00.1429086950_2037389/libsapcrypto.so"

  Platform:   linux-gcc-4.3-x86-64   (linux-gcc-4.3-x86-64)

  Versions:   SAPGENPSE     8.4.35 (Mar 16 2015)

              FILE-Version  8.4.35.0

              CommonCryptoLib (SAPCRYPTOLIB) Version 8.4.35 pl40 (Mar 16 2015) MT-safe

  USER="svmadm"

  Environment variable $SECUDIR is defined:

  "/usr/sap/SVM/HDB00/mo-0f5ffe310/sec"

[former_member182832 · Accepted solution]

Great

Now please check if your pse's exist in folder "/usr/sap/SVM/HDB/mo-fff310/sec"

If they exist, please try to Stop/Start hana ("./HDB stop" and  "./HDB start")

If xsengine still not running please go to your hana studio  go to administration screen > Diagnosis files > xsengine_mo-fff310-3007.trc

In the same list of files check if there are dump or alert files (xsengine_alert.trc) and please attach them so we can look directly in traces.

you can also get these trace files from os level under /usr/sap/SVM/HDB/mo-ff310/trace/

Regards,

Mehdi

[slim_trabelsi · Accepted solution]

I had a timeout during the start command:

➜  HDB00 ./HDB start

StartService

Impromptu CCC initialization by 'rscpCInit'.

  See SAP note 1266393.

OK

OK

Starting instance using: /usr/sap/SVM/SYS/exe/hdb/sapcontrol -prot NI_HTTP -nr 00 -function StartWait 2700 2

20.09.2016 12:49:05

Start

OK

20.09.2016 13:34:06

StartWait

FAIL: Timeout

in the log for the xsengine_alert.trc I got this:

[64546]{-1}[-1/-1] 2016-09-20 07:26:25.039774 e Crypto           CommonCryptoLib.cpp(00249) : SECUDIR unknown

now it is no more unknown ..

Ihave to discover why I got the timeout