SAP HANA DB Connectivity Issue

[samanasa]

Statement throwing error from an .xsjs file is mentioned below

this.connection = $.hdb.getConnection();

Error Thrown
Connection failed (RTE:[300002] OpenSSL is not available: Unresolved symbol (<ip>:<portnumber> -> <cloud_instance_endpoint>))

Any Inputs on resolving this would be helpful

[showkath_naseem]

If you encounter the error message 'OpenSSL is not available: Unresolved symbol (xxxxxxx.hanacloud.ondemand.com:443)' during the deployment or connection to HANA, it is necessary to update the version of the HANA Cloud client in your project. Specifically, you should use a relatively recent HANA client version, such as 2.16.21 or a newer version.

Please ensure that you update all instances of the @sap/hana-client module that are potentially utilized in your project, whether directly or indirectly.

Source Code Changes :
In db/package.json

Try hana-client 2.16.21 or latest versions

"@sap/hdi-deploy": "^4.6.0",    
"@sap/hana-client": "^2.16.21"
"@sap/hdi": "^4.4.0", 

Afterwards, execute the command 'npm install' and ensure that you have downloaded the latest version into the 'node_modules' folder.

If you are utilizing 'hbd', make sure to update it to at least version '0.19.5'.

Additionally, ensure that you maintain the appropriate versions of 'cds' and 'node.js' in your 'package.json' file

For example . "@sap/cds": "^6.7.0",

"node": "^14.0.0 || ^16.0.0"

[chenghai_nie]

Thanks, it's fixed by updating @sap/hana-client to 2.16.21.

[breglerj]

This error typically happens when using an old HANA client (below version 2.12) on the new Cloud Foundry stack cflinuxfs4.

To solve this you'll have to update the HANA client and all libraries that include the HANA client (like the HDI deployer, hdbext, etc.) in your project to the latest version.

Best regards,

Jonathan

[chenghai_nie]

I also met this issue on stack cflinuxfs3 yesterday, the CAP app can't access hana cloud suddenly, throw same error

[Ratneshtoday1]

i am also facing same issue :

2023-06-20T09:45:43.56+0000 [APP/PROC/WEB/0] ERR [deploy|t0] - Error: Connection failed (RTE:[300002] OpenSSL is not available: Unresolved symbol

though my all libraries are up to date:

"@sap-cloud-sdk/http-client": "^3.1.1", "@sap/cds": "^6.8.1", "@sap/cds-mtxs": "^1.8.1", "@sap/cds-odata-v2-adapter-proxy": "^1.4.53", "@sap/hana-client": "^2.17.14", "@sap/hdbext": "^7.7.4", "@sap/xsenv": "^3.4.0", "@sap/xssec": "^3.2.17", "cfenv": "^1.2.4", "debug": "^4.3.4", "express": "^4", "generator-easy-ui5": "^3.3.0", "hdb": "^0.19.5", "passport": "^0.6.0", "request": "^2.88.2", "requires-port": "^1.0.0", "sap-hdbext-promisfied": "^2.202305.1"
ERROR : Deployment to container <id>failed - error: Connection failed (RTE:[300002] OpenSSL is not available: Unresolved symbol (<id>.hna0.prod-eu10.hanacloud.ondemand.com:443)) [Deployment ID: none].any suggestion ?RegardsRatnesh

[chenghai_nie]

I checked again, the CAP on BTP is run on stack cflinuxfs4.