Devtoberfest
Find out what's happening, and when, in the Devtoberfest schedule – don't miss out!
cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 
A New Home in the New Year for SAP Community!

πŸ”΅ Hybrid development on SAP HANA Cloud and SAP HANA using SAP Business Application Studio

Devtoberfest

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.



Event has ended
You can no longer attend this event.

Starts:
Ends:
9 Comments
mvinci
Employee
Employee

Brilliant - Very useful thanks

Cocquerel
Stellar 2
Stellar 2

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
Employee
Employee

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
Stellar 2
Stellar 2

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
Stellar 2
Stellar 2

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
Stellar 2
Stellar 2

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
Stellar 2
Stellar 2

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
Employee
Employee

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
Stellar 2
Stellar 2

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