Connect to SQL Console and Database Explorer error: 'Cannot create SSL context'

[#1]

Using VMWare HANA Express.

When going from HANA Cockpit to SQL Console ....

Screen comes up but when the screen accesses HANA SYSTEM and Tenant databases I get the following error:

SQL Error: Connection failed (RTE:[300010] Cannot create SSL context: Error in api.SSL_CTX_set_default_pse_by_name - SSL error [4129]: Unknown error, General error: 0x00001021 | SAPCRYPTOLIB | SSL_CTX_set_default_pse_by_name SAPCRYPTO API error

The PSE file does not....<EOM>

I believe the ‘end of this message’ is ‘does not exit’ as it is truncated.

From the hxehost instance I see the following and it looks like I have the necessary pse files:

hxeadm@hxehost:/usr/sap/HXE/HDB90> xs domains

Getting domains...

name type org

--------------------------------

hxehost shared (default)

hxeadm@hxehost:/usr/sap/HXE/HDB90> sudo -s

hxehost:/hana/shared/HXE/HDB90 # find / -name *.pse

/usr/sap/hostctrl/exe/sec/SAPSSLS.pse

/hana/shared/HXE/HDB90/hxehost/sec/sap_system_pki_instance.pse

/hana/shared/HXE/HDB90/hxehost/sec/SAPSSLS.pse

/hana/shared/HXE/HDB90/hxehost/sec/SAPSSLC.pse

/hana/shared/HXE/HDB90/hxehost/sec/SAPSSLA.pse

/hana/shared/HXE/HDB90/hxehost/sec/saplogon.pse

/hana/shared/HXE/HDB90/hxehost/sec/sapsrv.pse

/hana/shared/HXE/xs/controller_data/controller/router/webdispatcher/sec/default.pse

/hana/shared/HXE/xs/controller_data/controller/router/webdispatcher/sec/internal_root.pse

hxehost:/hana/shared/HXE/HDB90 # find / -name sapgenpse

/usr/sap/hostctrl/exe/sapgenpse

/hana/shared/HXE/global/hdb/saphostagent_setup/sapgenpse

/hana/shared/HXE/exe/linuxx86_64/HDB_2.00.030.00.1522210459_bb2ff6b25b8eab5ab382c170a43dc95ae6ce298f/sapgenpse

hxehost:/hana/shared/HXE/HDB90 # cd /hana/shared/HXE/HDB90/hxehost/sec

hxehost:/hana/shared/HXE/HDB90/hxehost/sec # ll

total 28

-rw------- 1 hxeadm sapsys 1787 Apr 4 12:25 SAPSSLA.pse

-rw------- 1 hxeadm sapsys 1895 Apr 4 12:25 SAPSSLC.pse

-rw------- 1 hxeadm sapsys 1880 Apr 4 12:25 SAPSSLS.pse

-rw------- 1 hxeadm sapsys 3540 Apr 4 12:23 sap_system_pki_instance.p12

-rw------- 1 hxeadm sapsys 2231 Apr 4 12:23 sap_system_pki_instance.pse

-rw------- 1 hxeadm sapsys 1798 Apr 4 12:25 saplogon.pse

-rw------- 1 hxeadm sapsys 1979 Apr 4 12:25 sapsrv.pse

Interesting to note that the config files reference another pse file “sapsrv_internal” which I do not have (as seen in DBA Cockpit global.ini file.

Appreciate any help out there as I am at a standstill. Everything is working except for this.

JWJ

[Vitaliy-R]

Could not replicate in my HXE, but may be you should try to upgrade your version? The new HXE 2.0 Rev 31 just became available.