Learn how to use SAP Business Application Studio (BAS) to work on SAP HANA Platform, extended services, advanced models.
See how you can use BAS to create and deploy database, analytics, and intelligent data applications projects from the SAP Business Technology Platform into your on-premise environment.
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 ?
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".
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: 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.
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
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 ?
Looking at hrtt-service log on XSA side, I can see the following http 500 error:
(9223372036854775776) [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,18.104.22.168"#
(9223372036854775777) [RTR] OUT 22.214.171.124 - - 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