[HDB] Build DB fails in Web IDE with Cloud Foundry

[MENGRI]

I have a trial account in Cloud Foundry. And I create SAP Cloud Platform Business Application with template. After I finish Creating a Business Service Using CDS, I want to build db. But it goes wrong with following message.

2:14:31 PM (HDB) .build.js,.serviceinfo.log,data-model.cds,node_modules,package-lock.json,package.json,src

2:14:31 PM (HDB) @sap/hdi-deploy, version 3.11.0 (mode default), server version unknown (0.0.0.0), node version 8.12.0, HDI version -1, container API version -1

2:14:31 PM (HDB) Detection of server version failed; root cause: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:23803))

2:14:31 PM (HDB) Detection of container API version failed; root cause: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:23803))
Detection of HDI version failed; root cause: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:23803))

2:14:31 PM (HDB) The server does not support live updating of make messages. The messages will be displayed, when the make is done.

I don't know what happens because I refer to Tutorial step by step.

[gregorw]

I've conducted a workshop last week and my participants faced the same issue. Only for me the deploy worked as intended.

[liat_b]

Hi Richard,

The problem should be resolved. Can you check?

Thanks,

Liat

[liat_b · Accepted solution]

Hi,

Thanks for reaching out. There's a known issue with deploy to HANA db on trial ( in general, not specifically in Web IDE). the issue is currently under investigation with the highest priority, and I hope it would resolve soon.

Sorry for any inconvenience,

Thanks,

Liat

[MENGRI · Accepted solution]

Hi Liat,

Thanks for your reply. Could you inform me immediately when this issue is fixed?

Regards,

Richard

[alfonsoarmenta · Accepted solution]

Hello, I'm facing the same issue in my java prototype:

Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:23803 [Cannot connect to host zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:23803 [Connection refused (Connection refused) (local port 56642 to address 0.0.0.0, remote port 23803 to address 18.196.126.43 (ec2-18-196-126-43.eu-central-1.compute.amazonaws.com))], -813.].

And I thought I was personally doing something wrong, coincidentally my trial was reset yesterday and upon recreation I received this error.

It would be good to be notified of an update here.

[liat_b · Accepted solution]

Hi,

I would update once the issue I'm aware of is resolved. However, since the scenario you describe is not exactly the same, I would recommend to also open a ticket. That way we can make sure the origin of the problem is the same.

Thanks,

Liat

[MENGRI · Accepted solution]

Hi Liat,

That's solved. Thanks.

Richard

[former_member286801 · Accepted solution]

Hi Liat,

I am facing the same issue when trying with nodejs.Could you please help me with the fix?

@sap/hdi-deploy, version 3.11.6 (mode default), server version unknown (0.0.0.0), node version 12.14.1, HDI version -1, container API version -1 Detection of server version failed; root cause: Connection failed (RTE:[89006] System call 'connect' failed, rc=61:Connection refused {18.196.126.43:27174} (zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:27174)) Detection of container API version failed; root cause: Connection failed (RTE:[89006] System call 'connect' failed, rc=61:Connection refused {18.196.126.43:27174} (zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:27174)) Detection of HDI version failed; root cause: Connection failed (RTE:[89006] System call 'connect' failed, rc=61:Connection refused {18.196.126.43:27174} (zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com:27174)) Using default environment variables from file "default-env.json" The server does not support live updating of make messages. The messages will be displayed, when the make is done.

With Regards,

Joseph.

[AlexandreFossat]

It still have problems of connectivity, with SAP Business Application Studio at least.

My HANA Cloud was configured with "Deny all IP adresses except from SAP Cloud Platform" and today on trial I've build a MTA application that fails on deploy exactly with this error.

Then I tried to delete my database and create a new one with "Allow all IP adressess" and it worked.

The fun fact is that last week I had this problem several times, but I didn't imagine that this was the problem, because I've created other projects that were deploying absolutely normal in the first database.

Apparently the conclusion is that the "Deny all IP adresses except from SAP Cloud Platform" options is still not working perfectly.

[former_member700118]

Its is correct.

I've this problem and modified this parameter in the "sap Hana cloud", follow the print bellow.

It worked!

[former_member269503]

on the hana trial , this worked when i edited the parameter of IP address

I've this problem and modified this parameter in the "sap Hana cloud", follow the print bellow.

(HDB) Detection of server version failed; root cause: Connection failed (RTE:[89008] System call 'connect' failed, rc=111:Connection refused (xxxxxxx.hana.trial-eu10.hanacloud.ondemand.com:443))

[jeff_albion]

Hello,

By default, HANA Service instances are IP whitelisted. Please see the help for additional details: https://help.sap.com/viewer/18956b5b1b004347b7c350f9378bd2e3/Cloud/en-US/f84dc89c648644a299df1990434...

Is the location you're using 'cds deploy' from allowed to connect to the HANA Service instance?

Is the HANA Service server running correctly according to the HANA cockpit details?

Thanks and best regards,

Jeff Albion

[rolandleung]

But, it's already Dec 1, 2020. And I am still getting the same error. I'll try "allowing all IPs" now to see if it resolves it.

[former_member245748]

I am also facing the same error. I have tried deploying with "allowing all IPs" which also failed.
Only difference is that I am using a non-trial account.

[Former Member]

unless corrected, i'm going to assume that Web IDE is not working in the trial accounts or at least it is not being supported even if it may sometimes display.

[liat_b]

meital.kalaf Could you please assist?