cancel
Showing results for 
Search instead for 
Did you mean: 

How to access SAP HANA 2.0 tenant database XS admin page and Web-based Development Workbench

srikanthin
Participant
1,958

I have created a tenant database on SAP HANA 2.0, how to access Web-based Development Workbench and XS admin page URLs for particular tenant database. Can someone please help me out with this.

Accepted Solutions (1)

Accepted Solutions (1)

bryan_bingay
Participant

Hi Srikanth, this is how I did it.

  • Create DNS Entries for <SID> system: IP address is needed; if clustered then use the VIP IP.
Entry Type System Purpose <sid>.hana.fqd.com ANAME <SID> XS Classic IDE (/sap/hana/ide) for tenant DB (EH2) sys<sid>.hana.fqd.com ANAME <SID> XS Classic IDE (/sap/hana/ide) for SYSTEMDB
  • Update SYSTEMDB parameter webdispatcher.ini [profile] wdisp/system_auto_configuration to true.
  • Restart the web dispatcher process:
--login to HANA SYSTEMDB and open a SQL console. Replace sid with yours.

--Update URL
--parameters: This is XS Clasic only change the sid part. Execute the following
--commands.

--Execute
all in SYSTEMDB:
--HTTP:
ALTER SYSTEM ALTER CONFIGURATION ('nameserver.ini', 'system')
SET('public_urls','http_url') = 'http://syseh2.hana.fqd.com:8000'
WITH RECONFIGURE; 

--HTTPS:
ALTER SYSTEM ALTER CONFIGURATION ('nameserver.ini', 'system')
SET('public_urls','https_url') = 'https://syseh2.hana.fqd.com:4300'
WITH RECONFIGURE; 

--Tenant
--HTTP:
ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', 'EH2')
SET ('public_urls', 'http_url') = 'http://eh2.hana.fqd.com:8000'
WITH RECONFIGURE;
 
--HTTPS:
ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', 'EH2')
SET ('public_urls', 'https_url') = 'https://eh2.hana.fqd.com:4300'
WITH RECONFIGURE;

You should be able to get into get to Web development workbench in both SYSTEMDB and Tenant. If you want to configure HTTPS see this.

http://sid.hana.fqd.com:8000/sap/hana/ide/

http://syssid.hana.fqd.com:8000/sap/hana/ide/

Best of luck!

Bryan

srikanthin
Participant
0 Kudos

Hi Bryan,

After configuring XS engine public URL for tenant database, when am trying access system database XS engine its showing below error.

Answers (1)

Answers (1)

bryan_bingay
Participant
0 Kudos

Did you create the DNS arecord entries? Can you ping the the DNS arecord entries?

srikanthin
Participant
0 Kudos

Hi Bryan,

Thanks, the issue is resolved now.

srikanthin
Participant
0 Kudos

Hi Bryan,

I have created two different tenants and configured Public URL for those tenants but its not possible to maintain DNS A records with a different sub domain name and same IP in this case how can we call the tenant URL