on 11-20-2020 2:56 PM
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.
Thanks in advance,
Lukas
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear thomas.jung ,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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
>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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.