HXE Server + Apps on Docker not able to start container

[Phillip_P]

Hi,

Trying to get HXE server + apps working on docker as per the following

https://www.sap.com/uk/developer/tutorials/hxe-ua-install-using-docker-xsa.html

The container doesnt start, the following error:

FAIL: process hdbxsexecagent HDB XS Execution Agent not running

The first possible error I notice is:

nameserver hxehost:39001 not responding

Anyone managed to get this container working on Docker? the Server only version works but not the Server + Apps version.

[Former Member]

Hi everybody,

trying to start SAP HANA Express with Docker I also encounter the reported bug and hope somebody can help me:

• nameserver hxehost:39001 not responding
• FAIL: process hdbnameserver HDB Nameserver not running.

Any tipps are much appreciated! 🙂

Besh wishes,

Tobi

My Environment:

System: Windows 10

Docker: Community Edition Version 18.06.0-ce-win72 (19098)

Procedure:

docker pull store/saplabs/hanaexpressxsa:2.00.031.00.20180712.1

docker run -ti --privileged centos sysctl fs.file-max=20000000

docker run -ti --privileged centos sysctl fs.aio-max-nr=262144

docker run -ti --privileged centos sysctl kernel.shmmax=1073741824

docker run -ti --privileged centos sysctl kernel.shmmni=524288

docker run -ti --privileged centos sysctl kernel.shmall=8388608

docker run -ti --privileged centos sysctl vm.max_map_count=135217728

all above respond fine.

docker run

-p 39013:39013

-p 39015:39015

-p 39041-39045:39041-39045

-p 1128-1129:1128-1129

-p 59013-59014:59013-59014

-p 39030-39033:39030-39033

-p 51000-51060:51000-51060

-p 53075:53075

-h hxehost

-v c:/Users/braeut_t:/hana/mounts

--ulimit nofile=1048576:1048576

--sysctl kernel.shmmax=1073741824

--sysctl net.ipv4.ip_local_port_range="60000 65535"

--sysctl kernel.shmmni=524288

--sysctl kernel.shmall=8388608

--name express_edition3

store/saplabs/hanaexpressxsa:2.00.031.00.20180712.1

--agree-to-sap-license

--passwords-url file:///hana/mounts/hanapw.json

--proxy-host <MY_HOST>

--proxy-port <MY_PORT>

Result

======== Starting HANA container run script ========

Started at: Fri Aug 10 11:38:38 UTC 2018

Script parameters: --agree-to-sap-license --passwords-url file:///hana/mounts/hanapw.json --proxy-host

HANA version: 2.00.031.00.1528768600

Linux kernel version: 4.9

Processing hooks in folder /hana/hooks/system_check ...

Hook candidates:

/hana/hooks/system_check/100_hxe_check_system_prerequisites

Executing hook /hana/hooks/system_check/100_hxe_check_system_prerequisites ...

Checking /proc/sys prerequisites ...

ok: /proc/sys/kernel/shmmax: 1073741824>=1073741824

ok: /proc/sys/kernel/shmmni: 524288>=4096

ok: /proc/sys/kernel/shmall: 8388608>=8388608

ok: /proc/sys/fs/file-max: 20000000>=20000000

ok: /proc/sys/fs/aio-max-nr: 262144>=131072

WARNING: Unable to access /proc/sys/vm/memory_failure_early_kill (skipping check)

ok: /proc/sys/vm/max_map_count: 135217728>=2048576

ok: /proc/sys/net/ipv4/ip_local_port_range: 60000>=40000

Check succeeded: /proc/sys prerequisites

Checking limits ...

ok: max number of open file descriptors (ulimit -n): 1048576>=1048576

Check succeeded: limits

Execution of hook /hana/hooks/system_check/100_hxe_check_system_prerequisites finished (exit code 0)

Finished execution of hooks in folder /hana/hooks/system_check

Checking version compatibility ...

Downloading password file from file:///hana/mounts/hanapw.json ...

% Total% Received % XferdAverage SpeedTimeTimeTimeCurrent

DloadUploadTotalSpentLeftSpeed

100401004000199900 --:--:-- --:--:-- --:--:-- 19990

Deleting local password file: /hana/mounts/hanapw.json

Entering pre start initialization phase ...

Creating consistency check files ...

