cancel
Showing results for 
Search instead for 
Did you mean: 

HANA View Modelling with SAP WEB IDE / SAP HANA Cloud Trial

LukeSybit
Participant

Dear community,

I´ve read through several blogposts to start with modelling of custom hana views using the WEB IDE on SAP HANA Cloud trail. Unfortunately I´ve got the attached error message. Can somebody tell me what I´ve done wrong? I tried several times with different trial accounts but I always got that particular error.

Meanwhile I contacted the launchpad support but the service agent only referred me to this community to deal with error messages in HANA cloud. I hope somebody can help.

error-message-web-ide.png

Thanks in advance,

Lukas

Accepted Solutions (0)

Answers (3)

Answers (3)

thomas_jung
Developer Advocate
Developer Advocate

Cannot connect to host might just mean that your HANA instance isn't running. Remember in the trial that it shuts down every night to save costs. You have to manually go in each day that you want to use it and restart the system.

LukeSybit
Participant
0 Kudos

Dear thomas.jung ,

protocoll-web-ide.txt

here you can find the protocoll of WEB IDE monitoring.

I also checked the allowed IP settings, by now it´s on "allow all ip".

Kind regards,

Lukas Wissing

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

This is either a different error or we are finally seeing all of it:

Could not connect to any host: [ a67a3c02-5d23-4d13-b46d-1ce6a21a8c79.hana.trial-eu10.hanacloud.ondemand.com:443 - certificate has expired ] [depId].11:51:40 (HDB) Error: Could not connect to any host: [ a67a3c02-5d23-4d13-b46d-1ce6a21a8c79.hana.trial-eu10.hanacloud.ondemand.com:443 - certificate has expired ]

The key here is:

certificate has expired

So your system is running and is reachable but has an expired SSL certificate. I can only suggest that you delete and recreate your HANA Cloud Instance.

LukeSybit
Participant
0 Kudos

Dear thomas.jung ,


I allready set up HANA trail for at least 3 times and always got a error message. Is there any other way to bring that instance into action?`

Thanks,

Lukas Wissing

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

There is a suggestion from a development colleague that you update the version of the @sap/hdi-deploy module in the package.json file as suggested in the log earlier:

Requested version of @sap/hdi-deploy is 3.7.0, found in package.json. 11:51:40 (HDB) You're not using the latest available version of @sap/hdi-deploy. You might want to consider upgrading to version 3.11.10.

LukeSybit
Participant
0 Kudos

Good morning thomas.jung ,


can you please tell me how I can update the package? I´m not familiar with hana cloud yet. Maybe we can arrange a Teams session to do that.

Thanks in advance.

Kind regards,

Lukas Wissing

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

There is a file named package.json in the /db folder. Just edit it like any other file. Change the version number requested for hdi-deploy packaged within this file.

LukeSybit
Participant
0 Kudos

Dear thomas.jung ,


today I updated the version number to 3.11.10 and after that I started to build the db folder again. First it looked good but a few seconds alter the same error occured. Please see the attachted files.error-log-after-upgrading-to-version-31110.txtpackage-json-update.png

Could you please take a look on it again?

Kind regards,

Lukas

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

>irst it looked good but a few seconds alter the same error occured.

Definitely not the same error. You are getting connected to HANA just fine now. You are deploying a large amount of artifacts. According to the error log you have a syntax errors in multiple development objects:

Error: com.sap.hana.di.table: Syntax error: "incorrect syntax near" [8250009] at "src/hdbtables/M_TIME_DIMENSION.hdbtable" (3:26) Error: com.sap.hana.di.tabletype: Syntax error: "incorrect syntax near" [8250009] at "src/sap/hana-app/cuan/custom_seg/PR_CE_CONTACT_ENGAGEMENT_SCORE_PERCENTILE_tabletype_var_out.hdbtabletype" (1:130) Precompiling "src/sap/hana-app/cuan/custom_seg/PR_MODEL_DEF_DESERIALIZE.hdbprocedure"... Error: com.sap.hana.di.tabletype: Syntax error: "incorrect syntax near" [8250009] at "src/sap/hana-app/cuan/custom_seg/PR_CE_LOCCOMPANY_NO_OF_ACTIVE_CONTACTS_tabletype_var_out.hdbtabletype" (1:127)

Error: com.sap.hana.di.tabletype: Syntax error: "incorrect syntax near" [8250009] at "src/sap/hana-app/cuan/custom_seg/PR_MODEL_DEF_DESERIALIZE_tabletype_ot_model_def.hdbtabletype" (1:119)

Error: com.sap.hana.di.tabletype: Syntax error: "incorrect syntax near" [8250009] at "src/sap/hana-app/cuan/custom_seg/PR_NAME_TO_STRING_tabletype_it_name.hdbtabletype" (1:108)

Error: com.sap.hana.di.tabletype: Syntax error: "incorrect syntax near" [8250009] at "src/sap/hana-app/cuan/custom_seg/PR_READ_MODEL_DEF_N_tabletype_ot_model_def.hdbtabletype" (1:112) Error: com.sap.hana.di.tabletype: Syntax error: "incorrect syntax near" [8250009] at "src/sap/hana-app/cuan/custom_seg/PR_READ_MODEL_DEF_N_tabletype_ot_model.hdbtabletype" (1:98)

There were many more errors but I stopped pulling them out of the log. According to the summary at the end of the log - 19 errors.

Error: Precompiling... failed [8212133] Error: Calculating dependencies... failed [8212108] Make failed (19 errors, 17 warnings): tried to deploy 477 files, undeploy 0 files, redeploy 0 dependent files Error: Making... failed [8211605] Error: Starting make in the container "MKT_METADATA_HDI_DB_1" with 477 files to deploy, 0 files to undeploy... failed [8214168]12:35:29 (HDB) Error: HDI make failed12:35:29 (HDB) (9s 741ms) 12:35:29 (HDB) Deployment failed with exit code: 1

LukeSybit
Participant
0 Kudos

Dear thomas.jung ,


ok I restarted the HANA instance but now and I´ve got the same error message in monitoring window.

Any other solution propositions? Thanks in advance,

Lukas Wissing

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

You only posted the very bottom of the log this 2nd time. Is it in fact the same cannot connect to any host error message you posted originally? Seeing more of the log would certainly be helpful. The part you posted just says there was an error but any of the details is higher up in the log.

If it is the same error and you confirmed that the HANA Cloud Trial instance is running, have you also checked the Allow IP settings on your instance.

https://www.youtube.com/watch?v=Lv_40d1ZtsM&t=185s