🔵 Hybrid development on SAP HANA Cloud and SAP HANA using SAP Business Application Studio

mvinci · ‎2023 Sep 21

Brilliant - Very useful thanks

Cocquerel · ‎2023 Sep 21

The xs command tool provide information for all XSA end points (XS Controller, XSUAA, XS Deployer, XS HRTT Service, XS HANA Cockp) . I was able to create the related destinations in BTP and they are working fine.

My issue is only for the "SAP HANA Database" destination. there is no XSA end point provided by xs command for this destination. The documentation only provide information on how to get the SQL port but nothing related to the URL that should be set for this destination. Could you please clarify ?

breglerj · ‎2023 Sep 21

You can find the connection details to your SAP HANA database via the command "xs tenant-databases". This outputs information like this:

$> xs tenant-databases

Getting tenant databases as XSA_ADMIN...

name   XSA   status   master host   sql-port   mappings
---------------------------------------------------------------------
WI6    yes   active   myhost        30615      <default>, orgname:SAP

The required information can be found in the "master host" and "sql-port" columns. In this example the database URL to configure in the destination would be "http://myhost:30615".

Cocquerel · ‎2023 Sep 21

The deployment of hdi container to hana on-premise is successfull but it failed to connect via jdbc with the following error
Error: Connection failed (RTE:[89133] Proxy server connect: Network unreachable (127.0.0.1:41924 -> <myhost>:36615)
I do not see any trace of this connection attempt in Cloud Connector log.
Looking at the .env file, I'm surprised not to see the location ID of the Cloud Connector that I have specified in the database destination.

L

Cocquerel · ‎2023 Sep 21

I have tried to set the location ID to blank at SAP Cloud Connector level. I have no more jdbc error but I get the following error in BAS in the DB Explorer view when trying to make appear the list of XSA Connection
"Advanced connection list: failed to update request header for header key authorization: Cannot get the XS token.: Cannot get the XS token.: CF/XS CLI error (3001): Cannot get the XS token: Cannot get the XS token:; Please check the SAP HANA XS Advanced Endpoint in the settings."
Note that deployment is working fine and I can see my hdi service in the XSA target view from BAS

Cocquerel · ‎2023 Sep 21

Note that, in my case, Hana Cockpit is running on an other instance than the one I deployed the hdi container. So, the controler end point for HANA Cockpit destination is different from the other destinations. Could it be the raison of the XS token error ?

Cocquerel · ‎2023 Sep 24

Looking at hrtt-service log on XSA side, I can see the following http 500 error:

(9223372036854775776)[1695561608033] [APP/34-1] SYS #2.0#2023 09 24 15:20:08:032#+02:00#INFO#/Security##XSAC_HRTT###2867e140-9cf9-4679-a827-54d3b1a8e4db##########2867e140-9cf9-4679-a827-54d3b1a8e4db#PLAIN##location=/hana/shared/DHL/xs/app_working/tosap018/executionroot/08459e70-a5dd-4852-ad99-0d3ef6e60807/app/lib/component/audit/Audit.js;functionType=legacy;function=info;message="Request Authorized - URL: /sap/hana/cst/api/v2/objects(%27:%27)/tree()?freshen=true&sqltraceDir=false&hdlContainers=false&schedulerJobs=true&_=1695561607702; Scopes: undefined; User: TO23455; IP: ::ffff:127.0.0.1; X-Forwarded-For: ::ffff:127.0.0.1,44.55.109.44"#
(9223372036854775777)[1695561608034] [RTR] OUT 44.55.109.44 - - to airbus-sap-hrtt-service.dhlhvie0.eu.airbus.corp:36633 "GET /sap/hana/cst/api/v2/objects(':')/tree() HTTP/1.1" 500 sent 401 in 5 by 006-08459e70-a5dd-4852-ad99-0d3ef6e60807

breglerj · ‎2023 Sep 25

Hi @Cocquerel,

please open a support ticket on HAN-BAS-EXL. We'll have to investigate your situation which is easier in a support ticket than in this comment section.

Cocquerel · ‎2023 Sep 25

Here is the ticket I opened on the subject Case ID: 797524 / 2023