Processing hooks in folder /hana/hooks/pre_start_init ...

Hook candidates:

/hana/hooks/pre_start_init/010_license_agreement

/hana/hooks/pre_start_init/010_license_agreement.json (ignored, not an executable regular file)

Hook /hana/hooks/pre_start_init/010_license_agreement requires parameters: AGREE_TO_SAP_LICENSE

Executing hook /hana/hooks/pre_start_init/010_license_agreement ...

License agreement check succeeded (AGREE_TO_SAP_LICENSE=true)

Execution of hook /hana/hooks/pre_start_init/010_license_agreement finished (exit code 0)

Finished execution of hooks in folder /hana/hooks/pre_start_init

Entering pre start phase ...

Processing hooks in folder /hana/hooks/pre_start ...

Hook candidates:

(no executable files detected)

Finished execution of hooks in folder /hana/hooks/pre_start

Change hardware key...

nameserver hxehost:39001 not responding.

Opening persistence ...

run as transaction master

converting topology from cloned instance...

- keeping instance 90

- keeping host hxehost

done.

Finished pre start sequence

Starting up HANA server...

Impromptu CCC initialization by 'rscpCInit'.

See SAP note 1266393.

StartService

OK

OK

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

StartWait
FAIL: process hdbdaemon HDB Daemon not running

[lcasavola · Accepted solution]

Hi guys,I worked out the issue,

I removed the container and restarted it with the added option "--dont-exit-on-error".

In this way I have had time to inspect the system and looked around the step process and finally discovered that the stager command ( actually a java program) wrote other log informations under /hana/shared/HXE/xs/controller_data/controller/tracing/log

In the file controller_0.log I found the useful indications ( a java exception):

[2018-06-26 20:44:39:467]-[Controller.Admin]-[error]-[controller]-[startup]: Could not startup the controller components: /hana/shared/HXE/xs/app_working/stager

java.nio.file.DirectoryNotEmptyException: /hana/shared/HXE/xs/app_working/stager

at sun.nio.fs.UnixCopyFile.move(UnixCopyFile.java:500)

at sun.nio.fs.UnixFileSystemProvider.move(UnixFileSystemProvider.java:262)

at java.nio.file.Files.move(Files.java:1395)

at com.sap.xs2rt.server.impl.fileaccess.FileAccessBasic.move(FileAccessBasic.java:238)

at com.sap.xs2rt.controller.impl.staging.StagerImpl.reliablyMove(StagerImpl.java:1841)

at com.sap.xs2rt.controller.impl.staging.StagerImpl.<init>(StagerImpl.java:542)

at com.sap.xs2rt.controller.staging.StagerFactory.createSynchronized(StagerFactory.java:59)

at com.sap.xs2rt.controller.impl.ControllerImpl.startUpInternal(ControllerImpl.java:1288)

at com.sap.xs2rt.controller.impl.ControllerImpl.startUp(ControllerImpl.java:789)

at com.sap.xs2rt.controller.impl.ControllerConsole.main(ControllerConsole.java:723)

Hence, the folder /hana/shared/HXE/xs/app_working/stager is not empty. Probably it has created in docker image and the setup process fails because he wants it empty.

In my case I solved the problem just removing such folder and restart all

I don't know exaclty how to restart hana express, in my case I used the command

sapcontrol RestartSystem ALL

Now by accessig the web page https://hxehost:39030/ I get the system is up and running.

Unfortunately I have now another problem, I cannot autenticate to the system, the password provided with the json file seems not to be imported and I don't know which other password to use:

hxeadm@hxehost:/usr/sap/HXE/HDB90/hxehost/trace> hdbsql -i 90 -u SYSTEM -d SYSTEMDB
Password:
* 10: authentication failed SQLSTATE: 28000

Is there a way to reset the password or just provide a default one ?

For example I found onhanaexpress docker 's entrypoint shell ( /run_hana ) a reference to HXEHana1 ( declare system_password=HXEHana1 )

but unfortunateli it doesn't work.

Please Help!

[lcasavola · Accepted solution]

Hi again, I have un update,

acctually HXEHana1 works, after connecting the system asks to enter a new password.

[Phillip_P · Accepted solution]

Thanks for the update Luca, this worked for me too on Fedora Server 28.