cancel
Showing results for 
Search instead for 
Did you mean: 

SAP UPS Instance to access SAP BTP Hana DB

DebashishDas
Active Participant
0 Kudos
45

Hello SAP Gurus,

I was doing some test analysis to use the UPS instance (User Provided Service), and access SAP BTP hana cloud DB. 

I created one schema(UPS_SCHEMA) and table inside it. Now i provided the details to access the DB.

DebashishDas_0-1737648609246.png

Created a CAP project. Below is the MTA file, which i deployed to BTP -

_schema-version: 3.3.0
ID: UPS
version: 1.0.0
description: "A simple CAP project."
parameters:
  enable-parallel-deployments: true
build-parameters:
  before-all:
    - builder: custom
      commands:
        - npm ci
        - npx cds build --production
modules:
  - name: UPS-srv
    type: nodejs
    path: gen/srv
    parameters:
      buildpack: nodejs_buildpack
      readiness-health-check-type: http
      readiness-health-check-http-endpoint: /health
      memory: 256M
      disk-quota: 256M
    build-parameters:
      builder: npm
    provides:
      - name: srv-api # required by consumers of CAP services (e.g. approuter)
        properties:
          srv-url: ${default-url}
    requires:
      - name: ups-database-external
      - name: UPS-auth

  - name: UPS-db-deployer
    type: hdb
    path: gen/db
    parameters:
      buildpack: nodejs_buildpack
      memory: 256M
      disk-quota: 256M
    requires:
      - name: ups-database-external

resources:
  - name: ups-database-external
    type: org.cloudfoundry.existing-service
    parameters:
      service: User-Provided
      service-name: ups-database-external
  - name: UPS-auth
    type: org.cloudfoundry.managed-service
    parameters:
      service: xsuaa
      service-plan: application
      path: ./xs-security.json
      config:
        xsappname: UPS-${org}-${space}
        tenant-mode: dedicated

Once i tried to open nodejs Service link, it shows the below error -

Spoiler
502 Bad Gateway: Registered endpoint failed to handle the request.

I checked the logs of the service, which shows "out of memory".

DebashishDas_1-1737649027681.png

I already have the schema and the data in the table for the particular user in hana DB.

DebashishDas_2-1737649174221.png

I really stuck here. 

Looking for guidance to help me out and to understand the process.

 

 

Accepted Solutions (0)

Answers (0)