XSA SAP Hana Database Module (Template) fail to build (point to wrong port)

[german_avanzato]

Hi Everyone,

I have a problem when I try to build the template module for hana db in XSA webide.

We have a new installation of BW4HANA 2 (SP4) over a HANA Enterprise 2 SP4.

In XSA, we have 2 spaces: SAP and DEV.

SAP is map to SYSTEMDB, DEV is map to Tenant database.

When I create a proyect in DEV space, and create a SAP HANA db module, the build fail with the following error

12:00:27 (Builder) Build of "/Planta/db" started.
12:00:30 (DIBuild) Service provisioning for module: '/db'Could not create the 'XSA_DEV-02ryj7yjzltw9iq9-Planta-hdi_db' instance of the 'hana' service type for the 'hdi_db' resource. Cannot provision services due to XSA error: Asynchronous job 'Creating service instance 'XSA_DEV-02ryj7yjzltw9iq9-Planta-hdi_db' [service: 'hana', plan:'hdi-shared'] of [Org 'cofco', Space 'DEV'].' failed: Failed to open connection to the database, because of: Failed to get connection for database 'afbd5084-2303-4bbf-90a9-f18dc5f7df1d' (useazdevdi002:30015), because of: SAP DBTech JDBC: Cannot connect to jdbc:sap://useazdevdi002:30015/ [Cannot connect to host useazdevdi002:30015 [Connection refused (Connection refused) (local port 9008 to address 10.68.18.59 (useazdevdi002.ci.corp), remote port 30015 to address 10.68.18.59 (useazdevdi002.ci.corp))], -813.]. 

I know that my tenant Database is running on port 30041, thats why I have this error, but I cant find a place where I can indicate the port.

When I list the tenant database through XS the port is correct

name       XSA   status   master host     sql-port   mappings
-------------------------------------------------------------------------
DI0        yes   active   useazdevdi002   30041      <default>, cofco:DEV
SYSTEMDB   yes   active   useazdevdi002   30013      cofco:SAP

The same (problem) happens when I try to create a services of hana (hdi-shared)

Have anyone any suggestion where I can start to look at these error?

Regards

German

[ssurampally]

Hi, you XSA space is trying to reach 30015 port(which is default port for the first tenant)., though you mapped to 30041 port. I am not sure how it is happening, may be you can wait for an Administrator to comment on this question. Or Can you try unmap the tenant and map it again, secondly if you do not have data and it's your initial set up of the tenant, you can delete the tenant and recreate it.

[german_avanzato]

Thanks for the response and for following my question.

I have tried all the combination between mapping, unmapping the tenant, install , uninstall the compiler , create , delete the DEV space, create a new space; and I always end up with the same result.

Unfortunetly, the tenant database is de BW4HANA database, and I cant delete and recreate it. The idea is put the artifact in there, so the BW4HANA can consume them (like you mentioned in your original post here).

Thanks for the support.