CAP: cds deploy to hana: HDI Deployment failed

[todd_fisher]

Hello,

I am deploying my CAP to a trial hana cloud instance. Following the CAP Java Tutorial for the bookstore.

1. npm install --save-dev --save-exact @sap/hdi-deploy@3.7.0

2. cds deploy --to hana:bookstore-hana

bookstore-hana is created fine, but hdi creation fails:

"Deployment to container E4054C6FDA834469A673B93C4C488B5C failed - error: Could not connect to any host: [ 879d15b4-b970-4f2c-a644-158acee78b34.hana.trial-eu10.hanacloud.ondemand.com:443 - Client network socket disconnected before secure TLS connection was established ] [Deployment ID: none].

Error: Could not connect to any host: [ 879d15b4-b970-4f2c-a644-158acee78b34.hana.trial-eu10.hanacloud.ondemand.com:443 - Client network socket disconnected before secure TLS connection was established ]"

Thank you.

The entire output of the deploy:

*----------------------------------------------------------------------------------------------*

user: bookstore $ cds deploy --to hana:bookstore-hana

[cds.deploy] - Starting deploy to SAP HANA ...

[cds.deploy] - Creating build tasks

[cds.deploy] - Running build

[cds.deploy] - Running 'cf marketplace -s hana' with options {}

Getting service plan information for service hana as todd.fisher@sap.com...

OK

service plan description free or paid

hdi-shared HDI container on a HANA database free

sbss User with permissions to use SBSS free

schema Schema on a HANA database free

securestore User with permissions to use secure store free

[cds.deploy] - Using container bookstore-hana

[cds.deploy] - Running 'cf create-service hana hdi-shared bookstore-hana' with options {}

Creating service instance bookstore-hana in org 20cfa8b2trial / space dev as todd.fisher@sap.com...

OK

Create in progress. Use 'cf services' or 'cf service bookstore-hana' to check operation status.

..........

Showing info of service bookstore-hana in org 20cfa8b2trial / space dev as todd.fisher@sap.com...

name: bookstore-hana

service: hana

tags:

plan: hdi-shared

description: Manage schemas and HDI containers on an existing SAP HANA database.

documentation: https://help.sap.com/viewer/a36ee1aa073e4e8e840573fb30a72d95/Cloud/en-US/1e9a6cb47e1b44f990a917b4bf8...

dashboard:

service broker: sm-hana-broker-6ee33e0e-bc5a-4a6b-8715-5a697a76b655

Showing status of last operation from service bookstore-hana...

status: create succeeded

message:

started: 2020-08-12T16:50:41Z

updated: 2020-08-12T16:51:42Z

There are no bound apps for this service.

Upgrades are not supported by this broker.

[cds.deploy] - Running 'cf create-service-key bookstore-hana bookstore-hana-key -c {"permissions":"development"}' with options {}

Creating service key bookstore-hana-key for service instance bookstore-hana as todd.fisher@sap.com...

OK

[cds.deploy] - Writing /home/user/projects/bookstore/db/default-env.json

[cds.deploy] - Error while calling git: Error: spawn git ENOENT

[cds.deploy] - Error while calling git: Error: spawn git ENOENT

[cds.deploy] - Writing /home/user/projects/bookstore/default-env.json

[cds.deploy] - Writing /home/user/projects/bookstore/package.json

[cds.deploy] - Deploying to HANA from /home/user/projects/bookstore/db

[cds.deploy] - Using HDI deployer from /home/user/projects/bookstore/node_modules/@sap/hdi-deploy/library.js

@sap/hdi-deploy, version 3.7.0 (mode default), server version unknown (0.0.0.0), node version 10.20.1

Detection of server version failed; root cause: Could not connect to any host: [ 879d15b4-b970-4f2c-a644-158acee78b34.hana.trial-eu10.hanacloud.ondemand.com:443 - Client network socket disconnected before secure TLS connection was established ]

Using default environment variables from file "default-env.json"

No ignore file at /home/user/projects/bookstore/db/.hdiignore.

Collecting files...

Collecting files... ok (0s 2ms)

3 directories collected

56 files collected

0 reusable modules collected

Target service: bookstore-hana

Processing grants files...

Processing grants files... ok (0s 0ms)

Preprocessing files...

Preprocessing files... ok (0s 3ms)

Connecting to the container "E4054C6FDA834469A673B93C4C488B5C"...

Deployment to container E4054C6FDA834469A673B93C4C488B5C failed - error: Could not connect to any host: [ 879d15b4-b970-4f2c-a644-158acee78b34.hana.trial-eu10.hanacloud.ondemand.com:443 - Client network socket disconnected before secure TLS connection was established ] [Deployment ID: none].

Error: Could not connect to any host: [ 879d15b4-b970-4f2c-a644-158acee78b34.hana.trial-eu10.hanacloud.ondemand.com:443 - Client network socket disconnected before secure TLS connection was established ]

(0s 126ms)

[ERROR] [cds.deploy] - HDI deployment failed with exit code 1

at hdiDeployLib.deploy (/home/user/projects/bookstore/node_modules/@sap/cds/bin/deploy/to-hana/hdiDeployUtil.js:92:35)

at ChildProcess.<anonymous> (/home/user/projects/bookstore/node_modules/@sap/hdi-deploy/library.js:68:14)

at ChildProcess.emit (events.js:198:13)

at maybeClose (internal/child_process.js:982:16)

at Socket.stream.socket.on (internal/child_process.js:389:11)

at Socket.emit (events.js:198:13)

at Pipe._handle.close (net.js:607:12)

[former_member643578]

Could you please give me one clarification are you doing with Visual Studio Code or Business Application Studio?

[maxstreifeneder]

Could you please double-check if the SAP HANA Cloud instance is not in state stopped? The SAP HANA Cloud instance is automatically stopped after a while in SAP Cloud Platform Trial. My second guess is that you haven't properly whitelisted IPs while creating the SAP HANA Cloud instance.

[former_member554851]

Thanks for answering. Definitely the problem is not because of the HANA instance, since I always verify that it is not stopped.

I will try the second assumption. Having a CAP Application, what is the IP or URL that I should add to the whitelist? Since the problem is the connection between the HANA instance and SAP Business Application due to the Socket issue.

I have tried to establish a Tunneling from the SAP Business Application terminal without being successful, using the indications of the following Post: https://blogs.sap.com/2020/07/01/how-to-tunnel-business-application-studio -sqltools-to-shared-hana-cloud-service-instance/

Additionally I have added an SSL certificate in case this was the problem, which they recommend in the following post: https://blogs.sap.com/2020/06/26/connect-hana-cloud-service-instance-with -sap-business-application-studio /

Actually no option has connected me correctly with a HANA HDI instance in SAP Cloud Foundry. Even try changing the versions "@ sap / hdi-deploy": "3.7.0" to "@ sap / hdi-deploy": "3.11.11"

Stay tuned if you have any feedback.

Thank you.

[former_member554851]

I have the same problem, help please

[former_member554851]

Basically the problem is that the connection to the database cannot be established for some reason. It may be a Trial problem. I'll keep trying

[former_member554851]

I have reported this bug on the official Github site, to wait for a forceful response to the problem. We will be very attentive: https://github.com/SAPDocuments/Tutorials/issues/5704

[christian_paulus]

@sap/hdi-deploy, version 3.7.0 is not working with HANA Cloud instances at all. Please use the latest HDI deployer version (3.11.x) and update us here with the error message in case there is still an issue.

Best regards,

Christian Paulus

[jungwoo_han]

Yes correct. I've tried 3.11.15 version and it worked. thanks.

[srimukhakarantha_babukodi]

version 3.11.11 worked for me and I had to make few config changes in package.json : https://answers.sap.com/questions/13048899/error-could-not-find-the-comsaphanadicds-build-plu.html

[former_member643578]

Hello santiago,

https://answers.sap.com/questions/13064561/cap-local-deploy-to-hana-error-connection-failed-r.html

check this once..

It maybe helpful to you.

[todd_fisher]

Hello - I looked at the post and understand the concept, but when I use "cds deploy --to hana:bookstore-hana --vcap-file ./default-env.json" it does not recognize the --vcap-file addition. I am most likely missing something to enable this, but I really do not want to mess with it as it appears to be a bug where the wrong credentials are being pulled.

[former_member554851]

Hello vasundhara lella

I have tried to try what you recommend, but in this case it is not the same error. Thank you very much for sharing, we will continue looking for what the problem may be. 🙂

[sergeywp92]

Had the same. The problem with allowing connections to IPs in HANA instance.
Go to the Hana Instance Tools, press Manage Configurations, go to Connections and select "Allow all IP addresses".
This helped me to 

[former_member2284]

Hello @todd fisher

If you are using a trial account then go to your cockpit and check if you are having multiple instances created. Go to service instances and delete all the instances then go back to your SAP Business Application studio and run cds deploy --to hana command

let me know if it works 🙂

Thanks and regards,

Gargi Deshpande

gargi.deshpande@sap.com